Senior ETL Developer: Informatica PowerCenter & SQL Server

Publicis Sapient; United States; On-site; MXN 600,000 - 900,000; Full time

Benefits offered by this job

Comprehensive health benefits

Generous paid leave and holidays

Wellness program and employee support

Flexible work-life balance

Job summary

Publicis Sapient in Mexico City is seeking a Senior ETL Developer to maintain and evolve enterprise financial data pipelines within a regulated environment. You will contribute to modernization efforts, including migrations from Sybase to SQL Server, and provide L2/L3 support across project delivery and production operations.

You will design, develop, and optimize ETL workflows using Informatica PowerCenter, troubleshoot batch loads, and collaborate in a Scrum team with autonomy to own

Qualifications

• 6–7 years of ETL development experience.
• 2–3 years of hands-on Informatica PowerCenter experience (must-have).
• Strong SQL skills.
• Experience migrating or refactoring ETL from legacy databases (Sybase → SQL Server).
• Experience with batch processing and file-based integrations.
• Experience with enterprise job schedulers, shell scripting, SFTP, and Git.
• Experience working in regulated data-heavy environments and with remote Agile/Scrum teams.

Responsibilities

• Design and support inbound and outbound data feeds.
• Develop and maintain ETL workflows in Informatica PowerCenter.
• Troubleshoot failed or delayed batch loads.
• Support file-based integrations and vendor feeds.
• Refactor and migrate ETL processes from Sybase to SQL Server.
• Collaborate as an active member of a Scrum team.
• Take ownership of deliverables with a high level of autonomy.

Skills

ETL development

SQL

Shell scripting

SFTP

Git

Agile/Scrum collaboration

Data issue troubleshooting

Sybase to SQL Server migration

Remote/Distributed teams

Regulated environment experience

Tools

Informatica PowerCenter

Job description

Publicis Sapient in Mexico City is seeking a Senior ETL Developer to maintain and evolve enterprise financial data pipelines within a regulated environment. You will contribute to modernization efforts, including migrations from Sybase to SQL Server, and provide L2/L3 support across project delivery and production operations.

You will design, develop, and optimize ETL workflows using Informatica PowerCenter, troubleshoot batch loads, and collaborate in a Scrum team with autonomy to own