ETL & Informatica Application Support Analyst - Virtual

Alight Solutions

3d • Remote

About The Position

Alight is looking for an ETL/Informatica Application Support Engineer with strong analytical skills, excellent troubleshooting abilities, and a proactive approach. The ideal candidate will drive stability and continuous improvement in production environments, working independently in a fast-paced setting while delivering high-quality support within the Applications Support team. The IT Support Engineer is part of a team responsible for 24X7 customer support for Alight’s proprietary Leave of Absence Management software platforms, including troubleshooting and resolving incoming issues upon first contact within the team whenever possible; documenting tickets with triage information before escalating to next tier; providing ongoing support until issues are resolved.

Requirements

• 3-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.
• Handson experience with job scheduling tools such as ControlM or AutoSys for monitoring and support automation.
• Excellent communication skills and ability to work both independently and as part of a distributed global team.
• Strong analytical thinkers 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.

Responsibilities

• Monitor, support, and troubleshoot ETL and data integration workflows across production, QA, and development environments to ensure smooth daily operations.
• Analyse 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, nearrealtime, and realtime patterns.
• Finetune 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.

Benefits

• We offer programs and plans for a healthy mind, body, wallet and life because it’s important our benefits care for the whole person. Options include a variety of health coverage options, wellbeing and support programs, retirement, vacation and sick leave, maternity, paternity & adoption leave, continuing education and training as well as a number of voluntary benefit options.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed