Application Support ETL & Informatica Engineer

As an experienced ETL/Informatica Application Support Engineer at Alight, you will be responsible for ensuring smooth daily operations, driving stability, and continuous improvement in production environments. Your role will involve monitoring, supporting, and troubleshooting ETL and data integration workflows across various environments, resolving incidents and performance issues, and optimizing existing jobs and processes. You will collaborate with cross-functional teams, manage support tickets, and ensure compliance with established standards and practices. Key Responsibilities: - Monitor, support, and troubleshoot ETL and data integration workflows across production, QA, and development environments. - Analyze and resolve incidents, job failures, and performance issues related to Informatica workflows, mappings, and SQL jobs. - Own and maintain ETL components, identify optimization opportunities, and ensure stability of data ingestion pipelines. - Collaborate with DBAs and Data Architects to implement data partitioning, indexing, and optimization strategies. - Develop or modify SQL scripts, stored procedures, and queries for incident resolution and performance tuning. - Manage multiple support tickets, change requests, and enhancement tasks, ensuring compliance with support SLAs and operational guidelines. Qualifications Required: - 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, and query tuning. - Hands-on experience with job scheduling tools such as Control-M or AutoSys. - Bachelors degree in a technology or engineering field. Additional Details: Alight offers a competitive total rewards package, continuing education & training opportunities, and tremendous potential for growth within a growing worldwide organization. (Note: The disclaimer section has been omitted as it does not contain relevant job description information) As an experienced ETL/Informatica Application Support Engineer at Alight, you will be responsible for ensuring smooth daily operations, driving stability, and continuous improvement in production environments. Your role will involve monitoring, supporting, and troubleshooting ETL and data integration workflows across various environments, resolving incidents and performance issues, and optimizing existing jobs and processes. You will collaborate with cross-functional teams, manage support tickets, and ensure compliance with established standards and practices. Key Responsibilities: - Monitor, support, and troubleshoot ETL and data integration workflows across production, QA, and development environments. - Analyze and resolve incidents, job failures, and performance issues related to Informatica workflows, mappings, and SQL jobs. - Own and maintain ETL components, identify optimization opportunities, and ensure stability of data ingestion pipelines. - Collaborate with DBAs and Data Architects to implement data partitioning, indexing, and optimization strategies. - Develop or modify SQL scripts, stored procedures, and queries for incident resolution and performance tuning. - Manage multiple support tickets, change requests, and enhancement tasks, ensuring compliance with support SLAs and operational guidelines. Qualifications Required: - 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, and query tuning. - Hands-on experience with job scheduling tools such as Control-M or AutoSys. - Bachelors degree in a technology or engineering field. Additional Details: Alight offers a competitive total rewards package, continuing education & training opportunities, and tremendous potential for growth within a growing worldwide organization. (Note: The disclaimer section has been omitted as it does not contain relevant job description information)