Job Responsibility-----SQL developer, Creating tables ,indexes, stored procedure, joins and more DBMS concept.As an MSBI engineer, I am responsible for evaluating, developing, maintaining and testing BI solutions for various analytics projectsBe responsible for building data warehouses, data marts & OLAP solutionsPlan, create, coordinate, and deploy data warehouse and business intelligence solutionsCreate best practices for data loading and extraction (ETL framework)Develop data architecture, data modeling, and ETL mapping solutions and data warehouse consistencyWould have a strong focus on collecting, parsing, managing, analyzing and visualizing large sets of data to turn information into insights using multiple platformsStrong knowledge of Data visualization using few visualization tools like Tableau, Visualr, Qlickview, expert in making KPI's. Import the data from different different data sources like flat file, excel, SQL server, My SQL, Oracle, sap and more.Qualification & Experience------3+ years of experience as a Data Warehouse Architect / Developer3+ years of experience with data analysis using SQL and other tools2+ years of data modeling experience, and knowledge of 3NF, Star-Schema and other data3 + years of experience working in SQL Server, SSIS and SSAS or SSRSAbility to work with multiple data sourcesAbility to develop, execute and analyze Multidimensional expressions (MDX)Ability to quickly create Analysis Service objects like data source views, dimensions and cubes and do enhancements to existing objectsAlso have----Proven ability with SQL Server database design best practices Demonstrated solid understanding of Data Warehouse design theory, including dimensional data modelingSignificant experience developing logical / physical dimensional models, OLAP processesProven ability using SQL Server 2012 (or 2014), SSIS Packages, Procedures, Functions, SQL, and other SQL Server Database Objects