Data Warehouse Developer: ETL & IDMC Migration

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

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.