Senior Data Engineer (Must: Informatica)

Santex is a global Certified B technology company as well as one of North America's fastest-growing companies, according to the Inc. 5000. It’s present in 18 countries and over 100 cities, and headquartered in Argentina with offices in the United States, Mexico, and Peru.

Its two service lines — AI Tech Consulting and AI-Optimized Engineering — help organizations comprehensively adopt technology, expand their capabilities, and improve business outcomes at scale.

The same approach defines its culture: Santex has 80.4% employee engagement (global average: 21%), 8% annual turnover (tech sector: 20–25%), 9,369 training hours invested in 2025 — more than double the global average —, and a 26.5% year-over-year reduction in carbon footprint, achieving carbon neutrality through offsetting.

Santex. A company with purpose and judgment. Yes, it's possible.

 

We are an Equal Opportunity Employer and are committed to fostering an inclusive and diverse workplace. We do not discriminate on the basis of race, color, religion, sex, gender identity or expression, sexual orientation, national origin, age, disability, veteran status, genetic information, or any other characteristic protected by applicable law. All qualified applicants will receive consideration for employment without regard to any of these factors. We strongly encourage candidates from all backgrounds to apply.

 

Position Summary

We are seeking a Senior Informatica Data Engineer to design, develop, and support scalable enterprise data integration solutions across cloud and on-premises environments. This role will be responsible for building and optimizing ETL/ELT pipelines using Informatica technologies, Python, and SQL to support data warehousing, analytics, reporting, and business intelligence initiatives.

The ideal candidate combines deep expertise in Informatica development, advanced SQL and Python skills, cloud data platforms, and data warehouse architecture, with the ability to lead technical initiatives and mentor junior team members.

 

Key Responsibilities

• Design, develop, and maintain ETL/ELT processes using Informatica PowerCenter and/or Informatica Intelligent Data Management Cloud (IDMC/IICS).
• Build scalable data pipelines integrating data from databases, applications, APIs, cloud platforms, and flat files.
• Develop and support enterprise data warehouse, data lake, and analytics solutions.
• Create and maintain Python-based automation, data processing, validation, and monitoring solutions.
• Develop and optimize complex SQL queries, stored procedures, and database integrations.
• Implement data quality, reconciliation, and governance controls to ensure data accuracy and reliability.
• Monitor, troubleshoot, and optimize data integration workflows and platform performance.
• Partner with Data Architects, BI teams, business stakeholders, and application teams to deliver data solutions aligned with business objectives.
• Lead design reviews, establish development standards, and mentor junior data engineers.
• Support cloud modernization and migration initiatives.

 

• 8+ years of experience in Data Engineering, ETL/ELT development, or Data Integration.
• 5+ years of hands-on Informatica development experience, including PowerCenter and/or IDMC/IICS.
• 3+ years of experience developing data engineering solutions using Python.
• Strong experience with data warehouse design and dimensional modeling.
• Advanced SQL development and performance tuning experience.
• Experience working with large-scale enterprise data environments.
• Strong analytical, troubleshooting, and problem-solving skills.

 

Technical Skills

Data Integration

• Informatica PowerCenter
• Informatica IDMC / IICS
• Cloud Data Integration (CDI)
• ETL / ELT Development
• Data Quality & Data Governance

Programming & Databases

• Python
• SQL
• PySpark (preferred)
• SQL Server
• Oracle
• PostgreSQL
• Snowflake

Cloud & Analytics Platforms

• Azure, AWS, or GCP
• Snowflake
• Microsoft Fabric
• Azure Data Lake
• Azure Synapse
• Databricks

DevOps & Automation

• Git
• Azure DevOps
• CI/CD Pipelines
• REST APIs
• Shell Scripting

Preferred Qualifications

• Informatica, Azure, or Snowflake certifications.
• Experience with Databricks, Spark, and modern cloud data architectures.
• Experience with API-based integrations and workflow orchestration tools.
• Knowledge of Master Data Management (MDM), metadata management, and data governance frameworks.
• Experience leading technical projects and mentoring development teams.

Success Profile

The ideal candidate is a hands-on senior data engineer who brings expertise in Informatica, Python, SQL, and cloud data platforms, while serving as a technical leader capable of delivering scalable, high-quality data solutions that enable enterprise reporting, analytics, and business decision-making.