1Digital Stack Interview Questions and Answers

I have extensive experience working with data, utilizing various technologies in my day-to-day work.

• I have worked with SQL databases to extract and analyze data.

• I have used Excel and Tableau for data visualization and reporting.

• I have experience with Python and R for data manipulation and analysis.

• I have worked with ETL tools like Informatica for data integration.

• I have used JIRA and Confluence for project management a

Different types of joins in SQL include inner join, left join, right join, and full outer join.

• Inner join: Returns rows when there is a match in both tables.

• Left join: Returns all rows from the left table and the matched rows from the right table.

• Right join: Returns all rows from the right table and the matched rows from the left table.

• Full outer join: Returns rows when there is a match in either table.

Union combines results from two tables, while Outer join combines matching rows and includes non-matching rows.

• Union combines all rows from both tables, removing duplicates

• Outer join combines matching rows and includes non-matching rows with NULL values

• Syntax for Union: SELECT * FROM table1 UNION SELECT * FROM table2

• Syntax for Outer join: SELECT * FROM table1 LEFT OUTER JOIN table2 ON table1.id = table2.id

Sort and remove duplicates to ensure availability of products for Blinkit and Zepto campaigns throughout the day in Python.

• Sort the products list for each campaign

• Remove duplicates from the sorted list

• Repeat the process for both Blinkit and Zepto campaigns