Job Tittle - Sr. Data Warehouse ETL Developer
Visa - USC & GC
Location - Hybrid - 2 days in Fairfield, CA
Remote in CA - open to travel to be onsite for critical meetings
Rate - $60-66/hr on W2
Project Duration - 6+ months
Exp. - 9+ Year
End Client - CN
Must have LinkedIn
GC Front & back
JD:
* 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....
Still looking for candidates coming from a medical/healthcare background.
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).