Sr. Data Warehouse ETL Developer

POSITION

Sr. Data Warehouse ETL Developer

LOCATION

Remote- The manager is open to candidates looking to be remote until conversion

While on Contract ideally:

Hybrid – 2 days in Fairfield, CA

Remote in CA – open to travel to be onsite for critical meetings

When converted or if we place direct:

Required - Hybrid – 2 days in Fairfield, CA

DURATION

4-6 Months, CTH

INTERVIEW TYPE

Video

VISA RESTRICTIONS

No Sponsorship

REQUIRED SKILLS

Need candidates to come from a medical/healthcare background or worst case financial industry.

I've been informed they are in a structured SQL environment, which is why healthcare & financial care candidates could work for them.

The manager is asking that we focus on Sr. Data Warehouse Developers (8-10 years total with this experience) with heavier Qlik Compose experience (3-5 years).

Compose experience:

Qlik Compose Development

Configuring tasks

Monitoring tasks

Qlik Replicate experience

Advanced SQL:

Need to know complex joins

Sub queries

Common table expression

Performance tuning techniques

Good debugging skills

Senior Level – 5-10 years of experience

Senior ETL Developer at Partnership HealthPlan of California:

• Responsible for data extraction from multiples sources such as Oracle, SQL, SAS, Access, Flat files etc.

• Experience leading ETL Developers on different projects such as adding new features to the Data Warehouse or creating Data Marts for our BI (Business Intelligence) Team.

• Possess extensive experience in writing Complex Queries using Microsoft SQL (T-SQL) like (Derived Tables, Correlated Queries, While Loops, Variables, Merge Statements and so forth)

• Creation, Optimization and Maintenance of Databases

• Responsible for developing ETL Processes for the Enterprise Data Warehouse (EDW)

• Provide support with Ad-Hoc queries or Data mart options to our Reporting Layers to be used by BI tools such as Tableau and Business Objects and soon, SSRSS and Power BI

• Implementation of ETL Architecture

• Implementing Data Models for Data Marts

• Highly Adaptable and Experienced ETL Developer using SSIS and Attunity

• Create Source to Target mapping document for tables used on the different schemas such as EDW (Star Schema) or for Data Marts

• Responsible for presenting to Business Users any new enhancements done to our reporting capabilities utilizing visual tools such as PowerPoint and or Visio

• I have knowledge working with Data Modeling Tool: ER/Studio from Embarcadero

• I am a Quick Learner and Self-Motivated individual with Excellent Problem Solving Skills

• and more....