Senior Data Engineering Technical Lead – Informatica IDMC & AWS | Remote 2866

We are looking for an experienced Senior Data Engineering Technical Lead with 8+ years of experience to lead and organize a team of data engineers and IDMC administrators. This role requires strong hands-on expertise in Informatica IDMC Full Stack, AWS data services, data integration, data quality, and modern data platform architectures.

The ideal candidate will act as the technical reference for the team, driving data integration initiatives, defining technical standards and best practices, leading modernization projects, and ensuring the end-to-end delivery of enterprise data products.

Key Responsibilities:

• Lead and organize a team of 9 engineers, including data integration developers and IDMC administrators.
• Provide technical leadership for enterprise data integration initiatives using Informatica IDMC.
• Lead the development of data pipelines using Cloud Data Integration (CDI) and Cloud Mass Ingestion (CMI).
• Extract, transform, and deliver data from heterogeneous source systems into Amazon Redshift and Denodo Data Marketplace.
• Define technical standards, development patterns, architectures, and best practices.
• Lead end-to-end development of data products, from source discovery and ingestion to curated models and governed datasets.
• Oversee platform maintenance and support, including L2/L3 incident resolution, RCA, problem and change management, monitoring, and continuous improvement.
• Define and implement methodologies for ETL migration and modernization projects.
• Lead workload assessment, migration strategy, conversion, validation, parallel runs, cutover, and rollback activities.
• Collaborate with technical and business stakeholders and provide technical estimations and proposal reviews.
• Mentor data engineering teams and promote engineering best practices.

Technical Skills Required:

Informatica IDMC – Full Stack:

• Cloud Data Integration (CDI)
• Mapping and Mapping Task development
• Taskflow orchestration
• Pushdown optimization
• Parameterization and reusable assets
• Hierarchical and complex-file processing
• Performance tuning
• Dev / QA / Production promotion

Cloud Mass Ingestion (CMI):

• Database, file, application, and streaming ingestion
• Initial loads and incremental CDC
• Oracle
• Redshift
• SQL
• Schema-drift handling
• Amazon S3 integration

Cloud Application Integration (CAI):

• Process and service-connector design
• REST / SOAP APIs
• Event-driven orchestration
• Near-real-time integration

Cloud Data Quality (CDQ):

• Data profiling
• Quality rule specifications
• Scorecards
• Data quality remediation
• Integration of quality controls into data pipelines

IDMC Administration:

• Secure Agent sizing
• Runtime environment groups
• Connections and asset management
• RBAC
• License / IPU consumption monitoring
• Operational Insights
• Upgrade planning

Data Engineering & Cloud:

• AWS Glue
• Amazon S3
• Amazon Redshift
• AWS Step Functions
• Amazon Athena
• AWS Lake Formation
• AWS SageMaker
• AWS Bedrock
• AWS Secrets Manager
• Databricks / Lakehouse
• Medallion Architecture: Bronze / Silver / Gold
• Data modeling
• Semantic layers
• Power BI

Nice to Have:

• Terraform
• CloudFormation
• Informatica AI-assisted development / CLAIRE
• Informatica Cloud Data Integration Developer Professional Certification
• Informatica IDMC Foundation
• Informatica CDGC Foundation
• IDMC for Databricks Foundation
• Informatica Cloud Data Governance & Catalog Professional Certification

Qualifications:

• 8+ years of professional experience
• Proven experience leading data engineering teams
• Strong hands-on experience with Informatica IDMC Full Stack
• Experience with enterprise data platforms and cloud environments
• Experience in financial or highly regulated environments
• Experience mentoring teams of 5+ engineers
• Strong technical leadership and stakeholder management skills
• Advanced English (mandatory)

Location & Schedule:

• Remote position
• Candidates must currently reside in Mexico
• Monday to Friday, 09:00 – 18:00 hrs
• Advanced English is mandatory