Database / ETL / Power BI 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 a Database / ETL / Power BI Developer with at least 4 years of relevant experience. The ideal candidate will have strong SQL skills, expertise in Power BI, and an analytical mindset. Responsibilities include designing database schemas, maintaining ETL applications, and creating interactive dashboards. This role offers a dynamic work environment with opportunities for growth.

Qualifications

• 4 to 6 years of total IT experience, with min 4+ years of relevant experience.
• Good knowledge of SQL and experience with T-SQL objects.
• Experience with data gateways and report integration in web applications.

Responsibilities

• Design and deploy database schemas using data modeling techniques.
• Develop and maintain ETL applications.
• Create Dashboards & Visual Interactive Reports using Power BI.

Skills

SQL Performance tuning

Data Modeling

Power BI

DAX functions

ETL development

Education

Bachelor of Engineering (BE)

Tools

Power BI Report Server

SSIS

Job description

About the job Database / ETL / Power BI Developer

Job Description

• 4 to 6 years of total IT experience, with min 4+ years of relevant experience
• Good Interpersonal skill and ability to manage multiple tasks with enthusiasm.
• Interact with clients to understand the requirements.
• Up to date knowledge about the best practices and advancements in Power BI
• Should have an analytical and problem-solving mindset and approach.

Mandatory:

Education: Only BE will be preffered

• Using data modelling techniques, design and deploy database schemas.
• Strong SQL skills and SQL Performance tuning. Familiar with creating T-SQL objects, scripts, views, and stored procedure.
• Development and maintenance of (SSIS) ETL platform/applications.
• Diagnose and resolve database access and performance issues with excellent experience in query optimization and indexing.
• Understand business requirements in BI context and design data models to transform raw data into meaningful insights.
• Good knowledge of Power BI (Power BI Service, Power BI Report Server) and provide expertise in Data Modeling and provide recommendations.
• Experience working with direct query and import mode.
• Expertise in implementing static & dynamic Row level security.
• Knowledge to integrate Power BI reports in external web applications.
• Should have experience setting up data gateways & data preparation.
• Creation of Dashboards & Visual Interactive Reports using Power BI
• Experience working with third party custom visuals like Zebra BI etc.
• Have good knowledge of the various DAX functions and ability to write complex DAX queries.
• Awareness of star and snowflake schemas in DWH and DWH concepts
• Creation and maintenance of technical documentation.