Sr. Data Warehouse ETL Developer
3B Staffing LLC, Fairfield, CA, United States
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....
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....