Dot Net/VC++ Engineers

Vortalsoft Inc; New Jersey; On-site; USD 80,000 - 100,000; Full time

Job summary

Vortalsoft Inc is seeking a skilled IT professional to design and enhance its SQL Server data warehouse using MSBI tools. The ideal candidate should have 4-5 years of overall experience in IT, with strong skills in SQL, ETL development, and a solid understanding of data warehousing concepts.

The role requires expertise in query optimization, programming in T-SQL, Python, and R, along with the ability to collaborate effectively in cross-functional teams. Familiarity with various data sources is essential.

Qualifications

• 4-5 Years of overall experience in IT.
• 3-4 years of hands-on experience in complex ETL development in SSIS.
• Proficient in Data warehousing concepts and Kimball Architecture.

Responsibilities

• Design, develop, and enhance SQL Server data warehouse using MSBI tools.
• Optimize queries and manage SQL Server databases.
• Work with various data sources and experience in web development.

Skills

SQL

T-SQL

Python

R programming

C#

MSBI

Web services development

Data Warehousing

Query Optimization

ORM frameworks

Education

BE/MCA or equivalent degree in computer science

Tools

SQL Server

PowerBI

Qlik Sense

DB2

Microsoft Dynamics 365

MS-Access

SharePoint

Job description

Responsibilities

• Design, Development, and enhancement of SQL server data warehouse using MSBI tools (SSIS, SQL Server development, PowerBI/ Qlik Sense)
• Programming (T-SQL) in SQL Server, Python, R programming, and machine learning
• Experience in Query Optimization, Procedures/View, and Functions.
• Educational qualification: BE/MCA or equivalent degree in computer science
• In-depth knowledge of modules Design, C#, and .net Proficient in C# Development and CRM365
• Experience with HTML, JavaScript, and web development frameworks (AngularJS, Bootstrap, jQuery)
• Proven experience with software design and OOD methodologies
• Familiarity with Relational Databases and SQL
• Experience with ORM frameworks
• Experience with Web services development (SOAP, REST)
• Strong in Object Oriented Programming, MVC, Design patterns, and SOLID principles
• Ability to troubleshoot SQL server databases, ETL packages, and Reports.
• Data warehouse management and SQL Server using Kimball Architecture
• Experience working with various data sources like Microsoft Dynamics 365(CRM), Oracle, SQL Server, DB2, SQL Azure, MS-Access, and SharePoint, is a must.
• Good knowledge of DB2 and writing efficient SQLs
• Knowledge of SQL and T-SQL to write a complex query for reporting solutions is a must.
• Must be good at debugging in Query Optimization, Procedures/View, Functions and ETL.

Skills Required

• 4-5 Years of overall experience in IT.
• 3-4 years of hands-on experience in complex ETL development in SSIS for a Data Warehouse
• Proficient in Data warehousing concepts and Kimball Architecture.
• Proficient in writing complex SQL and PLSQL code.
• Ability to work effectively in cross-functional teams/modules.
• Strong analytical, problem-solving, and strategic thinking skills.
• Should be open to work in 24/7 setup and in rotational shifts.