Responsibilities

- Administer, configure, and maintain the Informatica platform (Informatica IDMC), including environment setup, upgrades, patching, connectivity, monitoring, and overall platform health.

- Design, develop, and maintain ELT and ETL data integration workflows using Informatica, dbt and Snowflake, ensuring efficient, reusable, and well-documented transformation logic.

- Build and maintain scalable ingestion, orchestration, and transformation patterns to integrate data from diverse sources into the enterprise data platform and develop reusable templates/modules to accelerate onboarding and delivery.

- Build and maintain CI/CD for data integration assets and pipeline deployments, promoting consistent, automated, and reliable releases.

- Partner with security and governance stakeholders to administer platform access, including role-based access control (RBAC), user onboarding, connection management, and remediation of security incidents on the Informatica platform.

- Optimize cost and performance in Informatica through proactive resource and IPU monitoring and mapping, transformation and task optimization.

- Optimize cost and performance across Snowflake warehouses, queries, and data loads; recommend and deploy schema changes (tables, views, materialized views, etc.); and perform query tuning and optimization for ELT and ETL workloads.

- Implement data quality and data observability checks within integration pipelines and integrate with enterprise monitoring and alerting.

- Manage service requests, change requests, and incident management, including Major Incident Management (MIM) with Root Cause Analysis (RCA) and remediation; create and maintain documentation for Informatica configurations, dbt models, integration workflows, and operational runbooks.





- Weekly operational reporting on service request status, incident management, RCA tickets, platform improvements, and platform consumption (FinOps) monitoring.

- Mentor associate engineers; contribute to data integration standards, best practices, and documentation.

Skills

- Strong data integration and platform engineering background with 5+ years of relevant experience.

- Hands-on experience administering the Informatica platform (Informatica IDMC, CIH) is required.

- Hands-on Snowflake experience is required, with a focus on ELT and ETL development and maintenance.

- Strong hands-on experience with dbt for building and maintaining data transformation models.

- Proficiency in SQL and Python for data processing and automation.

- Proven experience with API-based data ingestion (REST APIs, JSON/XML) and integrating diverse source systems.

- Strong understanding of ETL/ELT patterns, data modeling, and the end-to-end data lifecycle.

- Experience implementing and maintaining CI/CD and environment management for data integration solutions.

- Solid operational discipline: incident management, problem management, and release/change practices; familiarity with cloud data platforms (Azure, AWS).

- Agile/Scrum delivery exposure.

Education / Professional Experience/ Qualifications

- Bachelors degree in Information Technology, Computer Science, Engineering, or related discipline.

- Hands-on experience administering and supporting the Informatica platform (Informatica IDMC) in enterprise environments.

- Hands-on experience with Snowflake and dbt for ELT and ETL development and maintenance.

- Experience with enterprise authentication/authorization patterns, RBAC, and secrets management; exposure to FinOps practices for platform consumption.

📌 Hiring For Data Integration - Senior Associate - Hybrid (Hyderabad)
🏢 Grant Thornton
📍 Hyderabad