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.
3rchitect and develop complex PL/SQL solutions (procedures, packages, triggers, dynamic SQL) with advanced performance tuning and optimization.
3Design and implement scalable ETL solutions using Informatica PowerCenter (On-Prem) and Informatica Intelligent Cloud Services (IICS).
3Build and optimize mappings, workflows, and transformations for large-scale data warehouse environments.
3Engage directly with business stakeholders to gather requirements and translate them into technical ETL and database designs.
3Provide technical oversight and code reviews for offshore teams, ensuring quality, standards compliance, and timely delivery.
3Support data quality, validation, reconciliation, production monitoring, troubleshooting, and release management activities.
3Strong foundation in Oracle databases, dimensional modeling, ETL best practices, Unix/Linux environments, and batch scheduling tools.