Job Title: Senior Informatica Developer

Job Location: Arizona
Experience: 12–14+ years
Job Type: Full-time / Contract

Job Summary

We are seeking an experienced Senior Informatica Developer to design, develop, implement, and maintain enterprise data integration and ETL solutions. The ideal candidate will have strong expertise in Informatica PowerCenter, data warehousing, SQL, performance tuning, and data quality management. The candidate will collaborate with business analysts, data architects, database administrators, and other technical teams to deliver reliable and scalable data solutions.

Key Responsibilities

• Design, develop, test, and deploy ETL workflows using Informatica PowerCenter.

• Develop complex mappings, mapplets, sessions, workflows, and reusable transformations.

• Analyze business requirements and translate them into technical specifications.

• Develop and optimize SQL queries, stored procedures, and database objects.

• Perform ETL performance tuning and troubleshoot data integration issues.

• Integrate data from multiple sources, including relational databases, flat files, APIs, and enterprise applications.

• Support data warehouse, data mart, and business intelligence initiatives.

• Implement data validation, data cleansing, reconciliation, and quality checks.

• Monitor production ETL jobs, investigate failures, and resolve incidents.

• Work with Oracle, SQL Server, DB2, Teradata, or other enterprise databases.

• Participate in code reviews, unit testing, system integration testing, and deployment activities.

• Maintain technical documentation, data mappings, and operational procedures.

• Collaborate with cross-functional teams and mentor junior developers.

• Follow data governance, security, and development standards.

Required Technical Skills

• Strong experience with Informatica PowerCenter and ETL development.

• Advanced SQL and PL/SQL programming skills.

• Experience with data warehousing concepts, dimensional modeling, and data integration.

• Knowledge of relational databases such as Oracle, SQL Server, DB2, or Teradata.

• Experience with ETL optimization, debugging, and production support.

• Familiarity with Unix/Linux shell scripting.

• Understanding of data quality, data profiling, and data reconciliation.

• Experience with scheduling tools such as Autosys, Control-M, or similar tools.

• Proficiency in SDLC, Agile methodologies, version control, and deployment processes.

• Informatica PowerCenter

• ETL/ELT Development

• SQL and PL/SQL

• Oracle / SQL Server / Teradata

• Data Warehousing

• Unix Shell Scripting

• ETL Performance Tuning

• Informatica IDMC / IICS

• AWS / Azure / Snowflake

• Production Support

Preferred Qualifications

• Experience with Informatica Intelligent Data Management Cloud (IDMC), Informatica Cloud Data Integration, or Informatica Data Quality.

• Exposure to cloud data platforms such as AWS, Azure, or Snowflake.

• Experience with big data technologies such as Hadoop or Spark.

• Knowledge of CDC (Change Data Capture) and incremental data loading.

• Familiarity with CI/CD pipelines and automated ETL testing.

• Experience in banking, healthcare, insurance, retail, or other enterprise environments.

Education

Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent practical experience.

Key Competencies

• Strong analytical and problem-solving skills.

• Excellent communication and collaboration abilities.

• Ability to manage multiple priorities and meet project deadlines.

• Attention to detail and commitment to data accuracy.

• Ability to work independently and provide technical leadership.

Expected Deliverables

• High-quality, reusable ETL mappings and workflows.

• Optimized data integration processes.

• Accurate and reliable data warehouse loads.

• Production issue resolution and root-cause analysis.

• Technical documentation and deployment support.