Software Engineer Database

Affinity Global Advertising Pvt Ltd

Mumbai - Malad West

₹

5,00,000 - 13,00,000

/ monthly

Requirements

4 - 6 years experience

Graduate

27 - 35 years

No gender preference

Salary slips

Shift timings

Working days

5 days/week

Week offs

SATURDAY, SUNDAY

Morning Shift

10:00am - 7:00pm

Job description

The Job: The ideal candidate is someone who has rich experience handling data and building internet scale products. Our product deals with delivering ads to millions of users from around the world. We need someone who is a creative problem solver, good at writing SQL queries and resourceful in getting things done, and productive working independently or collaboratively. The person will be responsible for developing database processes for our advertising product, generating reports, managing data and deploying large databases across multi-cloud environment and adapting to changing and highly-disruptive advertising technology platform.

Responsibilities

Develop database processes, gather and process raw data at scale (including writing scripts, web scraping, calling APIs, write SQL queries in MySQL, etc.)
Work closely with our engineering team to integrate your amazing innovations and algorithms into our production systems
Support business decisions with ad hoc analysis as needed
Troubleshoot production issues and identify practical solutions
Routine check-up, back-up and monitoring of the entire MySQL and Hadoop ecosystem
Take end-to-end responsibility of the Traditional Databases (MySQL), Big Data ETL, Analysis and processing life cycle in the organization
Build, deploy and maintain real-time streaming pipelines and real-time analytics
Manage deployments of big-data clusters across private and public cloud platforms
Required Skills
4+ years of experience with SQL (MySQL) a must
2+ years of Hands-on experience working with Cloudera Hadoop Distribution platform and Apache SparkExperience as a Database developer writing SQL queries, DDL/DML statements, managing databases, writing stored procedures, triggers and functions and knowledge of DB internalsKnowledge of database administration, performance tuning, replication, backup and data restorationComprehensive knowledge of Hadoop Architecture and HDFS, to design, develop, document and architect Hadoop applicationsWorking knowledge of SQL, NoSQL, data warehousing & DBAWorking knowledge of Map-Reduce, Hive, Impala, Kafka, HBase, Pig, and JavaExperience processing large amounts of structured and unstructured dataExperience extracting and transforming data from remote data stores, such as relational databases or distributed file systemsExperience with Python, R, and Big Data tools like Oozie, Zookeeper, Sqoop, Hive, Impala to manage and administer TB of data processingWorking expertise with Apache Spark, Spark streaming, and Python or Scala programming.Strong knowledge and experience with data analytics, mathematics and statistics
Additional Desired Skills

Excellent teamwork skills, ability to self-start, share insights, ask questions, and report progress
Strong enthusiasm in solving messy problems with good solution design skills
Adequate experience with data analysis or software development in a Unix-based system
Ability to grasp emerging technical standards and apply in right direction

Benefits

Young, Dynamic, Competitive work environment
5-day work week
Casual dress code
Allowances (medical, maternity, etc.)
Bonus- Performance, Referral, Marriage & Child
Big Results = Big Rewards
Daily Recreational Activities organized by WeWork Community (Stand Up shows, Yoga Classes, Dance Classes, Training Programmes, etc.)

Additional Requirements

Experience

Analytics / Business Intelligence / Data Science,

IT- Software

Job Type

Full Time

Skills

Mysql

Hadoop

Python

Apache Hadoop

Oracle DBA

Documents

Joining and Relieving Letters

Other requirements

- Working knowledge of SQL, NoSQL, data warehousing & DBA

- Working knowledge of Map-Reduce, Hive, Impala, Kafka, HBase, Pig, and Java

- 4+ years of experience with SQL (MySQL) a must

- 2+ years of Hands-on experience working with Cloudera Hadoop Distribution platform and Apache Spark

- Experience as a Database developer writing SQL queries, DDL/DML statements, managing databases, writing stored procedures, triggers and functions and knowledge of DB internals

- Working expertise with Apache Spark, Spark streaming, and Python or Scala programming.

Posted on 27 Mar 2020

Home

•

IT support

•

IT support in Affinity Global Advertising Pvt Ltd