Data Engineer

NTT DATA BUSINESS SOLUTIONS; New Delhi; On-site; INR 900,000 - 1,500,000; Full time

Job summary

NTT DATA BUSINESS SOLUTIONS is seeking a Senior Associate Data Engineer to transform data into analyzable structures and develop reusable data sets for reporting and insights.

You will analyze sources, design data models, and build ETL pipelines to support analytics, BI, and data science initiatives across enterprise systems. The role requires strong SQL, data modeling, and scripting skills, with on-site collaboration in Delhi, India.

Qualifications

• Bachelor's degree in computer science, software engineering, IT, or related field.
• Relevant certifications such as SAP, Microsoft Azure preferred.
• Certified Data Engineer or similar certifications preferred.

Responsibilities

• Create data models to enable analysis across datasets.
• Design and develop scalable ETL pipelines from source systems.
• Transform object and data models into database schemas.
• Support data migrations across databases and ERP systems (MS Dynamics, Oracle, SAP).
• Define data table structures and data models per requirements.
• Document ETL and migration processes and assist change initiatives.

Skills

Analytical mindset

Programming: Perl

Python

Shell scripting

Bash

SQL

Data modeling

ETL

Communication

Education

Bachelor's degree in CS/IT or related field

Tools

SAP Data Services

SAP BTP

Microsoft Azure Data Factory

SQL Analysis Services

SAP

MS SQL / MySQL

Hadoop

Cassandra

Storm

Job description

Job Summary

The Senior Associate Data Engineer is a developing specialist role, tasked with supporting the transformation of data into a structured format that can be easily analyzed in a query or report.

This role is responsible for developing structured data sets that can be reused or compliment other data sets and reports.

This role analyzes the data sources and data structure and designs and develops data models to support the analytics requirements of the business which includes management / operational / predictive / data science capabilities.

Key responsibilities

• Contributes to the creation of data models in a structured data format to enable analysis thereof.
• Proactively supports the design and development of scalable extract, transform and loading (ETL) packages from the business source systems and the development of ETL routines to populate data from sources.
• Participates in the transformation of object and data models into appropriate database schemas within design constraints.
• Interprets installation standards to meet project needs and produce database components as required.
• Receives instructions from various stakeholders to create test scenarios and be responsible for participating in thorough testing and validation to support the accuracy of data transformations.
• Proactively supports the running of data migrations across different databases and applications, e.g. MS Dynamics, Oracle, SAP and other ERP systems.
• Support the definition and implementation of data table structures and data models based on requirements.
• Contributes to analysis, and development of ETL and migration documentation.
• Receives instructions from various stakeholders to evaluate potential data requirements.
• Supports the definition and management of scoping, requirements, definition, and prioritization activities for small-scale changes and assist with more complex change initiatives.
• Contributes to the recommendation of improvements in automated and non-automated components of the data tables, data queries and data models.

To thrive in this role, you need to have:

• Knowledge of the definition and management of scoping requirements, definition and prioritization activities.
• Understanding of database concepts, object and data modelling techniques and design principles and conceptual knowledge of building and maintaining physical and logical data models.
• Knowledge of Microsoft Azure Data Factory, SQL Analysis Server, SAP Data Services, SAP BTP.
• Understanding of data architecture landscape between physical and logical data models.
• Analytical mindset with good business acumen skills.
• Problem-solving aptitude with the ability to communicate effectively, both written and verbal.
• Ability to build effective relationships at all levels within the organization.
• Seasoned expert in programing languages (Perl, bash, Shell Scripting, Python, etc.).

Academic qualifications and certifications:

• Bachelor's degree or equivalent in computer science, software engineering, information technology, or a related field.
• Relevant certifications preferred such as SAP, Microsoft Azure etc.
• Certified Data Engineer, Certified Professional certification preferred.

Required experience:

• Moderate level experience in data engineering, data mining within a fast-paced environment.
• Familiarity with building modern data analytics solutions that delivers insights from large and complex data sets with multi-terabyte scale.
• Moderate level experience with architecture and design of secure, highly available and scalable systems.
• Familiarity with automation, scripting and proven examples of successful implementation.
• Familiarity with scripts using scripting language (Perl, bash, Shell Scripting, Python, etc.).
• Moderate level experience with big data tools like Hadoop, Cassandra, Storm etc.
• Moderate level experience in any applicable language, preferably .NET.
• Familiarity with working with SAP, SQL, MySQL databases and Microsoft SQL.
• Moderate level experience working with data sets and ordering data through MS Excel functions, e.g. macros, pivots.

Workplace type

On-site