Description:
Our client is looking for an experienced Data Warehouse ETL Developer to do the following responsibilities:
- Build ETL to centralize data into a Data Warehouse environment. Develop, unit test and system test integration components Create support documentation describing the functionality of the integrations. Maintain consistency in naming standards and ensure standards are followed. Ensure adherence to data management/governance policies, processes, and standards. Support/Maintain existing data interfaces.
Required Qualifications
- 5 - 7 years of prior IT experience in Data Management / ETL / ELT / Data Warehousing
- Proven experience with Data Management & Integration
- o Recent experience developing integrations using Informatica Cloud Data Integration (IICS CDI Service) is required.
- o Recent experience developing integrations using Informatica PowerCenter is required.
- o Experience in integrating multiple sources into a centralized data platform or Enterprise Data Warehouse
- o Experience in integrating data into, Star Schemas, Normalized Data Models. Data Vault models
- 5+ years of in-depth experience working with a wide variety of RDBMS (SQL Server, Azure SQL DB, Oracle etc.).
Nice to have: HealthCare Experience with Claims data and Clinical data. Experience with BI tools and their data needs (i.e. Qlik, Tableau, BOE, or SAS as examples) desired o Experience in using visualization tools and an understanding of how those tools consume data Understanding of Data Quality concepts and ability to use them effectively. Experience in writing Data Quality routines for cleansing of data and capturing confidence score Data Modeling experience ETL tuning experience