Upload Button Icon Add office photos

Filter interviews by

WERTMARK TECHNOLOGIES Senior SQL Developer Interview Questions and Answers

Updated 28 Mar 2023

WERTMARK TECHNOLOGIES Senior SQL Developer Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Feb 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(3 Questions)

  • Q1. Write an sp to with 5 input var and one output var,all int and display the max of input variables
  • Ans. 

    SP with 5 input and 1 output var, all int. Display max of input vars.

    • Create a stored procedure with 5 input parameters and 1 output parameter

    • Use the MAX function to find the maximum value among the input parameters

    • Assign the maximum value to the output parameter

    • Test the stored procedure with sample input values

  • Answered by AI
  • Q2. Pivote table syntax, trigger syntax,
  • Q3. Write a job scheduler code to backup up database daily at a particular time
  • Ans. 

    Code to schedule daily database backup

    • Use SQL Server Agent to create a new job

    • Set the schedule to run daily at the desired time

    • Add a step to the job to backup the database

    • Specify the backup location and file name

    • Test the job to ensure it runs successfully

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn syntax properly, complete technical share your screen and write code

Skills evaluated in this interview

If you are a fresher, click here to continue

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Jun 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Coding Test 

Stored procedures and function

Interview Preparation Tips

Interview preparation tips for other job seekers - What to as a sql developer and uses of sql? And difference between delete and truncate

If you are a fresher, click here to continue

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. What are the various data warehousing techniques used, and can you explain them in detail?
  • Ans. 

    Various data warehousing techniques include dimensional modeling, star schema, snowflake schema, and data vault.

    • Dimensional modeling involves organizing data into facts and dimensions to facilitate easy querying and analysis.

    • Star schema is a type of dimensional modeling where a central fact table is connected to multiple dimension tables.

    • Snowflake schema is an extension of star schema where dimension tables are normali...

  • Answered by AI
  • Q2. How has your analytics work contributed to the organization?
  • Ans. 

    My analytics work has helped the organization make data-driven decisions, improve operational efficiency, and identify new opportunities for growth.

    • Developed data models and algorithms to optimize business processes

    • Generated insights from large datasets to drive strategic decision-making

    • Identified trends and patterns to improve customer experience and retention

    • Implemented data governance policies to ensure data quality

  • Answered by AI
Round 2 - Psychometric Test 

(2 Questions)

  • Q1. How would you respond in various situations?
  • Ans. 

    I would respond in various situations by remaining calm, assessing the situation, and providing a thoughtful and strategic solution.

    • Remain calm and composed

    • Assess the situation thoroughly

    • Provide a thoughtful and strategic solution

    • Communicate effectively with all parties involved

  • Answered by AI
  • Q2. What is more important career , team
  • Ans. 

    Both career and team are important, but ultimately career growth should be prioritized.

    • Career growth is essential for personal development and achieving professional goals.

    • A strong team can support career growth by providing mentorship, collaboration, and opportunities for learning.

    • Balancing career and team dynamics is key to long-term success in any role.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for TCS Data Architect interview:
  • Data Architecture

If you are a fresher, click here to continue

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Explainyour job role
  • Ans. 

    ETL Developers are responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into a data warehouse.

    • Designing ETL processes to extract data from multiple sources

    • Transforming data to meet business requirements

    • Loading data into a data warehouse or other target systems

    • Developing and maintaining ETL jobs using tools like Informatica, Talend, or SSIS

  • Answered by AI
  • Q2. Explain implementation of SCD 1 in IICS
  • Ans. 

    SCD Type 1 in IICS involves overwriting existing data with new data without maintaining historical changes.

    • In IICS, use the Mapping Designer to create a mapping that loads data from source to target.

    • Use a Lookup transformation to check if the record already exists in the target table.

    • If the record exists, update the existing record with new data using an Update Strategy transformation.

    • If the record does not exist, inse...

  • Answered by AI

Skills evaluated in this interview

If you are a fresher, click here to continue

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. Analytical functions difference
  • Ans. 

    Analytical functions are used to perform calculations across a set of rows related to the current row.

    • Analytical functions operate on a group of rows and return a single result for each row

    • They can be used to calculate running totals, moving averages, rank, percentiles, etc.

    • Examples include ROW_NUMBER(), RANK(), SUM() OVER(), AVG() OVER()

  • Answered by AI
  • Q2. Which transformation uses in scd2?
  • Ans. 

    The Slowly Changing Dimension Type 2 (SCD2) transformation is used for handling historical data changes in a data warehouse.

    • SCD2 transformation is used to track historical changes in dimension tables.

    • It maintains multiple versions of a record by adding new rows with updated information and end-dating the previous record.

    • Commonly used in scenarios where historical data needs to be preserved and queried.

    • Example: When a c...

  • Answered by AI
  • Q3. Unix basic, how to find particular file in directory?
  • Q4. Given 2 table A and B. Find count of left join, right join, inner join, full outer join?
  • Ans. 

    To find the count of different types of joins between two tables A and B.

    • Left join: Includes all records from table A and matching records from table B.

    • Right join: Includes all records from table B and matching records from table A.

    • Inner join: Includes only the matching records from both tables.

    • Full outer join: Includes all records when there is a match in either table A or table B.

  • Answered by AI
  • Q5. Incremental load

Skills evaluated in this interview

If you are a fresher, click here to continue

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Jun 2024. There were 3 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Questions related to the current and past projects.
  • Q2. Aws related questions.
  • Q3. Data warehousing basics
Round 2 - Technical 

(2 Questions)

  • Q1. Explain about the roles and responsibilities.
  • Q2. Discussion about the role in Genpact.
Round 3 - HR 

(2 Questions)

  • Q1. Asked about expectated salary
  • Q2. Why are you switching

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare about the points given in your resume and the work you have done.

If you are a fresher, click here to continue

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Asked about data tools other than AWS services
  • Q2. When did you use HUDI and Iceberg
  • Ans. 

    I have used HUDI and Iceberg in my previous project for managing large-scale data lakes efficiently.

    • Implemented HUDI for incremental data ingestion and managing large datasets in real-time

    • Utilized Iceberg for efficient table management and data versioning

    • Integrated HUDI and Iceberg with Apache Spark for processing and querying data

  • Answered by AI

Skills evaluated in this interview

If you are a fresher, click here to continue

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What is sql , index , stored proc , triggers

If you are a fresher, click here to continue

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - Technical 

(4 Questions)

  • Q1. Start up parameters of sql server
  • Ans. 

    Start up parameters are used to configure the behavior of SQL Server when it starts up.

    • Start up parameters are specified in the SQL Server Configuration Manager.

    • Common start up parameters include -d (database files location), -e (error log location), -m (single user mode), -T (trace flags), etc.

    • Start up parameters can be modified to customize the behavior of SQL Server during startup.

    • Example: -dC:\Program Files\Microso...

  • Answered by AI
  • Q2. Differential backup query
  • Q3. Sql server statics
  • Q4. Log file architecture

Interview Preparation Tips

Interview preparation tips for other job seekers - kindly prepare all the topics about sql server.

Skills evaluated in this interview

If you are a fresher, click here to continue

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is Android Manifest
  • Q2. What are services

If you are a fresher, click here to continue

Contribute & help others!
anonymous
You can choose to be anonymous

WERTMARK TECHNOLOGIES Interview FAQs

How many rounds are there in WERTMARK TECHNOLOGIES Senior SQL Developer interview?
WERTMARK TECHNOLOGIES interview process usually has 2 rounds. The most common rounds in the WERTMARK TECHNOLOGIES interview process are Resume Shortlist and Technical.
What are the top questions asked in WERTMARK TECHNOLOGIES Senior SQL Developer interview?

Some of the top questions asked at the WERTMARK TECHNOLOGIES Senior SQL Developer interview -

  1. write an sp to with 5 input var and one output var,all int and display the max ...read more
  2. write a job scheduler code to backup up database daily at a particular t...read more
  3. pivote table syntax, trigger synt...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.1k Interviews
Accenture Interview Questions
3.9
 • 7.9k Interviews
Infosys Interview Questions
3.7
 • 7.4k Interviews
Wipro Interview Questions
3.7
 • 5.5k Interviews
Cognizant Interview Questions
3.8
 • 5.5k Interviews
Amazon Interview Questions
4.1
 • 4.9k Interviews
Capgemini Interview Questions
3.8
 • 4.7k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.7k Interviews
HCLTech Interview Questions
3.5
 • 3.7k Interviews
Genpact Interview Questions
3.9
 • 3k Interviews
View all
Compare WERTMARK TECHNOLOGIES with

Infosys

3.7
Compare

TCS

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent