SQL Server Developer with Azure Cloud at Princeton, NJ

Job Title: SQL Server Developer with Azure Cloud Location: Princeton, NJ - Onsite Duration: Long term Job Description:

• At least having 10 + Years of IT and min At least having 8+ years of Strong Experience in T-SQL, Creating Table, Stored procedure, View, Function, Data Modelling, Database Design, SQL performance tuning and ETL on SQL Server/ Azure SQL databases. Min 3 Years working Experience on Azure cloud PAAS implementations (ADF, ADLS, Logic Apps, Azure Functions, Azure HDInsight, Azure Devops/repo/CICD/ Boards)
• Experience working on Sql server Analysis Services SSAS Tabular model
• At least 1 year experience working on SAP: Business Object Data Services (BODS)
• At least having 1+ years of Hands-on experience in PowerBI. Designing and building reports with advance charts and graphs. User mapping and security setup in PowerBI. Analyze data, hierarchies, groups, trends etc.
• ITIL/ ITSM/ Support process knowledge
• Familiarity with SSIS or Informatica experience
• Analyze source data, understand relationships, hierarchies, groups, trends etc.
• Good Exposure to ETL Concepts & Designing Sematic Layer based on Requirements
• Provide guidance in designing dashboards, reports, data load procedures (ETL Scripts)
• Recommend and establish standards to be adopted for organization for data integration, processing, and visualization.
• Strong understanding of data engineering and data ingestion technologies
• Collaborate with stakeholders / business unit representatives on data initiatives
• Review and provide feedback and recommendations for data models at conceptual, logical, and physical levels.
• Strong leadership skills with the ability to adapt to challenges and to mentor team members
• Must have good analytical and communication skills
• Provide the hands-on technical leadership to drive the team to innovate and deliver initiative on time.
• Lead in data governance, master data management initiatives
• Provide support in other areas beyond data architecture on an ad-hoc basis where required.
• knowledge of Python, Scala and other Big Data technologies are added advantage.