Data Engineer (Datawarehousing)

Technology (I.T., and Systems) Chennai, India Mumbai, India


Description

Position at DNEG

Job Title: Data Engineer

Location: Mumbai

 

Our global IMS (Information Management Systems) team provides technical support, maintenance and development services to Operations departments such as Finance, HR & Talent Acquisition, Legal and Marketing and provide crucial support to various SaaS solutions and CMS systems.

Our Data Engineers have the following responsibilities:

  • Design and maintain ETL pipelines consolidating different data sources into the internal application structure
  • Design and maintain our internal Data Warehouses
  • Design and implement logical and physical data models based on technical and functional requirements.
  • Help optimize Data virtualization platform and associated data management/ modeling best practices  i.e. JBoss
  • Participate in work stream planning processes including inception, technical design, development, testing and the delivery of Analytics solutions.
  • Consult with other report developers and BI analyst around their reporting data requirements and assist in technical design, and performance troubleshoots.
  • Create easy-to-follow IT documentation for installation and configuration of applications, roadmaps, instructions, root cause analysis, change records, etc.

Must have

  • 2 years’ experience in a data engineer (or similar) role 
  • Experience in Databases, Relational and Non-relation: Postgres, SQL server, Elasticsearch
  • Experience programming in Python
  • Experience in writing and optimizing SQL queries and scripts
  • Experience in create ETLs: Informatica, Pentaho, Spark, SSIS (DTS)
  • Experience with Big Data platforms: Hadoop, Spark
  • Experience in Data Modeling and Data Warehousing concepts
  • Strong analytic skills related to working with unstructured datasets
  • Experience in agile methodology and scrum process
  • Fluent in English

 Nice to have

  • Exposure to Tibco Spotfire
  • Experience with data virtualization technology e.g. JBoss
  • Experience with Data pipeline tools Apache Airflow
  • Proven experience with concurrency, multithreading, and distributed system architectures

 

 

About Us

We are DNEG, one of the world's leading visual effects, animation and stereo conversion companies for feature film and television, with studios in London, Vancouver, Mumbai, Los Angeles, Chennai, Montréal, Chandigarh, Hyderabad and Goa. 


About Us
We are DNEG, one of the world's leading visual effects, animation and stereo conversion companies for feature film and television, with studios in London, Vancouver, Mumbai, Los Angeles, Chennai, Montréal, Chandigarh, Hyderabad and Goa.