Object Technology Solutions Senior Data Engineer Interview Questions and Answers

Q1. Ecommerce salesforce
Add your answer
Q2. Ecommerce and salesforce
Add your answer

Q1. Ecommerce salesforce
Add your answer
Q2. Salesforce com ecommerce
Add your answer

I was given a test which was not that difficult

Q1. Why are you leaving the current job
Ans. 
Seeking new challenges and growth opportunities in a more innovative environment.
• Looking for new challenges and opportunities for growth

• Interested in working in a more innovative environment

• Seeking a change in company culture or work-life balance
Answered by AI
Add your answer
Q2. What's the driving factor for you to join Altair
Ans. 
The innovative projects and collaborative work environment at Altair are the driving factors for me to join.
• Innovative projects: I am excited about the opportunity to work on cutting-edge projects that push the boundaries of technology.

• Collaborative work environment: I value teamwork and believe that working with talented individuals at Altair will help me grow professionally.

• Company culture: I have heard great things ...read more
Answered by AI
Add your answer

Q1. What is Informatica tool
Ans. 
Informatica is a data integration tool used for ETL (Extract, Transform, Load) processes in data engineering.
• Informatica is used for extracting data from various sources like databases, flat files, etc.

• It can transform the data according to business rules and load it into a target data warehouse or database.

• Informatica provides a visual interface for designing ETL workflows and monitoring data integration processes.

• It ...read more
Answered by AI
Add your answer
Q2. What is Datastage tool
Ans. 
Datastage is an ETL tool used for extracting, transforming, and loading data from various sources to a target destination.
• Datastage is part of the IBM Information Server suite.

• It provides a graphical interface to design and run data integration jobs.

• Datastage supports parallel processing for high performance.

• It can connect to a variety of data sources such as databases, flat files, and web services.

• Datastage jobs can b...read more
Answered by AI
Add your answer

Q1. Tell me about 1 project you have worked on and what did you learn during this?
Ans. 
Developed a machine learning model to predict customer churn for a telecom company.
• Collected and cleaned customer data including demographics, usage patterns, and customer service interactions.

• Used various machine learning algorithms such as logistic regression, random forest, and XGBoost to build and evaluate the model.

• Identified key factors contributing to customer churn such as contract length, monthly charges, and ...read more
Answered by AI
Add your answer
Q2. How do you build a recommendation system?
Ans. 
A recommendation system can be built using collaborative filtering, content-based filtering, or hybrid approaches.
• Collect and preprocess data on user preferences and item attributes

• Implement collaborative filtering by recommending items based on user behavior and preferences

• Utilize content-based filtering by recommending items similar to those previously liked by the user

• Consider hybrid approaches that combine collabor...read more
Answered by AI
Add your answer

Done in notepad. Data analysis fundamental and coding fundamentals were covered.

Q1. Piviot tables, vlookups excel case study.
Add your answer
Q2. Window fucntions SQL question and pandas data manupilation.
Add your answer

Q1. There were multiple questions on azure cloud and projects i worked on
Add your answer
Q2. Sql queries and scenario based azure questions
Add your answer

General Aptitude test

Q1. On SQL functions
Add your answer
Q2. Python coding questions
Add your answer

Q1. Functional Interface,java 8 features,predicate functions
Add your answer

Q1. General question & scenario based questions
Add your answer