The Role
Provide application and production support for Informatica ETL (PowerCenter/IDMC): monitor batches, troubleshoot failures, perform RCA, implement enhancements, tune performance, automate tasks with shell/Python, manage deployments across environments, maintain runbooks, and support a 24x7 shift model while coordinating with DB, infra, cloud, Unix, and application teams.
Summary Generated by Built In
Roles & Responsibilities – Informatica Application Support Engineer
1. Enhancement & Continuous Improvement Activities
- Analyze enhancement requests from business and technical teams.
- Implement modifications in mappings, workflows, parameters, and ETL logic based on change requests.
- Develop new ETL workflows and reusable components for evolving business requirements.
- Perform performance tuning and optimization of Informatica mappings and sessions.
- Identify automation opportunities for repetitive operational activities using Shell scripting or Python.
- Recommend process improvements to increase ETL stability, efficiency, and maintainability.
- Monitor daily ETL batch execution for Informatica PowerCenter / IDMC workflows and mappings.
- Track workflow, session, and task execution status to ensure successful completion within SLA.
- Support critical business cycles and provide on-call support when required.
- Analyze and troubleshoot workflow, mapping, session, and data load failures.
- Perform root cause analysis (RCA) for production incidents and recurring issues.
- Coordinate with database, infrastructure, cloud, Unix, and application teams for issue resolution.
- Handle workflow recovery, rerun, restart, and data correction activities.
- Perform impact analysis for production issues and outages.
- Validate source-to-target data reconciliation and completeness.
- Investigate data discrepancies, missing records, and transformation issues.
- Support data quality checks and exception handling processes.
- Ensure data integrity and compliance with business rules.
- Coordinate with business users for data validation and issue confirmation.
- Support code migration and deployment activities across Dev, QA, UAT, and Production environments.
- Validate deployment packages and ensure successful release implementation.
- Maintain version control and deployment documentation.
- Monitor ETL performance bottlenecks and optimize resource utilization.
- Tune mapping transformations, SQL queries, partitioning, and workflow execution strategies.
- Maintain operational runbooks, SOPs, support documents, and troubleshooting guides.
- Document RCA findings, known issues, and resolution procedures.
- Maintain knowledge repositories for support and enhancement activities.
- Participate in knowledge transfer sessions and cross-team collaboration.
- Install, Patch, Maintain, troubleshooting Platform support
- Perform deployment of code
- Coordinate with Application team for schedule maintenance including performing activity.
- support 24*7 Shift model
Responsibilities
- 2. Production Monitoring & Batch Support
- 3. Incident Management & Issue Resolution
- 4. Data Validation & Data Quality Support
- 5. Deployment & Release Management
- 6. Performance Optimization & Preventive Maintenance
- 7. Documentation & Knowledge Management
- 8. Informatica Platform support
Skill Required
- Strong experience in Informatica PowerCenter and/or IDMC ETL support and troubleshooting
- Good knowledge of SQL, database concepts, and Unix/Linux scripting
- Experience in production support, incident management, and performance tuning
- Strong analytical, problem-solving, and stakeholder coordination skills
About UsHoneywell helps organizations solve the world's most complex challenges in automation, the future of aviation and energy transition. As a trusted partner, we provide actionable solutions and innovation through our Aerospace Technologies, Building Automation, Energy and Sustainability Solutions, and Industrial Automation business segments – powered by our Honeywell Forge software – that help make the world smarter, safer and more sustainable.
Skills Required
- Strong experience in Informatica PowerCenter and/or IDMC ETL support and troubleshooting
- Good knowledge of SQL and database concepts
- Unix/Linux scripting (Shell/Bash) experience
- Experience in production support, incident management, and performance tuning
- Experience with automation using Shell scripting or Python
- Ability to perform root cause analysis and coordinate with multiple technical teams
- Support in a 24x7 shift/on-call model
Honeywell Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Honeywell and has not been reviewed or approved by Honeywell.
-
Retirement Support — Retirement plans feature a notably strong company 401(k) match with vesting after three years, enhancing long-term savings security. Additional tax-advantaged accounts and company contributions for eligible earners further strengthen financial preparedness.
-
Leave & Time Off Breadth — Time off policies include flexible or unlimited vacation for many salaried roles and a broad observed-holiday schedule, providing manager-approved flexibility. This structure supports rest and work-life balance across varied needs.
-
Parental & Family Support — Parental leave offers paid time for birth, adoption, or foster care that can be taken consecutively or intermittently. The design enables practical flexibility in how family leave is used.
Honeywell Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Honeywell is a Fortune 500 company that invents and manufactures technologies to address tough challenges linked to global macrotrends such as safety, security, and energy. With approximately 110,000 employees worldwide, including more than 19,000 engineers and scientists, we have an unrelenting focus on quality, delivery, value, and technology in everything we make and do.
.png)
