Required Skills

Joins Cross Apply Aggregate Queries Merge Pivot

Work Authorization

  • US Citizen

  • Green Card

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 :- 13th Dec 2023

JOB DETAIL

This is what I am looking for -

•        Expertise in creating streaming and batch workflows in Databricks Lakehouse using Pyspark and Spark SQL.

•        Expertise in creating data load / ETL processes in Snowflake cloud.

•        Proficient in scripting queries in T-SQL, Spark SQL, Pyspark, Python and DAX for creating and managing database objects, applying business logic, monitoring, and data analysis.

 

•       

o        Working experience with T-SQL and relational databases including currently supported versions of Microsoft SQL Server in Azure.

o        Design, develop and maintain Stored Procedures, Functions and Views

o        Working experience with development and maintenance of Data Factory data pipelines.

o        Working experience with development and maintenance of data pipelines on the DataBricks platform in Azure.

o        Working experience using DevOps CI/CD in Azure.

o        Proficient with the following: T-SQL, SSIS, data pipelines, and ETL concepts & practices

o        Understanding of data lakehouse architecture in Azure.

o        Write high performance SQL queries using Joins, Cross Apply, Aggregate Queries, Merge, Pivot

 

 

•        Expertise in creating streaming and batch workflows in Databricks Lakehouse using Pyspark and Spark SQL.

•        Expertise in creating parameterized streaming and batch data processing using Azure Synapse and Azure Data Factory.

•        Expertise in creating data load/ETL processes in Snowflake cloud.

•        Experienced in delivering reporting solutions to stakeholders using tools like Power BI, Databricks SQL, Tableau and SSRS.

•        Proficient in scripting queries in T-SQL, Spark SQL, Pyspark, Python and DAX for creating and managing database objects, applying business logic, monitoring, and data analysis.

Company Information