Data Warehouse ETL Developer

Cloud Analytics Technologies, LLC; Fairfield (CA); Vor Ort; USD 120.000 - 150.000; Vollzeit

Zusammenfassung

Cloud Analytics Technologies LLC is seeking a senior data engineer in California to monitor production ETL jobs and optimize data workflows. You will monitor daily job health, troubleshoot errors, and implement security-related improvements.

The role requires strong SQL skills, complex joins, and experience with SSIS and data warehousing automation tools.

Qualifikationen

• Must have 8–10 years of experience in data analytics/ETL.
• Strong SQL skills with complex joins, subqueries, and CTEs.
• Experience with data warehousing automation tools.

Aufgaben

• Monitor the jobs that are configuring in compose to track on a daily basis for any errors (production support).
• Modify tasks to add tables and transforms.
• Maintain core structure upgrades, implementing security related tasks, monitoring latencies.

Kenntnisse

Advanced SQL

Complex joins

Subqueries

CTE (Common Table Expressions)

Performance tuning

Debugging

SSIS

Tools

SSIS

Jobbeschreibung

• Monitoring the jobs that are configuring in compose to track on a daily basis for any errors (more like a productions support
• 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

CLOUD ANALYTICS TECHNOLOGIES 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. CLOUD ANALYTICS TECHNOLOGIES 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 CLOUD ANALYTICS TECHNOLOGIES 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

Equal Opportunity Employer

CLOUD ANALYTICS 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. CLOUD ANALYTICS 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 CLOUD ANALYTICS 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

Some of our Business Ventures - Knowledge Analytics

Do restrictive necessities, your capability for advanced analytics or your business model need custom-made applications and infrastructure configurations? opt for our hosted managed services to urge comprehensive analytics solutions supported industry-leading Cloud Analytics Technologies, LLC code - delivered by the Cloud Analytics Technologies, LLC consultants UN agency understand these solutions best. Through a mix of with-it technology and dedicated service and support, Cloud Analytics Technologies, LLC hosted managed services will facilitate you: