Data Warehouse Engineer: PowerCenter to IDMC Migration

Novalink Solutions LLC

Alabama

On-site

USD 85,000 - 120,000

Full time

4 days ago

Be an early applicant

Application generator

An application made for this job — a tailored resume and cover letter that speak straight to the posting.

Get past ATS filters

Job summary

Novalink Solutions LLC in Madison, WI seeks a Data Warehouse Developer II to migrate mappings, mapplets, sessions, and workflows from Informatica PowerCenter to IDMC. You will assist in ETL design, development, testing and maintenance of data warehouse initiatives, ensuring data quality and security.

The role requires 4–5 years of experience, strong SQL/DB2/Oracle skills, and ability to collaborate with cross-functional teams.

Qualifications

IDMC migration of Informatica assets and related testing.
Data warehouse design, development and performance tuning.
SQL/ relational DB skills with Oracle/DB2/SQL Server.
Experience with end-to-end SDLC deliverables and requirements gathering.
Excellent communication and collaboration abilities.

Responsibilities

Migrate mappings, mapplets, sessions, and workflows from PowerCenter to IDMC.
Assist in ETL design, development, testing, maintenance and metadata implementation.
Develop ETL mappings for loading data warehouse and ensure data reliability.
Improve performance and security of data warehouse; work with IT teams and users.
Document design specifications and test plans; support complex projects.