Find Jobs
Hire Freelancers

Hive/SQL queries for equivalent Excel transformations

$30-250 USD

Closed
Posted over 4 years ago

$30-250 USD

Paid on delivery
Write Hive/SQL queries which can be incorporated as Hive queries so that transformations done through excel can be automated. All Create, Insert table statements need to be included. Currently the data is being transformed manually and through excel formulas. NOTE - 1) No updation is allowed in Hive, so use only Insert Overwrite. 2) Intake input data in Raw format (csv) and process/transform it through SQL queries. 3) Hive and Python is being taken care of, you need to be only good at SQL !!
Project ID: 20778170

About the project

20 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
20 freelancers are bidding on average $169 USD for this job
User Avatar
Hi Dear I read your requirements carefully. I have rich experience with Python Django, Flask, selenium, Web Scrapy, software architecture and so on. You can see my good reviews for python projects. Please touch me. I will provide good service for you. Regards.
$140 USD in 7 days
5.0 (28 reviews)
5.2
5.2
User Avatar
Highly effective Data Scientist/Data Engiener with over 25 years of experience. I have extensive Spark experience both in PySpark and Scala also in MLLib. I checked your Scala code and should be able to convert it to PySpark. TECHNICAL SKILLS • Big Data (Hortonworks and Cloudera) – Spark(PySpark, Scala), Kafka, Hive,Impala, NiFi, HDFS, Sqoop, Ranger, Yarn, Solr, SAM, Schema Registry, SuperSet • Language: Python, Scala, R, JavaScript • Data Visualization – Tableau, PowerBI, OBIEE, DOMO • Plunk & ELK Stack – ElasticSearch, Logstash, Filebeat, Kibana • AWS – S3, RefShift, DynamoDB, Athena, Kinesis, EMR, Aurora, Glue • Azure – Data Warehouse, Polybase, SQL Server, HDInsight, SSIS, SSAS • ETL – Informatica Power Centre, Informatica Big Data Management (BDM), SSIS • Data Science & Engineering – R / RStudio / SparkR Packages: dplyr, ggplot2, stringr, plyr, carrat, SparkR, NLP, tibble, TensorFlow, curl, Python / PySpark, MLLib • Libraries: MLLib, NumPy, SciPy, Pandas, Matplotlib, Seaborn, SciKit-Learn
$250 USD in 7 days
5.0 (2 reviews)
4.1
4.1
User Avatar
- I have experience of working on Hive SQL for the similar in my working company. -Looking to bring the benefits of data analysis to your business, the company might have analytics already implemented but with the skill of R Programming Language, Knowledge of Machine Learning, Algorithms, SQL, Amazon Redshift, TIBCO Spotfire, MS Excel I can help to present the metrics well. -I have done Certifications in Business Analytics and working as Analyst for 3 years. -Proper coding skills with Python, R, Pyspark, SMV, HIVE SQL, etc., I am well into Big Data so any kind of data can't challenge my skills -With the experience in customer retention and Operations, my analytical skills have delved into good business insights which can help the business. -Very good with statistics and predictive modeling -I worked with USA multinational healthcare giants such as Genentech, Aimmune, etc on various projects which makes me very comfortable to work within different aspects
$140 USD in 3 days
4.9 (4 reviews)
4.0
4.0
User Avatar
Hi, I have 8 years of experience and working on hadoop, spark, nosql, java, BI tools(tableau, powerbi), cloud(Amazon, Google, Microsoft Azure)... Done end to end data warehouse management projects on aws cloud with hadoop, hive, spark and presodb. Worked on multiple etl project like springboot, angular, node, PHP, Kafka, nifi, flume, mapreduce, spark with XML/JSON., Cassandra, mongodb, hbase, redis, oracle, sap hana, ASE.... Many more. Let's discuss the required things in detail. I am committed to work done and strong in issue resolving as well. Thanks
$277 USD in 5 days
5.0 (3 reviews)
3.4
3.4
User Avatar
Hi, I am a bigdata developer and a module lead in reputed MNC.i an into the IT industry for more then 12 years. I have tonnes of experience in developing projects using Java,Apache Spark,Hive,Kafka,Scoop,Pig,Scala,aws,jsp,html,css,jquery and managing cluster on aws cloud. I have my youtube channel to on AWS . I have delivered multiple projects and lectures on setting up apache Spark on AWS EMR... I can be the best suitable person for your requirements I have also created multiple freelance project on AWS EMR,S3,REKOGNITION, RDS, and many more services Let me know your view Regards,
$250 USD in 7 days
5.0 (1 review)
1.7
1.7
User Avatar
Hey, we are a company based out of the United States and I believe that we can complete what you are asking in an efficient manner. Please reach back out to us and we are looking forward to working with you in the future
$166 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
My main specialty is Oracle Developer. But we have 6 months experience with Spark and Hive. Update is suspicious operation. You should remember that Hive fully rewrights tables .
$140 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have extensive experience with SQL. Please consider me for this project. Thanks and regards, Kavita
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Experience in oracle sql Will be able to complete your task if it is considering oracle sql. Over 7 years experience in working with oracle db
$150 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Experienced Senior Software Engineer with a demonstrated history of working in the hospital & health care industry. Skilled in SQL, Oracle Database, Requirements Analysis, Databases, and PL/SQL. Have a strong knowledge in PHARMA domain. Completed NUCLEUS & Aggregate Spend training. Mentoring the team of 15 members to stick to the ETA for deliverable, solved number of production issues. Closed 500 clarify tickets. Given Presentations on the topic NUCLEUS PROCESS (MDM), RELTIO DCR PROCESS. Strong engineering professional with a Bachelor of Technology (B.Tech.) focused in Information Technology from Sri Sai Ram Engineering College,Chennai.
$90 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello , I’d really like to work with you on this one if possible! I do have a couple of questions, but first I’d like to make you an offer and some background so you can check my work out. However, I am new to freelancer and looking to get a few clients that I can build upon. If you take a look at my work and feel that I could help you, I’ll do it. You’ll get all the expected stuff like a great professional service and a fast turn around, at a bit less, and I get a bit more exposure. Please let me know about the job/project details If the above offer sounds like something you would be interested in, I’d love to hear from you. Regards, Raja C S
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
yes. I will do this project within given time period. Give me full details related to your project .
$160 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have 3 years in it industry mainly on data transformation. I worked 2 years with hive so I sure I can do the job. Best Regards, Aleksandar Atanasov Relevant Skills and Experience I have experience with Hive, MySQL, teradata, oracle
$166 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have already worked on such projects and currently working on the same kind of projects. I am very good at writing SQL's for complex data transformations as needed.
$150 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have over 7 years experience in Hadoop technologies. I have worked with big MNC's from USA as well as India. I have both developer as well as architect experience and currently well equipped with Hortonworks and Cloudera Distributions. I have hands on production experience on Apache Nifi, Kafka, Hive, Sqoop, Spark (Scala), Shell, Flume and HBase technologies. Willing to start asap.
$250 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have real time experience of 7 years in SQL and Hive. I worked in various projects where I written sql / hive queries to load the data.
$60 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
1. Cleans the input dataset 2. Populate these dataset in HDFS which is optional but recommended. We can use local files too to create Hive tables 3. Load data during the table creation through Hive shell entries. 4. Implement the logic for your excel’s formula. 5. Finally Plates are ready to analysis and consume. I hope this would help you.
$180 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
PATIALA, India
0.0
0
Payment method verified
Member since Feb 13, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.