70 Semarchy Interview Questions and Answers | HR, Technical & Aptitude Prep

20 common asked question in every interview

Ques:- I'am new to SAS, can anybody explain the process of extracting data from source systems,storing in ODS and how data modelling is done.

Asked In :- FACTENTRY DATA SOLUTIONS, semaconnect, semarchy,

Right Answer:
To extract data from source systems in SAS, you typically use the SAS/ACCESS interface to connect to various data sources (like databases, flat files, etc.). You can write a DATA step or use PROC SQL to pull the data into SAS.

Once the data is extracted, it is stored in an Operational Data Store (ODS) using a SAS library. You can create a library pointing to a specific location where the ODS will reside.

For data modeling, you can use SAS tools like SAS Data Integration Studio or SAS Enterprise Guide to design your data model. This involves defining the structure of your data, including tables, relationships, and data types, and then creating ETL processes to transform and load the data into the ODS.

Etl Project Leader/ Project Manager

Ques:- What are the different versions of Informatica?

Asked In :- Solix Technologies, Inc, DAG, semarchy,

Right Answer:
The different versions of Informatica include:

1. Informatica PowerCenter
2. Informatica Cloud
3. Informatica Data Quality
4. Informatica MDM (Master Data Management)
5. Informatica Data Integration
6. Informatica Big Data Management
7. Informatica Enterprise Data Catalog

These versions cater to various data integration and management needs.

Etl Project Leader/ Project Manager

Ques:- What is Informatica Metadata and where is it stored?

Asked In :- Velocity Software Solutions, Solix Technologies, Inc, Eidiko Systems Integrators, WhereScape Software, attunity, workato, semarchy,

Right Answer:
Informatica Metadata refers to the data that describes other data within the Informatica environment, including information about data sources, transformations, mappings, workflows, and sessions. It is primarily stored in the Informatica Repository Database.

Etl Project Leader/ Project Manager

Ques:- What is ETL process ?How many steps ETL contains explain with example?

Asked In :- PrimeSoft Solutions, Thorogood, Metrics4 Analytics, WhereScape Software, Real Time Data Services (P), Snowflake, trifacta, semarchy,

Right Answer:
ETL stands for Extract, Transform, Load. It is a process used to move data from multiple sources into a data warehouse. The ETL process contains three main steps:

1. **Extract**: Data is collected from various sources, such as databases, CRM systems, or flat files. For example, extracting customer data from a SQL database.

2. **Transform**: The extracted data is cleaned, formatted, and transformed into a suitable structure for analysis. For example, converting date formats and removing duplicates.

3. **Load**: The transformed data is loaded into a target data warehouse or database for analysis. For example, loading the cleaned customer data into a data warehouse for reporting.

These steps ensure that data is accurate, consistent, and ready for analysis.

Data Warehouse Developer Etl

Ques:- What is the metadata extension?

Asked In :- Eidiko Systems Integrators, EvolveWare, Infometry, DAG, iron mountain, zaloni, semarchy,

Right Answer:
Metadata extension refers to additional information that describes the structure, operations, and context of data within a data warehouse or ETL process. It helps in understanding the data's origin, format, and relationships, facilitating better data management and usage.

Data Warehouse Developer DB Architecture

Ques:- How do I make bitmaps and captures screens display well in slide show?

Asked In :- KRIOS Info Solutions, Excelerate, iqvia, semarchy,

Data Warehouse Developer Informatica

Ques:- How do you transfert the data from data warehouse to flatfile?

Asked In :- semarchy,

Data Warehouse Developer MySQL

Ques:- Types of joins ?

Asked In :- semarchy,

Data Warehouse Developer Oracle

Ques:- If the entire disk is corrupted how will you and what are the steps to recover the database

Asked In :- semarchy,

Data Warehouse Developer Oracle

Ques:- I would like to know the detail coding and procedure of connecting Oracle and Sql with VB and VB.Net

Asked In :- semarchy, metadata technologies,

Business Intelligence Database Analyst/ Programmer

Ques:- What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?

Asked In :- FourKites, Quality Kiosk, Azuga, Inspeero Technologies, Real Time Data Services (P), cotiviti, gofluent, asian infrastructure investment bank, komodo health, semarchy,

Business Intelligence Data Warehouse Developer

Ques:- How open document syntax works?

Asked In :- Trinamix Inc, florida blue, saxo bank, elections canada, nafa, zaloni, royal london, transparent value, eon energy, semarchy,

Business Intelligence Project Leader/ Project Manager

Ques:- Name some of the standard Business Intelligence tools in the market?

Asked In :- Aranca (Mumbai), RCT, Atria Logic, Winjit Technologies, kalkitech, accenture japan, sggg fund services inc., mineraltree, inc., semarchy, stibo,

Business Intelligence Data Warehouse Developer

Ques:- What is index awareness in universe?

Asked In :- Vinove Software & Services Pvt Ltd, axiom real-time metrics, semarchy,

Business Intelligence Database Architect/ Designer

Ques:- Have you been involved in editing the data or writing data queries?

Asked In :- Exusia, Accelya, Harris Global Enterprise, IOOF, corelogic, sirius computer solutions, norges bank investment management, thescore, inc., neebal technologies, applied data finance,

API

Ques:- What is the difference between synchronous and asynchronous API calls

Asked In :- Vinove Software & Services Pvt Ltd, Winsoft Technologies India Pvt. Ltd, STIC SOFT E-SOLUTIONS, Toxsl Technologies, Solace Infotech, iROID Technologies, MatchMove India, CakeSoft Technologies, Razorpay-Startup, Fission Infotech,

Right Answer:
Synchronous API calls wait for the response before moving on to the next task, while asynchronous API calls allow the program to continue executing other tasks while waiting for the response.

API

Ques:- What is OAuth and how does it work in API authentication

Asked In :- Xoriant Solutions Pvt Ltd, DREAMORBIT SOFTECH PVT, Netaxis IT Solutions (p), Queppelin Technology Solutions, Rock Solid Solutions, Toxsl Technologies, Itobuz Technologies, Define Labs, Oodles Technologies, Cyber Group India,

Right Answer:
OAuth is an open standard for access delegation commonly used for token-based authentication and authorization. It allows third-party applications to access a user's resources without sharing their credentials.

In API authentication, OAuth works by having the user authorize the application to access their data. The process involves:

1. The user is redirected to an authorization server to log in and grant permission.
2. The authorization server issues an access token to the application.
3. The application uses this access token to make API requests on behalf of the user.
4. The API validates the token and grants access to the requested resources.

API

Ques:- What is JSON and how is it used in APIs

Asked In :- Addweb solutions, Startup - Navya Network, Webvillee Technology, Cyber Group India, SENSEI Technologies, Fission Infotech, Principal Global Services, Noesys Consulting, Digital Nirvana Information Systems (I), Manipal Technologies,

Right Answer:
JSON (JavaScript Object Notation) is a lightweight data interchange format that is easy for humans to read and write, and easy for machines to parse and generate. In APIs, JSON is commonly used to format data exchanged between a client and a server, allowing for structured data representation in requests and responses.

API

Ques:- What are the different types of APIs

Asked In :- Vinove Software & Services Pvt Ltd, Object Frontier Software, Hidden Brains InfoTech, AnAr Solutions, Netaxis IT Solutions (p), Walkover Web Solutions, Itobuz Technologies, Codiant Software Technologies, Infinity Labs LLP, Define Labs,

Right Answer:
The different types of APIs are:

1. **Open APIs (Public APIs)** - Available to developers and third parties.
2. **Internal APIs (Private APIs)** - Used within an organization.
3. **Partner APIs** - Shared with specific business partners.
4. **Composite APIs** - Combine multiple endpoints into a single call.
5. **Web APIs** - Accessible over the internet using HTTP/HTTPS.

API

Ques:- What is the difference between GET, POST, PUT, and DELETE in HTTP

Asked In :- Xoriant Solutions Pvt Ltd, Object Frontier Software, KRIOS Info Solutions, Hidden Brains InfoTech, Shipco IT, Ziffity Solutions, Toxsl Technologies, Itobuz Technologies, Born Commerce, Infinity Labs LLP,

Right Answer:
GET is used to retrieve data from a server, POST is used to send data to a server to create a resource, PUT is used to update an existing resource on the server, and DELETE is used to remove a resource from the server.

Previous Next

Semarchy is a leading provider of master data management (MDM) and data governance solutions. Founded in 2011, the company has quickly established itself as a key player in the field, helping organizations across industries manage and leverage their data more effectively. One of Semarchy's flagship products is the Intelligent Data Hub™ (IDH), a versatile platform designed to empower businesses to master their data and drive better decision-making. The IDH offers a unified approach to managing, governing, and sharing data across the enterprise, enabling organizations to break down silos, improve data quality, and streamline processes. Semarchy's solutions are known for their flexibility, scalability, and ease of use. Whether an organization is looking to consolidate customer data, standardize product information, or ensure compliance with regulatory requirements, Semarchy provides the tools and expertise needed to succeed. In addition to its cutting-edge technology, Semarchy is also recognized for its commitment to customer success. The company works closely with clients to understand their unique challenges and requirements, delivering tailored solutions that meet their specific needs. Semarchy's team of experts provides ongoing support and guidance to help organizations maximize the value of their data investments. With a strong track record of innovation and customer satisfaction, Semarchy continues to be a trusted partner for organizations seeking to unlock the full potential of their data assets.

Find Interview Questions for Semarchy

What makes Takluu valuable for interview preparation?

Get Our Mobile App

Programming

Reasoning

Network & Telecom

Management

What makes Takluu valuable for interview preparation?