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
Pro-active team player with focus on delivery Vimerse is a fast growing IT Company having a team of well trained professionals and with a huge spectrum of services to offer. It s having Innovation and Reliability as its driving force. We are proud to say that with our fleeting yet diverse experiences we are able to become a partner of choice with an astonishing accomplishment and customer satisfaction for our clients. Our main motive is to provide professional support system to our clients aligned to their core business activity with an aim to provide cost effectiveness and optimum utilization of available resource while keeping pace with dynamic market conditions. We are an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status