Senior Software Engineer, Data Engineering

Senior Software Engineer, Data Engineering

L ocation : Mumbai or Bengaluru

JOB DESCRIPTION

Purpose : This position is required to provide technology leadership on medium to large scale products / platform with internal and direct customer impact.

Education : B.E. / B.Tech, MCA or Equivalent Computer Degree

Purpose :

Big Data team is responsible for providing the cloud-native platform for distributed data processing at SonyLiv, working with Spark, Presto as well as other

supporting technologies. This team is central to batch data processing in Data Platform at SonyLiv. It provides support for Spark, to ETL data into the

Petabytes-scale data warehouse and access that data using Spark and Presto & different Columnar Db like Redshift. It also provides sub-second latency for a

certain class of queries using Timeseries Db for monitoring. This team will collaborate with different stakeholder like Marketing, Analytics team, sales team,

content team to organises, classify, filter and structure data to make them available for their queries.

Reporting Relationship : Engineering Manager, Digital Business

Business / Channel / Function : Digital

Experience :

Overall 6+ years of IT experience with 5+ years in Data related technologies, and expertise of 3+ years in data-related AWS Cloud services

Have 3+ year of experience in ClickHouse or any other OLAP system

Mandatory to have knowledge of RedShift, Presto and BigQuery

Good to have experience in Druid.

Expert in SQL, Hive

Worked on at least one distributed data processing framework : Spark (Core, Streaming, SQL), Storm or Flink, etc.

Experience is building data warehouse for Marketing, sales and content team will be added advantage.

Roles & Responsibility

Establish and enforce Data Model, Data Warehouse, ETL, and BI standards

Gather and review analytical needs of key groups such as Sales & Marketing, Finance and Manufacturing

Train internal customers on available technologies

Analyse, document, develop, integrate, and deploy analytics as per business needs

Carry out monitoring and performance tuning in EDW, ETL and BI environments

Create, Manage the BI reports and Alerts for Product and Business requirement.

Why join us?

Sony Pictures Networks is home to some of India’s leading entertainment channels such as SET, SAB, MAX, PAL, PIX, Sony BBC Earth, Yay!, Sony

Marathi, Sony SIX, Sony TEN, SONY TEN1, SONY Ten2, SONY TEN3, SONY TEN4, to name a few!

Our foray into the OTT space with one of the most promising streaming platforms, Sony LIV brings us one step closer to being a progressive digitally-led

content powerhouse.

Our independent production venture- Studio Next has already made its mark with original content and IPs for TV and Digital Media.

But our quest to Go Beyond doesn’t end there. Neither does our search to find people who can take us there.

We focus on creating an inclusive and equitable workplace where we celebrate diversity with our Bring Your Own Self Philosophy. We strive to remain an

‘Employer

of Choice’ and have been recognized as :

• India’s Best Companies to Work For 2021 by the Great Place to Work® Institute
• 100 Best Companies for Women in India by AVTAR & Seramount for 6 years in a row - UN Women Empowerment Principles Award 2022 for Gender

Responsive

Marketplace and Community Engagement & Partnership

The biggest award of course is the thrill our employees feel when they can Tell Stories Beyond the Ordinary!