Company Name: Thetradedesk

Role: Summer Intern

Batch eligible: 2024 and 2025 passouts

Apply: https://careers.thetradedesk.com/jobs/4150177007/2024-summer-internship-software-engineering-bangalore

Frontend developer internship
For 2025/2026 Grads

https://www.linkedin.com/posts/ravinder-pal-singhh_we-are-looking-to-hire-2nd-and-3rd-year-college-activity-7142438105487224832-J1jz?utm_source=share&utm_medium=member_android

Wheels Eye is hiring Data Science Interns

Duration: 6 months

For 2023/2024 Grads

https://www.linkedin.com/posts/pulkit-bansal-29602025_google-forms-sign-in-activity-7142428855985745921-sPEs?utm_source=share&utm_medium=member_android

📣 Hiring Opportunity (Immediate)

💼 Data Analyst Intern
🤠 Data Engineer Job
📚 Frontend Developer Intern
💼 Backend Developer (Node.js)
💸 Competitive Salary
📍 Job Location - #workfromhome

✅ Apply now and begin your best career journey at SUESYS

✅Intreated share resume --> careers@suesys.com

Date: 19-12-2023
Company name: IKEA
Role: Data Analyst
Topic: Statistics, SQL

1. How can we deal with problems that arise when the data flows in from a variety of sources?

There are many ways to go about dealing with multi-source problems. However, these are done primarily to solve the problems of:

Identifying the presence of similar/same records and merging them into a single recordRe-structuring the schema to ensure there is good schema integration



2.  Where is Time Series Analysis used?

Since time series analysis (TSA) has a wide scope of usage, it can be used in multiple domains. Here are some of the places where TSA plays an important role:

Statistics
Signal processing
Econometrics
Weather forecasting
Earthquake prediction
Astronomy
Applied science


3. What are the ideal situations in which t-test or z-test can be used?

It is a standard practice that a t-test is used when there is a sample size less than 30 and the z-test is considered when the sample size exceeds 30 in most cases.


4. What is the usage of the NVL() function?

The NVL() function is used to convert the NULL value to the other value. The function returns the value of the second parameter if the first parameter is NULL. If the first parameter is anything other than NULL, it is left unchanged. This function is used in Oracle, not in SQL and MySQL. Instead of NVL() function, MySQL have IFNULL() and SQL Server have ISNULL() function.


5. What is the difference between DROP and TRUNCATE commands?

If a table is dropped, all things associated with that table are dropped as well. This includes the relationships defined on the table with other tables, access privileges, and grants that the table has, as well as the integrity checks and constraints. 

However, if a table is truncated, there are no such problems as mentioned above. The table retains its original structure and the data is dropped.

————————————————————-


Stay Safe & Happy Learning💙

GroupM is hiring!!

*GroupM Nexus | Data Tech Interns

Requirement: Engineering background preferred, Knowledge of SQL, Python, Java or any other similar languages, preferably who can join us by the First week of January.
Location: Gurgaon

Interested candidates can share their resume at prerna.bhatnagar@groupm.com