Software Engineer Database
at Affinity Global Advertising Pvt Ltd(Posted by affinity global advertising pvt ltd)Software Engineer Database
at Affinity Global Advertising Pvt Ltd(Posted by affinity global advertising pvt ltd)
Premium
1 Opening
Posted 2 months, 3 weeks Back
Salary
INR5Lac 5Lac - 13Lac CTCCTC
Salary
INR5Lac 5Lac - 13Lac CTCCTC
Experience
4 yrsto6 yrs experience| Resume Required
Experience
4 yrsto6 yrs experience| Resume Required
Location
Malad West, Mumbai
Location
Malad West, Mumbai
Company Typically replies in 4 d
Additional Details
Job Type
Full Time
Shift Timings
10:00 AM - 7:00 PM(day shift)
Working Days
5 days|Off Days:Saturday,Sunday
Job Requirements
Education
Bachelor of Technology (B.Tech)/Bachelor of Engineering (B.E.) in Engineering mandatoryCompulsory
Master of Science (M.Sc.)/ Master of Technology (M.Tech.) mandatoryCompulsory
Graduation degree preferred
Experience
4 yrs to 6 yrs of experience as Analytics / Business Intelligence / Data Science in IT- Software mandatoryCompulsory
Age
27 - 35 yrs
Documents
Salary slipsCompulsory
Joining and Relieving Letters
Skills
MysqlHadoopPythonApache HadoopOracle DBACompulsory
Others
Working knowledge of SQL, NoSQL, data warehousing & DBACompulsory
Working knowledge of Map-Reduce, Hive, Impala, Kafka, HBase, Pig, and JavaCompulsory
4+ years of experience with SQL (MySQL) a mustCompulsory
2+ years of Hands-on experience working with Cloudera Hadoop Distribution platform and Apache SparkCompulsory
Experience as a Database developer writing SQL queries, DDL/DML statements, managing databases, writing stored procedures, triggers and functions and knowledge of DB internalsCompulsory
Working expertise with Apache Spark, Spark streaming, and Python or Scala programming.Compulsory
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 Adequate exposure to Linux environment and file system
- 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
- 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.)
Company Details
Affinity Global Advertising Pvt Ltd(Posted by affinity global advertising pvt ltd)
Small & Medium Enterprises (SMEs)|IT- Software|50-200 Employees
Founded in 2006, Affinity is a media + tech company focused on creating proprietary and thrilling ad experiences for brands with it’s key focus on user experience. Affinity operates 3 independent businesses:
1. mCanvas (mcanvas.com)
2. SitePlug (siteplug.com)
3. Display SSP
For more information, please visit www.affinity.com
Software Engineer Database
at Affinity Global Advertising Pvt Ltd(Posted by affinity global advertising pvt ltd)
5Lac - 13Lac CTC
Malad West, Mumbai
4 yrsto6 yrs experience
Company Typically replies in 4 d
