InterSources Inc · 16 hours ago
ETL Developer
Irvine, CA
Full-time
Onsite
Senior Level, Lead/Staff
9+ years expInterSources Inc is seeking an experienced ETL Developer / PL/SQL Specialist with extensive expertise in enterprise data integration and data warehousing. The role involves architecting and implementing complex PL/SQL solutions, developing ETL processes using Informatica, and providing technical oversight to offshore teams while engaging with business stakeholders.
Artificial Intelligence (AI)Cyber SecurityInformation TechnologySoftware
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
Qualification
Required
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
Company
InterSources Inc
Innovative IT Solutions Built for Your Business. InterSources Inc is your partner in Growth and CyberSecurity.
501-1000 employees
H1B Sponsorship
InterSources Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (4)
2024 (5)
2023 (16)
2022 (1)
2021 (7)
2020 (7)
Funding
Current Stage
Late StageLeadership Team
Ankit Shah
Chief Executive Officer
Jigar kyada
Business Development Manager/Client Partner
Recent News
2023-11-07
Company data provided by crunchbase