The Role
Provide production support and enhancement for Informatica ETL (PowerCenter/IDMC): develop and tune mappings/workflows, monitor batches, troubleshoot incidents, perform RCA, coordinate cross-team fixes, validate data quality, manage deployments, maintain runbooks, and support a 24x7 shift model.
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
- Experience with Informatica PowerCenter and/or IDMC ETL support and troubleshooting.
- Proficiency in SQL and strong database concepts.
- Unix/Linux scripting experience (Shell/Bash).
- Experience with Python for automation.
- Production support and incident management experience.
- Performance tuning and ETL optimization experience.
- Strong analytical, problem-solving, and stakeholder coordination skills.
- Ability to support a 24x7 shift model and on-call rotations.
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
