MSBI + PowerBI Developer

PradeepIT Consulting Services Pvt Ltd; Bengaluru; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A leading IT consulting firm in Bengaluru is seeking an experienced IT professional for a Business Intelligence role. The ideal candidate has 4-6 years of experience in Microsoft stack BI, strong SQL programming skills, and the ability to manage client interactions. Responsibilities include designing data models and migrating large data sets. This role offers an opportunity to work in a dynamic environment.

Qualifications

• 4 to 6 years of total IT experience, with a minimum of 4 years in project implementation.
• Experience with Microsoft stack Business Intelligence.
• Awareness of star and snowflake schemas in DWH.

Responsibilities

• Interact with clients to understand requirements.
• Design data models to transform raw data into insights.
• Migrate huge data loads.

Skills

Interpersonal skills

SQL Programming

T-SQL

SSIS Development

Data warehouse concepts

Data migration

SQL Performance tuning

Debugging Stored Procedures

Job description

• Good Interpersonal skill and ability to manage multiple tasks with enthusiasm.
• Interact with clients to understand the requirements.
• 4 to 6 years of total IT experience, min 4 years of project implementation experience in Microsoft stack Business Intelligence.

Technical Skills

• Understand business requirements in MSBI context and design data models to transform raw data into meaningful insights.
• Awareness of star and snowflake schemas in DWH and DWH concepts
• Should be familiar and experienced in T-SQL queries.
• Have good knowledge and experience in SSIS (ETL) Development and deployment.
• Minimal knowledge in C# (Business Logic)
• Should have worked with migrating huge data loads.
• Good understanding of Data warehouse concepts.
• Strong SQL Programming skills and SQL Performance tuning
• Analyze / Debug Stored Procedures, Functions
• Should have hand-on experience in writing complex SQL queries.