Company :Microsoft ( Consulting Division)
Location :Hyderabad ( >50% onsite travel required )
Location :Hyderabad ( >50% onsite travel required )
Job Title :BI – Associate Consultant/Consultant
Location: Hyderabad
Experience : 3 – 7 yrs only
Education : Any engineering /MCA/MSC Comp Science /BSC Comp Science
Job Title - BI Associate Consultant/ Consultant
ROLE :
To engage in delivery of solutions that involve providing a realization of Microsoft’s SQL Server technology stack and to provide technology depth and experience in the conceptualization, design, and implementation of BI solutions based on MS technologies
Responsibilities :
KRA:
Maintain a high standard of delivery quality to ensure high level of Customer Partner Experience
Build on existing breadth of Microsoft products to provide significant contribution
Across technologies
Provide technical thought leadership and architectural vision
Mentor other consultants (associates and juniors)
SME and help with pre-sales, POCs and deal acquisition and management.
Skills :
Expertise / indepth knwoledge on BI related solution architecture
Expert Skill level in SQL Server Analysis Services as Follows:
· Experience in building data warehouse with at least one of the popular approach
· Experience in dimension modeling with at least more than 40-50 dimensions. Experience implementing Slowly changing dimensions.
· Experience Designing Cubes with each cube size > 100gb
· Experience Writing KPIs, Implement Drill-through
· Automated Deployment of a Data warehouse, Automated processing of Partitions/Cubes
· Experience designing Real-Time cubes with superior performance
Desired skill level in SQL Server Integration Services –
· Experience Implementing Highly scalable SSIS package
· Experience Implementing Checkpoint, Transactions, logging etc.
· Experience implementing all/most of the Data flow/Control flow Tasks in SSIS
· Experience in building Package deployment and package Configuration
· Experience implementing Analysis Services tasks
Optional /Nice to have:
· Experience in writing MDX scripts
· Experience working on SQL Server reporting services/ProClarity/Performance Point Server