Engineering Associate Software Engineer – Database (Mumbai, India)

Affinity (, is a media + tech company focused on creating proprietary and thrilling ad experiences for brands with its key focus on user experience. We are seeking Technocrats who are eager, energetic & highly motivated for an Associate Software Engineer - Database position with our Engineering Group, located in Mumbai. The applicant will be expected to work in a team-oriented environment tackling tasks at various stages in the development process ranging from requirements gathering to implementation and testing. Emphasis is placed on the candidate's contribution to the group and their advancement in understanding and helping extend and maintain Affinity's technical product and infrastructure.


Because we work on the cutting edge of a lot of technologies, we need someone who is a creative problem solver, resourceful in getting things done, and productive working independently or collaboratively. This role will be responsible for developing and deploying a game-changing and highly-disruptive advertising technology platform. This person would also take on the following responsibilities:

  • Work closely with our engineering team to integrate your amazing innovations and algorithms into our production systems
  • Write amazing SQL queries
  • Work with Large datasets to build queries and derive insights from data, generate reports, manage databases, deliver quality.
  • Support business decisions with ad hoc analysis as needed
  • Propose and investigate new techniques
  • 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:

  • 2+ years of experience with SQL a must (preferably MySQL)
  • Experience as a Database developer writing SQL queries, DDL/DML statements, managing databases, writing stored procedures, triggers and functions and knowledge of DB internals
  • Knowledge of database administration, performance tuning, replication, backup and data restoration
  • Working knowledge of SQL, NoSQL, data warehousing & DBA
  • Experience processing large amounts of structured and unstructured data
  • Experience extracting and transforming data from remote data stores, such as relational databases or distributed file systems

Desired Skills:

  • 1+ year of Hands-on experience working with Cloudera Hadoop Distribution platform and Apache Spark
  • Comprehensive knowledge of Hadoop Architecture and HDFS, to design, develop, document and architect Hadoop applications
  • Working expertise with Apache Spark, spark streaming, and Python or Scala programming
  • Working knowledge of Map-Reduce, Hive, Kafka, HBase, Pig, Java and Impala
  • Experience with Python, R, and Big Data tools like Oozie, Zookeeper, Sqoop, Hive, Impala to manage and administer TB of data processing
  • Strong knowledge and experience with data analytics, mathematics and statistics

Additional Desired Skills:

  • Adequate exposure to Linux environment and file system
  • Exposure to handling large datasets (billions of records) is a plus
  • Excellent communication skills, ability to tailor technical information for different audiences
  • 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


Leave travel allowance, medical allowance, conveyance allowance, bonus etc. are a given everywhere & here at Affinity too. However, we strive to go beyond the usual & the drab. If a young competitive work environment, casual dress code, flexible working hours, on-the-house snacks, movies, sports events, flexible leaves, 5-day work week (Mon-Fri), recreational facilities (Pool, TT, Foosball, etc.) are your cheat-codes, then you're sure to win at Affinity.

We are a company, which realizes that its employees are its most important assets & hence we strive towards providing a conducive work environment which is flexible, professional, prospering, stable, innovative and truly international in scope. If you wish to build a career with a thriving, fast-paced and cutting-edge technology company that offers personal & professional growth, we sure do want to hear from you!

About Affinity

Founded in 2006, we are world's leading contextual ad network. We build innovative advertising media and monetization solutions for Advertisers & Publishers.

Our advertising media and monetization solutions are delivered via Affinity's Global Pay-Per-Click (PPC) & Display Advertising Networks. Both these networks help 100,000+ Advertisers reach out to their target audience by delivering over 50 Billion ad impressions each month.

This is achieved through exclusive contextual ad distribution via our network of 10,000+ premium publishers and syndication channels from across North America, Western Europe, Middle East, South-East Asia, India and Australia.

To apply, please send your resume to