ETL Production Support Engineer

• 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