ETL Developer

R Systems; Irvine (CA); On-site; USD 85,000 - 110,000; Full time

Job summary

R Systems in Irvine, CA is seeking an experienced ETL Developer to design, develop, and maintain data integration solutions. The role focuses on building efficient ETL processes, ensuring data quality, and supporting reporting and analytics.

You will develop and optimize ETL workflows using Informatica PowerCenter and write PL/SQL procedures, packages, and queries, while collaborating with business and technical teams to meet data requirements.

Qualifications

• 3+ years of experience in ETL development.
• Hands-on experience with Informatica PowerCenter and Oracle PL/SQL.
• Strong SQL and data analysis skills.
• Understanding of ETL processes, data warehousing, and database concepts.
• Excellent analytical and problem-solving abilities.
• Bachelor's degree in Computer Science, IT, or a related field.

Responsibilities

• Develop and maintain ETL workflows using Informatica.
• Design and optimize PL/SQL procedures, packages, and queries.
• Perform data extraction, transformation, and loading from multiple sources.
• Analyze data, validate results, and ensure data accuracy.
• Troubleshoot ETL and database performance issues.
• Collaborate with business and technical teams to understand data requirements.

Skills

Data Analysis

Education

Bachelor's degree in Computer Science, IT, or a related field

Tools

Informatica PowerCenter

Oracle PL/SQL

Job description

We are looking for an experienced ETL Developer with strong skills in PL/SQL, Informatica, and Data Analysis to design, develop, and maintain data integration solutions. The ideal candidate will be responsible for building efficient ETL processes, ensuring data quality, and supporting business reporting and analytics needs.

Key Responsibilities

• Develop and maintain ETL workflows using Informatica.
• Design and optimize PL/SQL procedures, packages, and queries.
• Perform data extraction, transformation, and loading from multiple sources.
• Analyze data, validate results, and ensure data accuracy.
• Troubleshoot ETL and database performance issues.
• Collaborate with business and technical teams to understand data requirements.

Requirements

• 3+ years of experience in ETL development.
• Hands-on experience with Informatica PowerCenter and Oracle PL/SQL.
• Strong SQL and data analysis skills.
• Understanding of ETL processes, data warehousing, and database concepts.
• Excellent analytical and problem-solving abilities.
• Bachelor's degree in Computer Science, IT, or a related field.