Application Support ETL & Informatica Engineer
On-site · Noida, Uttar Pradesh, India
Job Summary
Application Support ETL & Informatica Engineer will 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.
Required Qualifications
- Bachelor’s degree in a technology or engineering field
- 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 independently and as part of a distributed/onshore-offshore team
Apply with one swipe on Sorce. We auto-fill applications and apply on your behalf — no cover letters, no 40-minute forms.
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.