Job Description:
Job Description
Details
Project Details
Comments
Business Title
Technical Lead
Years of Experience
Min 6 and max upto 10.
Job Descreption
The purpose of this role is to oversee the development of our database marketing solutions, using database technologies such as Microsoft SQL Server/Azure, Amazon Redshift, Google BigQuery. The role will be involved in design, development, troubleshooting, and issue resolution.
The role involves upgrading, enhancing, and optimizing the technical solution. It involves continuous integration and continuous deployment of various requirements changes in the business logic implementation. Interactions with internal stakeholders and/or clients to explain technology solutions and a clear understanding of client’s business requirements through which to guide optimal design/solution to meet their needs.
The ability to communicate to both technical and non-technical audiences is key.
Must have skills
Demonstrated expertise in Microsoft Azure, including Synapse, Azure Databricks, Azure Data Factory, Azure Data Lake Storage, Blob Storage, and Azure SQL Database.
Strong understanding of data warehousing, data marts, data modeling, data structures, and database design.
Proficiency in ETL processes, data ingestion, transformation, and orchestration.
Strong command of SQL and Spark SQL.
Hands-on experience with Snowflake, Azure Synapse (mandatory), Oracle, and relational databases.
Practical experience with PySpark and scripting in Python or UNIX shell.
Experience with streaming technologies such as Kafka or Kinesis.
Familiarity with real-time data processing frameworks like Spark Streaming or Flink.
Strong debugging and performance optimization skills.
Ability to independently deliver mid- to complex-level tasks.
Strong communication and client-facing experience.
Proficiency with version control systems (e.g., SVN) and project management tools (e.g., JIRA).
Comprehensive understanding of both relational and non-relational databases.
Good to have skills
Experience with data marketing platforms and campaign management systems.
Familiarity with SSIS and Informatica in addition to Azure Data Factory.
Knowledge of enterprise data workflow schedulers (Tivoli, Tidal, Stonebranch).
Strong understanding of modern development methodologies and SDLC principles.
Ability to mentor team members and contribute to solution design discussions. Should have an experience in Technical Lead/ team management experience. Understanding of Generative AI.
Key responsibiltes
Design and implement scalable, high‑quality data engineering solutions for clients.
Translate documented business requirements into technical designs and deliver solutions within defined timelines.
Develop, optimize, and maintain ETL/ELT pipelines using Azure Data Factory, Databricks, and other enterprise tools.
Create and maintain HLD (High-Level Design) and LLD (Low-Level Design) documentation and explain architectural decisions to internal teams.
Troubleshoot and resolve production issues quickly with effective root‑cause analysis.
Lead and participate in code reviews, ensuring adherence to development standards and best practices.
Independently handle medium to complex development and data engineering tasks.
Collaborate closely with cross-functional internal teams and external clients to ensure successful delivery.
Manage or contribute to 1–2 projects simultaneously, typically involving small teams (2–3 members).
Ensure efficient workflow execution using orchestration/scheduling tools like Tivoli, Tidal, or Stonebranch.
Maintain strong documentation and ensure project clarity for stakeholders.
Education Qulification
1. Bachelor’s or Master Degree or equivalent Degree
Certification If Any
1. Azure certification
2. Snowflake Associate / Core
.
Shift timing
12 PM to 9 PM and / or 2 PM to 11 PM - IST time zone
Location:
DGS India - Pune - Indiqube OrchidBrand:
MerkleTime Type:
Full timeContract Type:
PermanentSkills Required
- Bachelor's or master's degree, or equivalent degree
- Minimum 6 years of experience, with up to 10 years applicable
- Demonstrated expertise in Microsoft Azure, including Azure Synapse, Azure Databricks, Azure Data Factory, Azure Data Lake Storage, Blob Storage, and Azure SQL Database
- Strong understanding of data warehousing, data marts, data modeling, data structures, and database design
- Proficiency in ETL processes, data ingestion, transformation, and orchestration
- Strong command of SQL and Spark SQL
- Hands-on experience with Snowflake, Azure Synapse, Oracle, and relational databases
- Practical experience with PySpark and Python or UNIX shell scripting
- Experience with Kafka or Kinesis streaming technologies
- Familiarity with Spark Streaming or Flink
- Strong debugging and performance optimization skills
- Strong communication and client-facing experience
- Proficiency with version control systems such as SVN and project management tools such as JIRA
- Understanding of relational and non-relational databases
- Azure certification
- Snowflake Associate or Core certification
- Experience with data marketing platforms and campaign management systems
- Familiarity with SSIS and Informatica
- Knowledge of Tivoli, Tidal, or Stonebranch workflow schedulers
- Experience as a technical lead or in team management
- Understanding of Generative AI
dentsu Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about dentsu and has not been reviewed or approved by dentsu.
-
Parental & Family Support — Paid parental leave at full pay and caregiver supports (including backup care) are emphasized as standout elements. Feedback suggests family-oriented benefits are a strong part of the package.
-
Leave & Time Off Breadth — Flexible or unlimited PTO, extensive paid holidays, and a year-end office closure are established components. Feedback suggests time-off policies are generous and add meaningful flexibility.
-
Retirement Support — A large, established 401(k) plan with employer matching is clearly documented. Feedback suggests retirement benefits feel competitive and straightforward.
dentsu Insights
What We Do
We are dentsu. We team together to help brands predict and plan for disruptive future opportunities and create new paths to growth in the sustainable economy. We know people better than anyone else and we use those insights to connect brand, content, commerce and experience, underpinned by modern creativity. We are the network designed for what’s next
