Offer summary

Qualifications:

Bachelor's degree in Computer Science or related field., Extensive experience with SQL Server, MSBI, and ETL processes., Familiarity with NoSQL databases like MongoDB or Cassandra is preferred., Strong skills in data warehousing and reporting tools such as Power BI..

Key responsibilities:

Design and implement ETL processes and data mappings for data warehousing solutions.

Collaborate with stakeholders to understand business needs and develop scalable solutions.

Create and manage database objects including stored procedures and functions.

Develop reports and dashboards to present data insights effectively.

Job description

Job Purpose: Design ETL processes and develop source-to-target data mappings, integration workflows, and load processes. Design, develop, and implement enterprise-class data warehousing solutions. Use the MSBI (SSIS,SSAS,SSRS) platform and Power BI. Crafting and executing queries upon request for data. Presenting information through reports and visualization.

Major Key Result Areas:

1.Participate in design, development and support of Data Warehouse solutions.

2.Work with stakeholders to understand business needs and develop highly scalable solutions and make recommendations to help solve problems or improve processes.

3.Understanding and working with multiple data sources to meet business rules and supports analytical needs.

4.Good knowledge of creating Database objects like Stored Procedures, functions, triggers ,view and data migration from SQL Sever to MySQL Database.

5.Extensive knowledge of Power BI workspace and sharing concepts.

6. Good knowledge of NoSQL Database like MongoDB/Cassandra (Preferred)

Essential:

• SQL Server

• MSBI

• MSQL/Oracle/MongoDB

Preferred:

• Excellent understanding of Microsoft SQL Server/MySQL/MongoDB

• Design, build and configure applications to meet business process and application requirements.

• Experience in creating ETL using SSIS, Sql Server