ETL Developer: Informatica & Cloud Data Warehouse Expert

Robotic Technologies Automation

Santa Ana (CA)

On-site

USD 83,000 - 107,000

Full time

6 hours ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Robotic Technologies Automation is seeking an experienced ETL Developer to design, develop, and maintain data integration pipelines and data warehouse solutions in a Santa Ana, CA environment. The role emphasizes Informatica, SQL, data transformation, and cloud-based data platforms to support scalable data architectures.

The ideal candidate will design ETL/ELT pipelines, build mappings and workflows, perform data extraction/loading, and integrate data from databases, flat files, and REST APIs.

Qualifications

5+ years of ETL development experience.
Strong hands-on Informatica PowerCenter or IICS experience.
Advanced SQL/PLSQL development.
Knowledge of data warehousing concepts and ETL architectures.
Experience with full loads, incremental loads, and data transformations.
Strong troubleshooting and production support skills.

Responsibilities

Design, develop, and maintain ETL/ELT pipelines and data integrations.
Develop mappings, workflows, and transformations using Informatica PowerCenter or IICS.
Perform data extraction, transformation, loading, and incremental processing.
Work with databases, cloud data warehouses, and REST APIs for data integration.

Skills

ETL development

Informatica PowerCenter/IICS

SQL/PLSQL

Data warehousing concepts

ETL architecture

Production support

Tools

Informatica PowerCenter

IICS

Oracle

SQL Server

AWS Glue

Snowflake

Azure Synapse

Job description

The ideal candidate will design ETL/ELT pipelines, build mappings and workflows, perform data extraction/loading, and integrate data from databases, flat files, and REST APIs.

Get your free, confidential resume review.

or drag and drop your file here.