Jr. SQL Developer - Onsite

Title Jr SQL Developer Location - New York, NY (Onsite) Type: Fulltime Must have Skills :SQL Developer with Power BI exp. Job Description:

• Design and Develop dashboard and reports for the client based on their requirements using Power BI and Power Query .
• Strong SQL Developer with Database design and modelling skills
• Good working knowledge of SSIS, SSRS and proper workflow design and exception management.
• Expertise working with relational and multidimensional database schemas and writing queries .
• Good to have hands on experience in Power Automate, other Power Platform tools and Excel Macro (VB Scripting) Skills Required: Power BI, SQL Server, SSIS, SSRS .
• Work closely with our business teams to understand business reporting and analytic requirements
• Develop new database schema/objects and/or review existing objects to improve storage efficiency and access
• Experience with Microsoft SQL databases, designing Power BI data models and reporting
• Creating, reviewing, analyzing, and modifying SQL scripts, Stored procedures and supporting programs to ensure proper execution
• Expert in data validation, cleansing, analysis, and Transforming Experience
• Experience in performance optimization and expert in writing SQL queries
• Should be having good knowledge on SQL Server database
• Should be able to analyze data issues.
• Should be able to debug View and Stored Procedure code issues
• DML, DDL, Stored Procedure, Views, Index
• Snowflakes Schema, Star Schema, Fact and Dimension modelling
• Complete the build of code on time and as per application coding standards and perform unit testing.
• Should have worked in SQL Server 2016, 2019 version.
• Working with delivery teams and users to manage Change Requests Issues, Risks and Assumptions associated with delivery.
• Defining innovative and effective solutions that meet the business requirements within architecture standards