Add office photos
Filter interviews by
Upstate Legal Service S Authority Interview Questions and Answers
Be the first one to contribute and help others!
Interview questions from similar companies
ABHISHEK JHA
I applied via Company Website and was interviewed in Oct 2024. There were 4 interview rounds.
(2 Questions)
- Q1. Deep dive on current migration project and architecture, Type of dimensional modelling , normalization & de normalization
- Q2. Which AWS services used and AWS architecture for those services
- Ans.
AWS services used include S3, Redshift, Glue, EMR, and Lambda in a scalable and cost-effective architecture.
AWS S3 for storing large amounts of data
AWS Redshift for data warehousing and analytics
AWS Glue for ETL processes
AWS EMR for big data processing
AWS Lambda for serverless computing
(5 Questions)
- Q1. Current project end to end explanation
- Ans.
Developed a real-time data processing pipeline for analyzing customer behavior
Designed and implemented data ingestion process using Apache Kafka
Utilized Apache Spark for data processing and analysis
Built data models and visualizations using tools like Tableau
Implemented machine learning algorithms for predictive analytics
- Q2. Questions on spark optimization, Coalesce/Repartition, Handling data skew
- Q3. Explain spark submit command in detail
- Ans.
Spark submit command is used to submit Spark applications to a cluster
Used to launch Spark applications on a cluster
Requires specifying the application JAR file, main class, and any arguments
Can set various configurations like memory allocation, number of executors, etc.
Example: spark-submit --class com.example.Main --master yarn --deploy-mode cluster myApp.jar arg1 arg2
- Q4. SQL question on self join
- Q5. Easy Python question on printing even numbers in a range
(4 Questions)
- Q1. Current project explanation end to end
- Ans.
Developed a real-time data processing pipeline for analyzing customer behavior
Designed and implemented data ingestion process using Apache Kafka
Utilized Apache Spark for data processing and analysis
Built data models and visualizations using tools like Tableau
Implemented machine learning algorithms for predictive analytics
- Q2. PySpark coding question
- Q3. Question on spark internals JVM & GC
- Q4. Configure Cluster for 100 TB data
- Ans.
To configure a cluster for 100 TB data, consider factors like storage capacity, processing power, network bandwidth, and fault tolerance.
Choose a distributed storage system like HDFS or Amazon S3 for scalability and fault tolerance.
Select high-capacity servers with sufficient RAM and CPU for processing large volumes of data.
Ensure high-speed network connections between nodes to facilitate data transfer.
Implement data r...
(3 Questions)
- Q1. Current project architecture end to end
- Ans.
Our current project architecture involves a microservices-based approach with data pipelines for real-time processing.
Utilizing microservices architecture for scalability and flexibility
Implementing data pipelines for real-time processing of large volumes of data
Leveraging cloud services such as AWS or Azure for infrastructure
Using technologies like Apache Kafka for streaming data
Ensuring data quality and reliability t
- Q2. Case study with order management , Create Facts & dimension for Amazon orders
- Q3. SQL query to find the 2nd most order item in a category
- Ans.
Use a SQL query with a subquery to find the 2nd most ordered item in a category.
Use a subquery to rank items within each category based on the number of orders
Select the item with rank 2 within each category
Order the results by category and rank to get the 2nd most ordered item in each category
Interview Preparation Tips
- AWS
- Pyspark
- SQL
- Python
- Data Modeling
Skills evaluated in this interview
Anonymous
I applied via Company Website and was interviewed in Nov 2024. There were 2 interview rounds.
I am currently graduating. I am in the 2nd year of B.Sc. this year.
(3 Questions)
- Q1. What is the work in technical
- Q2. How is technology used
- Ans.
Technology is used in the workplace for communication, organization, automation, and efficiency.
Communication: Email, messaging apps, video conferencing
Organization: Project management tools, calendars, cloud storage
Automation: Workflow automation, data entry automation
Efficiency: Time tracking software, collaboration platforms
- Q3. What work will be given to me in technical
Interview Preparation Tips
- Aptitude
- Personality Development
- Communication Skills
- Knowledge Management
Selected
I applied via Naukri.com and was interviewed in Dec 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Self introduction
- Q2. Strength & weakness
(2 Questions)
- Q1. Self introduction
- Q2. About zolvit
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Nov 2024. There were 3 interview rounds.
Two hours and 32 questions
(2 Questions)
- Q1. Write commands for DML
- Ans.
DML commands are used to manipulate data in a database. Examples include INSERT, UPDATE, DELETE.
INSERT: Adds new data into a table
UPDATE: Modifies existing data in a table
DELETE: Removes data from a table
- Q2. Write commands for Joins
- Ans.
Joins are used to combine rows from two or more tables based on a related column between them.
INNER JOIN: Returns rows when there is at least one 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 JOIN: Returns rows when there is a match in one of the tables
(2 Questions)
- Q1. Ask questions regarding advance excel
- Q2. Ask questions from Power BI
Interview Preparation Tips
- SQL
failure become success one day
Skills evaluated in this interview
Selected
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Take me through your profile?
- Ans.
Experienced Senior Manager with a proven track record in leading teams and driving business growth.
Over 10 years of experience in management roles
Successfully led cross-functional teams to achieve project milestones
Implemented strategies that resulted in a 20% increase in revenue
Strong communication and leadership skills
MBA in Business Administration from XYZ University
- Q2. Why do you want to change ?
- Ans.
Seeking new challenges and opportunities for growth.
Desire for new challenges and learning experiences
Opportunity for career advancement
Seeking a more dynamic work environment
Wish to broaden skill set and knowledge
Desire for increased responsibility and leadership roles
(1 Question)
- Q1. Questions related to Strategic sourcing?
IT Helpdesk Engineer Interview Questions & Answers
Quislex Legal Services
priyanka bollepally
posted on 25 Oct 2024
Selected
(1 Question)
- Q1. Explain about job description
(3 Questions)
- Q1. Checking communication skills
- Q2. Self introduction
- Q3. Basic questions about ticketingtool
Selected
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
(2 Questions)
- Q1. Previous experience
- Q2. Question on automobiles
Interview Preparation Tips
- Automobile
- Mechanical Engineering
Sulthana Parveen
Selected
(2 Questions)
- Q1. Convert gallon (us) to litre
- Q2. What is the standard drying conditions
I applied via Naukri.com and was interviewed in Oct 2024. There were 3 interview rounds.
(2 Questions)
- Q1. Tell me About yourself
- Q2. Tell me about your past experience and CTC
Test of contract abstraction
(3 Questions)
- Q1. Tell me about your self
- Q2. Tell me about patent the and its tenure
- Ans.
A patent is a legal protection granted to inventors for their inventions, giving them exclusive rights for a certain period of time.
Patents are granted by government agencies to protect the intellectual property of inventors.
The tenure of a patent is typically 20 years from the date of filing, during which the inventor has exclusive rights to the invention.
During the tenure of a patent, the inventor can prevent others ...
- Q3. Tell me about past experience
- Ans.
I have 2 years of experience working as a customer service representative in a call center.
Handled customer inquiries and resolved complaints
Provided product information and assistance with orders
Maintained accurate records of customer interactions
Collaborated with team members to improve customer satisfaction
Received positive feedback from supervisors for excellent communication skills
I applied via Recruitment Consulltant and was interviewed in Aug 2024. There was 1 interview round.
(2 Questions)
- Q1. Is there any difference in the R&Ws provided to minority v majority shareholders?
- Ans.
R&Ws provided to minority and majority shareholders may differ based on the terms of the agreement and the rights of each group.
R&Ws may vary based on the percentage of ownership held by minority vs majority shareholders.
Majority shareholders may have more influence in negotiating the terms of the R&Ws.
Minority shareholders may have specific protections in place to safeguard their interests.
The specific terms of the R&...
- Q2. Can ESOPs be issued to promoters and directors of company?
- Ans.
Yes, ESOPs can be issued to promoters and directors of a company.
ESOPs can be issued to promoters and directors as long as they are employees of the company.
Promoters and directors may receive ESOPs as part of their compensation package.
ESOPs can help align the interests of promoters and directors with those of the company and its shareholders.
Tell us how to improve this page.
Interview Questions for Popular Designations
Interview Questions from Similar Companies
Upstate Legal Service S Authority Reviews and Ratings
based on 1 review
Rating in categories
Aparajitha Corporate Services
Integreon
UnitedLex
Y-Axis Overseas Careers
- Home >
- Interviews >
- Upstate Legal Service S Authority Interview Questions
