B.Tech. or equivalent in Computer Science or Information Technology with at least 5+ years of experience in BI Technologies. Over all Exp minimum 8years .
Extensive experience with SQL, SQL Server Reporting Services (SSRS), Power BI Services, MDX and DAX functions.
Perform detailed analysis of source systems and source system data and model that data in Power BI & SSRS.
Experience in Power BI Rest API implementation and CI\CD.
Expertise and proven experience in development of reports, dashboards, KPI scorecards, aggregating data from multiple sources.
Extracting, transforming and loading data from multiple sources into Power BI applications.
Design, create and tune physical database objects (tables, views, indexes) to support logical and dimensional models; Maintain the referential integrity of the database.
Background in data warehouse design (e.g. dimensional modelling) and SQL databases and SQL statements.
In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
Analyse Data Model and Report Build with Other BI tools and Migrate to Power BI & SSRS.
Experience on writing SQL queries.
Good understanding in Datawarehouse Concepts like Star Schema, Snowflake Schema, Fact, Dimensions etc.
Good Knowledge on Writing Complex DAX function, MDX & Power Query.
Hands on experience in Building Power BI Data Model, Dashboard & Reports using various Chart, Slicer, Pivot and Custom Visuals.