Senior Informatica Data Engineer

Company Overview

{Company Overview details were not provided.}

Job Summary

We are seeking a highly skilled Senior Informatica Data Engineer with strong expertise in both Informatica On-Prem (PowerCenter, IDQ) and Cloud (IICS, Cloud Data Warehouses) platforms. The ideal candidate will have a proven track record in designing, developing, and optimizing data pipelines across on-premise and cloud environments. This role will play a key part in modernizing data integration processes, ensuring data quality, and enabling seamless data flow across enterprise applications and analytics platforms.

Responsibilities

• Design, develop, and maintain Informatica ETL workflows (PowerCenter, IDQ, IICS) for large-scale data integration.
• Work with cloud platforms (Azure, AWS, GCP) and integrate data with Snowflake, Synapse, Redshift, BigQuery, or other cloud data warehouses.
• Implement data quality, profiling, and cleansing using Informatica IDQ.
• Optimize ETL/ELT pipelines for high performance and scalability.
• Develop real-time and batch data pipelines using Informatica CDC, Kafka, Spark, or other streaming technologies.
• Collaborate with data architects, analysts, and business teams to gather requirements and design robust data solutions.
• Ensure data governance, security, and compliance practices are followed.
• Support and troubleshoot issues in production environments, ensuring minimal downtime.
• Mentor junior engineers and contribute to best practices for data engineering and DevOps automation.

Qualifications

• Strong hands-on experience with Informatica PowerCenter (ETL/ELT) and Informatica Data Quality (IDQ).
• Expertise in SQL and PL/SQL (Oracle, SQL Server, Teradata, DB2, etc.).
• Experience with Informatica Intelligent Cloud Services (IICS) – Data Integration (DI), Application Integration (AI), API Management.
• Strong understanding of cloud platforms (Azure, AWS, or GCP) and their data services.
• Proficiency in integrating with Cloud Data Warehouses (Snowflake, Synapse, Redshift, BigQuery).
• Hands-on knowledge of data modeling (Star, Snowflake schemas, OLTP, OLAP).
• Proven ability to handle large-scale data integration and performance tuning.
• Bachelor’s or Master’s degree in Computer Science, Information Technology, Data Engineering, or a related field.

Preferred Skills

• Programming & Automation: Python, Java, or Shell scripting.
• Big Data Ecosystem: Hadoop, Spark, or Databricks for large-scale data processing.
• DevOps/CI-CD: Jenkins, Git, Azure DevOps for deployment automation.
• API Integration: REST/SOAP API-based ingestion and integration.
• Data Governance & Metadata: Experience with Informatica Axon / EDC.
• Visualization Tools: Power BI, Tableau.
• Agile Ways of Working: Familiarity with Scrum/Kanban frameworks.
• Strong communication, stakeholder management, and mentoring skills.

Experience

• 7+ Years of Experience in data engineering and integration.

Environment

{Typical work setting, location, and other environmental conditions were not provided.}

Salary

{Estimated salary range was not provided.}

Growth Opportunities

{Potential opportunities for career advancement were not provided.}

Benefits

{Offered benefits such as insurance, paid leave, etc., were not provided.}