20049BR
Illinois
Job Description
MSBI Expert having 5+ years of Experience in various data management projects like data migration, data warehousing and Business Intelligence.
Must have handled data management project for complete SDLC life cycle
5+ years of Hands on experience in SSIS, SSRS and SSMS.
Having very strong SQL Query and SSIS performance optimization skill
2+years of Hands on experience in Azure SQL DB is good to have and Very Strong T-SQL
Ability to convert complex business requirements into Effective Data integration solutions
Design relational and analytical database schemas and architectures based on best practices and customer requirements/needs
Strong aptitude with ability to quick data analysis and turnaround
Provide recommendations on existing server and database level BI architecture using best practices
Architect, design, deploy and maintain enterprise level data warehouses and data marts including various data modeling techniques, multi-dimensional and tabular architectures
Understand Agile framework
Performance tuning and optimization in SQL SERVER and SSIS.
TFS - Branching, merging, code release to ensure the delivery of data related projects
Define and track assurance metrics such as peer review, code review, unit testing defects.
Document all problems and assists in their resolution
Understand Agile methodology and principles in product development.
Active participation and discussions with Client , Business partners, Scrum, and other stockholders.
Good experience in Microsoft SQL Server 2016/2019
Good to have Experience with other BI Tools such as Power BI, Big data tools and Azure Dev ops etc.
Good command over writing SQL queries and Stored Procedures.
Expert in Automation process implementation and Hands on experience in multiple system reconciliation
Familiarity with metadata management concepts, change management/version control concepts.
Qualifications
MS
Range of Year Experience-Min Year
5
Range of Year Experience-Max Year
8
#J-18808-Ljbffr