i
Altimetrik
Filter interviews by
I applied via Naukri.com and was interviewed in Aug 2024. There were 3 interview rounds.
Hacker rank test based on python and selenium along with a python programming question
OOPs concept refers to Object-Oriented Programming principles like inheritance, encapsulation, polymorphism, and abstraction.
Inheritance: Reusing code and creating a hierarchy of classes
Encapsulation: Hiding the internal implementation details of a class
Polymorphism: Ability to use a single interface for different data types or objects
Abstraction: Showing only necessary details and hiding unnecessary details
Synchronization is the coordination of multiple processes to ensure they work together effectively.
Synchronization is important in multi-threaded applications to prevent race conditions and ensure data consistency.
We can handle synchronization using techniques like locks, semaphores, and monitors.
For example, in Java, we can use synchronized keyword or ReentrantLock class to achieve synchronization.
Another example is u...
Find the frequency of characters in an array of strings.
Iterate through each string in the array
For each character in the string, increment its count in a hashmap
Return the hashmap with character frequencies
Robot framework is keyword-driven, while pytest is a full-featured testing framework.
Robot framework is based on keywords and test cases are written in tabular format, while pytest is a full-featured testing framework with fixtures, asserts, and plugins.
Robot framework has built-in libraries for various tasks like file operations, database interactions, etc., while pytest relies on external libraries for such functiona...
I applied via Approached by Company and was interviewed in Oct 2024. There was 1 interview round.
Implementing incremental load in a table involves updating only new or changed data without reloading the entire dataset.
Identify a column in the table that can be used to track changes, such as a timestamp or a version number
Use this column to filter out only the new or updated records during each load
Merge the new data with the existing data in the table using SQL queries or ETL tools
Ensure data integrity by handling...
What people are saying about Altimetrik
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
Altimetrik interview questions for popular designations
Get interview-ready with Top Altimetrik Interview Questions
Use SQL query to find columns with timestamp data type in a table.
Use a SQL query like 'SHOW COLUMNS FROM table_name WHERE Type = 'timestamp''
Alternatively, query the information_schema.columns table for column data types
Check for variations of timestamp data types like datetime, timestamp, etc.
To delete a column from a table, use the ALTER TABLE command.
Use the ALTER TABLE command followed by DROP COLUMN to delete a column from a table.
Specify the name of the column you want to delete after the DROP COLUMN keyword.
Make sure to carefully consider the impact of deleting a column on the data and any dependent objects.
Drop removes a table from the database, truncate removes all rows from a table, and delete removes specific rows from a table.
DROP: Removes the entire table structure and data from the database.
TRUNCATE: Removes all rows from a table but keeps the table structure.
DELETE: Removes specific rows from a table based on a condition.
Example: DROP TABLE table_name;
Example: TRUNCATE TABLE table_name;
Example: DELETE FROM table_n
Top is used to select the first few rows from a dataset, while limit is used to restrict the number of rows returned in a query.
Top is commonly used in SQL Server, while limit is commonly used in MySQL.
Top is used with the SELECT statement in SQL Server to limit the number of rows returned, while limit is used in MySQL to restrict the number of rows returned.
Example: SELECT TOP 5 * FROM table_name; (SQL Server) vs. SEL
count(*) counts all rows in a table, while count(1) counts the number of non-null values in a specific column.
count(*) counts all rows in a table
count(1) counts the number of non-null values in a specific column
count(*) is generally used when you want to count all rows in a table, while count(1) is used when you want to count non-null values in a specific column
Find the second index of 'l' in the string 'Hello'.
Use the find() method to find the first index of 'l'.
Use the find() method again starting from the index after the first 'l' to find the second index.
Handle cases where the first 'l' is not found or there is no second 'l'.
Coding + Aptitude question
I applied via LinkedIn and was interviewed in Sep 2024. There was 1 interview round.
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
GCP main components include Compute Engine, Cloud Storage, BigQuery, and Dataflow for various uses.
Compute Engine - Virtual machines for running workloads
Cloud Storage - Object storage for storing data
BigQuery - Data warehouse for analytics
Dataflow - Stream and batch processing of data
Optimizing dags involves reducing unnecessary tasks, parallelizing tasks, and optimizing resource allocation.
Identify and remove unnecessary tasks to streamline the workflow.
Parallelize tasks to reduce overall execution time.
Optimize resource allocation by scaling up or down based on task requirements.
Use caching and memoization techniques to avoid redundant computations.
Implement data partitioning and indexing for eff
Unacknowledged messages in pubsub can be handled by implementing retries, dead letter queues, and monitoring mechanisms.
Implement retries for unacknowledged messages to be redelivered.
Use dead letter queues to store messages that repeatedly fail to be processed.
Set up monitoring mechanisms to track unacknowledged messages and identify potential issues.
Some of the top questions asked at the Altimetrik interview -
The duration of Altimetrik interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 177 interviews
Interview experience
based on 1.1k reviews
Rating in categories
Senior Software Engineer
1.2k
salaries
| ₹0 L/yr - ₹0 L/yr |
Staff Engineer
865
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Engineer
638
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
313
salaries
| ₹0 L/yr - ₹0 L/yr |
Staff Software Engineer
236
salaries
| ₹0 L/yr - ₹0 L/yr |
Accenture
Persistent Systems
Mphasis
LTIMindtree