Data Warehouse ETL Developer

MACHINE LEARNING TECHNOLOGIES LLC; Fairfield (CA); On-site; USD 69,000 - 124,000; Full time

Job summary

MACHINE LEARNING TECHNOLOGIES LLC in Fairfield, CA is seeking a Data Warehouse ETL Developer to join our team for a 12-month engagement with possible extension. The role requires 8-10 years of senior-level experience, advanced SQL, SSIS, and strong data quality focus. Responsibilities include production support, data modeling enhancements, and security-related tasks.

Employment could be W-2, 1099, or C2C. Hourly rate is DOE, reflecting experience and technical depth.

Qualifications

• Advanced SQL with complex joins and subqueries.
• Experience with data quality validation and ETL processes.
• Proficient in SSIS and performance tuning techniques.

Responsibilities

• Monitor jobs configured in Compose to track daily for errors (production support).
• Validate data quality and accuracy.
• Modify tasks to add tables and transforms.
• Maintain core structure upgrades and implement security-related tasks; monitor latencies.

Skills

Advanced SQL

Complex joins

Sub queries

CTE

Performance tuning

Debugging skills

SSIS

Senior experience 8-10 years

Tools

SSIS

Job description

Job Description

Job Overview

• Job ID: J52341
• Job Title: Data Warehouse ETL Developer
• Location: Fairfield, CA
• Duration: 12 Months + Extension
• Hourly Rate: Depending on Experience (DOE)
• 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, 1099, C2C

Duties/Day to Day Overview

• Monitoring the jobs that are configuring in compose to track on a daily basis for any errors (more like a productions support
• Validate data quality, accuracy
• Modify tasks to add tables and transforms
• Maintain core structure upgrades, implementing security related tasks, monitoring latencies,

Top Requirements

(Must haves)

• Advanced SQL:
  • Need to know complex joins
  • Sub queries
  • Common table expression
  • Performance tuning techniques
  • Good debugging skills
  • SSIS
• Senior Level 8-10 years of experience

Additional Qualifications

(Nice to Haves)

• Data Modeling Experience
  • Architecture
  • What Kind of Data Modeling What is the subject? Healthcare
• Worked on data warehousing automation tools

Equal Opportunity Employer

MACHINE LEARNING 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. MACHINE LEARNING 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 MACHINE LEARNING 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