Required Skills

Power BI SQL

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 :- ( 1 )

  • Post :- 26th Dec 2023

JOB DETAIL

Skills required: 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.
a) Should be able write complex and efficient -SQL queries.
b) Should be able design & Implement end-end data pipelines using cosmos and ADF.
c) Problem analysis and troubleshooting complex & “large volume of dataset’s” data issues.

 

Skills Required:

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

Company Information