Alight Solutions

Alight Inc. (NYSE: ALIT) is a leading cloud-based human capital technology and services provider

ETL, Informatica Application Support Analyst

Support EngineerSupport EngineerFull TimeRemoteTeam 10,001+Since 2016H1B SponsorCompany SiteLinkedIn

Location

Illinois

Posted

2 days ago

Salary

$110K - $130K / year

Bachelor Degree3 yrs expEnglishCloudETLInformaticaSQL

Job Description

• 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, near-realtime, and realtime 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

Job 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
  • Hands-on 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

Benefits

  • 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
  • Number of voluntary benefit options

Related Categories

Related Job Pages

More Support Engineer Jobs

Lead EMR Systems and Support Analyst

Natera

We are a global leader in cell-free DNA (cfDNA) testing, dedicated to oncology, women’s health, and organ health.

Support Engineer2 days ago
Full TimeRemoteTeam 1,001-5,000Since 2004H1B Sponsor

Lead EMR Support Analyst at Natera managing EMR integrations and escalations

United States
$128.4K - $160.5K / year
Full TimeRemoteTeam 1,001-5,000

Responsibilities include providing exceptional customer service in a phone-based environment while accurately entering high volumes of prescription data and utilizing drug knowledge for authorizations and transfers. Technicians will also perform claim adjudication, audit duties, and work through case queues to resolve patient care issues.

Pharmacy Technician CertificationData EntryPrescription ProcessingClaims AdjudicationPatient CommunicationPharmacy BillingDrug KnowledgeCustomer ServicePharmacy Software Systems
United States

Technical Support Specialist

Smardt Chiller Group

Revolutionary energy savings from the global no.1 in oil-free chillers

Support Engineer2 days ago
Full TimeRemoteTeam 501-1,000Since 2005H1B No Sponsor

We're Looking For a Technical Support Specialist to work with the Technical Support Manager - West on matters that escalate above the Commercial Business Unit (Service) level in your coverage area (AMER/EMEA), with an emphasis on the North America region and equipment sold in the...

chillersmagnetic bearing compressorstroubleshootingRCA8Dengineeringmanufacturingquality assurancecustomer relations
United States

ETL & Informatica Application Support Engineer

Alight Solutions

Alight Inc. (NYSE: ALIT) is a leading cloud-based human capital technology and services provider

Support Engineer2 days ago
Full TimeRemoteTeam 10,001+Since 2016H1B Sponsor

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

ETLInformatica PowerCenterSQL ServerControl-MAutoSysSQLTroubleshootingPerformance Tuning
United States