ETL & Informatica Application Support Engineer - Virtual

Application Support Engineer

Amazing Opportunity and Great Place to Work!

Are you a fast learner who is fascinated by technology?

Our Story

At Alight, we believe a company’s success starts with its people. At our core, we Champion People, help our colleagues Grow with Purpose and true to our name we encourage colleagues to “Be Alight.”

Our Values

Champion People – be empathetic and help create a place where everyone belongs.

Grow with purpose – be inspired by our higher calling of improving lives.

Be Alight – act with integrity, be real and empower others.


It’s why we’re so driven to connect passion with purpose. Alight helps clients gain a benefits advantage while building a healthy and financially secure workforce by unifying the benefits ecosystem across health, wealth, wellbeing, absence management and navigation.

With a comprehensive total rewards package, continuing education and training, and tremendous potential with a growing global organization, Alight is the perfect place to put your passion to work.

Join our team if you Champion People, want to Grow with Purpose through acting with integrity and if you embody the meaning of Be Alight.

Learn more at careers.alight.com.

“This role supports services provided to the federal government or federal government contractor and therefore requires US Citizenship. Proof of citizenship status will be required at time of hire.”

​This is a 24x7 environment and on-call work is expected

About the Role

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.

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. 

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.