ETL Production Support Engineer

Company Description

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