Data Warehouse Developer

ManpowerGroup; Madison (WI); On-site; USD 80,000 - 120,000; Full time

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

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.

ManpowerGroup is committed to providing equal employment opportunities in a professional, high quality work environment. It is the policy of ManpowerGroup and all of its subsidiaries to recruit, train, promote, transfer, pay and take all employment actions without regard to an employee's race, color, national origin, ancestry, sex, sexual orientation, gender identity, genetic information, religion, age, disability, protected veteran status, or any other basis protected by applicable law.