us bank internal jobs:

https://www.jobzmall.com/u-s-bank-corp/job/business-technology-analyst-2?utm_campaign=google_jobs_apply&utm_source=google_jobs_apply&utm_medium=organic

nov 2023

https://www.jobzmall.com/u-s-bank-corp/job/workday-automation-data-analyst-2?utm_campaign=google_jobs_apply&utm_source=google_jobs_apply&utm_medium=organic

nov 2023

https://usbank.jobs/seattle-wa/trade-finance-technology-analyst/5C049A80B81547439A3ED1C5AD210656/job/?vs=28&utm_campaign=google_jobs_apply&utm_source=google_jobs_apply&utm_medium=organic

https://usbank.jobs/seattle-wa/ascent-investments-performance-analyst/2BDC025E5CE64EA9947B82B8536DC1A0/job/?utm_campaign=google_jobs_apply&utm_source=google_jobs_apply&utm_medium=organic 

----------------------

Dynamic CRM - Remote - United States:

https://www.linkedin.com/jobs/search/?currentJobId=3754940722&f_WT=2&keywords=dynamic%20crm&origin=JOBS_HOME_LOCATION_SUGGESTION&refresh=true 

Associate product manager:

Instacart: https://instacart.careers/job/?id=5822049 

https://www.linkedin.com/jobs/view/3804380480/ product manager 

https://www.linkedin.com/jobs/view/3849874364 associate product manager 

https://www.linkedin.com/jobs/view/3842803219 associate product manager

https://www.linkedin.com/jobs/view/3855473515

https://www.linkedin.com/jobs/view/3857535348 

https://www.linkedin.com/jobs/view/3841651112

quadrant technologies

https://www.linkedin.com/jobs/view/3855008745 

Data Analyst 2 Job Postings in Seattle:

1. https://www.amazon.jobs/en/jobs/2536069/business-analyst-selling-partner-support-engagement
2. https://www.amazon.jobs/en/jobs/2544892/business-analyst-brand-excellence 
3. ​Data Engineer: https://www.linkedin.com/jobs/view/3855008745
   
4. Stripe, Remote, Data Analyst: https://www.linkedin.com/jobs/view/3819196303
5. Business intelligence analyst: Doordash: Seattle: https://www.linkedin.com/jobs/view/3805567170
6. Business Intelligence Engineer: Seattle: https://www.amazon.jobs/en/jobs/2590021/business-intelligence-engineer-pv-discovery-analytics 
7. 
   

https://www.linkedin.com/jobs/search/?currentJobId=3823679485&geoId=104116203&keywords=data%20analyst&location=Seattle%2C%20Washington%2C%20United%20States&origin=JOB_SEARCH_PAGE_LOCATION_AUTOCOMPLETE&refresh=true&sortBy=R 

Resume:

https://www.overleaf.com/project/65f8f7bdf76a4e7312909543

1. 

SQL:

Leetcode SQL: https://leetcode.com/studyplan/top-sql-50/ 

https://leetcode.com/problemset/ 

​Complete SQL (Topic wise):-

1. Basic SQL Syntax:
SQL keywords
Data types
Operators
SQL statements (SELECT, INSERT, UPDATE, DELETE)

2. Data Definition Language (DDL):
CREATE TABLE
ALTER TABLE
DROP TABLE
Truncate table

3. Data Manipulation Language (DML):
SELECT statement (SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING, JOINs)
INSERT statement
UPDATE statement
DELETE statement

4. Aggregate Functions:
SUM, AVG, COUNT, MIN, MAX
GROUP BY clause
HAVING clause

5. Data Constraints:
Primary Key
Foreign Key
Unique
NOT NULL
CHECK

6. Joins:
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL OUTER JOIN
Self Join
Cross Join

7. Subqueries:
Types of subqueries (scalar, column, row, table)
Nested subqueries
Correlated subqueries

8. Advanced SQL Functions:
String functions (CONCAT, LENGTH, SUBSTRING, REPLACE, UPPER, LOWER)
Date and time functions (DATE, TIME, TIMESTAMP, DATEPART, DATEADD)
Numeric functions (ROUND, CEILING, FLOOR, ABS, MOD)
Conditional functions (CASE, COALESCE, NULLIF)

9. Views:
Creating views
Modifying views
Dropping views

10. Indexes:
Creating indexes
Using indexes for query optimization

11. Transactions:
ACID properties
Transaction management (BEGIN, COMMIT, ROLLBACK, SAVEPOINT)
Transaction isolation levels

12. Data Integrity and Security:
Data integrity constraints (referential integrity, entity integrity)
GRANT and REVOKE statements (granting and revoking permissions)
Database security best practices

13. Stored Procedures and Functions:
Creating stored procedures
Executing stored procedures
Creating functions
Using functions in queries

14. Performance Optimization:
Query optimization techniques (using indexes, optimizing joins, reducing subqueries)
Performance tuning best practices

15. Advanced SQL Concepts:
Recursive queries
Pivot and unpivot operations
Window functions (Row_number, rank, dense_rank, lead & lag)
CTEs (Common Table Expressions)
Dynamic SQL​

Interview Preparation for Data Analyst Position at Amazon

Round 1: Technical Screening

Questions:

1. What are some of the common data cleaning techniques that you use in your analysis?
2. What is your experience with time series analysis and forecasting?
3. Explain the concept of overfitting and how you address it in your analysis.
4. What are the different types of joins in SQL?
5. What is the difference between supervised and unsupervised learning?
6. How do you handle missing data in your analysis?
7. What is your experience with A/B testing?
8. What is your experience with data visualization tools like Tableau or Power BI?
9. How would you approach developing a machine learning model for a specific business problem?
10. Explain the concept of clustering and its applications in data analysis.

Round 2: Behavioral Interview

Questions:

1. Describe a time when you had to solve a difficult problem in your previous job or project.
2. Answer:
3. Situation: In my previous internship at ABC Solutions, I was given the task of applying measurement system analysis (MSA) to qualify relocated test equipment.
4. Task: The relocated test equipment was vital for the production process, but we needed to ensure the accuracy and reliability of the data it produced.
5. Action: Successfully applied MSA and identified the required actions to qualify the relocated test equipment.
6. Result: Authored three technical reports for relocated packaging equipment that met IQOQPQ guides that provided reliable and accurate data.
7. Tell me about a time where you had to learn a new skill to complete a project or task.
8. Answer:
9. Situation: In my previous internship at MedApps, I was tasked with assessing equivalency of proposed alternate plastic packaging material.
10. Task: The proposed alternate packaging material was significantly different in its composition, properties, and manufacturing process. I had to learn new statistical techniques to perform accurate analysis and determine its equivalency.
11. Action: Successfully learned new statistical techniques such as Minitab and identified the suitable test methods to test the equivalency of the proposed packaging material.
12. Result: The proposed alternate plastic packaging material was found to be equivalent to the original packaging material using Minitab, leading to significant cost savings in production processes.
13. Describe a time when you had to work effectively in a team to solve a problem or accomplish a task.
14. Answer:
15. Situation: In my academic project, our team of three had to design a custom hand cycle for polio victims.
16. Task: The project involved several design challenges such as ensuring comfortable and ergonomic design, proper balance, and low manufacturing cost.
17. Action: Effectively collaborated with my team members by identifying the strengths and weaknesses of each member and dividing the tasks accordingly. Took on the responsibility to ensure adherence to Design Control Procedures according to CFR by conducting regular quality checkups.
18. Result: Successfully designed and developed a hand cycle that was recognized as the "Best Presentation" out of 15 teams by the faculty audience.
19. Describe a time when you had to communicate complex technical information to a non-technical stakeholder.
20. Answer:
21. Situation: In my previous internship at MedApps, I had to create and deliver presentations to train field sales representatives on the new product features.
22. Task: The product was significantly different than the previous product, and the field sales reps had limited technical knowledge. Hence, the training had to be detailed and comprehensive, yet understandable.
23. Action: Developed the presentation in PowerPoint that was informative, yet easy to understand for non-technical stakeholder. Added real-life examples to explain the changes in the product features.
24. Result: The training was successful, and the sales reps were equipped with the knowledge and skills required to sell the new product to customers.
25. Describe a time when you had to manage and prioritize multiple tasks simultaneously.
26. Answer:
27. Situation: During my tutoring job at Arizona State University, I had to manage and prioritize multiple students with different courses, assignments, and skill levels.
28. Task: I had to make sure that I give equal attention to each student and am available to them whenever they require my assistance.
29. Action: Prepared a schedule for the tutoring hours and gave priority to students who required immediate assistance. Identified the strengths and weaknesses of each student and tailored my tutoring methods accordingly.
30. Result: Successfully tutored 10-15 undergraduate engineering students per week in MATLAB programming and math coursework.

Round 3: Coding Interview

Questions:

1. What is the time and space complexity of the merge sort algorithm? Explain your answer.
2. Write a function to reverse a string in Python.
3. Implement a function to determine if a given string is a palindrome.
4. Implement a program to find the common elements between two arrays in C.
5. What is the time and space complexity of a hash table? Explain your answer.
6. Write a program to find the maximum element in an array using binary search in C.
7. What is the difference between a stack and a queue? Provide an example where each can be used.
8. Implement a function to find the kth largest element in an array in Python.
9. Write a program to implement breadth-first search in C.
10. Implement a function to find the longest common substring between two given strings in Python.

Round 4: Design Interview

Questions:

1. Design a system to track the number of users on a social media platform like Facebook.
2. Design a database schema for an e-commerce website like Amazon.
3. Design a system to monitor the performance of a web server.
4. Design a parking garage management system.
5. Design a program to sort a large file containing records in C.
6. Design a system to prevent credit card fraud.
7. Design a system to recommend products to users based on their purchase history.
8. Design an algorithm to find the shortest path between two points in a city.
9. Design a system to detect and prevent plagiarism in academic papers.
10. Design a program to compress and decompress large files in Java.

Conclusion

Preparing for the data analyst position at Amazon requires a good understanding of technical, behavioral, coding, and design concepts. It is essential to prepare both high-level and low-level answers based on your expertise and previous experience. Mastery of data analysis techniques, programming languages, and problem-solving skills is crucial to succeed in the interview process. Use this guide to prepare yourself for the interview process and showcase your skills and knowledge to secure the position.