Job Description
- Years of Experience : 5+ years ( PHARMA MANDATORY )
- Role Type : Fixed Term Contract (6 Months)
- Payroll Organization : Talpro
- Shift Timing : Day shift IST, from 12pm
- Notice Period : Immediate Joiners Only
- Work Location : Mumbai / Pune / Bangalore / Chennai / Ahmedabad / Noida (Chennai Most Preferred)
- Work Mode : Hybrid (3 Days from Office Weekly)
Mandatory Skills : - Databricks
- SQL
- PySpark
- Pharma or Life Sciences domain experience
Good to Have Skills :
Delta LakeData Lakehouse ArchitectureUnity Catalog or similar data governance toolsSQL development & performance tuning with large datasetsGit for version controlCI / CD for data pipelines (Databricks Repos, Terraform, dbx)Azure Databricks or Databricks on AWSPython for data manipulationStructured streaming in SparkAzure Purview or equivalent governance toolsAutomation experience with Terraform / dbxDatabricks NotebooksData documentation and dictionary practicesRole Overview / Job Summary :
We are looking for an experienced Databricks SQL Engineer with a Pharma or Life Sciences background to join our offshore Data Engineering team.
This role focuses on building efficient, scalable SQL-based data models and pipelines using Databricks SQL, Spark SQL, and Delta Lake.
The ideal candidate will play a key role in transforming raw data into valuable analytical insights, enabling critical decision-making across pharma-related business functions.
Key Responsibilities / Job Responsibilities :
Design and optimize SQL queries and data models in Databricks for large-scale datasetsDevelop and maintain robust ETL / ELT pipelines using Databricks workflowsImplement Delta Lake and Unity Catalog for secure and governed data assetsEnsure data quality via validation, testing, and monitoring mechanismsOptimize performance and cost for the data lakehouse environmentCollaborate with stakeholders to support analytics and business needsDeploy notebooks and SQL workflows using CI / CD best practicesDocument pipelines, queries, and data models to foster self-service(ref : hirist.tech)