Blueprint Technologies Kronos Consultant Interview Questions and Answers

Sql assessment round

Q1. Python gcp biquery airflow dataflow sql
Add your answer

Q1. Recent projects experience, bigquery, sql
Add your answer

Q1. Salary discussion
Add your answer

Coding round had one SQL and one Python question. And some mcqs around python and math

Q1. It was on store and products querying with SQL
Add your answer
Q2. Same questions were asked in Python
Add your answer

Q1. It was a techno-managerial round with some guesstimates and about my recent projects
Add your answer

Python and SQL questions were asked

Q1. I was asked about the project
Add your answer

Q1. ACID properties of DBMS
Add your answer

Q1. HR question and family background
Add your answer

It was a written test where theoretical SQL questions were asked like primary key, foreign key, set operators and some queries

Q1. All SQL Concepts like Join, normalization, trigger, stored procedure, keys, drop truncate del difference, where having difference, Aggregate scaler window functions, fetch duplicate records query, acid pro...read more
Add your answer

Two coding questions

Q1. DBMS questions, keys
Add your answer
Q2. SQL related queries
Add your answer

Q1. Testing concepts STLC
Add your answer
Q2. Java code to reverse a string
Ans. 
Java code to reverse a string
• Use StringBuilder class to reverse the string

• Call reverse() method on the StringBuilder object

• Convert the StringBuilder object back to String using toString() method
Answered by AI
Add your answer

Q1. Agile concepts like sprints planning and Jira
Add your answer

Q1. Describe your workflow of the last project
Ans. 
Developed ETL pipeline to ingest, clean, and analyze customer data for personalized marketing campaigns
• Gathered requirements from stakeholders to understand data sources and business objectives

• Designed data model to store customer information and campaign performance metrics

• Implemented ETL process using Python and Apache Spark to extract, transform, and load data

• Performed data quality checks and created visualizations ...read more
Answered by AI
Add your answer
Q2. What are the different transformations you have used
Ans. 
I have used various transformations such as filtering, joining, aggregating, and pivoting in my data engineering projects.
• Filtering data based on certain conditions

• Joining multiple datasets together

• Aggregating data to summarize information

• Pivoting data from rows to columns or vice versa
Answered by AI
Add your answer

Q1. The interviewer asked all the concepts of pyspark, ETL and a code on dsa
Add your answer