The Job logo

What

Where

DBA Consultant-Technical

ApplyJoin for More Updates

You must Sign In before continuing to the company website to apply.

Smart SummaryPowered by Roshi
We are looking for an experienced SQL Developer with 3+ years of experience in MS BI Stack (MS SQL Server, Dataverse, SSIS, SSRS), MS Excel, PowerPivot, PowerQuery. You will be responsible for connecting to data sources, importing data, transforming data for Business Intelligence and creating advanced level calculations. Proficiency in Data Modelling, problem-solving, and excellent communication skills are required. Certification is not mandatory but beneficial.

Job Description

SQL Developer

Location

Bangalore

Who are we looking for?

A SQL Developer with minimum 3+ Years of experience 3+ years of experience in MS BI Stack (MS SQL Server, Dataverse, SSIS, SSRS), MS Excel, PowerPivot, PowerQuery.

 

Requirements:

 Proficiency in Data Modelling and Dimensional Analysis. Effectively liaison between Business Analysts, Developers, Systems Support and Customers/Stakeholders with a reputation for timely resolution of issues and a drive for business results.

 Experience performing Data cleaning and Data Quality control activities.

 Experience in communicating with stakeholders, Subject Matter Experts (SMEs), and end-users to better understand, analyse, communicate, and validate requirements.

 Advanced Execution Plan understanding

 Ability to create relationships between different tables from different data sources.

 Excellent communication, interpersonal, problem solving, and analytical skills.

 Ability to work in groups as well as individually with minimum supervision.

 Willing to learn new technologies as and when needed.

 Should have good communication skills in English..

 

Responsibilities:

 Connecting to data sources, importing data, and transforming data for Business Intelligence.

 Design methodology and project documentation creation

 Properly understand business requirements and develop data views/models accordingly.

 Creating advanced level calculations to provide prescriptive and predictive analysis.

 Understand business requirements to set functional specifications for reporting applications..

 

Technical Skills (Mandatory):

 3+ years of experience in MS BI Stack (MS SQL Server, Dataverse, SSIS, SSRS), MS Excel, PowerPivot, PowerQuery

 3+ years of experience in SQL/TSQL. Creating complex Custom Views using SQL, ETL services to create data sets for reporting.

 3+ years of experience in Data Warehouse /Business Intelligence Experience /SQL Development/Database concepts/DB performance Optimization

 3+ years of experience reviewing and documenting Technical & Business Requirements in relation to Business Intelligence, Data Management or software development projects.

 Experience in developing and managing stored procedures.

 Should have a proven track record of the skills outlined and a willingness to learn for gaps in the requirements..

 

Good to have Skills :

 Excellent in analytical thinking for translating data into informative visuals and reports.

 Should have knowledge and skills for secondary tools such as Power BI, SQL data warehouse, Visual Studio, etc..

Certification:

NA

 

Skills

PRIMARY COMPETENCY : Data Engineering PRIMARY SKILL : Microsoft SSIS/SSRS/T-SQL PRIMARY SKILL PERCENTAGE : 51 SECONDARY COMPETENCY : Data Engineering SECONDARY SKILL : Microsoft T-SQL Development SECONDARY SKILL PERCENTAGE : 25 TERTIARY COMPETENCY : Data Engineering TERTIARY SKILL : Oracle PL/SQL Development TERTIARY SKILL PERCENTAGE : 24

 

Set alert for similar jobsDBA Consultant-Technical role in Bangalore Urban, India
Mphasis Logo

Company

Mphasis

Job Posted

a year ago

Job Type

Full-time

WorkMode

On-site

Experience Level

3-7 years

Category

IT Services and IT Consulting

Locations

Bangalore Urban, Karnataka, India

Qualification

Bachelor

Applicants

Be an early applicant

Related Jobs

Mphasis Logo

DBA Consultant

Mphasis

Bengaluru, Karnataka, India

Posted: a year ago

We are looking for an experienced NOSQL DB Developer with expertise in Aerospike or other NOSQL Databases. Your role will involve enabling high availability, replication, backup and restoration, monitoring, performance tuning, partitions, and migrations. You should be proficient in configuring and fine-tuning NoSQL databases, identifying suitable indexes, and performing capacity planning. Knowledge of Linux, Perl, Python, Saltstack, Powershell, and Ansible is required. Additionally, experience with Splunk query development and dashboard creation is desirable. As part of the team, you will be responsible for incident management, change management, release management, and problem management. Collaborating with app developers to optimize queries and improve database execution plans is also expected. You will contribute to the development of automation and monitoring software, and participate in the delivery of proactive tasks to improve stability, performance, and fault tolerance. Excellent problem-solving skills and the ability to explore alternate design solutions are essential. As a team player, you should foster teamwork, effectively communicate with stakeholders, and ensure client satisfaction. Training and coaching team members to facilitate knowledge management activities will be required.