ETL Developer
Listed on 2026-07-01
-
IT/Tech
Data Engineering, Database Administrator, Data Warehousing
ETL Developer / PL/SQL Specialist – Informatica (On-Prem & Cloud)
Location:
Irvine, CA (Onsite)
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.
- Design, develop, and maintain ETL solutions using Informatica Power Center (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.
- 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.
- 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.
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 Power Center (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.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).