Previous Job
Previous
DATAWAREHOUSE DEVELOPER-Midtown, NYC
Ref No.: 18-02334
Location: Midtown, NYC, Georgia
  
Job Title               : LEAD DATAWAREHOUSE DEVELOPER
Location               : Midtown, NYC
Position Type       : Contract  
US Citizen, Green Card, TN, GC EAD and H4 EAD only No Third-party agencies corp to corp.
Experience:
  • Minimum of five years of experience in Data Integration projects working on ETL framework for Data Warehouse projects and writing ETLs using SQL scripts and/or ETL tools (Informatica,Glue, Matillion) required.
  • Working knowledge of databases such as Oracle, SQL Server, Postgres or Redshift required.
  • Experience with query performance tuning techniques required. Hands on experience in performance tuning of SQL scripts required.
  • Experience with Scheduling tools such as Autosys, Control-M or Tivoli etc. required. Working knowledge of data modeling (BI Snowflake/3NF, Star, Slowly Changing Dimensions) and experience with data modeling tools such as Erwin or ER/Studio required.
  • Demonstrated understanding of how best to store the data for reporting (BI Snowflake/3NF, Star, Dimensional models), making certain that a best approach solution is used to achieve optimized performance required.
  • Understanding various data stores (database, files, XML, etc.) and how best to extract data required.
  • Understating various aspects of logical, conceptual and physical modeling of data warehouse projects required.
  • Ability to work independently, take initiative and contribute to new ideas required. Enterprise BI Experience preferred.
  • Healthcare experience preferred. Exposure to Microstrategy preferred. AWS Ecosystem experience preferred. Big Data experience (Cloudera, Horton, HIVE, Impala) preferred.