Hybrid Data Warehouse Engineer: IDMC Migration & ETL Lead

I O DATASPHERE; Madison, Northern (WI, KY); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Wisconsin Department of Children & Families (DCF) seeks a Data Warehouse Developer to design, develop, and maintain relational databases for data storage and data mining. This role is mostly remote but may require onsite work with sufficient notice and the candidate must provide their own equipment.

Key tasks include migrating mappings from Informatica PowerCenter to IDMC, ETL design and development, data warehouse initiatives, and performance tuning while ensuring data security.

Qualifications

• Experience migrating assets from Informatica PowerCenter to IDMC, including testing and validation.
• Familiarity with relational and dimensional data models.
• Experience with slowly changing dimensions.
• Strong communication with customers and technical staff.
• Knowledge of the full project lifecycle: planning through support.
• Requirements gathering skills.
• Ability to work with large organizations and cross-functional teams.
• Proficiency with MS Office, Visio, and Outlook.
• Experience with mainframe COBOL and DB2 is a plus.

Responsibilities

• Migrate mappings, mapplets, sessions, and workflows from PowerCenter to IDMC.
• Assist in ETL design, development, testing, maintenance and metadata management.
• Develop ETL mappings for loading data into the warehouse and ensure data reliability.
• Improve data warehouse performance and ensure data security.
• Collaborate with IT teams and business users to implement solutions.
• Design and test data warehouse components including metadata and repository creation.
• Establish processes for entering data into warehouse systems.

Skills

PowerCenter to IDMC migration

Relational data modeling

Dimensional data modeling

Communication

SDLC knowledge

Requirements gathering

Team collaboration

MS Office / Visio / Outlook

COBOL / DB2 mainframe knowledge

Tools

IDMC

Informatica PowerCenter

Oracle / DB2 / SQL Server

Job description

Wisconsin Department of Children & Families (DCF) seeks a Data Warehouse Developer to design, develop, and maintain relational databases for data storage and data mining. This role is mostly remote but may require onsite work with sufficient notice and the candidate must provide their own equipment.

Key tasks include migrating mappings from Informatica PowerCenter to IDMC, ETL design and development, data warehouse initiatives, and performance tuning while ensuring data security.