Alight is seeking an experienced ETL/Informatica Application Support Engineer with strong analytical and problem‑solving capabilities, excellent troubleshooting skills, and the ability to drive stability and continuous improvement in production environments. This role requires a proactive, self‑motivated professional who can work independently in a fast‑paced operational landscape while delivering high‑quality support and enhancements.
The Application Support ETL & Informatica Engineer will serve as a technical leader within the Applications Support team.
The individual will be involved in the following critical support and operational activities:
-
Monitor, support, and troubleshoot ETL and data integration workflows across production, QA, and development environments to ensure smooth daily operations.
-
Analyze and resolve incidents, job failures, and performance issues related to Informatica workflows, mappings, and SQL jobs.
-
Own and maintain ETL components including Informatica mappings, metadata, scripts, schedules, and operational procedures. Identify opportunities to optimize performance, scalability, and reliability of existing jobs/processes.
-
Ensure stability of data ingestion pipelines spanning batch, near‑real‑time, and real‑time patterns. Fine‑tune ETL solutions by developing a deep technical understanding of data flows and upstream/downstream dependencies.
-
Collaborate with DBAs and Data Architects to implement appropriate data partitioning, indexing, and optimization strategies to enhance job performance.
-
Develop or modify SQL scripts, stored procedures, database triggers, and queries as part of incident resolution, change requests, or performance tuning.
-
Work closely with cross‑functional and offshore teams, ensuring timely resolution of issues, clear communication, and adherence to support SLAs and operational guidelines.
-
Manage multiple concurrent support tickets, change requests, and enhancement tasks, balancing priorities based on business impact and urgency.
-
Ensure compliance with published support, development, coding, and testing standards, as well as change management practices.
-
Strong analytical thinker with the ability to troubleshoot complex data and integration issues effectively.
-
Flexible, adaptable, and pragmatic, with the ability to remain focused on objectives while handling shifting priorities.
-
5+ years of experience in ETL application support, Informatica PowerCenter/Cloud, and SQL Server in production environments.
-
Practical experience with SQL Server, including schema understanding, stored procedure development, query tuning, and optimization.
-
Hands‑on experience with job scheduling tools such as Control‑M or AutoSys for monitoring and support automation.
-
Excellent communication skills and ability to work both independently and as part of a distributed/onshore‑offshore team.
-
Bachelor’s degree in a technology or engineering field.
We offer you a competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization.
DISCLAIMER:
Nothing in this job description restricts management's right to assign or reassign duties and responsibilities of this job to other entities; including but not limited to subsidiaries, partners, or purchasers of Alight business units.
.
