SQL Specialist – Informatica (On-Prem & Cloud)

Dataflix•Irvine, CA

23h

About The Position

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.

Requirements

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.

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