Data Engineer (ETL Specialist)

BOT VFX; Chennai District; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

BOT VFX in Chennai, India, is seeking a Data Engineer (ETL Specialist) for a full-time contract role on site. You will transform petabytes of unstructured media data into structured, sanitized datasets and work with legacy storage, VFX pipelines, and creative teams to enable efficient data workflows.

The role focuses on designing scalable ETL/ELT pipelines, implementing purge rules, handling large image sequences and video formats, and ensuring data quality across tiered storage.

Qualifications

• At least 3–5 years of experience as a Data Engineer building large-scale, automated ETL/ELT pipelines, with a proven track record of handling unstructured data, heavy media assets, or computer vision datasets.
• Strong technical grounding in pipeline development using Python (and bash/shell scripting) along with heavy data processing frameworks (e.g., Apache Spark, Ray, Dask).
• Hands-on experience with modern data architectures, containerization (Docker, Kubernetes), and cloud/on-prem block/object storage systems.
• Solid problem-solving capabilities focused on maximizing throughput under strict hardware constraints (balancing egress speeds with staging capacities).
• Exceptional communication skills with the ability to collaborate effectively across multidisciplinary teams, including VFX technical directors, systems engineers, and AI research teams.

Responsibilities

• Lead the architecture, implementation, and automation of scalable ETL/ELT pipelines capable of moving and processing tens of terabytes of unstructured media data daily.
• Implement automated "Purge & Keep" business rulesets to systematically clean directory trees, wiping intermediate render caches, temporary scratch files, and duplicates while preserving core visual assets.
• Build high-throughput processing pipelines to transcode, compress, and restructure massive image sequences (linear EXR, DPX) and video formats into AI-friendly data structures (e.g., WebDataset shards).
• Integrate and normalize lightweight metadata scrapings (camera telemetry, tracking curves, geometry tags) extracted from VFX workfiles (Silhouette, Nuke) and bind them deterministically to their corresponding visual assets.
• Manage high-velocity data movement across tiered storage layers (Hot NVMe/SSD staging, Warm Object Storage, and Deep Cloud/Tape Archives), ensuring the pipeline never bottlenecks network bandwidth or staging limits.
• Establish robust data quality assurance (QA) validation loops within the pipeline to catch corrupted frames, missing frame ranges, and accidental inclusion of restricted IP or sensitive assets.

Skills

Data engineering

ETL/ELT pipelines

Python

bash/shell scripting

Apache Spark

Ray

Dask

Docker

Kubernetes

Cloud/on-prem storage

Data quality and QA

VFX data handling

Tools

Silhouette

Nuke

FFmpeg

OpenEXR toolset

Job description

BOT VFX, a visual effects services company with global clients, is looking for a Data Engineer (ETL Specialist) as a full-time contract role. This is strictly an on location role in Chennai, India.

In this role, you will be responsible for transforming petabytes of unstructured, legacy VFX data (including heavy video plates, multi-layered OpenEXR sequences, and proprietary DCC workfiles) into highly structured, sanitized, and compressed datasets.

The ideal candidate brings deep expertise in large-scale data engineering and ETL pipeline architecture alongside an understanding of physical infrastructure limits. You will bridge legacy storage/tape systems, VFX pipeline scripts, and Creative Innovation needs. Reporting to the CIO, the role works closely with IT/IO and Creative Innovation teams.

POSITION RESPONSIBILITY

• Lead the architecture, implementation, and automation of scalable ETL/ELT pipelines capable of moving and processing tens of terabytes of unstructured media data daily.
• Implement automated "Purge & Keep" business rulesets to systematically clean directory trees, wiping intermediate render caches, temporary scratch files, and duplicates while preserving core visual assets.
• Build high-throughput processing pipelines to transcode, compress, and restructure massive image sequences (linear EXR, DPX) and video formats into AI-friendly data structures (e.g., WebDataset shards).
• Integrate and normalize lightweight metadata scrapings (camera telemetry, tracking curves, geometry tags) extracted from VFX workfiles (Silhouette, Nuke) and bind them deterministically to their corresponding visual assets.
• Manage high-velocity data movement across tiered storage layers (Hot NVMe/SSD staging, Warm Object Storage, and Deep Cloud/Tape Archives), ensuring the pipeline never bottlenecks network bandwidth or staging limits.
• Establish robust data quality assurance (QA) validation loops within the pipeline to catch corrupted frames, missing frame ranges, and accidental inclusion of restricted IP or sensitive assets.

REQUIRED SKILLS

• At least 3–5 years of experience as a Data Engineer building large-scale, automated ETL/ELT pipelines, with a proven track record of handling unstructured data, heavy media assets, or computer vision datasets.
• Strong technical grounding in pipeline development using Python (and bash/shell scripting) along with heavy data processing frameworks (e.g., Apache Spark, Ray, Dask).
• Hands-on experience with modern data architectures, containerization (Docker, Kubernetes), and cloud/on-prem block/object storage systems.
• Solid problem-solving capabilities focused on maximizing throughput under strict hardware constraints (balancing egress speeds with staging capacities).
• Exceptional communication skills with the ability to collaborate effectively across multidisciplinary teams, including VFX technical directors, systems engineers, and AI research teams.

Preferred Skills

• Basic familiarity with VFX file structures, directory archetypes, image sequence formatting, or open-source media utilities (FFmpeg, OpenEXR toolset).