Proficiency in MS SQL Server and related technologies.
Strong understanding of Data Warehouse concepts like Star Schema and Snowflake Schema.
Experience in designing, developing, and maintaining SQL-based solutions and ETL processes.
Educational background in any graduate field with relevant technical expertise.
Requirements:
Design and develop scalable SQL Server solutions for business and operational analysis.
Implement and optimize data warehouse models and ETL processes.
Provide post-go live support and resolve client issues related to SQL solutions.
Gather requirements and deliver end-to-end Business Intelligence projects.
Job description
Implement solutions using SQL Server suite and related technologies
Leverage advanced database systems including data warehouses, data marts, and models needed for business and operational analysis Develop high performing, reliable and scalable solutions
Work independently or as part of a team to design and develop solutions. Provide post-go live resolution of issues from clients. Strong knowledge in MS SQL Server.
Thorough Knowledge on Data Warehouse concepts like Star Schema, Snow Flake Schema, Dimension Tables and Fact Tables.
Strong experience on SQL building blocks.
Hands on experience in ETL process using any ETL will be a plus. Expert knowledge of Data Management, Business Intelligence and Analytics
Hands on experience in Report Designing, Report Deploying, Report Subscriptions using any reporting tool will be plus.
Experience in gathering requirements and coming up with solution approach. Should have delivered BI projects end to end.