Data Engineer

Job Summary

Are you passionate about innovation that transforms everyday products into extraordinary experiences?

IFF is a global leader in flavors, fragrances, food ingredients and health & biosciences, we deliver sustainable innovations that elevate everyday products.

Digital Technology Solutions: Accelerating innovation through data, technology and digital transformation, building intelligent solutions that enhance experiences and power smarter decisions.

The role is based in Chennai, India (Hybrid role). Be part of a motivated, passionate, and open-minded team where together we can achieve greatness and make a real impact. Your potential is our inspiration.

Where You’ll Make a Difference Design, develop, and maintain scalable ELT/ETL pipelines using Fivetran, HVR, and DBT to ingest data from SAP, Salesforce, Workday, and other source systems into the cloud data warehouse.

Build and maintain dimensional data warehouses (Kimball star/snowflake schemas) supporting Sales, Finance, Supply Chain, Manufacturing, HR, and Commercial analytics domains.

Write performant, modular Python/PySpark code for custom data ingestion, transformations, data quality checks, and orchestration logic.

Develop and optimize DBT models, macros, tests, and documentation; enforce coding standards, version control, and CI/CD discipline.

Own end-to-end administration and tuning of cloud data warehouses (Snowflake, Redshift, or Synapse) — warehouse sizing, RBAC, resource monitors, query performance, cost optimization, and data sharing.

Map and reverse-engineer SAP source tables and relationships across SD, FICO, Supply Chain, and Manufacturing modules to build accurate downstream models.

Implement data quality, observability, and lineage controls — tests, anomaly detection, freshness monitors, alerting, and incident response.

Partner with data architects on modelling standards, naming conventions, and reusable patterns; partner with analytics/BI teams to deliver consumption-ready datasets.

Troubleshoot production pipeline failures, perform root-cause analysis, and drive permanent fixes; participate in on-call rotations as needed.

What Makes You the Right Fit Bachelor's or Master's degree in Computer Science, Information Systems, Engineering, Finance or any other related discipline.

Minimum 5+ years of professional data engineering experience, with at least 3+ years building cloud data warehouses on Snowflake / Redshift / Synapse.

Demonstrated experience delivering production-grade pipelines from SAP ECC or S/4HANA into a modern cloud warehouse.

Deep, hands-on expertise with Fivetran and/or HVR for replicating data from SAP, Salesforce, Workday, and SaaS sources.

Production-grade experience with DBT — models, macros, tests, snapshots, exposures, packages, and CI/CD integration.

Strong understanding of ELT patterns, incremental loads, CDC (change data capture), and slowly changing dimensions.

Expert proficiency in Python for data engineering — pandas, SQLAlchemy, requests, orchestration SDKs, unit testing.

Hands-on experience with PySpark for distributed data processing on large datasets.

Strong SQL — advanced window functions, CTEs, query optimization, execution plan analysis.

How Would You Stand Out? Hands-on experience with lakehouse platforms — Databricks, Apache Iceberg, Delta Lake (medallion architecture, Unity Catalog).

SnowPro Core/Advanced, DBT Analytics Engineer, Databricks Data Engineer, AWS/Azure data certifications.

Experience with NoSQL databases — Neo4J (graph), MongoDB / CouchDB (document), Cassandra (wide-column) — and knowing when to use them.

Why Choose Us? Multinational and supporting environment

Health insurance

Training opportunities

Learning and development programs

We are a global leader in taste, scent, and nutrition, offering our customers a broader range of natural solutions and accelerating our growth strategy. At IFF, we believe that your uniqueness unleashes our potential. We value the diverse mosaic of the ethnicity, national origin, race, age, sex, or veteran status. We strive for an inclusive workplace that allows each of our colleagues to bring their authentic self to work regardless of their religion, gender identity & expression, sexual orientation, or disability.

Visit IFF.com/careers/workplace-diversity-and-inclusion to learn more