Description
Senior Data Warehouse Engineer
Skills: Informatica, SQL, Data Analysis, MDM a huge plus!
Summary
This is a 3-6 month+ contract opportunity. The Senior Data Warehouse Engineer is responsible is for the design, development, and support of data movement and cleansing processes for the Enterprise Data Warehouse and related data assets. Database is Oracle and Netezza. Company has sustained growth; great opportunity to get in the door and be a valued member of an enterprise organization!
Responsibilities
• Design and Develop Informatica mappings and workflows.
• Optimize and troubleshoot Informatica mappings and workflows
• Perform and document unit tests for workflows
• Conduct deep data analysis on source data to be able to implement business rules required.
• Be able to create mappings and workflows from data models and design sessions with the data architect and other team members
• Resolve most technical issues independently
• Provide the second/third level support function, ETL incident/Eevent management.
• Work with the team to ensure the quality of coordinated business functions.
• Respond quickly and effectively to production issues and taking responsibility for seeing those issues thru resolution.
Qualifications
• Bachelors degree in a related discipline or a combination of education and experience
• 7+ years experience in Data Warehousing
• 7+ years experience with Informatica
• 7+ years experience with complex query development
• Experience with performance tuning and optimization
• Experience with Informatica Data Quality and/or MDM a plus
• At least 7 years experience with one or more of the following databases: Oracle, Teradata, or Netezza
Benefits
As an Agile consultant, you’ll gain many of the advantages and benefits of being a direct hire, while experiencing the flexibility of consulting. It’s the best of both worlds! Our IT consultants enjoy a wide array of benefits including: medical, dental, 401K, life insurance, Employee Assistance Program and more.