Informatica Developer
Job Title: Informatica Developer
Location: Phoenix, AZ (Hybrid)
Duration: 12 Months
Job Description:
We are seeking an experienced Informatica Developer to support the development and maintenance of enterprise data warehouse solutions. The ideal candidate will have strong expertise in ETL development, data warehousing concepts, and database programming.
Key Responsibilities:
Develop, implement, administer, and support ETL processes for large-scale data warehouse environments using Informatica PowerCenter .
Perform data analysis, requirement gathering, and data mapping for ETL workflows.
Design, develop, and maintain ETL pipelines using SQL Server, PL/SQL, and SQL Loader .
Create and optimize complex SQL queries , including joins, unions, and views.
Monitor and tune Informatica mappings and sessions to resolve performance bottlenecks across sources, targets, and transformations.
Implement database programming using PL/SQL , including stored procedures, triggers, and packages.
Work with UNIX shell scripting to support ETL processes and automation tasks.
Collaborate with data architects and business teams to support data warehouse design and deployment .
Required Skills:
Strong experience with Informatica PowerCenter .
Solid SQL development skills with complex queries and data transformations.
Hands-on experience with data warehousing concepts , including:
Dimensional Modeling
Star & Snowflake Schemas
Data Marts
Fact and Dimension Tables
Logical and Physical Data Modeling
Experience in performance tuning of ETL processes .
Knowledge of UNIX and shell scripting .
Preferred / Desirable Skills:
Experience with Netezza and Yellowbrick databases.
Prior experience in ETL design and development within large data warehouse environments.
Recommended Jobs
Marketplace Operations & Development Manager
Job Description Job Description About the Role We’re hiring a Marketplace Operations & Development Manager to take full ownership of our multi-channel marketplace presence. This is an intern…
Solar Sales Manager
Icon Power: Offers extremely aggressive compensation plan Assists in recruiting and building out your team Installs quickly so you get paid faster Pays on time and treats reps fairly I…
Pediatric Dentist
Job Description Job Description PLEASE NOTE - This position may require temporarily relocation to other TONHC Facilities: Sells Hospital, Santa Rosa Health Center, San Simon Health Center, and Sa…
Senior Project Manager, Municipal
Job Description Job Description:\n\nDescription: Since 1980, CobbFendley has been committed to providing innovative engineering and surveying solutions with the goal of bettering communities. Our …
Regional Refrigeration Specialist, RME Sub Same Day (SSD)
DESCRIPTION Application deadline: Mar 11, 2026 Operations is at the heart of Amazon's business. We are known for our speed, accuracy, and exceptional service. Our buildings deliver tens of th…
Total Rewards - Health & Welfare Benefits Senior Consultant
Human Capital Our Human Capital practice is at the forefront of transforming the nature of work. As converging forces reshape industries, our team uniquely addresses the complexities of work, work…
Physician Liaison for Medi Weightloss
Physician Liaison – Medi-Weightloss® Company Description Medi-Weightloss® is a nationally recognized, physician-supervised weight loss program known for delivering medically proven, individualize…
Driver / Data Collector in Phoenix, SC
Job Description Job Description Company description Service Measure (SM) is a field data collection company founded in 2013 in New York. We collect data where automation is not possible. We…
Commercial Concrete Finisher
Commercial Concrete Finisher Concrete Finishers are responsible for smoothing and finishing of poured concrete floors, slabs, walls, tilt-walls, elevated slabs, and site work (curbs, sidewalks, load…
Comic Book Creation (Part Time, After School, In-Person)
Schedule: Typically 1 hour per week for 10 weeks (after school); exact days/times vary by assignment Location: On-site at a partner school; varies by assignment Start Date: Rolling openings …