ETL Production Support Engineer
Jobsbridge1 · San Ramon, CA
View and Apply ↗
Opens the original job posting in a new tab.
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 DWH, ETL Multiple Openings