Hiring For Data Integration - Senior Associate - Hybrid

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.
• Strong 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.