Mandatory Skills
Python, Sql, AWS(Redshift, S3, EC2, API Gateway), Git, CICD
Experience
6 to 10 Years
Job Description
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 teams use to better understand trends and insights to improve market share/songwriter deals
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, 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
Education Qualificaiton
B.E., B.Tech, MCA
Roles & Responsibilities
Works with product owners, developers and AWS Infrastructure team to design and develop ETL processes
Develop and optimize stored procedures
Work on API integrations
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