Data Warehouse Developer

Experis; Madison (WI); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Impactful government data projects

Collaborative team environment

Contract extension possible

Public service organization

Job summary

Experis is seeking a Data Warehouse Developer to join their team in Madison, WI. You will support data integration and warehousing initiatives within the Data Management Department, migrating assets from Informatica PowerCenter to IDMC and assisting in ETL design, development, testing, and implementation.

Ideal candidates have 2+ years in PowerCenter to IDMC migrations and 4+ years in data warehousing with Informatica tools, plus 3+ years of SQL and related relational databases.

Qualifications

• Experience 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).
• Strong SQL data management skills with relational databases (3+ years).
• Ability to gather requirements and translate them into technical solutions.
• Excellent verbal and written communication with diverse 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

ETL design

Data warehousing

SQL

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.

About ManpowerGroup, Parent Company of: Manpower, Experis and Talent Solutions.

Experis® is a global leader in technology services and part of the ManpowerGroup® (NYSE: MAN) family of brands. We connect skilled technology professionals with meaningful opportunities where they can grow their careers, expand their expertise and make a real impact. Guided by the belief that it takes Human Ingenuity to unlock the true potential of technology, Experis helps people gain experience with leading organizations, build sought-after skills and take the next step toward a brighter future. Backed by ManpowerGroup's 75+ years of workforce expertise and global reach across more than 70 countries and territories, Experis brings the scale, insight and opportunity to help people and businesses thrive. ManpowerGroup is consistently recognized for its commitment to inclusion, ethics and responsible business, including being named one of the World's Most Ethical Companies. Learn more at Experis.com.