Tech Lead Data Engineer

Why Join Us?

At Omnicom Global Solutions India, work is more than a jobit is a space to grow, thrive, and feel celebrated. We foster a culture built on integrity, respect, equity, pride, and belonging, offering a holistic employee experience that empowers real impact.

What Makes Life at OGS Special:

Trust Through Transparency & Integrity: We keep things open and fair with easy access to leaders and HR, ways to share your feedback, and clear processes that ensure honesty and accountability.

Culture of Support & Care: We prioritize your well-being through comprehensive benefits (Group Personal Accident Insurance, Health Insurance, Group Term Insurance), flexible leave options (Care4Me, MeDay, paternity leave, maternity leave, bereavement leave), structured onboarding, and resources for emotional and physical health.

We also offer complimentary meals, sports facilities like a TT table, subsidized CULT gym membership, and cab services at subsidized ratesbecause your comfort matters. Our people-centric policies drive equity for all.

Recognition & Growth: We empower your career through sponsored learning, leadership development programs, internal mobility opportunities, and meaningful recognitioncelebrating impact while enabling continuous growth.

At OGS India, we are not just hiring for a rolewe are inviting you to join a purpose-driven, people-first culture where your growth, well-being, and individuality are celebrated every step of the way.

Role Overview:

We are seeking an experienced Azure & Azure Databricks Tech Lead to lead our organization's strategic migration from Informatica & Oracle to Databricks and oversee the modernization of our data infrastructure on Azure. This is a critical technical leadership role that combines hands-on expertise with mentoring responsibilities, driving both technical excellence and organizational capability development in cloud-native data platforms.

The successful candidate will provide technical vision and direction for our Databricks migration initiative, lead a team of data engineers, and ensure enterprise-grade data management practices, design patterns, and architectural standards are implemented across all projects.

The Azure & Databricks Tech Lead is responsible for:

Leading the Informatica & Oracle-to-Databricks Migration Project Designing and executing the technical strategy for migrating critical data workloads from Oracle to Databricks on Azure

Technical Leadership Providing expert guidance on Azure

Databricks architecture, best practices, and implementation strategies:

Team Development Coaching and mentoring senior data engineers and data engineers on Databricks, Azure, and enterprise data management principles

Quality & Standards Establishing and enforcing data management best practices, design patterns, and architectural standards

Solution Design & Review Collaborating on technical designs, architecture decisions, and code quality oversight

Cross-Functional Collaboration Working with stakeholders, solution architects, and business teams to align technical solutions with organizational needs

Technical Architecture & Design:

Provide technical leadership on Azure and Databricks architecture decisions

Participate in designing data pipelines, schemas, and integration solutions

Conduct technical design and code reviews to ensure adherence to best practices and architectural standards

Identify and resolve complex technical challenges related to data modeling, partitioning, indexing, and performance

Collaborate with cloud architects and solution designers on enterprise scale solutions

Ensure proper understanding of how concepts transfer across platforms

(e.g., Oracle partitioning vs. Databricks approaches)

Data Management & Quality:

Champion enterprise data management best practices and prevent,"Cowboy coding" approaches

Oversee data modeling, schema design, and database structure to ensure consistency and maintainability

Ensure proper separation between source data management and use-case specific views/transformations

Address data integrity, consistency, and quality concerns proactively

Advise on potential Azure SQL integrations and relational database design considerations

Establish standards for data partitioning, access patterns, and performance optimization

Technical Leadership & Standards:

Define and evolve development practices, tools, and procedures for the data engineering team

Champion adoption of cloud-native patterns and Azure/Databricks best practices

Participate in design reviews and recommend changes to meet business and technical requirements

Manage technical documentation and knowledge repositories

Stay current with Databricks, Azure, and data platform technologies and innovations

Collaboration & Communication:

Work closely with project managers, solution architects, and technical stakeholders

Provide regular technical status updates and escalations to leadership

Collaborate cross-functionally to optimize development processes and ensure successful project delivery

Communicate technical concepts clearly to both technical and business stakeholders

Partner with QA and infrastructure teams to resolve issues and optimize solutions

Core Technical Experience:

Azure Databricks (PRIMARY FOCUS) 5+ years of hands-on

Databricks experience; deep expertise in Databricks architecture, cluster management, and data processing

Relational Databases (ADVANCED) 7+ years of advanced relational database expertise including design, optimization, and data integrity concepts

Oracle Experience (HIGHLY PREFERRED) 5+ years of Oracle database administration, development, or architecture; understanding of Oracle-specific concepts and optimization techniques

Azure Cloud Platform 4+ years of Azure experience; proficiency with Azure data services, storage, networking, and integration services

Data Platforms & Tools Experience with modern data stack tools; understanding of ETL/ELT, data warehousing, and data lake concepts

Leadership & Project Experience:

Technical Leadership 3+ years in a technical lead or architect role with proven mentoring and team development experience

Project Leadership Experience leading complex technical projects, preferably including migration, modernization, or platform transformation initiatives

Team Management 2+ years managing or leading technical teams with full responsibility for performance and development

Migration Experience (HIGHLY PREFERRED) Experience leading database migrations or platform modernization projects; understanding of migration challenges, data validation, and cutover processes

REQUIRED KNOWLEDGE & ABILITIES

Technical Competencies:

Data Modeling & Database Design Expert-level understanding of relational design, normalization, data integrity constraints, and dimensional modeling

SQL & Query Optimization Advanced SQL proficiency; ability to optimize queries and troubleshoot performance issues

Databricks Ecosystem Spark, Delta Lake, MLflow, Notebooks, jobs, clusters, and production deployment patterns

Data Pipeline Architecture ETL/ELT design, data orchestration, error handling, and monitoring

Azure Services Azure Data Factory, Azure SQL Database, Azure Storage, Azure Synapse, networking, and security

Programming/Scripting Python, Scala, SQL, and scripting for data engineering tasks

Cloud Architecture Principles Scalability, security, cost optimization, and disaster recovery

Soft Skills & Leadership Abilities:

Strong technical leadership and mentoring abilities

Excellent communication skills (written and verbal); ability to explain complex technical concepts to diverse audiences

Ability to manage multiple priorities and complex projects with tight deadlines

Detail-oriented with strong problem-solving and analytical skills

Collaborative approach with ability to partner effectively with cross-functional teams

Demonstrated commitment to quality, best practices, and continuous improvement

Strong ownership mindset for entire technical solutions and outcomes

Strong technical background with proven leadership abilities

Ability to balance hands-on technical work with mentoring and strategic guidance

Ownership of entire technical solution lifecycle

Availability for after-hours support during critical migration phases

Willingness to travel if needed for project requirements or team collaboration

Experience with PostgreSQL or other relational databases

Experience with data governance, data quality frameworks, or metadata management

Background in data warehouse or data lake implementations

Experience with Apache Spark or Hadoop ecosystems

AWS or GCP experience (for cloud platform comparison and best practices)

Agile/Scrum certification or experience

Background in solution architecture or enterprise architecture

Location- Chennai & Bangalore

Shift - 2 to 11 pm