W-2 Jobs Portal

  • W-2 Open Positions Need to be Filled Immediately. Consultant must be on our company payroll, Corp-to-Corp (C2C) is not allowed.
Candidates encouraged to apply directly using this portal. We do not accept resumes from other company/ third-party recruiters

Job Overview

  • Job ID:

    J36993

  • Specialized Area:

    ETL

  • Job Title:

    ETL Developer

  • Location:

    San Clemente,CA

  • Duration:

    6 Months

  • Domain Exposure:

    Manufacturing, Retail, Aerospace/ Airlines

  • Work Authorization:

    US Citizen, Green Card, OPT-EAD, CPT, H-1B,
    H4-EAD, L2-EAD, GC-EAD

  • Client:

    To Be Discussed Later

  • Employment Type:

    W-2 (Consultant must be on our company payroll. C2C is not allowed)




Job Description

Essential Duties & Responsibilities

  • Create ETL / ELT design specifications, develop ELT/ETL data integration code, perform unit testing and prepare technical documentation.
  • Analyze procedures and design / implement data movement solutions to attain high data quality and process automation.
  • Design, develop and implement solutions based on standards and processes that establish consistency across the enterprise data, reduce risk, and promote efficiencies in support of the organization's goals and objectives.
  • Design Oracle queries, tables, and SQL Statements
  • Develop and implement data integration architecture including Data Warehousing, data movement and staging
  • Map data from data sources to through the Data Warehouse layers

Skills

  • Knowledge of general (ROLAP) data warehouse and BI concepts
  • 3+ years Informatica and Oracle DAC experience
  • 1+ years Oracle ODI experience
  • Solid, quantifiable experience in using Data Modeling ERD-Dimensional modeling tools such as Erwin, and RDBMSs such as Oracle and MS SQL Server databases.
  • 1+ years of Oracle OBIA Experience: Financials, Supply Chain, Manufacturing

Apply Now
Equal Opportunity Employer

DIGITAL TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. DIGITAL TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will DIGITAL TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract