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
Recommended Jobs
Customer Care Coordinator - Travel Services
Position Overview We are seeking a Customer Care Coordinator who is passionate about delivering excellent service and building positive client relationships. In this role, you will help guide tr…
Aircraft Mechanic / A&P Technician, Piston Aircraft - IWA Airport
5K Sign On Bonus For Qualified AMTs About Us ATP is the nation's largest flight school, providing students with the most efficient path to a successful airline pilot career. For over 40 years, A…
Bilingual Family Connection Consultant/Nurturing Parenting Practitioner
General Description: Family Connection Consultant (FCC) Nurturing Parenting Practitioner (NPP) works with families and their children through home/virtual visitation to deliver the Family Connecti…
Account Manager
Territory Account Manager CR&R Incorporated is one of Southern California's most innovative and successful waste and recycling collection companies, serving more than 3 million people and over 25,…
Broccoli Foreperson I
Title: Broccoli Foreperson I Salary Range: $76,000 - $77,450 Annually Status: Exempt Reports to: Superintendent Location: Salinas, CA / Yuma, AZ _________________________…
Entry-Level Freight Dispatcher (Remote) - Earn $2,200 to $3,000 Weekly ($114,400-$156,000 Annually)
Entry-Level Freight Dispatcher (Remote) – Earn $2,200 to $3,000 Weekly ($114,400–$156,000 Annually) We are hiring motivated individuals to join our logistics team as Freight Dispatchers. This is a …
Mental Health Technician
Mentor Community Services Mentor Community Services, a part of the Sevita family, provides community-based services for individuals with intellectual and developmental disabilities. Here we believ…
Leasing Consultant
Leasing Consultant - Cambria Apartments - Gilbert, AZ Salary Range $19.00 - $21.00 Hourly Overview We are committed to creating an inspiring and inclusive experience, celebrating our diverse…
Open Rank Faculty position in Neurosurgery Research
Why Mayo Clinic Mayo Clinic is top-ranked in more specialties than any other care provider according to U.S. News & World Report. As we work together to put the needs of the patient first, we ar…
Sr Collections Specialist
: Under the direct supervision of the Supervisor Collections and Manager Credit/Collections, protects and recovers the hospital's assets by monitoring accounts receivable, collecting delinquent accou…