Application Support ETL & Informatica Engineer

Alight, Inc.
Center Township, United States of America
5 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Center Township, United States of America

Tech stack

CA Workload Automation Ae
Cloud Computing
Data Integration
ETL
Job Scheduling
Microsoft SQL Server
Performance Tuning
Query Optimization
SQL Stored Procedures
SQL Databases
Data Streaming
Informatica Powercenter
Indexer
Database Rules and Triggers
Data Pipelines
Control M

Job description

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.

Key Responsibilities

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.

Requirements

  • 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.

Benefits & conditions

We offer you a competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization.

Apply for this position