ETL Developer

ETL Developer / PL/SQL Specialist - Informatica (On-Prem & Cloud)
Location: Irvine, CA (Onsite)


Overview:
We are seeking an experienced 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.


Responsibilities:

• Architect, design, and implement complex PL/SQL solutions , including stored procedures, functions, packages, triggers, and dynamic SQL .
• Perform advanced SQL and PL/SQL performance tuning , query optimization, and indexing strategies to support large-scale data volumes.
• Ensure database design and code adhere to best practices for scalability, maintainability, and performance.
• Troubleshoot and resolve complex data, performance, and integrity issues within the database layer.

ETL & Data Warehouse Integration:

• Design, develop, and maintain ETL solutions using Informatica PowerCenter (On-Prem) and Informatica Intelligent Cloud Services (IICS) .
• Build and optimize Informatica mappings, workflows, mapplets, and transformations for complex Data Warehouse environments .
• Support data ingestion, transformation, and loading processes across multiple source systems and targets.
• Participate in on-prem to cloud migration initiatives and hybrid ETL architectures.
• Ensure data quality, validation, reconciliation, and audit controls are embedded in ETL processes.

Business Engagement & Functional Consulting (Approx. 25% Customer-Facing):

• Act as a functional/technical consultant by engaging directly with business users and stakeholders.
• Gather, analyze, and clarify business requirements and translate them into detailed technical specifications and ETL designs .
• Support requirement walkthroughs, solution reviews, and design discussions with business and technical teams.
• Proactively identify data-related risks, gaps, and optimization opportunities aligned with business objectives.

Delivery Oversight & Offshore Coordination:

• Provide technical oversight and guidance to offshore ETL and database development teams.
• Review ETL designs, PL/SQL code, and implementation deliverables to ensure compliance with architectural standards and best practices .
• Ensure offshore deliveries meet project milestones, quality expectations, and performance benchmarks .
• Assist in resolving complex technical issues and support knowledge transfer across teams.

Operational & Support Responsibilities:
Support production ETL jobs and database processes, including monitoring, troubleshooting, and root-cause analysis.
Participate in deployment planning, release activities, and post-production support.
Create and maintain technical documentation, including data mappings, ETL design documents, and operational runbooks.


Required Qualifications:

• Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent experience).
• 9-10 years of experience in ETL development, data warehousing, and database engineering.
• Expert-level experience with PL/SQL , including dynamic SQL, performance tuning, and complex database logic.
• Strong hands-on experience with Informatica PowerCenter (On-Prem) .
• Experience with Informatica Intelligent Cloud Services (IICS) .
• Solid understanding of Data Warehouse architecture , ETL patterns, and dimensional modeling.
• Experience working with Oracle or similar enterprise relational databases.
• Familiarity with Unix/Linux environments and batch scheduling tools.