TEKsystems Interview Questions, Process, and Tips

Q1. Rate your skills
Ans. 
I rate my SAS programming skills as advanced, with experience in data manipulation, statistical analysis, and reporting.
• Advanced proficiency in SAS programming language

• Experience in data manipulation, statistical analysis, and reporting

• Familiarity with clinical trials data and CDISC standards
Answered by AI
Add your answer
Q2. What experience do you have in sas programming and sql
Ans. 
I have 3 years of experience in SAS programming and SQL, including data manipulation, analysis, and reporting.
• 3 years of experience in SAS programming and SQL

• Proficient in data manipulation, analysis, and reporting

• Experience in creating complex queries and reports
Answered by AI
Add your answer

Q1. Explain your recent project
Ans. 
Developed a predictive model for customer churn using machine learning algorithms
• Used Python and SAS to preprocess and analyze customer data

• Implemented logistic regression and random forest algorithms for prediction

• Evaluated model performance using metrics like accuracy, precision, and recall
Answered by AI
Add your answer
Q2. What can you bring to the table
Ans. 
I bring strong SAS programming skills, analytical mindset, and experience in data analysis.
• Strong proficiency in SAS programming language

• Ability to analyze and interpret complex data sets

• Experience in data manipulation and statistical analysis

• Strong problem-solving skills

• Effective communication and collaboration with team members
Answered by AI
Add your answer

Q1. One small logical programming question, its quite easy
Add your answer
Q2. Some SQL queries
Add your answer
Q3. Spring boot questions and about my previous clients and projects
Add your answer

Q1. Brief description of day to day work
Ans. 
Facilitating daily stand-up meetings, removing impediments, coaching team members, and ensuring Scrum practices are followed.
• Facilitate daily stand-up meetings to keep the team aligned and focused

• Remove impediments that are blocking the team's progress

• Coach team members on Scrum practices and principles

• Ensure that Scrum ceremonies are conducted effectively

• Collaborate with Product Owner to prioritize and refine the prod
Answered by AI
Add your answer
Q2. Skill based interviews
Add your answer

How do you manage conflict

Q1. Let us assume we have an array of 0's and 1's,how would you find the first index for 1.
Ans. 
Iterate through the array and return the index of the first occurrence of 1.
• Iterate through the array using a loop.

• Check each element of the array, if it is 1 then return its index.

• If no 1 is found, return -1.
Answered by AI
Add your answer
Q2. SQL queries related to Order By and Group By
Add your answer

Decent not so tough can Crack with practice

Two coding questions, moderate difficulty level

My suggestion try not to get hyper it's not a debate it's a discussion although communication is tested your patience and other interpersonal skills are too.

Q1. All simple but detailed questioning, they wanted to check if I knew the concepts or do I just know them by heart
Add your answer

Q1. What is data warehousing?
Ans. 
Data warehousing is the process of collecting, storing, and managing data from various sources for analysis and reporting.
• Data warehousing involves extracting data from multiple sources and consolidating it into a single repository.

• It is used for creating reports, analyzing trends, and making informed business decisions.

• Data warehouses are typically designed for query and analysis rather than transaction processing.

• Exa...read more
Answered by AI
Add your answer

Q1. Why did you do so many internships?
Add your answer

Online MCQ. On OOPS, Spring boot etc. One needs to score 68-75% marks

Q1. Explain the architecture of the project
Ans. 
The project architecture follows a microservices design pattern with a front-end client communicating with multiple backend services.
• Utilizes microservices architecture

• Front-end client communicates with multiple backend services

• Each service is responsible for a specific functionality

• Uses RESTful APIs for communication between services

• Possibly uses a message broker like Kafka or RabbitMQ for asynchronous communication
Answered by AI
Add your answer
Q2. What are your roles and responsibility
Ans. 
Roles and responsibilities include designing, developing, and implementing software solutions, providing technical guidance, and collaborating with clients.
• Designing and developing software solutions based on client requirements

• Providing technical guidance and support to team members

• Collaborating with clients to understand their needs and provide solutions

• Testing and debugging software applications

• Training end-users on
Answered by AI
Add your answer