Required Skills

Deep knowledge of Synapse and BI space creating dimensional model synapse and 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 :- ( 1 )

  • Post :- 10th Sep 2024

JOB DETAIL

Experience in Data modeling and advanced SQL techniques

Experience working on cloud migration methodologies and processes including tools like Databricks, Azure Data Factory, Azure Functions, and other Azure data services

Expert in SQL, Python, Spark, Databricks

Experience working with varied data file formats (Avro, json, csv) using PySpark for ingesting and transformation

Experience with DevOps process and understanding of Terraform scripting

Understanding the benefits of data warehousing, data architecture, data quality processes, data warehousing design and implementation, table structure, fact and dimension tables, logical and physical database design

Experience designing and implementing ingestion processes for unstructured and structured data sets

Experience designing and developing data cleansing routines utilizing standard data operations

Knowledge of data, master data, metadata related standards, and processes

Experience working with multi-Terabyte data sets, troubleshooting issues, performance tuning of Spark and SQL queries

Experience using Azure DevOps/Github actions CI/CD pipelines to deploy code

Microsoft Azure certifications are a plus

Minimum of 7 years of hands-on experience working on design, configuration, implementation, and data migration for medium to large sized enterprise data platforms

 

Key Responsibilities:

Working with varied data file formats (Avro, json, csv) using PySpark for ingesting and transformation

DevOps process and Terraform scripting

Leadership skills: must be able to put together and deliver presentation.

Solid communication while working with PMO. Must be able to translate what product is asking for and regurgitate to team.

 

Must Haves:

Need STRONG synapse experience and the ability to leverage Power BI for advanced data visualization and reporting.

 

Highly desired:

Click Stream experience would be a HUGE plus

Company Information