Data Warehouse ETL Developer: IDMC & PowerCenter

Beacon Hill Staffing Group, LLC; Richmond (VA); Remote; USD 100,000 - 150,000; Full time

Job summary

Beacon Hill Staffing Group, LLC seeks a Data Warehouse Developer experienced with Informatica PowerCenter and IDMC to advance enterprise data warehouse modernization. The role focuses on migrating PowerCenter assets to IDMC while enhancing ETL development, testing, performance, and data integration architecture.

You will design and implement ETL processes, develop mappings and documentation, perform data validation and tuning, and collaborate with technical teams and business stakeholders

Qualifications

• 4+ years of data warehouse design and development experience.
• 4+ years working with Informatica PowerCenter.
• 2+ years working with Informatica IDMC.
• Strong SQL development and data analysis skills.
• Experience with relational databases including Oracle, DB2, and SQL Server.

Responsibilities

• Migrate PowerCenter assets to IDMC and optimize ETL workflows.
• Design, develop, test, and maintain ETL processes and data warehouse solutions.
• Create ETL mapping specifications and technical documentation.
• Analyze data, validate results, and perform performance tuning.
• Collaborate with technical teams and business stakeholders.
• Participate in full SDLC activities.

Skills

Data warehouse design

PowerCenter

IDMC

SQL development

Relational databases

Performance tuning

Communication skills

Tools

Business Objects

Tableau

COBOL

DB2

Job description

Beacon Hill Staffing Group, LLC seeks a Data Warehouse Developer experienced with Informatica PowerCenter and IDMC to advance enterprise data warehouse modernization. The role focuses on migrating PowerCenter assets to IDMC while enhancing ETL development, testing, performance, and data integration architecture.

You will design and implement ETL processes, develop mappings and documentation, perform data validation and tuning, and collaborate with technical teams and business stakeholders