Job Description


Job Overview

  • Job ID:

    J55037

  • Job Title:

    ETL Developer

  • Location:

    Santa Ana, CA

  • Duration:

    8 Months + Extension

  • Domain Exposure:

    Pharmaceuticals

  • Client:

    To Be Discussed Later

  • Employment Type:

    W-2, 1099, C2C

  • Work Authorization:

    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.

Apply Now
Equal Opportunity Employer

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.