ETL Developer

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 PowerCenter (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. #J-18808-Ljbffr