ETL Developer
Listed on 2026-06-01
-
IT/Tech
Data Engineer, Database Administrator
Title : ETL Developer / PL / SQL Specialist – Informatica (On-Prem & Cloud)
Location :
Irvine, CA (Onsite) - In- person interview
ETL Developer / PL / SQL Specialist with 9–10 years of experience in enterprise data integration and data warehousing environments. This role requires deep hands‑on expertise in PL / SQL development, strong experience with Informatica (On-Prem and Cloud), and the ability to act as a functional consultant by engaging directly with business stakeholders. The candidate will also provide technical oversight to offshore teams, ensuring high-quality delivery aligned with architectural and performance standards.
9–10 years of experience in ETL development, data warehousing, and enterprise database engineering with strong PL / SQL expertise.
- Architect and develop complex PL / SQL solutions (procedures, packages, triggers, dynamic SQL) with advanced performance tuning and optimization.
- Design and implement scalable ETL solutions using Informatica Power Center (On-Prem) and Informatica Intelligent Cloud Services (IICS).
- Build and optimize mappings, workflows, and transformations for large-scale data warehouse environments.
- Engage directly with business stakeholders to gather requirements and translate them into technical ETL and database designs.
- Provide technical oversight and code reviews for offshore teams, ensuring quality, standards compliance, and timely delivery.
- Support data quality, validation, reconciliation, production monitoring, troubleshooting, and release management activities.
- Strong foundation in Oracle databases, dimensional modeling, ETL best practices, Unix / Linux environments, and batch scheduling tools.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).