Senior Application Support Data Engineer (Informatica Powercenter & PowerBI)

Publicis Groupe · Mexico City

Company description

Publicis Sapient is a digital transformation partner helping established organizations get to their future, digitally enabled state, both in the way they work and the way they serve their customers. We help unlock value through a start-up mindset and modern methods, fusing strategy, consulting, and customer experience with agile engineering and problem-solving creativity. United by our core values and our purpose of helping people thrive in the brave pursuit of next, our 20,000+ people in 53 offices around the world combine experience across technology, data sciences, consulting, and customer obsession to accelerate our clients’ businesses through designing the products and services their customers truly value.

Overview

Publicis Sapient is seeking a Senior Lead Application Support Data Engineer (Informatica PowerCenter & Power BI) to provide advanced production support, operational ownership, and incident management across enterprise data and integration platforms.

This role is primarily focused on supporting and maintaining critical ETL, data integration, and reporting environments, with Informatica serving as the core technology. The successful candidate will be responsible for incident resolution, root cause analysis, platform support, change management, deployment validation, and operational excellence across business-critical systems. Exposure to Power BI, MuleSoft, and Automation Anywhere is highly valued, but the ability to quickly learn and support additional platforms is equally important.

The ideal candidate combines strong troubleshooting capabilities, enterprise support experience, and deep Informatica expertise, with a willingness to ramp up on adjacent technologies within the platform ecosystem.

Responsibilities

Your Impact

Lead operational support across enterprise BI, ETL, API, and RPA platforms ensuring platform stability and SLA compliance.
Own end-to-end resolution of critical production incidents, including executive communications, bridge management, and permanent corrective actions.
Drive root cause analysis activities across multiple technology stacks and coordinate long-term remediation strategies.
Govern production releases, deployment pipelines, change approvals, and environment promotion processes.
Partner with infrastructure, development, database, cloud, and vendor teams to resolve complex technical issues.
Lead platform upgrade initiatives, capacity reviews, performance optimization efforts, and operational readiness activities.
Mentor L1 and L2 support engineers while establishing operational standards, runbooks, and knowledge management practices.
Identify automation opportunities and implement self-healing, monitoring, and operational efficiency improvements.

Qualifications

Key Responsibilities

Business Intelligence & Analytics Platforms

Administer and support Power BI workspaces, datasets, data gateways, Fabric capacity, deployment pipelines, tenant governance, and REST API automation.
Monitor and troubleshoot scheduled refreshes, subscription failures, data availability issues, and reporting performance concerns.
Administer Tableau Server environments, TSM operations, extract refreshes, subscriptions, platform upgrades, and capacity management.
Support SSRS reporting environments including subscriptions, execution logs, caching, snapshots, and report delivery services.

Data Integration & ETL Platforms

Support Informatica PowerCenter workflows, sessions, parameter files, workflow monitoring, and performance troubleshooting.
Administer Informatica Intelligent Cloud Services (IICS) mapping tasks, taskflows, secure agents, execution monitoring, and integration operations.
Troubleshoot ETL failures, performance bottlenecks, source-to-target discrepancies, and data integrity issues.
Partner with business and technical teams to validate critical enterprise data processing activities.

API & Integration Platforms

Monitor MuleSoft APIs and integrations using Anypoint Platform, Anypoint Monitoring, Splunk, and AppDynamics.
Support MuleSoft deployment pipelines, API Manager configuration, runtime environments, policies, connectors, and DataWeave transformations.
Troubleshoot integration failures, API performance issues, connectivity problems, and platform incidents.
Support CloudHub and Runtime Fabric deployment and operational activities.

Intelligent Automation Platforms

Administer Automation Anywhere Control Room environments including Bot Runners, queues, schedules, credentials, lockers, and device pools.
Support Agent Automation, AI Skills, AI Agent Studio, AARI, Document Automation, and IQ Bot capabilities.
Troubleshoot automation failures, exception handling issues, scheduling problems, and platform performance concerns.
Lead upgrade, patching, licensing, and capacity planning activities across automation environments.

Incident, Change & Service Management

Lead major incident response and cross-functional war-room activities for enterprise-critical outages.
Drive permanent-fix initiatives through structured problem management and RCA ownership.
Review, approve, and govern production change requests and deployment activities.
Ensure compliance with ITIL, change management, release management, and operational governance processes.
Own vendor escalations and coordinate resolution activities with Microsoft, Informatica, Salesforce/MuleSoft, and Automation Anywhere.

Platform Leadership & Operational Excellence

Drive continuous improvement initiatives focused on reliability, observability, automation, and service quality.
Establish operational best practices, standards, and governance frameworks.
Lead capacity planning, scalability reviews, platform health assessments, and operational maturity initiatives.
Serve as the technical escalation point for complex production issues.
Coach and mentor support engineers while improving team effectiveness and technical capabilities.

Skills & Experience

Required

6-8+ years supporting enterprise applications, ETL environments, or data platforms in production environments.
Strong hands-on experience with Informatica PowerCenter and/or Informatica IICS, including troubleshooting, workflow monitoring, incident resolution, and operational support.
Strong SQL expertise including query troubleshooting, stored procedures, data validation, and performance analysis.
Experience performing Root Cause Analysis (RCA), incident management, and production issue resolution.
Experience supporting enterprise platforms operating under SLAs and change management processes.
Knowledge of ITIL-aligned operational support practices.
Strong analytical, troubleshooting, and problem-solving skills.
Excellent communication, stakeholder management, and cross-functional collaboration skills.
Demonstrated ability to learn and support new enterprise platforms and technologies.

Preferred

Experience supporting Power BI environments, reporting platforms, or business intelligence solutions.
Exposure to MuleSoft integrations, APIs, or enterprise integration platforms.
Exposure to Automation Anywhere 360 or other RPA platforms.
Experience with monitoring and observability tools such as Splunk, AppDynamics, ELK, or similar technologies.
Experience working with CI/CD pipelines, release management, and deployment processes.
Experience mentoring support analysts or participating in operational knowledge-sharing initiatives.

Additional information

An inclusive workplace that promotes diversity and collaboration.
Access to ongoing learning and development opportunities.
Competitive compensation and benefits package.
Flexibility to support work-life balance.
Comprehensive health benefits for you and your family.
Generous paid leave and holidays.
Wellness program and employee assistance.

As part of our dedication to an inclusive and diverse workforce, Publicis Sapient is committed to Equal Employment Opportunity without regard for race, color, national origin, ethnicity, gender, protected veteran status, disability, sexual orientation, gender identity, or religion. We are also committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, you may contact us at hiring@publicis.sapient.com