Data Integration & Pipeline Lead

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Leads the end-to-end technical design and implementation of Informatica ETL/ELT pipelines, including sourcing, transformations, orchestration, error handling, restartability, and downstream dependencies.
• Establishes and enforces technical standards and reusable patterns for mappings, workflows, parameterization, performance tuning, and monitoring.
• PARTNERS WITH DATA ARCHITECTS TO TRANSLATE TARGET-STATE ARCHITECTURE INTO EXECUTABLE INFORMICATADesigns, including hybrid and dual run patterns.
• Reviews and guides implementation work to ensure design integrity, scalability, and operational resilience.
• Serves as the primary technical escalation point for complex production incidents, leading deep root cause analysis and permanent remediation.
• Identifies systemic failure patterns and drive architectural or design changes to reduce recurring incidents.
• Ensures pipelines meet defined SLAs, reliability, and audit expectations, especially for regulatory and risk sensitive data flows.
• Collaborates with support and scheduling teams to ensure smooth promotion, execution, and recovery of Informatica jobs.
• Breaks down requirements into technically meaningful components and helps shape realistic estimates based on data volume, transformation complexity, dependencies, and risk.
• Coordinates closely with the Informatica Manager to surface technical risks early, enabling proactive re planning rather than late delivery issues.
• Participates in project planning, design reviews, and readiness checkpoints to ensure technical feasibility and delivery confidence.
• Communicates technical concepts clearly to delivery managers and non-technical stakeholders without over or under simplifying.
• Mentor data engineers on best practices, debugging techniques, performance optimization, and operational thinking.
• Helps reduce key person risk through documentation, standardization, and shared ownership of critical pipelines.
• Identifies and reports suspicious activity.

Modernization & Platform Evolution (as applicable)

• Identifies candidates suitable for refactoring or migration to modern data platforms.
• SUPPORTS INCREMENTAL MODERNIZATION EFFORTS BY DEFINING SAFE MIGRATION APPROACHES THAT MINIMIZE BUSINESS DISRUPTION.
• CONTRIBUTES TECHNICALLY TO INITIATIVES INVOLVING SNOWFLAKE, DBT, AWS, OR CLOUD-NATIVE TOOLS, WHERE APPLICABLE.