Required Skills

complex T-SQL queries Performance tuning

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( )

  • Post :- 19th Dec 2023

JOB DETAIL

  • Cosmos + SQL experience / experience on MSBI stack – SSIS/SSAS. Any knowledge on C# and Azure Data Factory would be a plus.
  • Individual with strong technical background in SQL Server, BI, Data Analysis and strong knowledge of Data Warehousing Concepts.
  • Should be able write complex and efficient -SQL queries.
  • Should be able design & Implement end-end data pipelines using cosmos and ADF.
  • Problem analysis and troubleshooting complex & “large volume of dataset’s” data issues.

Skills Required:

  • Proven experience in SQL Server writing complex T-SQL queries, Performance tuning.
  • Proven experience in Data Analysis dealing with large volume of datasets.
  • Proven experience in Design & Implementation of end-end data pipelines.
  • Should have strong knowledge of Data Warehousing concepts.
  • Should have very good experience in BI tools (but not limited to)
  • ETL tools like SSIS
  • Reporting tools like Power BI,
  • Analytical tools like SSAS – Tabular and multi-Dimensional Cubes and MDX queries.
  • Cosmos and scope scripts
  • Good to have knowledge of Microsoft Big Data Technologies.
  • Good to have knowledge of Azure Data Factory and C#
  • Excellent communication skills – direct communication with Client

Company Information