AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Markone Technologies Postgresql DBA Interview Questions and Answers
Markone Technologies Postgresql DBA Interview Experiences
1 interview found
I applied via Job Fair and was interviewed in Mar 2024. There were 2 interview rounds.
(1 Question)
- Q1. Normal and Official Interview for Me.
(4 Questions)
- Q1. Manager or Client ask Company Based Technical Questions to Me.
- Q2. Do you know about MySQL and MSSQL ?
- Ans.
Yes, MySQL and MSSQL are both popular relational database management systems similar to PostgreSQL.
MySQL is an open-source RDBMS known for its speed and ease of use.
MSSQL is a proprietary RDBMS developed by Microsoft, known for its scalability and integration with other Microsoft products.
PostgreSQL is also a popular open-source RDBMS known for its advanced features like support for JSON data types and full-text search
- Q3. What is the backup tools to you used in your Company?
- Ans.
We use pg_dump and Barman for PostgreSQL backups.
pg_dump is a standard PostgreSQL tool for logical backups
Barman is a tool for physical backups and disaster recovery
We schedule regular backups using pg_dump and Barman to ensure data safety
- Q4. What is the messaging app to you used in your Company?
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
(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
- 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...
Skills evaluated in this interview
Oracle Database Administrator Interview Questions & Answers
Sutherland Global Services
Anonymous
posted on 28 Sep 2024
Selected
I applied via Campus Placement and was interviewed in Aug 2024. There were 8 interview rounds.
Database Management system SQL and PlSQL
Database Base Management system SQL and PlSQL
Database Management system
Database Management system
Database Management system
Database Management system
Database Base Management system
(5 Questions)
- Q1. Database Management system
- Q2. SQL and PlSQL Mango Data And Manu Database Management system
- Q3. C Language and C++Language and Java
- Q4. Data Analysis and Data entry
- Q5. DBMS C,C++ Java Data Entry Ms Excel Ms Word Ms PP
Interview Preparation Tips
Oracle Database Administrator Interview Questions & Answers
Hexaware Technologies
Anonymous
posted on 22 Oct 2024
(2 Questions)
- Q1. How to sync primary and standby?
- Ans.
Primary and standby databases can be synced using Data Guard in Oracle.
Configure Data Guard on primary and standby databases
Enable redo transport services
Monitor and resolve any synchronization issues
Perform switchover or failover when necessary
- Q2. Performance tuning?
(2 Questions)
- Q1. Why you want to change the job?
- Ans.
Seeking new challenges and growth opportunities in a dynamic environment.
Looking for new challenges to enhance my skills and knowledge
Seeking growth opportunities for career advancement
Interested in working in a more dynamic and innovative environment
- Q2. Expected salary.
Skills evaluated in this interview
Aptitude , reasoning, general questions
(2 Questions)
- Q1. What is spark architecture and partitions
- Ans.
Spark architecture refers to the structure of Apache Spark framework, while partitions are units of data distribution for parallel processing.
Spark architecture includes components like Driver, Executor, and Cluster Manager
Partitions are units of data distribution for parallel processing in Spark RDDs
Increasing the number of partitions can improve parallelism and performance
Example: In Spark, data is divided into parti...
- Q2. What is rdd, trsnsformations
- Ans.
RDD (Resilient Distributed Dataset) is a fundamental data structure in Apache Spark for distributed data processing. Transformations are operations that create a new RDD from an existing one.
RDD is a fault-tolerant collection of elements that can be operated on in parallel.
Transformations are functions that produce a new RDD by applying a computation on the existing RDD.
Examples of transformations include map, filter,
(2 Questions)
- Q1. Salary expectations
- Q2. Current ctc n expected ctc
- Ans.
The current CTC (Cost to Company) and expected CTC (Cost to Company) are typically discussed during salary negotiations.
Be honest about your current salary and provide a realistic expectation for your future salary.
Consider factors such as your experience, skills, industry standards, and the company's budget when discussing CTC.
It is important to have a clear understanding of your worth and negotiate accordingly.
Skills evaluated in this interview
I applied via Recruitment Consulltant and was interviewed in Jan 2024. There was 1 interview round.
(3 Questions)
- Q1. General Questions on overall Experience of Data Architect Role
- Q2. Data Mesh Concepts
- Q3. Exception Handling in Python Programming in case of class with subclass
- Ans.
Exception handling in Python for classes with subclasses involves using try-except blocks to catch and handle errors.
Use try-except blocks to catch exceptions in both parent and subclass methods
Handle specific exceptions using multiple except blocks
Use super() to call parent class methods within subclass methods
Reraise exceptions if necessary using 'raise'
Skills evaluated in this interview
I applied via Recruitment Consulltant and was interviewed in Aug 2023. There were 6 interview rounds.
Maths/English/Pattern check/Logical reasoning
(1 Question)
- Q1. Technical interview 1 - Teams meeting - Questions on Apache Spark - medium complexity , Delta lake architecture , SQL joins, Some cloud services - BigQuery/BigTable, SQL vs NoSQL, BigQuery vs Synapse, lan...
(1 Question)
- Q1. Technical interview 2 - Teams meeting - Questions on Apache Spark - advanced complexity, current project architecture, CAP theorem, questions on analytical stores on cloud, questions on delta lake, compara...
(1 Question)
- Q1. Technical interview 3 - Teams meeting - This is a design round. I was presented with customer requirements and had to present a bird's eye view of an end-to-end data architecture solution on GCP (since GCP...
(1 Question)
- Q1. Basic HR questions and salary negotiation.
Interview Preparation Tips
- Spark
- Delta lake
- Cloud
- SQL
- Data Architecture
2. Databricks knowledge
3. Delta lake knowledge
4. SQL proficiency
5. Data Modelling/ Data Integration/ Data cleaning/ Data quality/Data Governance knowledge
6. Good knowledge on any leading cloud and its services - Azure/AWS/GCP
Selected
I applied via Recruitment Consulltant and was interviewed in Jan 2024. There was 1 interview round.
(2 Questions)
- Q1. Basic Question Answer
- Q2. Basic SQL , SNWOFLAKE AND ETL Concepts
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Mar 2024. There was 1 interview round.
The interviewer was too much more concerned about syntax than logic.
Selected
I applied via Naukri.com and was interviewed in Nov 2022. There were 4 interview rounds.
(1 Question)
- Q1. Sql basic and advance
(1 Question)
- Q1. Data Architecture based real scenarios
Salary expectations, joining date, and other fundamental details were asked
Interview Preparation Tips
Markone Technologies Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- ETL Developer Interview Questions
- Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- MS SQL DBA Interview Questions
- Informatica Developer Interview Questions
- Lead Data Engineer Interview Questions
- Data Architect Interview Questions
- Show more
Markone Technologies Postgresql DBA Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Markone Technologies Postgresql DBA Reviews and Ratings
based on 2 reviews
Rating in categories
|
Oracle Database Administrator
58
salaries
|  ₹2.4 L/yr - ₹4.5 L/yr |
|
Software Engineer
24
salaries
| ₹2.5 L/yr - ₹4.5 L/yr |
|
Database Admin
15
salaries
| ₹3 L/yr - ₹5 L/yr |
|
Postgresql DBA
10
salaries
| ₹3 L/yr - ₹5 L/yr |
|
Java Developer
6
salaries
| ₹2.5 L/yr - ₹3.2 L/yr |
Infosys
TCS
Wipro
HCLTech
- Home >
- Interviews >
- Markone Technologies Interview Questions >
- Markone Technologies Postgresql DBA Interview Questions
