Add office photos
Filter interviews by
Trivent Systems Interview Questions and Answers
Trivent Systems Interview Experiences
5 interviews found
Priya
Selected
I applied via Approached by Company and was interviewed before Nov 2023. There were 3 interview rounds.
Gave patient surgery details which was an medical mal practice case and asked questions from it
(2 Questions)
- Q1. What is medical record review?
- Q2. Asked questions from previous case study?
(2 Questions)
- Q1. Asked about personal details?
- Q2. Previously worked company details?
Interview Preparation Tips
- Anatomy, diseases medical terms
Medical Record Reviewer Interview Questions asked at other Companies
Selected
I applied via Naukri.com and was interviewed before Mar 2023. There were 3 interview rounds.
We will be given a case which we need to summarize
(1 Question)
- Q1. Questions will be asked by physicians
(1 Question)
- Q1. Tell me about yourself
Associate Analyst Interview Questions asked at other Companies
Muthu Balaji
I applied via Referral and was interviewed in May 2021. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Interview process consist of 2 technical round where they evaluating knowledge in medical terminology and also testing the knowledge in reviewing medical records.
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Jun 2021. There were 7 interview rounds.
Interview Questionnaire
1 Question
- Q1. About medications, clinical findings, diagnostic tools
Interview Preparation Tips
Analyst Interview Questions asked at other Companies
Trivent Systems interview questions for popular designations
I applied via Other and was interviewed in Mar 2021. There were 9 interview rounds.
Interview Questionnaire
1 Question
- Q1. Common medical terminology, and they will give a case to arrange in date wise (chronological) and also you need to summarise that case in layman terms. Lastly you need to share your observations of that ca...
Interview Preparation Tips
Analyst Interview Questions asked at other Companies
Top trending discussions
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
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
Trivent Systems Interview FAQs
Tell us how to improve this page.
Trivent Systems Interviews By Designations
Interview Questions for Popular Designations
People are getting interviews through
Interview Questions from Similar Companies
Trivent Systems Reviews and Ratings
based on 42 reviews
Rating in categories
|
Medical Record Analyst
19
salaries
|  ₹2.7 L/yr - ₹5.6 L/yr |
|
Senior Analyst
13
salaries
| ₹4.8 L/yr - ₹8.6 L/yr |
|
Medical Record Reviewer
12
salaries
| ₹2.2 L/yr - ₹6.5 L/yr |
|
Analyst
12
salaries
| ₹3.1 L/yr - ₹8 L/yr |
|
Associate Analyst
7
salaries
| ₹3.2 L/yr - ₹3.5 L/yr |
Infosys
TCS
Wipro
HCLTech
Calculate your in-hand salary
- Home >
- Interviews >
- Trivent Systems Interview Questions
