About the role
Omnicom Global Solutions (OGS) is an integral part of Omnicom Group, a leading global marketing and corporate communications company. Omnicom’s branded networks and specialty firms deliver advertising, strategic media planning and buying, digital and interactive marketing, direct and promotional marketing, public relations, and other specialized communication solutions to over 5,000 clients across more than 70 countries.
OGS India serves as a key global capability center for Omnicom, enabling its agencies and group companies with scaled delivery, specialized expertise, and integrated solutions. Our capabilities span Media, Data & Analytics, Technology, MarTech, Commerce, Business Support Solutions, Creative Production, Healthcare, and Strategy & Insights.
With a workforce of over 7,000 professionals in India, OGS continues to expand its capabilities and global impact, supporting the evolving needs of clients and agencies. We are committed to building future-ready talent and delivering high-quality, outcome-driven solutions.
Responsibilities- Lead the analysis, design, development, testing, and deployment of data engineering solutions on Azure Databricks.
- Participate in the migration of existing ETL/ELT workloads from Informatica to Azure Databricks.
- Analyse Informatica mappings, workflows, and dependencies and translate them into scalable Databricks solutions.
- Design and develop performant batch and streaming data pipelines using PySpark and SQL.
- Build and maintain data ingestion frameworks for structured and semi-structured data sources.
- Develop, optimize, and maintain Delta Lake-based data architectures using Medallion Architecture principles (Bronze, Silver, Gold).
- Work closely with Solution Architects and Business Analysts to understand business requirements and translate them into technical solutions.
- Implement data quality, reconciliation, validation, and monitoring processes throughout the migration lifecycle.
- Create technical specifications, design documents, and operational support documentation.
- Participate in code reviews and enforce engineering best practices and development standards.
- Support deployment activities through CI/CD pipelines and Infrastructure-as-Code frameworks.
- Collaborate with stakeholders, project managers, and delivery teams to ensure successful project outcomes.
- Mentor junior engineers and provide technical leadership across the project team.
- Support production releases and troubleshoot complex data issues when required.
Databricks & Data Engineering
Azure Databricks, Databricks Genie AI, PySpark, Spark SQL, Delta Lake, Unity Catalog, Databricks Workflows, Databricks Asset Bundles, Lakehouse Architecture, Medallion Architecture, Advanced Data Engineering patterns and best practices
Azure Services
- Azure Data Lake Storage Gen2 (ADLS Gen2), Azure Data Factory, Azure Synapse Analytics, Azure Key Vault, Azure Entra ID, Azure Monitor, Azure DevOps, Azure Functions
Database Technologies
- Oracle Database (Must Have), Oracle SQL, Oracle Stored Procedures, Oracle Data Modelling, Oracle Data Warehouse Concepts and Ms SQL server
Migration & Integration
- Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS)
- ETL to ELT migration methodologies
- Data Validation and Reconciliation
- Data Quality Frameworks
- Source-to-Target Mapping Analysis
- Data Integration Design
Engineering Practices
- Git
- CI/CD
- Terraform
- Infrastructure as Code
- Unit Testing and Automated Testing
- Performance Optimization
- Experience with Databricks LakeBridge, GPT, Claude AI.
- Databricks certification(s).
- Microsoft Azure certification(s).