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