Sr. Data Warehouse ETL Developer

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Sr. Data Warehouse ETL Developer, lasting 4 to 6 months, with a pay rate of "TBD". Remote work in CA is required, with travel for critical meetings. Key skills include Qlik Compose, advanced SQL, and ETL process development.
🌎 - Country
United States
💱 - Currency
$ USD
💰 - Day rate
Unknown
Unknown
🗓️ - Date discovered
April 18, 2025
🕒 - Project duration
3 to 6 months
🏝️ - Location type
Remote
📄 - Contract type
Unknown
🔒 - Security clearance
Unknown
📍 - Location detailed
California, United States
🧠 - Skills detailed
#Data Warehouse #Data Extraction #Data Mart #Data Modeling #Oracle #Complex Queries #Tableau #Databases #Monitoring #EDW (Enterprise Data Warehouse) #Business Objects #BO (Business Objects) #Microsoft Power BI #BI (Business Intelligence) #"ETL (Extract #Transform #Load)" #SAS #SSIS (SQL Server Integration Services) #SQL (Structured Query Language) #Debugging #Qlik #Microsoft SQL
Role description

Position- Sr. Data Warehouse ETL Developer

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

Duration- 4 to 6 months CTH

Required Skills-

(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

   • 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....