*Hi* *Please go through the below position and if you feel comfortable, then please send me your updated resume*
*Position : Sr. Hadoop Architect* *Location : Los Angeles, CA* *Duration : 6+ Months* *Interview : Phone then F2F* *Must Have: Hadoop, Big Data, and AWS really well* Job description below. Basically building a big data system to aggregate multiple 3rd part data sources to make recommendations to millions of users. This would then later be followed by reporting to users and an API to connect to users. *Hadoop, MySQL, and AWS is important.* *Job Description* Come help us architect a system from scratch that will potentially enhance the way our customers interact and enjoy our products/services. Project Objectives and Responsibilities: 1. Design and build a system that combines geolocation information from multiple sources 2. Design and build a system that aggregates internal metrics correlated to geolocation data 3. Extract geolocation information from GeoIP databases and APIs 4. Conduct supporting analyses to verify the quality and completeness of underlying data 5. Visualize aggregate internal metrics correlated by location through a dashboard (e.g. Tableau) 6. Build supporting system such as logging and error handling 7. Collaborate with our engineers to ensure adherence with our company standards and best practices *Skills and Experience:* * Database design and architecture experience * SQL and RDBMS concepts * MySQL database experience * SQL query language * Hadoop/Map Reduce ecosystem (Hadoop, HIVE) * Hive and Hive Partitioning * Build ETLs using scripting languages (e.g. bash, python) * Optimize ETLs and queries based on database types * Data visualization tools (Preferably Tableau) [image: logo] *Ankush Nirala* | Technical Recruiter | Apetan Consulting LLC Tel: 201- 620- 9700* 112 | Mail: 72 Van Reipen Avenue # 255 Jersey City, NJ 07306 | Corp.Office: 15 Union Avenue, office # 6, Rutherford, New Jersey 07070 | [email protected] | G-talk: [email protected] | www.apetan.com *[image: https://s3.amazonaws.com/images.wisestamp.com/icons/facebook.png]* <http://www.facebook.com/Apetanconsulting> *[image: https://s3.amazonaws.com/images.wisestamp.com/icons/linkedin.png]* <http://www.linkedin.com/company/apetan-consulting-llc?trk=top_nav_home> *[image: https://s3.amazonaws.com/images.wisestamp.com/icons/twitter.png]* <http://twitter.com/ApetanLLC> [image: e verify] *Disclaimer*: We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at [email protected] and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e mails to you. We are sorry for the inconvenience.
