Job Description

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\xe2\x80\x99s 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