Why Join Us?At Omnicom Global Solutions India, work is more than a job—it 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 rates—because 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 recognition—celebrating impact while enabling continuous growth.At OGS India, we are not just hiring for a role—we 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 OverviewWe are seeking a highly skilled Senior Data Engineer to join our global team for a strategic initiative to migrate existing Informatica ETL jobs from Oracle Exadata to Azure Databricks. The target architecture will leverage Delta Lake and PostgreSQL within the Azure Databricks platform. This role requires deep expertise in Azure Databricks, strong familiarity with Informatica, and the ability to validate complex data transformation logic during migration.Key Responsibilities•Lead the conversion of Informatica workflows, mappings, and scripts into Databricks notebooks and pipelines.•Validate business logic by reviewing existing Informatica jobs using Informatica Developer tools.•Design and implement scalable data pipelines in Azure Databricks leveraging Delta Lake and relational databases.•Collaborate with onsite teams to ensure deliverables meet business requirements.•Perform unit testing and support QA teams during initial quality checks.•Optimize performance and reliability of migrated jobs.•Provide technical guidance to junior data engineers and contribute to best practices.Required Skills & Experience•5+ years of experience in data engineering with strong expertise in Azure Databricks.•Proficiency in PySpark, SQL, and Databricks workflows.•Hands-on experience with Informatica PowerCenter or similar ETL tools.•Familiarity with Oracle and PostgreSQL databases.•Strong understanding of Delta Lake architecture.•Experience with Lake Bridge (formerly Blade Bridge) or similar migration automation tools (highly desirable).•Knowledge of Azure services (Data Lake, Data Factory, Key Vault, etc.).•Ability to troubleshoot and optimize large-scale data pipelines.Nice-to-Have Skills•Experience with .NET development (C#, Node.js) for auxiliary tasks.•Exposure to data migration projects involving hybrid architectures.•Familiarity with CI/CD pipelines and DevOps practices in Azure.Location- Chennai & BangaloreShift - 2 to 11 pm
Job Title
Senior Data Engineer