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
Location: San Ramon, CA
Posted: Nov. 5, 2024, 7:22 a.m.
Apply Now Company Website