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.
Skills Required
C#, Rest, Javascript, Css, Entity Framework, Asp.net, Mvc, Azure, Sql, Html