Data Engineer || Chennai || WFO

Job Role : Data Engineer

Full time / Contract

Experience : 2 to 6Yrs

Mode of Work : WFO Only 

Location : Chennai

Job description:

Key Skills: SQL, ETL Tools, ADF, ADB, SSIS, Reporting Tools

Key Requirements:

The day-to-day development activities will need knowledge of the below concepts.

 Expert-level knowledge in RDBMS (SQL Server) with clear understanding of SQL query writing, object creation

and management and performance and optimisation of DB/DWH operations.

 Good understanding of Transactional and Dimensional Data Modelling, Star Schema, Facts/Dimensions,

Relationships

 Good understanding of ETL concepts and exposure to tools such as Azure Data Factory, Azure Databricks,

Airflow.

 In-depth expertise in Azure Data Factory and Databricks, including building scalable data pipelines, orchestrating

complex workflows, implementing dynamic and parameterized pipelines, and optimizing Spark-based data

transformations for large-scale integrations.

 Hands-on experience with Databricks Unity Catalog for centralized data governance, fine-grained access control,

auditing, and managing data assets securely across multiple workspaces.

 Should have worked on at least 1 development lifecycle of one of the below:

 End-to-end ETL project (Involving above mentioned ETL tools)

 Ability to write and review test cases, test code and validate code.

 Good understanding of SDLC practices like source control, version management, usage of Azure Devops and

CI/CD practices.

Project context:

 Should have the skill to fully understand the context and use-case of a project and have a personal vision for it –

Play the role of interfacing with customer directly on a daily basis.

 Should be able to converse with functional users and convert requirements into tangible processes/models and

documentation in available templates.

 Should be able to provide consultative options to customer on best way to execute projects

 Should have a good understanding of project dynamics – scoping, setting estimates, setting timelines, working

around timelines in case of exceptions, etc.

Preferred skills:

 Knowledge of Python is a bonus

 Knowledge of SSIS is a bonus

 Knowledge of Azure Devops, Source Control/Repos is good to have