Op Jindal Interview Questions and Answers

Q1. Current day to day tasks
Ans. 
My current day-to-day tasks involve designing and implementing data pipelines, optimizing data storage and retrieval, and collaborating with cross-functional teams.
• Designing and implementing data pipelines to extract, transform, and load data from various sources

• Optimizing data storage and retrieval processes for efficiency and scalability

• Collaborating with cross-functional teams to understand data requirements and del...read more
Answered by AI
Add your answer
Q2. Question on data modelling(star vs snowflake)
Add your answer
Q3. Questions on data warehousing Dimensions, Facts, CDC, SCD types
Add your answer
Q4. Questions on snowflake product and variety on objects there use case and optimizations, partition pruning.
Add your answer
Q5. SQL queries: as per snowflake documentation 1. Read json file and extract data 2. sql query with subqueries to update records 3. sql query on window functions
Add your answer
Q6. Easy Pyspark coding question.
Add your answer

Q1. Project end to end detailed explanation and follow up questions.
Add your answer
Q2. Questions on data warehousing concepts like facts & dimensions in detail
Add your answer
Q3. Question on semi structured file formats
Add your answer
Q4. Questions on snowflake product: 1. tasks 2. streams 3. time travel 4. meta data caching 5. views vs materialized views 6. how would you spin up an warehouse cluster
Add your answer
Q5. Questions on spark 1. lazy evaluation 2. handling skew 3. data partitioning 4. pandas vs spark
Add your answer
Q6. Questions on aws 1. lambda functions, synchronous vs asynchronous calls 2. dynamic frames, transformations 3. glue crawler 4. s3 storage classes
Add your answer
Q7. SQL question using cross join, python question on string
Add your answer

Q1. End to end project architecture.
Ans. 
The end-to-end project architecture involves designing and implementing the entire data pipeline from data ingestion to data visualization.
• Data ingestion: Collecting data from various sources such as databases, APIs, and files.

• Data processing: Cleaning, transforming, and aggregating the data using tools like Apache Spark or Hadoop.

• Data storage: Storing the processed data in data warehouses or data lakes like Amazon S3 ...read more
Answered by AI
Add your answer
Q2. Questions on data modelling: 1. facts and types of facts 2. dimensions and its types 3. normalization vs denormalization
Add your answer
Q3. Questions on automating spark notebooks and optimization on spark job.
Add your answer
Q4. How to migrate 1000s of tables using spark(databricks) notebooks
Ans. 
Use Spark (Databricks) notebooks to migrate 1000s of tables efficiently.
• Utilize Spark's parallel processing capabilities to handle large volumes of data

• Leverage Databricks notebooks for interactive data exploration and transformation

• Automate the migration process using scripts or workflows

• Optimize performance by tuning Spark configurations and cluster settings
Answered by AI
Add your answer
Q5. Questions on delta format
Add your answer
Q6. Sql question on joins and numbers of records for each type of join.
Add your answer

Q1. Reason for change
Ans. 
Seeking new challenges and opportunities for growth in a more dynamic environment.
• Desire for new challenges and learning opportunities

• Seeking a more dynamic work environment

• Looking to expand skill set and experience

• Interested in working on cutting-edge technologies

• Seeking better career advancement prospects
Answered by AI
Add your answer
Q2. Expectations from EPAM
Ans. 
I expect EPAM to provide challenging projects, opportunities for growth, a collaborative work environment, and support for continuous learning.
• Challenging projects that allow me to utilize my skills and knowledge

• Opportunities for professional growth and advancement within the company

• A collaborative work environment where teamwork is valued

• Support for continuous learning through training programs and resources
Answered by AI
Add your answer
Q3. Willing to relocate? when can you join
Ans. 
Yes, I am willing to relocate for the right opportunity. I can join the company within 4 weeks.
• Willing to relocate for the right opportunity

• Can join within 4 weeks

• Open to discussing relocation assistance if needed
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. About internship in details
Add your answer

Q1. Normal introduction
Add your answer
Q2. Tell me about IndiaMART
Add your answer

Q1. Tell me about yourself in briefly
Add your answer
Q2. About internship
Add your answer
Q3. About marketing and sales
Add your answer
Q4. Why do you choose the field work
Add your answer
Q5. About IndiaMART
Add your answer
Q6. Why do you choose the IndiaMART and job description
Add your answer
Q7. What is your strength and weakness
Add your answer
Q8. Skills and hobbies and achievements
Add your answer

Q1. About yourself in briefly
Add your answer
Q2. Hobbies
Add your answer
Q3. Skills
Add your answer
Q4. Achivement
Add your answer
Q5. About IndiaMART or job descriptions
Add your answer
Q6. Why do you choose IndiaMART
Add your answer

Q1. What will my responsibilities be in this role?
Ans. 
Your responsibilities will include servicing airless paint machines, selling paint, and conducting paint demos.
• Servicing airless paint machines to ensure they are in proper working condition

• Selling paint products to customers based on their needs and preferences

• Conducting paint demos to showcase the features and benefits of different paint products

• Providing excellent customer service and addressing any concerns or ques
Answered by AI
Add your answer
Q2. What will my responsibilities be in this role?
Ans. 
Your responsibilities will include servicing airless paint machines, selling paint, and conducting paint demos.
• Servicing airless paint machines to ensure they are in proper working condition

• Selling paint products to customers based on their needs and preferences

• Conducting paint demos to showcase the features and benefits of different paint products

• Providing excellent customer service and addressing any concerns or ques
Answered by AI
Add your answer
Q3. What will be my salary in my month?
Add your answer
Q4. How long will the working hours be
Add your answer

Q1. I. don't have time
Add your answer
Q2. What do u say💬
Add your answer
Q3. What you names. And company. Job
Add your answer
Q4. I like your questions about the new season
Add your answer
Q5. What you company name and company
Add your answer

Q1. Brief about your education, career, previous projects handled, and role & responsibility in past organisations?
Add your answer
Q2. Current roles & responsibilities and value addition done by you and your team?
Add your answer
Q3. Process flow for planning throughout project life-cycle?
Add your answer
Q4. Critical/concerning areas to be monitored?
Add your answer
Q5. Productivity and permissible material wastage, process to prepare material reconciliation?
Add your answer
Q6. Understanding about claim and type of claim raised/supported to raise in past experience?
Add your answer
Q7. Experience of technical aspects and planning assessment required at tendering stage, capabilities to prepare tender submittals and proving insights to management on same?
Add your answer
Q8. Necessity of providing PMO support to management?
Add your answer
Q9. Understanding about role & responsibility of regional planning manager?
Add your answer
Q10. MIS and type of reports prepared in past and their significance for Top managemennt?
Add your answer

MY aptitude round was on naukrii.com , which I cleared.

Q1. Questions were asked on OOPS Concept, Make sure you should have a strong command on oops.
Add your answer
Q2. 1 DSA Question and they told me to write the code on whiteboard
Add your answer

Q1. It was technical interview, she asked me about my project and asked me to tell test cases on my project.
Add your answer
Q2. 1 dsa question, 2 strings anagram, and other pattern question
Add your answer

Q1. It was with qa lead of infoedge company. she told me to tell test cases of chair.
Add your answer
Q2. She asked me about testing and all.
Add your answer

Q1. AAbhi hua nhi hai, jab hoga toh bata dungi.
Add your answer

Set of questions on english , aptitude , all are at easy level

Sql basics and some query questions

Q1. Why do u want to join zs ; what do u know about zs; where do u see urself after 5 years ; question on real life scenarios ;
Add your answer
Q2. Question on real life scenarios
Add your answer

Q1. Salary expectation
Add your answer
Q2. When can u join
Add your answer

Q1. What are the aml and kyc requirements?
Ans. 
AML and KYC requirements are regulations that financial institutions must follow to prevent money laundering and verify the identity of their customers.
• AML (Anti-Money Laundering) requirements involve monitoring transactions, reporting suspicious activities, and conducting customer due diligence.

• KYC (Know Your Customer) requirements involve verifying the identity of customers, assessing their risk level, and maintainin...read more
Answered by AI
Add your answer
Q2. Why should we hire you, briefly describe a scenario where you would showcase a different skill or talent compared with your fellow employees?
Ans. 
I have a strong attention to detail and analytical skills that set me apart from my colleagues.
• I have a proven track record of accurately identifying and resolving discrepancies in KYC documentation.

• I excel at conducting thorough research and analysis to ensure compliance with regulations.

• My ability to effectively communicate complex information to stakeholders sets me apart in team collaborations.
Answered by AI
Add your answer
Q3. Strength and weakness?
Ans. 
Strength: attention to detail, Weakness: perfectionism
• Strength: Ability to meticulously review documents and identify discrepancies

• Strength: Strong analytical skills to detect potential risks or fraudulent activities

• Weakness: Striving for perfection may lead to spending too much time on a task

• Weakness: Difficulty in delegating tasks due to desire for everything to be done perfectly
Answered by AI
Add your answer
Q4. Project and achievements?
Ans. 
Implemented a new KYC process resulting in 30% reduction in onboarding time and 20% decrease in errors.
• Led a team to revamp KYC procedures and systems

• Introduced automation tools to streamline verification process

• Trained staff on updated KYC regulations and best practices
Answered by AI
Add your answer
Q5. Are you a team player? What do you do when you don’t get along with certain colleagues? How do you manage conflict resolution?
Ans. 
Yes, I am a team player. I believe in open communication and collaboration. When conflicts arise, I address them directly and seek resolution.
• I believe in open communication and collaboration within the team.

• I address conflicts directly and seek resolution through constructive conversations.

• I focus on finding common ground and working towards a solution that benefits the team as a whole.
Answered by AI
Add your answer
Q6. Provide a situation where you might have failed previously? What has that experience taught you?
Ans. 
I failed to meet a deadline due to poor time management.
• Underestimated the time needed for a project

• Did not prioritize tasks effectively

• Learned to create a detailed schedule and set realistic deadlines
Answered by AI
Add your answer

General English grammar knowledge and some calculations

Q1. CTC and expected salary details?
Add your answer
Q2. No you cannot negotiate and end up taking what they give you!
Add your answer
Q3. No relocation time, do it during weekends
Add your answer
Q4. No target compensation or other benefits
Add your answer
Q5. If ur employed through agency or consultancy you will be always a contingent and treated less than permanent employees
Add your answer
Q6. 12 hours a day, 6 days a week, no social or life balance
Add your answer