ETL Developer – Informatica PowerCenter
Share
Job Location:
Phoenix, NM - USA
Monthly Salary:
Not Disclosed
Posted on:
7 hours ago
Vacancies:
1 Vacancy
Job Summary
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
Key Skills
- Anti Money Laundering
- Entry Level Sales
- Asset
- Application Engineering
- Electrical & Instrumentation
