ETL Developer
Irvine, CA · On-site
$54.75 - $71.75/hr
... Services (IICS) . * Build and optimize Informatica mappings, workflows, mapplets, and ... . * Assist in resolving complex technical issues and support knowledge transfer across teams.
ETL Developer
Irvine, CA · On-site
$54.75 - $71.75/hr
... Services (IICS) . * Build and optimize Informatica mappings, workflows, mapplets, and ... . * Assist in resolving complex technical issues and support knowledge transfer across teams.
Data Engineer
$117K - $140K/yr
... Informatica IICS, and Azure. Excellent communication skills, both verbal and written, with the ... Recommends and may assist in leading the definition of user stories and design workshops, data ...
Data Engineer
$117K - $140K/yr
... Informatica IICS, and Azure. Excellent communication skills, both verbal and written, with the ... Recommends and may assist in leading the definition of user stories and design workshops, data ...
Execute annual Disaster Recovery & Password rotation exercises * Assist with Audit requests ... IICS platform administration / management. * Good knowledge with ITIL framework & ITSM tools.
Execute annual Disaster Recovery & Password rotation exercises * Assist with Audit requests ... IICS platform administration / management. * Good knowledge with ITIL framework & ITSM tools.
Data Engineer
Okemos, MI · On-site
$103K - $124K/yr
PL/SQL, Python, T-SQL, StreamSets, Snowflake Cloud Data Platform, and Informatica PowerCenter, Informatica IICS or IDMC. * Experience creating and maintaining ETL processes that use Salesforce as a ...
Quick apply
Data Engineer
Okemos, MI · On-site
$103K - $124K/yr
PL/SQL, Python, T-SQL, StreamSets, Snowflake Cloud Data Platform, and Informatica PowerCenter, Informatica IICS or IDMC. * Experience creating and maintaining ETL processes that use Salesforce as a ...
Job Opportunity - Informatica Power Center Developer // Onsite
Austin, TX · On-site
$85 - $90/hr
... Power Center/IICS to pull data from external data sources and transform it to fit into a ... This is a dedicated line designed exclusively to assist job seekers whose disability prevents them ...
Quick apply
Job Opportunity - Informatica Power Center Developer // Onsite
Austin, TX · On-site
$85 - $90/hr
... Power Center/IICS to pull data from external data sources and transform it to fit into a ... This is a dedicated line designed exclusively to assist job seekers whose disability prevents them ...
Developer
Charlotte, NC · On-site
$110K - $120K/yr
... Assist in the development and implementation of transformation flows for the tenants in the ... IICS jobs. • Participate in team meetings to discuss project updates and progress. Generic ...
Developer
Charlotte, NC · On-site
$110K - $120K/yr
... Assist in the development and implementation of transformation flows for the tenants in the ... IICS jobs. • Participate in team meetings to discuss project updates and progress. Generic ...
Informatica Developer
$54.50 - $71.75/hr
... Cloud (IICS) is desired along with a strong passion for writing complex queries in an Oracle ... Help define acceptance test objectives, test cases, and assist in system and integration testing
Informatica Developer
$54.50 - $71.75/hr
... Cloud (IICS) is desired along with a strong passion for writing complex queries in an Oracle ... Help define acceptance test objectives, test cases, and assist in system and integration testing
Job Overview: We are seeking an Advanced Quality Assurance Analyst to assist the Office of ... Knowledge of Informatica IICS Cloud Data Integration tools and Snowflake is a plus.
Job Overview: We are seeking an Advanced Quality Assurance Analyst to assist the Office of ... Knowledge of Informatica IICS Cloud Data Integration tools and Snowflake is a plus.
SAP BODS Developer
Raleigh, NC · On-site
... IICS) components - application integration, data integration, Informatica data quality and ... Assistant Manager | Syntricate Technologies Inc. Direct: (781)-552-4332| Fax: 781-649-0786 Email ...
SAP BODS Developer
Raleigh, NC · On-site
... IICS) components - application integration, data integration, Informatica data quality and ... Assistant Manager | Syntricate Technologies Inc. Direct: (781)-552-4332| Fax: 781-649-0786 Email ...
... Assist, and Voltagetools to facilitate secure and efficient test data provisioning. • Data ... IICS-based data integration solutions and optimize performance for DB2and cloud storage. o Develop ...
... Assist, and Voltagetools to facilitate secure and efficient test data provisioning. • Data ... IICS-based data integration solutions and optimize performance for DB2and cloud storage. o Develop ...
Advanced Quality Assurance Analyst
Tallahassee, FL · On-site
$70/hr
Contribute to remediation of outdated interface technologies and assist in modernization activities ... Knowledge of Informatica IICS Cloud Data Integration and Snowflake Experience in testing or ...
Advanced Quality Assurance Analyst
Tallahassee, FL · On-site
$70/hr
Contribute to remediation of outdated interface technologies and assist in modernization activities ... Knowledge of Informatica IICS Cloud Data Integration and Snowflake Experience in testing or ...
Integration Lead/Manager
Memphis, TN · On-site
... IICS) and other iPaaS platforms. This role combines team leadership with hands-on technical ... * Assist developers with documenting integration designs and workflows, and provide on-call ...
Integration Lead/Manager
Memphis, TN · On-site
... IICS) and other iPaaS platforms. This role combines team leadership with hands-on technical ... * Assist developers with documenting integration designs and workflows, and provide on-call ...
... IICS) and other iPaaS platforms. This role combines team leadership with hands-on technical ... * Assist developers with documenting integration designs and workflows, and provide on-call ...
... IICS) and other iPaaS platforms. This role combines team leadership with hands-on technical ... * Assist developers with documenting integration designs and workflows, and provide on-call ...
This role will assist in driving to deliver high quality products through governing adherence to ... Should have hands on experience on Cloud services such as AWS, Azure, IICS. * Knowledge on FiveTran ...
This role will assist in driving to deliver high quality products through governing adherence to ... Should have hands on experience on Cloud services such as AWS, Azure, IICS. * Knowledge on FiveTran ...
Integration Lead/Manager
Memphis, TN · On-site
... IICS) and other iPaaS platforms. This role combines team leadership with hands-on technical ... * Assist developers with documenting integration designs and workflows, and provide on-call ...
Integration Lead/Manager
Memphis, TN · On-site
... IICS) and other iPaaS platforms. This role combines team leadership with hands-on technical ... * Assist developers with documenting integration designs and workflows, and provide on-call ...
Senior Business Analyst
Rosemont, IL · On-site
$93K - $120K/yr
Preferred knowledge in Sigma, Informatica PowerCenter/IICS, and Fivetran. Responsibilities ... Support and facilitate vendor selection process. Assist the BRM with the vendor relationship at the ...
Senior Business Analyst
Rosemont, IL · On-site
$93K - $120K/yr
Preferred knowledge in Sigma, Informatica PowerCenter/IICS, and Fivetran. Responsibilities ... Support and facilitate vendor selection process. Assist the BRM with the vendor relationship at the ...
Data Engineer
Okemos, MI · On-site
$103K - $124K/yr
PL/SQL, Python, T-SQL, StreamSets, Snowflake Cloud Data Platform, and Informatica PowerCenter, Informatica IICS or IDMC. * Experience creating and maintaining ETL processes that use Salesforce as a ...
Quick apply
Data Engineer
Okemos, MI · On-site
$103K - $124K/yr
PL/SQL, Python, T-SQL, StreamSets, Snowflake Cloud Data Platform, and Informatica PowerCenter, Informatica IICS or IDMC. * Experience creating and maintaining ETL processes that use Salesforce as a ...
... * Assist in vendor/product selection activities including the development of vendor/product ... ICRT, IICS, AWS Cloud, Relational and Analytics databases. * 2 years of Continues Integration ...
... * Assist in vendor/product selection activities including the development of vendor/product ... ICRT, IICS, AWS Cloud, Relational and Analytics databases. * 2 years of Continues Integration ...
Informatica Lead
Branchville, NJ · On-site
... IICS, or equivalent), owning code quality, deployments, and operational stability. * MsoNormal ... MsoNormal">Prioritization and planning: assist product owners and project managers in prioritizing ...
Informatica Lead
Branchville, NJ · On-site
... IICS, or equivalent), owning code quality, deployments, and operational stability. * MsoNormal ... MsoNormal">Prioritization and planning: assist product owners and project managers in prioritizing ...
... * Assist in vendor/product selection activities including the development of vendor/product ... ICRT, IICS, AWS Cloud, Relational and Analytics databases. * 2 years of Continues Integration ...
... * Assist in vendor/product selection activities including the development of vendor/product ... ICRT, IICS, AWS Cloud, Relational and Analytics databases. * 2 years of Continues Integration ...
Job description
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:
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:
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.
- 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.
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.
About InterSources
Sourced by ZipRecruiter
In 2007, Our journey began as pioneers in the realm of technology and security. Since then, InterSources Inc. has evolved into a trusted partner, leading the way in Cloud Security, Cybersecurity, PLG Consulting, Digital Transformation, and Professional Services. With a rich history of excellence and a forward-thinking approach, we continue to secure your digital future and drive innovation. Explore our legacy of success and discover the possibilities that lie ahead.
Company size
51 - 200 Employees
Headquarters location
Fremont, CA, US
Year founded
2007