Back to Jobs

ETL Informatica Developer

Not Disclosed

Job Description & Details

This is a senior ETL gig centered on building and maintaining Informatica pipelines for a client based in Phoenix. They need a consultant who can walk into the office tomorrow and start delivering real data‑integration value.

What You'll Actually Be Doing

You’ll spend most of your day in PowerCenter Designer and Workflow Manager, crafting mappings that pull data from source systems, apply business rules, and load into a data warehouse. Expect to troubleshoot broken workflows, tune performance for large volume loads, and collaborate with data architects to ensure the warehouse schema aligns with the ETL design. The role is hands‑on from day one – you’ll be debugging session logs, fixing deadlocks, and documenting the end‑to‑end flow for the team.

The Core Tech Stack

The non‑negotiable skill set is deep expertise in Informatica PowerCenter (mappings, transformations, workflows) plus solid SQL/PLSQL for source/target manipulation. They also expect you to know the underlying relational platform (Oracle, SQL Server, or similar) and data‑warehousing concepts like slowly changing dimensions, fact/lookup design, and push‑down optimization. If you’ve automated deployments with Informatica’s command‑line tools or used version control for mappings, you’ll be ahead of the curve.

Interview Expectations

  1. “Walk me through how you’d implement a Type 2 slowly changing dimension in Informatica and why you’d pick that approach over Type 1.” – They’re probing your grasp of CDC patterns and your ability to justify design trade‑offs.
  2. “A mapping that processes 50 million rows is failing with ‘Out of memory’ errors. How do you diagnose and resolve it?” – They want to see your systematic troubleshooting: checking session cache settings, partitioning strategy, push‑down vs. in‑database processing, and hardware constraints.

Application Advice

Tailor your resume to scream “10+ years of hands‑on Informatica” right at the top. Sprinkle keywords like Informatica PowerCenter, ETL development, performance tuning, SQL/PLSQL, data‑warehouse, SCD, workflow monitoring, on‑site consultant, Phoenix throughout the experience section. Highlight any past contracts where you hit production deadlines and mention that you’re local and can meet face‑to‑face interview requirements. A concise cover note that references the exact job title and location will help you get past the ATS and land the interview.