Data Processing and analytics - Production environment

Lukket Lagt ut 5 år siden Betales ved levering
Lukket Betales ved levering

Project requires you to process raw MYSQL table in AWS RDS and create derived logical tables. Need to create 35+ calculated variables using 4 different tables and 70+ raw variables. Creating 4 structured with complete

- Fault tolerance both at process and Data level

- Logging and monitoring

- Final solution document

Delivered after complete functional and stress testing. Must skill - Fluent in MYSQL data processing in production, Analytical and mathematical mindset, Project management and delivery

One glimpse of required derived variables can be found attached

Submit your interest only after answering following basic questions -

1. Out of Python or SQL , which language is best for MYSQL data processing in production environment?

2. Given 4 tables, you need to create multiple derived variables which might use one or multiple variables from one or all of these tables. How will you do such processing without running query in loop for each derived variable?

3. What are the top 3 things to consider while processing data in production environment?

4. How will you handle if there is a hung query or process in production environment. Fault tolerance methods?

Big Data Sales Databaseadministrasjon MySQL Python

Prosjekt-ID: #19579558

Om prosjektet

6 bud Eksternt prosjekt Aktiv 4 år siden

6 frilansere byr i gjennomsnitt $145 for denne jobben

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Mer

$250 USD på 7 dager
(50 Omtaler)
6.2
BestService222

Hi! How are you? I am python Expert. I can help you. I can deliver your tasks with great quality If you believe me and I will do my best for you. Please check my profile and message me for more details. Mer

$140 USD på 3 dager
(29 Omtaler)
5.4
Orientwork

I am a Data Entry Expert and proofreading with 15 years of experience. I also have experience in word, PowerPoint and excel. PDF to Word and Excel. My motive is to make my employer Happy without additional charges and Mer

$50 USD på 3 dager
(6 Omtaler)
3.0
aap31374

I have more then 15 years of experience in DBMS and immediately available

$155 USD på 1 dag
(0 Omtaler)
0.0
hernanlang

.. ... ... .. .. ... ... ... ... ... .. .. ... ... ...... ... ,........... ...,........ .................... ........ ,..... ........ ..... ...... ..... ....... ... ... ... ..... ...... ... .. .

$122 USD på 1 dag
(0 Omtaler)
0.0