The day-to-day development activities will require knowledge of the following concepts

- Expertlevel 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 (ADF), Azure Databricks, Airflow.

- In-Depth expertise in ADF and Databricks, including building scalable data pipelines, orchestrating complex workflows, implementing dynamic and parameterized pipelines, and optimising Spark-based data transfirmations for large-scale integrations.

- Hands-on experience with Databricks Unity Catalog for centralized data governance, fine-grained access control, auditing, and secure management of data assets across multiple workspaces.

- Should have worked on at least 1 development lifecycle of one of the following:

- End-to-end ETL project involving the above-mentioned ETL tools.

Ability to write and review test cases, test code, and validate code.
Good understanding of SDLC practices, including:

- Source control

- Version management

- Azure DevOps

- CI/CD practices

Requirements

From a project context

- Should have the ability to fully understand the context and use case of a project and develop a personal vision for it.

- Should be comfortable interfacing directly with customers on a daily basis.





- Should be able to communicate with functional users and translate requirements into tangible processes/models and documentation using available templates.

- Should be able to provide consultative options to customers on the best way to execute projects.

- Should have a positive understanding of project dynamics, including:

- Scoping

- Estimation

- Timeline planning

- Managing timelines in case of exceptions

Added Opportunities

- Opportunity to work as part of the Enterprise Data Management Centre of Excellence and contribute to the strategic growth of a fast-growing practice.

- Opportunity to mentor young, fresh minds from premier institutions.

- Exposure to multiple clients and projects simultaneously through the CoE model of working.

Secondary Skills

- Knowledge of Python is a bonus.

- Knowledge of SSIS is a bonus.

- Knowledge of Azure DevOps and Source Control/Repos is good to have.

Benefits

- At Psiog, we believe people grow when opportunities do. You’ll be part of an ecosystem that encourages curiosity, innovation, and ownership.

- Work with global clients, and enterprise environments, enabling exposure beyond conventional delivery models.

- Accelerated career tracks with a faster roadmap to leadership for those who demonstrate capability and initiative.

- Opportunity to explore diverse technologies, projects, learning opportunities and domains, allowing you to shape your own growth path.

- An organization that celebrates passion alongside profession, encouraging creativity, art, and individuality.

📌 Senior Databricks Engineer (Chennai)
🏢 Psiog
📍 Chennai