Data Warehouse Developer: IDMC Migration & ETL Lead

ManpowerGroup

Madison (WI)

On-site

USD 80,000 - 120,000

Full time

5 days ago

Be an early applicant

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

ManpowerGroup is seeking a Data Warehouse Developer in Madison, WI to support data integration and warehousing initiatives. The role focuses on migrating assets from Informatica PowerCenter to IDMC and contributing to ETL design, development, testing, and implementation.

You will translate user requirements into technical solutions, optimize warehouse performance, and ensure data security, collaborating with a team in a government data project context.

Qualifications

2+ years in migrating assets from Informatica PowerCenter to IDMC.
4+ years in data warehousing process design, development, and performance tuning using Informatica tools.
3+ years of relational DB experience (Oracle/DB2/SQL Server) and strong SQL skills.
Excellent verbal and written communication with stakeholders.

Responsibilities

Migrate mappings, mapplets, sessions, and workflows from Informatica PowerCenter to IDMC.
Assist in ETL design, development, testing, maintenance, and implementation of data warehouse projects.
Understand user requirements and develop solutions with high-quality deliverables.
Create ETL mapping specifications to ensure reliable data loading into the warehouse.
Optimize performance and tuning of the data warehouse while maintaining data security standards.

Skills

Informatica migration

DW design

SQL / data management

Stakeholder communication

Tools

Informatica PowerCenter

IDMC

Oracle

DB2

SQL Server

Job description

You will translate user requirements into technical solutions, optimize warehouse performance, and ensure data security, collaborating with a team in a government data project context.

Get your free, confidential resume review.

or drag and drop your file here.