Data Integration & Pipeline Lead

SUMMARY: We are seeking an Informatica Technical Lead to provide hands on technical leadership across our enterprise data integration platform. This role is responsible for the design, build, stability, and technical evolution of Informatica-based data pipelines while partnering closely with architecture, platform leadership, and delivery managers. This is a technical leadership role-not a people management role. The Technical Lead sets the technical bar, ensures production stability, mentors engineers, and coordinates execution across teams, while delivery ownership and people management remain with the Informatica Manager.

The role supports a hybrid environment that includes Informatica (Power Center / IDMC) and possibly a gradual evolution toward modern cloud and analytics platforms (Snowflake, dbt).

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties and special projects may be assigned.

• Technical Ownership & Delivery:
• 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 Informatica designs, including hybrid and dual run patterns.
• Reviews and guides implementation work to ensure design integrity, scalability, and operational resilience.
• Production Stability & Support:
• 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.
• Estimation, Planning & Coordination:
• 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.
• Mentorship & Technical Quality:
• Mentor data engineers on best practices, debugging techniques, performance optimization, and operational thinking.
• Raises overall team capability through design reviews, knowledge sharing, and consistent technical guidance.
• Help reduce key person risk through documentation, standardization, and shared ownership of critical pipelines.
• 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.
• Adheres to and complies with applicable, federal and state laws, regulations and guidance, including those related to anti-money laundering (i.e. Bank Secrecy Act, US PATRIOT Act, etc.).
• Adheres to Bank policies and procedures and completes required training.
• Identifies and reports suspicious activity.

EDUCATION

Bachelor's Degree preferred Master's Degree is a plus

EXPERIENCE

• 7+ years of experience in data engineering or data integration, with deep hands on experience using Informatica Power Center and/or IDMCrequired
• Proven experience supporting business critical, regulated datasets in production environmentsrequired
• Exposure to modern analytics and cloud platforms such as Snowflake, dbt, and AWS preferred
• Experience working in banking or…