-
Us Citizen
-
Green Card
-
EAD (OPT/CPT/GC/H4)
-
H1B Work Permit
-
UG :- - Not Required
-
PG :- - Not Required
-
No of position :- ( 1 )
-
Post :- 10th Sep 2021
- Architect, design, deploy and maintain enterprise level data warehouses and data marts in SSAS and Power BI using various data modeling methodologies
- Write complex T-SQL code to be utilized by applications, ETL/ELT and reports
- Develop simple and complex DAX and Power Query code in SSAS and Power BI to achieve business requirements and user adoption
- Review, recommend and implement changes to existing T-SQL, DAX and or Power Query code for performance improvements
- Design complex reports and dashboards to satisfy business needs using Power BI
- Microsoft SQL Server 2000 to 2019
- Experience with designing, developing, and supporting database environments
- Experience with project management methodologies including agile and scrum
- Hands on expertise in SSIS, SSAS, SSRS, and Power BI
- Development concepts of star and snowflake schemas for data warehouses
- Familiarity with metadata management concepts, change management/version control concepts
- Versatile and knowledgeable in T-SQL programming, SSIS design, SSAS semantic modeling and Power BI design
- Experience in Azure data analytics tools and services, other programming or machine learning languages is a plus