• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 20th Nov 2020

JD:

Location: Englewood, CO
Role: Data Analyst – Data warehouse Data Analyst

Mandatory Skills:

·         Data warehousing Professional

·         Excellent oral and written communication skills

·         Solid traditional Data warehousing experience – minimum 4 years

·         Excellent RDBMS Knowledge

·         Excellent SQL development skills

·         Excellent Analytical and Problem Solving Skills

 

Questions to be asked for choosing the right profile

1) Do you have Traditional and/or Cloud Data Warehousing experience? If so what percentage for each?
The Ideal candidate’s experience mix for this role would be Traditional (65-70%): Cloud (25 -30%).
Meaning traditional DWH experience is an absolute must, Cloud is “nice to have”.

2) As a data analyst, were you part of an Enterprise Data warehousing Team?
If so how for many years?

3) Have you worked on Data warehouses built on /Teradata/ Oracle/DB2/SQL Server or any other relational database management system? If so what was your role and for how many years?

4) Have you used SQL/Advanced SQL to create Reports from the Data warehouse? If so for how many years?

5) Have you translated business requirements for data warehouse - data integration into technical requirements? If so for how many years?

6) Have you used any reporting tools? If so which ones and for how many years?

 

Profiles that are not a good fit:

·         Exclusively Data scientist profiles

·         Exclusively BI developer profiles: Tableau, Power BI

·         Exclusively Data Engineer /ETL developer profiles

·         Exclusively NON - DWH data analyst profile

 

Partial (but not complete) list of data warehouse platforms today:

DW survivors, originally on premise, now hybrid
Teradata
Oracle
Microsoft
IBM
Pivotal/Greenplum

Pure Cloud
Redshift  [Amazon]
Snowflake [Snowflake]
Incorta
Google

 

 

 

Rama Kant Tiwari

Sr.Technical Recruiter (US Staffing)

IDC Technologies, Inc.

Work: 408-457-9399, EXT-3112

Direct: 315-762-1094
Mailto: ramakant.tiwari@idctechnologies.com