Our client is currently seeking a Senior ETL Developer to support and develop the business system's integrations and data warehousing solutions. This candidate will use Microsoft SSIS as the data integration technology and also utilize data presentation technologies including SAP Business Objects, 3rd party .Net reporting tools (Dev Express), SSRS, and Excel. The Developer will be interacting with data sources which reside in both Oracle (10g) and Sql Server (2005, 2008R2) databases. In this position, you will report to the Director of IT.
Principal Responsibilities Support, maintain and develop system integrations among enterprise front and back-office applications (ERP, CRM, EDI, Demand Planning, Manufacturing Control Systems) Design and develop ETL processes to integrate data among business systems and data warehouses in both Oracle and MS SQL Server environments. Design, code, test and trouble shoot business reporting for end-users in Business Objects Crystal Reports, SSAS, Microsoft Reporting services and other BI tools. Prepare documentation & flow charts of systems, business processes and databases Provide off-hours application and reporting support as needed
Qualifications/Requirements BA or BS in Information Systems, Information Technology, or Computer Science Must have solid understanding of relational database design Must have solid SQL skills and be able to work in both Oracle and SQL Server environments using PL-SQL and/or T-SQL Experience with BI and Reporting Platforms Business Objects, Crystal Reports.
Desired Work Experience Experience in manufacturing and distribution environment a plus. Experience working with ERP Systems (IFS, Oracle, SAP, Microsoft Dynamics etc.) and CRM systems (Salesforce, Pivotal, Sales Logix, Microsoft CRM) a plus Experience with EDI (Sterling Commerce Gentran) a plus. Experience with BI and Reporting Platforms such as Qlikview, Tableau, Business Objects, Cognos, Microstrategy, MS Sharepoint