Informatica Developer

Informatica Developer

Role Summary

We are seeking an Informatica Developer to join our Data Engineering team. The ideal candidate has 5+ years of hands-on experience building and maintaining ETL/ELT pipelines using Informatica, strong SQL skills, and working knowledge of Google BigQuery and Shell scripting. 

Responsibilities

• Design, develop, test, and maintain ETL/ELT workflows using Informatica PowerCenter and/or Informatica Cloud.
• Author complex and optimized SQL queries for data extraction, transformation, validation, reconciliation, and reporting.
• Integrate and process data in Google BigQuery and support data warehousing activities.
• Develop and maintain Shell scripts to automate data processing, job orchestration, and operational tasks.
• Perform data mapping, transformations, data quality checks, and ensure data consistency across multiple source systems.
• Monitor, troubleshoot, and resolve issues related to ETL workflows, data pipelines, job failures, and data quality incidents.
• Perform performance tuning and optimization of ETL mappings, workflows, and SQL queries.
• Collaborate with Data Engineers, Data Architects, Analysts, and business stakeholders to gather requirements and deliver scalable data solutions.
• Create and maintain clear technical documentation for ETL processes, data flows, and operational runbooks.

Requirements

• 5+ years of professional experience in Informatica development (PowerCenter and/or Informatica Cloud).
• Strong hands-on SQL skills including complex joins, subqueries, CTEs, window functions, aggregations, and query optimization.
• Practical experience working with Google BigQuery or similar cloud data warehouses.
• Proven experience with Shell scripting for automation and operational tasks.
• Solid understanding of ETL/ELT concepts, data integration patterns, and data warehousing principles.
• Familiarity with relational databases and data modeling concepts.
• Strong analytical, troubleshooting, and problem-solving capabilities.
• Ability to work independently in a remote environment and collaborate effectively across cross-functional teams.
• Good communication skills for working with technical and non-technical stakeholders.

Nice to Have

• Experience with other GCP services (Dataflow, Cloud Storage, Pub/Sub) or multi-cloud environments.
• Knowledge of dimensional modeling and data modeling best practices.
• Experience with ETL scheduling, orchestration, and monitoring tools (e.g., Airflow, Control-M, Autosys).
• Familiarity with version control (Git) and CI/CD practices for data pipelines.
• Experience working in Agile/Scrum teams.
• Informatica certification(s) or cloud platform certifications.