Data Warehouse Developer

ManpowerGroup Global, Inc.; Madison (WI); On-site; USD 85,000 - 120,000; Full time

Job summary

ManpowerGroup Global, Inc. seeks a Data Warehouse Developer to join the Data Management team in Madison, WI.

You will support data integration and warehousing initiatives, migrate mappings to IDMC, and contribute to ETL design, development, testing, and implementation. The ideal candidate has strong analytical and communication skills, experience with Informatica PowerCenter and IDMC, and a solid background in relational databases and SQL.

Qualifications

• 2+ years migrating assets from Informatica PowerCenter to IDMC.
• 4+ years in data warehousing design, development, and performance tuning with Informatica tools.
• 3+ years with Oracle/DB2/SQL Server and strong SQL data management.

Responsibilities

• Migrate mappings, sessions, and workflows from PowerCenter to IDMC.
• Assist in ETL design, development, testing, and implementation of data warehouse projects.
• Translate user requirements into technical data warehouse solutions with quality deliverables.
• Create ETL mapping specifications for reliable data loading.
• Optimize data warehouse performance while maintaining data security standards.

Skills

Informatica PowerCenter

IDMC migration

SQL

Relational databases

Tools

Informatica tools

Oracle

DB2

SQL Server

Job description

Our client is seeking a Data Warehouse Developer to join their team. As a Data Warehouse Developer, you will be part of the Data Management Department supporting data integration and warehousing initiatives. The ideal candidate will have strong analytical skills, excellent communication abilities, and a collaborative mindset which will align successfully in the organization.

Job Title:Data Warehouse Developer

Location: Madison, WI

What's the Job?

• 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 that meet organizational needs 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.

What's Needed?

• Experience in migrating assets from Informatica PowerCenter to IDMC (2+ years).
• Moderate experience in data warehousing process design, development, and performance tuning using Informatica tools (4+ years).
• Knowledge of relational database technologies such as Oracle, DB2, SQL Server, and strong SQL data management skills (3+ years).
• Ability to gather requirements and translate them into technical solutions.
• Excellent verbal and written communication skills, with experience facilitating meetings with technical and non-technical stakeholders.

What's in it for me?

• Opportunity to work on impactful government data projects.
• Collaborative team environment supporting professional growth.
• Potential for contract extension based on project needs.
• Work in a dynamic and supportive organization committed to public service.
• Gain valuable experience in data warehousing and data integration technologies.