ETL Production Support Engineer

Responsibilities

• Ability to understand and architect ETL solutions for production support activities.
• Provide L1 2 tier production support (oncallrotation ) for ETL jobs in production.
• Able to understand rite rouble shoot shell scripts and sql (Oracle) for regular maintenance jobs to improve performance and uptime of Informatica platform.
• Collaborate internally with BIDM and external sources to maintain SLA and provide escalations.
• Maintenance of the Informatica ETL platform infrastructure (upgrades, patches, health monitoring).
• Worked on Change Management Tools to track all the incidents and changes and to plan the production changes as per the change management policies.
• Troubleshooting ETL jobs and follow escalation procedures to resolve the issue.
• Collaborate and work with development team on L3 issues and follow the task to completion.
• Provide on call support for Informatica ETL jobs (on rotation 24x7).
• Participate in BIDM IT upcoming releases, risks, mitigation plan and create implementation plan.
• Ensures adherence to bank and information systems policies and procedures, security measures and audit standards.
• Able to understand process quickly and apply processes for the BIDM Prod-Ops.
• Team player and mentor junior support engineers.

• Bachelor's Degree in IT, Computer Science or a related field.

• 6+ years work experience within Data Warehousing or Business Intelligence.
• 5+ years work experience as team lead.
• Strong working knowledge of ETL infrastructure environment with Informatica.
• Strong knowledge of Database (ORACLE preferred).
• Experience in finance industry is plus.
• Extensive ETL development experience is preferred.