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.