1 HCLTech DOT NET Developer Job

PRINCIPAL FUNCTIONAL 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

EXPERIENCE & 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.
• Good team player.