Database / ETL / Power BI Developer - PradeepIT Consulting Services Pvt Ltd | Career Page

Database / ETL / Power BI Developer

Bengaluru, KA, India

Job Openings Database / ETL / Power BI Developer

Job Description

Roles & Responsibilities

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.

Good to have:

Description