Informatica PowerCenter ETL & BI/DW Developer

SmartRecruiters, Inc.; King of Prussia (PA); On-site; USD 95,000 - 135,000; Full time

Job summary

EROS Technologies is seeking an Informatica PowerCenter Developer with BI/DW experience to develop and enhance ETLs from various sources to a SQL Server data warehouse. You will work with Data Analysts and EDW Architects to design and enhance ETL architecture, create new Informatica scripts, transition SQL ETLs, and troubleshoot performance issues.

The role requires expertise in Informatica PowerCenter 9.x, ETL standards, complex SQL querying, and data warehouse population on a large scale.

Qualifications

• Experience with Informatica PowerCenter 9.x and ETL development.
• Ability to design and implement data integration solutions for data warehouses.
• Strong SQL skills and data modelling for large analytic environments.
• Experience in auditing, troubleshooting, and performance tuning ETL processes.

Responsibilities

• Develop and enhance ETLs from multiple sources to SQL Server data warehouse.
• Create and modify Informatica scripts; transition SQL ETLs to Informatica scripts.
• Collaborate with Data Analysts and EDW Architects on ETL architecture.
• Analyze transaction errors and perform debugging/bug fixes; optimize ETL performance.

Skills

Informatica PowerCenter

ETL

SQL

Data warehousing

Web Service Consumer

XML Transformations

Audit & Troubleshooting

Performance tuning

Banking domain

CSV

Tools

Informatica PowerCenter 9.x

Job description

EROS Technologies is seeking an Informatica PowerCenter Developer with BI/DW experience to develop and enhance ETLs from various sources to a SQL Server data warehouse. You will work with Data Analysts and EDW Architects to design and enhance ETL architecture, create new Informatica scripts, transition SQL ETLs, and troubleshoot performance issues.

The role requires expertise in Informatica PowerCenter 9.x, ETL standards, complex SQL querying, and data warehouse population on a large scale.