Filter interviews by
An inner join combines rows from two or more tables based on a related column, returning only matching records.
An inner join retrieves records that have matching values in both tables.
Example: If Table A has IDs 1, 2, 3 and Table B has IDs 2, 3, 4, an inner join on ID returns rows with IDs 2 and 3.
It is commonly used in SQL queries to filter data from multiple tables.
Syntax in SQL: SELECT * FROM TableA INNER JOIN ...
Madalain architecture is a design framework for scalable and efficient data processing systems.
Focuses on modularity and scalability in data systems.
Utilizes microservices for independent data processing tasks.
Supports real-time data processing and analytics.
Example: Using Madalian architecture in a healthcare app for patient data analysis.
Container orchestration with Docker automates deployment, scaling, and management of containerized applications.
Docker Swarm: Native clustering and orchestration tool for Docker, allowing easy management of multiple containers.
Kubernetes: A powerful orchestration platform that manages containerized applications across a cluster of machines.
Scaling: Automatically adjust the number of running containers based on loa...
CI/CD pipelines using YAML streamline software development by automating testing and deployment processes.
YAML (YAML Ain't Markup Language) is a human-readable data serialization format often used for configuration files.
In CI/CD, YAML files define the steps for continuous integration and continuous deployment, such as build, test, and deploy stages.
Example of a simple CI pipeline in YAML: ```yaml stages: - bui...
What people are saying about Tredence
Learn how to add Kubernetes services using Azure Kubernetes Service (AKS) effectively.
Create an AKS cluster using Azure CLI: `az aks create --resource-group myResourceGroup --name myAKSCluster --node-count 1 --enable-addons monitoring`
Use `kubectl` to deploy services: `kubectl apply -f service.yaml` where service.yaml defines your service configuration.
Expose your service using LoadBalancer type: `apiVersion: v1 k...
Partitioning divides data into distinct segments, while clustering groups similar data points based on characteristics.
Partitioning creates non-overlapping segments, e.g., dividing a database by region.
Clustering groups similar items, e.g., customer segmentation based on purchasing behavior.
Partitioning is often used for performance optimization in databases.
Clustering is used in machine learning for pattern recog...
Create a database to store information about colleges, students, and professors.
Create tables for colleges, students, and professors
Include columns for relevant information such as name, ID, courses, etc.
Establish relationships between the tables using foreign keys
Use SQL queries to insert, update, and retrieve data
Consider normalization to avoid data redundancy
Copy activity in Azure Data Factory (ADF) facilitates data transfer between various data stores.
Enables data movement from source to destination, e.g., SQL Database to Blob Storage.
Supports various data formats like CSV, JSON, and Parquet.
Can be scheduled or triggered by events, allowing for automation.
Utilizes integration runtime for data movement, which can be Azure or Self-hosted.
Allows for data transformation ...
Deadlocks occur when two or more processes are unable to proceed because each is waiting for the other to release a resource.
Deadlocks happen in multitasking environments where processes compete for resources.
Four conditions must hold for a deadlock to occur: mutual exclusion, hold and wait, no preemption, and circular wait.
Example: Process A holds Resource 1 and waits for Resource 2, while Process B holds Resourc...
Optimizing code involves identifying bottlenecks, improving algorithms, using efficient data structures, and minimizing resource usage.
Identify and eliminate bottlenecks in the code by profiling and analyzing performance.
Improve algorithms by using more efficient techniques and data structures.
Use appropriate data structures like hash maps, sets, and arrays to optimize memory usage and access times.
Minimize resour...
I applied via Campus Placement and was interviewed before Jul 2023. There were 3 interview rounds.
55 ML questions and aptitude and 3 python questions and 2 sql questions
Standardisation and normalisation are techniques used to scale and transform data in order to improve model performance.
Standardisation (Z-score normalisation) scales the data to have a mean of 0 and a standard deviation of 1.
Normalisation (Min-Max scaling) scales the data to a specific range, typically between 0 and 1.
Standardisation is less affected by outliers compared to normalisation.
Standardisation is preferred w...
Outliers can be handled by identifying, analyzing, and either removing or transforming them in the data.
Identify outliers using statistical methods like Z-score or IQR.
Analyze the outliers to understand if they are errors or valid data points.
Remove outliers if they are errors or transform them using techniques like winsorization or log transformation.
Consider using robust statistical methods that are less sensitive to...
Box-plot is a visual representation of the distribution of a dataset, showing the median, quartiles, and outliers.
Box-plot displays the median (middle line), quartiles (box), and outliers (dots or lines).
The length of the box represents the interquartile range (IQR).
Whiskers extend to the smallest and largest non-outlier data points within 1.5 times the IQR from the quartiles.
Outliers are plotted individually as dots o...
I manage my time by prioritizing tasks, creating schedules, setting deadlines, and using time management tools.
Prioritize tasks based on importance and deadlines
Create daily or weekly schedules to allocate time for different tasks
Set deadlines for each task to stay on track
Use time management tools like calendars, to-do lists, and productivity apps
Avoid multitasking and focus on one task at a time
Take breaks to avoid b...
I want to join Tredence because of their reputation for cutting-edge data science projects and collaborative work environment.
Tredence is known for their innovative data science projects
I value the collaborative work environment at Tredence
I believe Tredence will provide opportunities for professional growth and development
I appeared for an interview in Jun 2025, where I was asked the following questions.
Responsive design adapts layouts to different screen sizes; promises handle asynchronous operations in JavaScript; flex and grid are layout models.
Responsive design uses CSS media queries to adjust styles based on device characteristics.
Example of responsive design: Using 'max-width' in CSS to change layout for mobile devices.
Promises in JavaScript represent the eventual completion (or failure) of an asynchronous opera...
The filter method creates a new array with elements that pass a test, while map transforms each element in an array.
filter: Returns a new array with elements that meet a condition. Example: [1, 2, 3].filter(x => x > 1) results in [2, 3].
map: Creates a new array by applying a function to each element. Example: [1, 2, 3].map(x => x * 2) results in [2, 4, 6].
Both methods do not modify the original array and are c...
I applied via Campus Placement
1 good coding question and 33 mcqs
Create a database to store information about colleges, students, and professors.
Create tables for colleges, students, and professors
Include columns for relevant information such as name, ID, courses, etc.
Establish relationships between the tables using foreign keys
Use SQL queries to insert, update, and retrieve data
Consider normalization to avoid data redundancy
Lambda functions are anonymous functions in Python that can have any number of arguments but only one expression.
Lambda functions are defined using the lambda keyword.
They are commonly used with functions like map(), filter(), and reduce().
Example: double = lambda x: x * 2
Precision, recall, and F1 score are metrics used to evaluate the performance of classification models.
Precision is the ratio of correctly predicted positive observations to the total predicted positive observations.
Recall is the ratio of correctly predicted positive observations to the all observations in actual class.
F1 score is the harmonic mean of precision and recall, providing a balance between the two metrics.
Pre...
Elbow curve helps in determining the optimal number of clusters in a dataset.
Elbow curve is a plot of the number of clusters against the within-cluster sum of squares (WCSS).
The point where the rate of decrease of WCSS sharply changes is considered as the optimal number of clusters.
It helps in finding the balance between having too few or too many clusters.
For example, if the elbow point is at 3 clusters, it suggests t...
Support, confidence, and lift are key metrics in market basket analysis to identify relationships between items in a transaction.
Support measures how frequently an itemset appears in the dataset.
Confidence measures the likelihood that an item B is purchased when item A is purchased.
Lift measures how much more likely item B is purchased when item A is purchased compared to when item B is purchased independently of item ...
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
Data bricks is a unified analytics platform that provides a collaborative environment for data scientists, engineers, and analysts.
Data bricks simplifies the process of building data pipelines and training machine learning models.
It allows for easy integration with various data sources and tools, such as Apache Spark and Delta Lake.
Data bricks provides a scalable and secure platform for processing big data and running ...
Optimizing code involves identifying bottlenecks, improving algorithms, using efficient data structures, and minimizing resource usage.
Identify and eliminate bottlenecks in the code by profiling and analyzing performance.
Improve algorithms by using more efficient techniques and data structures.
Use appropriate data structures like hash maps, sets, and arrays to optimize memory usage and access times.
Minimize resource us...
SQL window function is used to perform calculations across a set of table rows related to the current row.
Window functions operate on a set of rows related to the current row
They can be used to calculate running totals, moving averages, rank, etc.
Examples include ROW_NUMBER(), RANK(), SUM() OVER(), etc.
I can join immediately or at a mutually convenient date, depending on your needs and my current commitments.
I am available to start immediately if needed.
If you prefer a specific start date, I can accommodate that as well.
I can discuss my current commitments to find a suitable start time.
For example, if you need someone to start within a week, I can make that work.
I applied via Approached by Company and was interviewed in Sep 2024. There were 3 interview rounds.
You will be getting questions on the tech stack you have experience with, in depth questions on Node js and React js, real time challenges faced, two coding questions (1 easy and 1 medium)
F2f round for about 1.5 hrs, you be given a task to create a functionality using frontend tech stack you have chosen, more coding questions medium level, framework related ij depth questions
I applied via Naukri.com and was interviewed in Aug 2024. There were 2 interview rounds.
Handle missing values by imputation, deletion, or using algorithms that can handle missing data.
Impute missing values using mean, median, mode, or predictive modeling
Delete rows or columns with missing values if they are insignificant
Use algorithms like XGBoost, Random Forest, or LightGBM that can handle missing data
Precision measures the accuracy of positive predictions, while recall measures the ability to find all positive instances.
Precision is the ratio of correctly predicted positive observations to the total predicted positives.
Recall is the ratio of correctly predicted positive observations to all actual positives.
Precision is important when the cost of false positives is high, while recall is important when the cost of fa...
I appeared for an interview in Feb 2025, where I was asked the following questions.
I appeared for an interview in May 2025, where I was asked the following questions.
An inner join combines rows from two or more tables based on a related column, returning only matching records.
An inner join retrieves records that have matching values in both tables.
Example: If Table A has IDs 1, 2, 3 and Table B has IDs 2, 3, 4, an inner join on ID returns rows with IDs 2 and 3.
It is commonly used in SQL queries to filter data from multiple tables.
Syntax in SQL: SELECT * FROM TableA INNER JOIN Table...
Madalain architecture is a design framework for scalable and efficient data processing systems.
Focuses on modularity and scalability in data systems.
Utilizes microservices for independent data processing tasks.
Supports real-time data processing and analytics.
Example: Using Madalian architecture in a healthcare app for patient data analysis.
The first round was mix of apti and coding
Deadlocks occur when two or more processes are unable to proceed because each is waiting for the other to release a resource.
Deadlocks happen in multitasking environments where processes compete for resources.
Four conditions must hold for a deadlock to occur: mutual exclusion, hold and wait, no preemption, and circular wait.
Example: Process A holds Resource 1 and waits for Resource 2, while Process B holds Resource 2 a...
Some of the top questions asked at the Tredence interview -
The duration of Tredence interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 110 interview experiences
Difficulty level
Duration
based on 573 reviews
Rating in categories
Consultant
484
salaries
| ₹11.6 L/yr - ₹20.1 L/yr |
Associate Manager
452
salaries
| ₹19.2 L/yr - ₹33.5 L/yr |
Data Engineer
335
salaries
| ₹6.7 L/yr - ₹19 L/yr |
Analyst
280
salaries
| ₹6 L/yr - ₹10.8 L/yr |
Senior Business Analyst
247
salaries
| ₹10.2 L/yr - ₹17 L/yr |
ITC Infotech
CMS IT Services
KocharTech
Xoriant