.NET/VC++ Engineer — ETL, Data Warehouse & BI

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

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.