ETL Developer Informatica PowerCenter

Job Title: ETL Developer - Informatica PowerCenter

Location: Phoenix, AZ - Onsite

Experience Required: 8-10 Years

Job Overview

We are seeking an experienced ETL Developer with strong Informatica PowerCenter expertise to design, develop, and maintain enterprise data integration solutions. The ideal candidate will have hands-on experience building complex ETL workflows, working with relational databases, and transforming data from multiple sources into reliable target systems.

This role requires strong analytical skills to troubleshoot data issues and ensure high data quality across data pipelines.

Key Responsibilities

ETL Development

• Design, develop, and maintain ETL workflows using Informatica PowerCenter.

• Build complex data integration pipelines to extract and transform data from multiple sources.

• Work with heterogeneous data sources including:

  • SQL databases

  • Oracle databases

  • XML files

  • Flat files

Data Integration & Transformation

• Map and transform data from source systems into target databases and data warehouses.

• Ensure data accuracy, integrity, and consistency across data pipelines.

• Optimize ETL workflows for performance and scalability.

Database Development

• Write and optimize SQL and PL/SQL queries.

• Develop stored procedures and scripts for ETL processing.

• Work with relational database structures and schemas.

Troubleshooting & Maintenance

• Analyze data discrepancies and resolve data integration issues.

• Perform root cause analysis for ETL failures and implement fixes.

• Monitor ETL jobs and ensure smooth execution in production environments.

Required Skills

• Strong experience with Informatica PowerCenter development.

• Advanced knowledge of SQL and PL/SQL programming.

• Experience working with relational databases (Oracle, SQL Server, etc.).

• Hands-on experience with Unix shell scripting.

• Experience handling data from multiple source systems and formats.

• Strong data analysis and problem-solving skills.

Core Technologies

Informatica PowerCenter | ETL Development | SQL | PL/SQL | Oracle | Unix Shell Scripting | Data Integration | Data Transformation