ETL Developer

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

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title:ETL Developer
Location:Santa Ana, CA
Duration: 8 Months + Extension
Bill Rate: $68/hour (C2C)
Job Type: W-2, 1099, C2C
Client: To Be Discussed Later
Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Position Overview:

We are seeking an experienced ETL Developer to design, develop, and maintain data integration pipelines and data warehouse solutions. The ideal candidate should have strong experience with Informatica, SQL, data transformation, and cloud-based data platforms.

ETL Development & Data Integration:

• Design, develop, and maintain ETL/ELT pipelines for integrating data from multiple sources.
• Develop mappings, workflows, and transformations using Informatica PowerCenter or IICS.
• Perform data extraction, transformation, loading, and incremental data processing.
• Integrate data from databases, flat files, and REST APIs.

Database & Data Warehousing:

• Develop complex SQL queries, stored procedures, and performance-optimized database operations.
• Work with Oracle, SQL Server, and cloud data warehouses.
• Perform source-to-target mapping, data validation, and reconciliation.
• Support data quality, data migration, and warehouse optimization.

Required Skills:

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

Preferred Qualifications:

• Experience with AWS Glue, S3, Snowflake, or Azure Synapse.
• Knowledge of Python or PySpark.
• Experience with REST APIs, JSON, and XML.
• Familiarity with Git, Jenkins, and Linux scripting.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.