ETL Data Engineer: IDMC & PowerCenter Migration

Beacon Hill Staffing Group, LLC; Austin (TX); Remote; USD 95,000 - 135,000; Full time

Benefits offered by this job

Medical, dental, vision

Leave programs as required

Remote work flexibility

Job summary

Beacon Hill Technologies is seeking a Data Warehouse Developer to migrate Informatica PowerCenter assets to IDMC and contribute to enterprise data warehouse modernization. The role focuses on ETL development, performance tuning, and data integration architecture across the full software development life cycle.

The ideal candidate will have 4+ years in data warehouse design and deep expertise with PowerCenter and IDMC, plus strong SQL and data analysis skills, supporting enterprise data

Qualifications

• 4+ years of data warehouse design and development experience.
• 4+ years working with Informatica PowerCenter.
• 2+ years working with Informatica IDMC.
• Experience migrating PowerCenter assets to IDMC.
• Strong SQL development and data analysis skills.
• Experience with relational databases including Oracle, DB2, and SQL Server.
• Knowledge of data warehouse architecture and integration strategies.
• Experience with performance tuning and optimization.
• Strong written and verbal communication skills.

Responsibilities

• Migrate mappings, workflows, sessions, and mapplets from Informatica PowerCenter to IDMC.
• Design, develop, test, and maintain ETL processes and data warehouse solutions.
• Create ETL mapping specifications and technical documentation.
• Perform data analysis, validation, testing, and performance tuning.
• Support requirements gathering and solution design activities.
• Collaborate with technical teams and business stakeholders.
• Develop test plans, test cases, and quality assurance procedures.
• Ensure data reliability, integrity, security, and warehouse performance.
• Participate throughout the full software development life cycle.

Job description

Beacon Hill Technologies is seeking a Data Warehouse Developer to migrate Informatica PowerCenter assets to IDMC and contribute to enterprise data warehouse modernization. The role focuses on ETL development, performance tuning, and data integration architecture across the full software development life cycle.

The ideal candidate will have 4+ years in data warehouse design and deep expertise with PowerCenter and IDMC, plus strong SQL and data analysis skills, supporting enterprise data