Job Description & Details
The data integration market is booming as companies rush to modernize their analytics pipelines, making seasoned Informatica experts highly sought after. A hybrid role in Texas offers the perfect blend of on‑site collaboration and flexible work, ideal for professionals with 15+ years of experience. This opportunity also welcomes candidates on H1B, Green Card, or US citizenship, giving you a clear path to contribute to a major state‑level project.
Job Summary
We are seeking a senior‑level Informatica Developer to design, develop, and maintain high‑performance ETL solutions for the State of Texas. The role involves end‑to‑end data pipeline creation, performance tuning, and close collaboration with business analysts and data architects in a hybrid work environment.
Top 3 Critical Skills Table
| Skill | Why it's critical | Mastery Level |
|---|---|---|
| Informatica PowerCenter | Core platform for building, scheduling, and monitoring ETL jobs | Senior |
| SQL & Relational Databases | Enables data extraction, transformation, and loading across multiple sources | Senior |
| Data Warehousing Concepts | Guarantees optimal schema design, performance, and data quality | Senior |
Interview Preparation
- Explain the architecture of an Informatica workflow and how you would troubleshoot a failed session. What the interviewer is looking for: Understanding of repository, integration service, and error handling.
- Describe how you would implement change data capture (CDC) using Informatica. What the interviewer is looking for: Knowledge of source capture methods, mapping design, and performance considerations.
- How do you optimize a slow‑running mapping that processes millions of rows? What the interviewer is looking for: Techniques such as partitioning, pushdown optimization, and proper use of indexes.
- What is the difference between connected and unconnected lookups, and when would you choose each? What the interviewer is looking for: Insight into lookup caching, performance impact, and reusability.
- Walk through a scenario where you had to migrate legacy ETL processes to Informatica. What the interviewer is looking for: Project management, data validation, and migration strategy.
Resume Optimization
- Informatica PowerCenter
- ETL Development
- SQL Server / Oracle
- Data Warehousing
- Change Data Capture (CDC)
- Performance Tuning
- Workflow & Session Management
- Mapping Design
- Hybrid Work Environment
- Visa Status: H1B, GC, US Citizen
Application Strategy
When reaching out to the recruiter, send a concise email that greets the recruiter, briefly introduces yourself, and attaches your resume. Clearly highlight your 15+ years of Informatica experience, mention projects where you delivered large‑scale ETL solutions, and map your top skills—such as PowerCenter, SQL optimization, and data‑warehouse design—to the job requirements. End by expressing enthusiasm for the hybrid Texas role and your eligibility to work in the US.
Career Roadmap
| Current Role | Typical Experience | Core Focus | Next Position |
|---|---|---|---|
| Informatica Developer (Senior) | 15+ years | End‑to‑end ETL architecture, performance tuning | Lead Data Integration Engineer |
| Lead Data Integration Engineer | 3‑5 years leading teams | Strategy, governance, cross‑platform integration | Data Architecture Manager |
| Data Architecture Manager | 5+ years overseeing data platforms | Enterprise data strategy, stakeholder alignment | Director of Data Engineering |