ETL Developer

ETL Developer Client: First Quality Location: King of Prussia PA Duration: 6 Months Rate: 60-70/hr on C2C JD: Requisition:

• Participate in the development of strategy and design of architectures for the analytics platforms (i.e. DW, ETL, and Reporting).
• Build new OLAP data model designs and ETL processes.
• Estimate engineering effort, plan implementation, and rollout system changes.
• Monitor DW & BI Applications to ensure customer defined expectations are met.
• Identify technical areas for improvement and present detailed business cases for improvements or new areas of opportunities.
• Independently design, code, and test major features, as well as work jointly with other team members to deliver complex changes.
• Work with external and internal teams to resolve infrastructure-related issues when developing integration modules.
• Partner with the business groups to evaluate and perform application development and/or business process change requests under minimal direction.
• Ensure optimal application performance and maintainability of assigned systems, thus enabling scalability and continuous updates from software vendors.
• Design and build extracts from various ERP systems.
• Coordinate with IT functional leads to understand business requirements.
• Design and develop a KPI framework that aligns to business goals.
• Minimum of 5 years Information Technology experience with a focus on ETL development within a Data Warehouse environment.
• Experience with Attunity Replicate a plus.
• 3+ years of development experience with a major ETL tool (i.e. SSIS, DataStage, Informatica).
• 3+ year's technical knowledge in the areas of general SQL\T-SQL\PLSQL\advance BTEG Scripts.
• Experience with SSIS, SSRS, and SSAS or similar database tools.
• Strong understanding of data warehousing or big data platform concepts like ETL best practices, dimensional modeling, and Semantic/reporting layer design.
• Strong understanding of QlikView development.
• Strong problem solving and decision making skills.
• Experience in working with vendors (onshore and offshore).
• Strong understanding of data governance/management concepts and practices.
• Experience working with Heath Care Validated Systems.
• Experience working in Data Warehouse environments managing terabytes of data and information.
• Ability to communicate complex ideas in simple terms, and effectively interact with decision makers.
• Strong background in systems development, including an understanding of project management methodologies and the development lifecycle.
• Ability to translate conceptual requirements into technical implementation requirements.
• Prior experience in the Manufacturing Industry preferred. ClifyX