We look for the risk-takers, the collaborators, the inspired and the inspirational. We want the people who are brave enough to work at the cutting edge and create solutions that will enrich and improve the lives of people across the globe. So, if you want to make the world say wow, let's talk.
The conversation starts here. If this role matches your ambitions and skillset, let's get started with your application. Take a look at our other open positions too. Our many opportunities can lead to infinite possibilities.
[Job Title]:
Data Engineer
[Project Details]:
This project is to design and develop data delivery on Sony Music Publishing’s data warehouse on AWS.
[Technology and Sub-technology]:
- AWS
[Base Location]:
- Bengaluru
[Type]:
- Hybrid
[Qualifications]:
- BE/B.Tech in Computer Science
- 4+ years experience.
[Job Overview]:
The Data Engineer is responsible for designing and developing data delivery on our data warehouse on AWS.This data will be consumed by visual dashboards/reports that Sony Music Publishing teams use to better understand trends and insights to improve market share/songwriter deals
[Primary Skills]:
- Experience in data architecture including data modeling, data mining and data ingestion
- Experience with AWS associated technologies (S3 buckets, Glue, Data Pipeline, DMS, RDS, Redshift, Aurora, Lambda)
- Knowledge of creating ETL scripts with languages such as Python, Node.js, SQL
- Experience in data warehousing and big data
- Experience with Relational databases (SQL Server)
- Experience working in Agile/Scrum teams
AWS Services/Skills
Competency (Basic, Intermediary, Advanced)
1
Python
Intermediary
2
PySpark
Intermediary
3
EMR/Glue
Advanced
4
CICD
Intermediary
5
Serverless Framework
Intermediary
6
Cloud Formation Templates
Intermediary
7
Redshift
Advanced
8
Lambdas
Advanced
9
Step Functions
Advanced
10
Cloud Watch
Intermediary
11
ElasticSearch/Open Search
Advanced
12
Kibana
Advanced
13
Kinesis
Advanced
14
Redshift Spectrum
Advanced
15
DMS
Advanced
[Good to have Skills]:
- PySpark
- CICD
- Cloud Formation Templates
[Responsibilities and Duties]:
- Works with product owners, developers and AWS Infrastructure team to design and develop ETL processes
- Ability to automate and optimize processes as much as possible
- Ability to work in an Agile/Scrum team
- Ability to problem solve and propose solutions
- Use established Analytics standards/processes in ETL processes
- Ability to communicate with technical and business teams
- Ability to learn new technology quickly
[Keywords]
- Python
- PySpark
- EMR/Glue
- CICD
- Serverless Framework
- Cloud Formation Templates
- Redshift
- Lambdas
- Step Functions
- Cloud Watch
- ElasticSearch/Open Search
- Kibana
- Kinesis
- Redshift Spectrum
- DMS
Similar Jobs
What We Do
See everything new from the world of Sony USA—including electronics, PlayStation, movies, music and TV shows—plus find support for your Sony products.
Sony’s purpose is simple. We aim to fill the world with emotion, through the power of creativity and technology. We want to be responsible for getting hearts racing, stirring ambition, and putting a smile on the faces of our customers. That challenge, combined with our spirit of innovation, motivates us to create groundbreaking technology, entertainment, and services for people worldwide.
Our history as a global brand has been built around employees that all have a passion for touching peoples' lives, and pride in pushing beyond the status quo to produce truly extraordinary results.
We’re uniquely positioned because we operate in many different industries - from movies and music to video games and electronics. And, with offices around the globe, we benefit from a global workforce that learns and grows together through mutual respect.
If you're ready to join a diverse team at an innovation-led company with the power to change lives, then we encourage you to read up on the different Sony group companies and check out our Life page. Then, get in touch, and together, let’s make the world say wow.
