Database/ETL Developer

Pradeepit Global Consulting Private Limited; Bengaluru; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Pradeepit Global Consulting Private Limited seeks an experienced Database/ETL Developer to design, implement and maintain databases across multiple projects within a shared business domain. The role covers data modelling, physical schemas, database programming, ETL development, and BI-related work.

Responsibilities include developing and maintaining stored procedures, views and functions, building and tuning ETL processes with SSIS, and ensuring performance and scalability of database systems to

Qualifications

• Overall 6-8 years of experience in data/DB development.
• 6-8 years in MS SQL Server and database development.
• 3-4 years of ELT development using SSIS.
• Experience with data modelling with normalization techniques.
• Strong skills in query optimisation and indexing.
• Experience in writing complex queries and stored procedures.

Responsibilities

• Design and deploy database schemas using data modelling techniques.
• Develop and maintain stored procedures, views and functions for hosted applications or batch processing.
• Develop and maintain ETL platforms/applications; diagnose and resolve DB access/performance issues.
• Ensure DB systems meet business and performance requirements.
• Identify inefficiencies and propose solutions to optimize databases.
• Develop, implement, and maintain change control and testing for DB modifications.
• Produce ad-hoc queries and reports to support business needs.
• Create and maintain technical documentation.

Skills

Data modelling

Query optimisation

Dynamic SQL

DML coding

Stored procedures

ETL development

Education

BE/BTech in IT

Master is a plus

Tools

MS SQL Server

SSIS

Java

Job description

Database/ETL Developer FAQ:

1. Min 3-4 years working experience on MS SQL Server are eligible candidate - SQL Query knowledge - Rating - ?/10
2. Have you worked on data physical modelling with normalization techniques? How much relevant experience (Mandatory min 3-4years)
3. How much relevant experience you have on ELT development using SSIS?
4. how much relevant experience on Stored procedures in MS SQL server?
5. Have you worked on SQL query performance tuning?

J ob Description

The role is to develop and maintain databases across multiple projects sharing a common business domain.

Database development cycles include data modelling, physical schemas, database programming, ETL development, Data warehouse and BI development.

Accountabilities:

• Using data modelling techniques, design and deploy database schemas.
• Development and maintenance of the database stored procedures, views and functions for hosted web applications or batch processing.
• Development and maintenance of ETL platform/applications Diagnose and resolve database access and performance issues with excellent experience in query optimisation and indexing.
• Ensure all database systems meet business and performance requirements.
• Identify inefficiencies in current databases and investigate solutions
• Develop, implement, and maintain change control and testing processes for database modifications.
• Produce ad-hoc queries and develop reports to support business needs
• Creation and maintenance of technical documentation.

Working and Skill Requirements:

• Overall 6 8 Yrs Exp
• In-depth experience in conceptual, logical and data physical modelling with normalization techniques.
• 4 6 years of experience in database development with MS SQL Server
• 3 4 years of experience in ELT development using SSIS
• In-depth experience in writing complex stored procedures.
• Command on writing dynamic SQLs
• Excellent knowledge of writing complex queries
• Hands-on query optimization and enhancements
• Command on writing DML codes
• Experience in constructing ETL packages, including data loads, transformations, file processing and notification tasks using SSIS
• Knowledge of Java programming is a plus Education: BE, Btech in IT.
• Master is a plus
• Experience: Have 6 -8 years of previous work experience in the areas mentioned above
• Experience Level Mid Level