Technical Round: Power BI theoretical and practical questions like PBI components, power query, power pivot, how to create calculate column and measure, explain about sumx, rolling avg, variables and their syntax, etc. SQL: theoretical and practical questions on window functions, joins, aggregates, etc.
Tell me a challenging project you have worked on
How I dealt with a manager making a decision I disagreed with
about conflict and how I resolved it
Seller Support Team is a more stricter rules on Shopee for Shipping and Delivery. How will you use Data to provide insights on the acceptable range to implement stricter rules on orders handover time?
Describe experience with data, fintech, which programs am I comfortable with
How would you optimize a SQL query for performance? How do you ensure data quality in a data pipeline?
Tell me about a time when you were tasked with influencing senior decision makers
latest jobs, family, studies and how resolve common problems,
Methods for cleansing data. (SAS character functions) Querying using SQL. (Summary report, complex joins, data merge) Transpose. Advanced SAS Macros. Puzzles to test your ability to think logically.
Viewing 971 - 980 interview questions