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:
PermanentJob details are sourced from the employer's original posting.
Open job postingAbout the company
Dentsu Aegis Network is made up of eight global network brands - Carat, Dentsu, Dentsu media, iProspect, Isobar, mcgarrybowen, Posterscope and Vizeum and supported by its specialist/multi-market brands including Amnet, Amplifi, Data2Decisions, Mitchell Communications (PR), psLIVE and 360i. Dentsu Aegis Network is Innovating the Way Brands Are Built for its clients through its best-in-class expertise and capabilities in media, digital and creative communications services. Offering a distinctive and innovative range of products and services, Dentsu Aegis Network operates in 110 countries worldwide with over 23,000 dedicated specialists, with 17 countries, in 36 offices and over 9,000 people across Asia Pacific. We have a unique operating model of one P&L which enables integrated solutions that drives objectivity, collaboration and efficiency.