ETL Developer / PL/SQL Specialist – Informatica (On-Prem & Cloud) at Dataflix

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.