Appmocx

SQL BI Developer

  • Job Type: Full Time
  • Industry Type: IT Sector
  • Industry Location: Bangalore/Bengaluru
  • Experience: 10-15yrs
  • No. of Positions: 10
  • Salary Range: 12-18 lac
  • Primary Skills: MDX Integration Services SSAS Stored Procedures Database Design MS SQL Server Dax
  • Secondary Skills: Data Warehousing SSIS ETL SQL
  • Job Location: Bangalore/Bengaluru
  • Posted Date: 382 days ago
Job Description

Roles and Responsibilities

 

Resource required for a regular position

 

Up to 1 year contract with MNC

 

SQL BI Developer (Data warehousing, MS SQL DB, SSIS, SSAS) - 10+ years

 

Excellent opportunity for a senior lead with more than 10yrs of experience in database, data warehousing with SSIS, SSAS. You are expected to work independently with minimal guidance.

 

Project Role: Senior Lead

 

Project Role Description: Design, build and configure applications to meet business process and application requirements.

 

Job Requirements:

Key Responsibilities : Design, build and deploy effective SSIS packages Implement stored procedures and effectively query a database Translate requirements from the business and analyst into technical code Identify and test for bugs and bottlenecks in the ETL solution Ensure the best possible performance and quality in the packages Provide support and fix issues in the packages

 

Technical Experience: Writes advanced SQL including some query tuning Experience in the identification of data quality Some database design experience is helpful Experience designing and building complete SSIS processes moving and transforming data for ODS, Staging, and Data Warehousing, Knowledge of DAX, MDX Query a plus, Utilize ad hoc techniques to perform on-the fly analysis of data Proficient in how to deploy to and debug a production SSIS environment

 

Professional Attributes:

A: Self-disciplined, strong problem solving, trouble shooting skills

B: Should have good communication skills verbal and written

C: Should have good team handling skills

 

Qualification: MCA/BE/BTECH

 

Work Experience: 10+ years

 

Must Have Skills: Microsoft SQL Server Integration Services (SSIS, SSAS), excellent knowledge of Database.

 

Good to Have Skills: DAX, MDX Query

Relevant Job Openings
Python Developer
Python Developer
Network Administrator or System Administrator
Associate Manager Marketing
SAP BI Developer
IOS Developer