ETL Production Support Engineer

Job Description

• Ability to understand and architect ETL solutions for production support activities.
• Provide L1\L2 tier production support (oncallrotation ) for ETL jobs in production.
• Able to understand\write\troubleshoot 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.

Required Education or Equivalent Experience

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

Required Experience:

• 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
• Strong knowledge of ITIL processes

Qualifications

DWH, ETL

Additional Information Multiple Openings