CrawlJobs Logo
Alight Solutions Logo Alight Solutions · IT - Administration

ETL & Informatica Application Support Engineer

United States of America, Virtual 110000.00 - 130000.00 USD / Year · Job Posted March 19, 2026
Apply Position
Job Link Share

Job Description

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.

Job Responsibility

  • 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
  • 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
  • US Citizenship required

What we offer

  • A variety of health coverage options
  • wellbeing and support programs
  • retirement
  • vacation and sick leave
  • maternity, paternity & adoption leave
  • continuing education and training
  • voluntary benefit options
Alight Solutions - All Job Offers

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Suggested Tags: Frontend Developer Secretary Talent Manager Salesforce Administrator Data Analyst
Similar Jobs for

ETL & Informatica Application Support Engineer

8 matching positions

Senior .NET Production Application Support Engineer

The Senior .NET Production Application Support Engineer will ensure the stabilit...
Location
Location
Canada , Halifax
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5+ years experience in .NET Production application support
  • 3+ years experience with ETL tools such as Informatica or Microsoft SSIS
  • 1+ year experience with AWS cloud services
  • Strong expertise in .NET and ETL tools (Informatica or SSIS)
  • Proficiency in multiple programming languages: .NET, C#, VB.NET, VB6, JavaScript, HTML
  • Ability to troubleshoot and optimize cloud data pipelines for performance, security, and reliability
  • Skilled in query performance optimization and database tuning
  • Experience in upgrading, configuring, and debugging existing systems
  • Strong problem-solving skills for triaging complex issues and handling escalations
  • Familiarity with modern data security and privacy practices
Job Responsibility
Job Responsibility
  • Monitor and maintain assigned production systems to ensure optimal performance and SLA compliance
  • Investigate, troubleshoot, and resolve application and data pipeline issues within agreed timelines
  • Provide customer-focused support, ensuring timely communication and resolution of incidents
  • Review existing systems and propose/implement enhancements for scalability and reliability
  • Perform root cause analysis and recommend break-fix solutions for code and database issues
  • Collaborate with cross-functional teams including business, risk, and IT stakeholders
  • Participate in on-call rotations and provide support during off-hours/weekends as needed
  • Document incidents, resolutions, and system changes for knowledge base and audit purposes
  • Fulltime
Read More
Arrow Right

Senior Production Support Engineer

We are seeking a Senior Production Support Engineer to ensure the stability, per...
Location
Location
Canada , Halifax
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5+ years experience in .NET Production application support
  • 3+ years experience with ETL tools such as Informatica or Microsoft SSIS
  • 1+ year experience with AWS cloud services
  • Minimum 5 years Application Management experience
  • Minimum 3 years Data Intelligence Management
Job Responsibility
Job Responsibility
  • Monitor and maintain assigned production systems to ensure optimal performance and SLA compliance
  • Investigate, troubleshoot, and resolve application and data pipeline issues within agreed timelines
  • Provide customer-focused support, ensuring timely communication and resolution of incidents
  • Review existing systems and propose/implement enhancements for scalability and reliability
  • Perform root cause analysis and recommend break-fix solutions for code and database issues
  • Collaborate with cross-functional teams including business, risk, and IT stakeholders
  • Participate in on-call rotations and provide support during off-hours/weekends as needed
  • Document incidents, resolutions, and system changes for knowledge base and audit purposes
  • Fulltime
Read More
Arrow Right

Production Support Engineer

The Production Support Engineer will ensure the stability, performance, and reli...
Location
Location
Canada , Vancouver
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Minimum 5 years Application Management experience
  • 4+ years experience in .NET Production application support
  • 2+ years experience with ETL tools such as Informatica or Microsoft SSIS
  • 1+ year experience with AWS cloud services
  • Strong expertise in .NET and ETL tools (Informatica or SSIS)
  • Proficiency in multiple programming languages: .NET, C#, VB.NET, VB6, JavaScript, HTML
  • Ability to troubleshoot and optimize cloud data pipelines for performance, security, and reliability
  • Skilled in query performance optimization and database tuning
  • Experience in upgrading, configuring, and debugging existing systems
  • Strong problem-solving skills for triaging complex issues and handling escalations
Job Responsibility
Job Responsibility
  • Monitor and maintain assigned production systems to ensure optimal performance and SLA compliance
  • Investigate, troubleshoot, and resolve application and data pipeline issues within agreed timelines
  • Provide customer-focused support, ensuring timely communication and resolution of incidents
  • Review existing systems and propose/implement enhancements for scalability and reliability
  • Perform root cause analysis and recommend break-fix solutions for code and database issues
  • Collaborate with cross-functional teams including business, risk, and IT stakeholders
  • Participate in on-call rotations and provide support during off-hours/weekends as needed
  • Document incidents, resolutions, and system changes for knowledge base and audit purposes
  • Fulltime
Read More
Arrow Right

Senior Production Support Engineer

The Senior Production Support Engineer will ensure the stability and performance...
Location
Location
Mexico , Mexico City
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5+ years experience in .NET Production application support
  • 3+ years experience with ETL tools such as Informatica or Microsoft SSIS
  • 1+ year experience with AWS cloud services
  • Strong expertise in .NET and ETL tools (Informatica or SSIS)
  • Proficiency in multiple programming languages: .NET, C#, VB.NET, VB6, JavaScript, HTML
  • Ability to troubleshoot and optimize cloud data pipelines for performance, security, and reliability
  • Skilled in query performance optimization and database tuning
  • Experience in upgrading, configuring, and debugging existing systems
  • Strong problem-solving skills for triaging complex issues and handling escalations
  • Familiarity with modern data security and privacy practices
Job Responsibility
Job Responsibility
  • Monitor and maintain assigned production systems to ensure optimal performance and SLA compliance
  • Investigate, troubleshoot, and resolve application and data pipeline issues within agreed timelines
  • Provide customer-focused support, ensuring timely communication and resolution of incidents
  • Review existing systems and propose/implement enhancements for scalability and reliability
  • Perform root cause analysis and recommend break-fix solutions for code and database issues
  • Collaborate with cross-functional teams including business, risk, and IT stakeholders
  • Participate in on-call rotations and provide support during off-hours/weekends as needed
  • Document incidents, resolutions, and system changes for knowledge base and audit purposes
Read More
Arrow Right

Senior Production Support Engineer

The Senior Production Support Engineer will ensure the stability and performance...
Location
Location
Canada , Vancouver
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Minimum of 4 years experience in .NET Production application support
  • 2+ years experience with ETL tools such as Informatica or Microsoft SSIS
  • 1+ year experience with AWS cloud services
  • Strong expertise in .NET and ETL tools (Informatica or SSIS)
  • Proficiency in multiple programming languages: .NET, C#, VB.NET, VB6, JavaScript, HTML
  • Ability to troubleshoot and optimize cloud data pipelines for performance, security, and reliability
  • Skilled in query performance optimization and database tuning
  • Experience in upgrading, configuring, and debugging existing systems
  • Strong problem-solving skills for triaging complex issues and handling escalations
  • Familiarity with modern data security and privacy practices
Job Responsibility
Job Responsibility
  • Monitor and maintain assigned production systems to ensure optimal performance and SLA compliance
  • Investigate, troubleshoot, and resolve application and data pipeline issues within agreed timelines
  • Provide customer-focused support, ensuring timely communication and resolution of incidents
  • Review existing systems and propose/implement enhancements for scalability and reliability
  • Perform root cause analysis and recommend break-fix solutions for code and database issues
  • Collaborate with cross-functional teams including business, risk, and IT stakeholders
  • Participate in on-call rotations and provide support during off-hours/weekends as needed
  • Document incidents, resolutions, and system changes for knowledge base and audit purposes
  • Fulltime
Read More
Arrow Right
New

Senior Data Engineer

At Schwab, you’re empowered to make an impact on your career. Here, innovative t...
Location
Location
United States , Southlake
Salary
Salary:
164000.00 - 183000.00 USD / Year
schwab.com Logo
Charles Schwab
Expiration Date
June 22, 2026
Flip Icon
Requirements
Requirements
  • Bachelor of Science in Computer Science or a related field
  • The ideal candidate should have at least 7+ years of data engineering experience, 5+ years development experience and 3 years or more experience with Postgres database management. The candidate must additionally have experience with Oracle, SQL Server, MySQL, and/or Mongo DB
  • Must have worked as alongside a business vertical to establish nomenclature, data catalogs, provenance, standards, semantics and usage of data
  • Deep knowledge and experience with query development and optimization (SQL, PL/SQL, and No SQL)
  • Experience in performance-tuning database applications is a MUST
  • Experience in multi-datacenter DB installations, disaster recovery, and replication techniques
  • Advanced knowledge of database backup and recovery strategies
  • Ability to work in a Unix environment including an ability to write scripts in Unix
  • Provide database technical support for Technology and Application Delivery projects
  • Must have excellent written and verbal communications skills
Job Responsibility
Job Responsibility
  • Define and maintain conceptual, logical, and physical database models by working with business stakeholders and identifying optimal database specifications. Ensures that database design and system capabilities meet validated user requirements. Work with application development teams designing, developing, and enhancing database schemas, creating database views, helping with query optimization, and figuring out ways to increase application performance. Enhance and recommend solutions / processes for downstream impact analysis associated with data and/or model changes. Support, maintain and enhance applications (when necessary) written with ETL tools such as Informatica, Airflow, Snowflake and additionally support teams using custom ingestion and transformation processes. Collaborate with enterprise stakeholders to implement and adhere to data storage standards and maintain catalogs to facilitate consistent data management practices. Establish data quality metrics and monitoring processes to proactively identify and resolve data quality issues. Work with various IT departments within Schwab to perform preventive and corrective maintenance and incident management measures. Ensure database integrity, availability, and restorability by working with enterprise operational excellence teams. Evaluates the integration of new tools or technologies based on the capabilities of the existing infrastructure. Recommend solutions and help with functional and performance testing needs (mock data, test environments, data refresh processes). Responsible for coordination of planning the installation of operating systems, databases, applications, development upgrades, and new releases. Follow and develop database standards, guidelines, and best practices. Establishes standards, controls, and procedures to ensure data integrity and security. Perform capacity planning and projection for future growth. And finally, be able to work in an Agile Scrum environment
What we offer
What we offer
  • 401(k) with company match and Employee stock purchase plan
  • Paid time for vacation, volunteering, and 28-day sabbatical after every 5 years of service for eligible positions
  • Paid parental leave and family building benefits
  • Tuition reimbursement
  • Health, dental, and vision insurance
  • Medical, dental and vision benefits
  • 401(k) and employee stock purchase plans
  • Tuition reimbursement to keep developing your career
  • Paid parental leave and adoption/family building benefits
  • Sabbatical leave available after five years of employment
  • Fulltime
Read More
Arrow Right
New

Enterprise Architect 3, MDM

Enterprise Architect III, Master Data Management (Remote, Texas). Lead Enterpris...
Location
Location
United States , Austin
Salary
Salary:
82.66 USD / Hour
mmcgrp.com Logo
MMC Group LP
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 8+ years designing and implementing Master Data Management (MDM) solutions
  • 8+ years developing enterprise ETL solutions using Informatica
  • 8+ years of advanced Informatica development experience
  • 8+ years implementing Enterprise Information Management (EIM) best practices
  • 8+ years designing custom Informatica PowerCenter solutions
  • 8+ years working with enterprise data modeling tools such as Erwin or ERStudio
  • Strong technical writing, communication, and presentation skills
  • Demonstrated ability to work effectively with executive leadership, technical teams, and business stakeholders
  • Proven success managing multiple priorities in complex enterprise environments
Job Responsibility
Job Responsibility
  • Design and implement enterprise Master Data Management (MDM) solutions using the Informatica Intelligent Data Management Cloud (IDMC) platform
  • Architect scalable solutions supporting healthcare provider, member, and reference data domains
  • Design and develop ETL processes using Informatica, Oracle, and Snowflake technologies
  • Lead implementation of enterprise metadata management and data governance initiatives
  • Develop and enhance MDM application components and integrations
  • Create logical and physical data models using Erwin, ERStudio, or equivalent modeling tools
  • Partner with business analysts, data engineers, program staff, and executive leadership to translate business requirements into enterprise data solutions
  • Support agile development and enterprise application lifecycle management
  • Oversee metadata loading processes and data quality improvements
  • Ensure compliance with agency security, coding, governance, and regulatory standards
What we offer
What we offer
  • Medical, dental, and vision coverage
  • Life and disability insurance
  • Additional voluntary benefits
  • Fulltime
Read More
Arrow Right

Junior Test Engineer

We are currently seeking a Junior Test Engineer to join our team in Bangalore, K...
Location
Location
India , Bangalore
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 2-4 years of experience in Software Testing / QA, with at least 2+ years in Data Warehouse / ETL testing
  • Practical experience in data migration / data platform modernization projects is strongly preferred
  • Strong SQL skills for writing complex queries and validations (joins, aggregations, window functions, filters)
  • Hands-on experience testing on at least one data platform such as: Snowflake, Databricks, or other cloud DW/Big Data platforms – experience with Snowflake/Databricks is a plus
  • Exposure to Informatica (understanding mappings/workflows and expected outputs)
  • Exposure to dbt or willingness to learn dbt-based validations (model outputs, dbt test results)
  • Good understanding of data warehouse concepts: facts/dimensions, SCDs, aggregations, grain, source-to-target mapping
  • Familiarity with test management and defect tracking tools (e.g., Azure DevOps, JIRA, TestRail, qTest)
  • Experience with Excel or similar tools for managing validation results and reconciliation artifacts
  • Strong attention to detail and a structured approach to validation
Job Responsibility
Job Responsibility
  • Execute data validation queries to compare Source (Yellowbricks / Informatica outputs) vs Target (Databricks / Snowflake / dbt outputs)
  • Perform Row-count checks between source and target tables
  • Aggregate validations (sums, counts, averages, distinct counts, min/max)
  • Sample and cell-level comparisons for critical entities and fields
  • Validate schema consistency (data types, lengths, precision/scale, nullable fields, constraints)
  • Log discrepancies, analyze patterns, and work with developers to support root-cause analysis
  • Understand Informatica mappings and workflows and their expected outputs
  • Validate dbt models (staging, core, marts) on Snowflake against legacy Informatica outputs
  • Test Databricks notebooks/jobs that replicate Yellowbricks logic — ensuring correct transformations, joins, filters, and aggregations
  • Validate CDC / incremental loads: new, changed, and deleted records are handled correctly
  • Fulltime
Read More
Arrow Right