Senior ETL Engineer - Informatica & Data Warehouse

Ethereum Technologies LLC; Santa Ana (CA); On-site; USD 77,000 - 110,000; Full time

Job summary

Ethereum Technologies in Santa Ana, CA is seeking an experienced ETL Developer to design, develop, and maintain data integration pipelines and data warehouse solutions. The ideal candidate will have strong hands-on experience with Informatica PowerCenter or IICS, SQL, and cloud-based data platforms.

You will design ETL/ELT mappings, workflows, and transformations, perform data extraction/loading including incremental processing, and integrate data from databases, flat files, and REST APIs.

Qualifications

• 5+ years of ETL development experience.
• Strong experience with Informatica PowerCenter or IICS.
• Advanced SQL/PLSQL and data warehousing knowledge.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines.
• Build mappings, workflows, and transformations using Informatica.
• Perform data extraction, transformation, loading and incremental processing.
• Integrate data from databases, flat files, and REST APIs.
• Support data quality and warehouse optimization.

Skills

ETL development

SQL & PL/SQL

Data warehousing concepts

Troubleshooting / production support

REST APIs / JSON / XML

Tools

Informatica PowerCenter / IICS

Job description

Ethereum Technologies in Santa Ana, CA is seeking an experienced ETL Developer to design, develop, and maintain data integration pipelines and data warehouse solutions. The ideal candidate will have strong hands-on experience with Informatica PowerCenter or IICS, SQL, and cloud-based data platforms.

You will design ETL/ELT mappings, workflows, and transformations, perform data extraction/loading including incremental processing, and integrate data from databases, flat files, and REST APIs.