ETL Production Support Engineer

Jobsbridge; San Ramon (CA); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading IT service provider in San Ramon, California, is looking for an experienced ETL Solutions Architect to provide L1/L2 production support and maintain the Informatica platform. The ideal candidate will have 6+ years in Data Warehousing, extensive ETL experience, and strong SQL skills, particularly in Oracle. This is a team-oriented role that requires collaboration with multiple teams and mentoring junior staff. If you are passionate about driving efficiency and ensuring uptime, we want to hear from you.

Qualifications

• 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 a plus.
• Extensive ETL development experience is preferred.

Responsibilities

• Ability to architect ETL solutions for production support.
• Provide L1/L2 tier production support for ETL jobs.
• Collaborate with internal and external sources to maintain SLA.
• Maintenance of the Informatica ETL platform infrastructure.
• Troubleshooting ETL jobs and escalate issues as necessary.
• Mentor junior support engineers.

Skills

ETL solution architecture

Shell scripting

SQL (Oracle)

Informatica platform maintenance

Change Management Tools

Collaboration with teams

Education

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

Job description

Responsibilities

• 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.