RPA Developer

JOB TITLE :RPA Developer
Job location:MUMBAI
duration:Full time
Notice period :immediate -20days

Product Developer

– RPA Implementation and Configuration management in Workfusion
and/or UI PATH

– Ability to create process flows on Visio, as well as generate
outcome on RPA

– 6 months min handson experience on RPA – Having delivered at
least two projects

– Understanding in Software Systems, Communication systems and BI
systems, for delivering RPA led product development

– Understanding in IOT, IIOT and Consumer as well as Industrial

Interested ppl send updated resume to n.karthik@keirinsofttech.com or call me 7207301235

Futureqtech.com Presents SQL Interview Questions for Developers, Testers

SQL Interview Questions :

What is SQL?

Structured Query Language, an ANSI (American National Standards Institute) standard language for accessing databases.

Using SQL we can Access Oracle, Sybase, DB2, SQL Server, MySQL, DB/400 and other Database Management Systems

Q. When SQL was appeared?

Structured Query Language was first appeared by IBM in 1974and it is Free Software(any body can use with free of cost).

Q. Who should learn SQL?

• Database Developers

• Database Testers

• Database Administrators

Q. What are the Usages of SQL?

•    Creating new databases
•    Creating new tables in a database
•    Inserting records in a database
•    Updating records in a database
•    Deleting records from a database
•    Retrieving data from a database
•    Executing queries against a database
•    Creating stored procedures in a database
•    Creating views in a database
•    Setting permissions on tables, procedures, and views

Q) What are important SQL Language Elements?

Identifiers: Names of Database objects such as tables, views, columns, and databases etc…

Data Types: Define the type of data that is contained by a column.

Constants: Symbols that represent specific data types.

Operators: Perform Arithmetic, Comparison, and Logical Operations.

Functions: Built-in Functions to perform specific operations.

Clauses: Constituent components of statements and queries.

Expressions: Produce either scalar values, or tables consisting of columns and rows of data.

Queries: Retrieve the data based on specific criteria. This is an important element of SQL.

Q. what is SQL Process?

When we are executing an SQL command for any RDBMS, the system determines the best way to carry out our request and SQL engine figures out how to interpret the task.
There are various components included in the process. These components are Query Dispatcher, Optimization engines, Classic Query Engine and SQL query engine etc. Classic query engine handles all non-SQL queries but SQL query engine won’t handle logical files. 

Q. Is SQL supports Programming?

No, SQL doesn’t have Conditional and Loop statements, using SQL Commands we can access databases. 

Q. What are the sub sets of SQL?

•    Data Definition Language
•    Data Manipulation Language
•    Data Control Language 

Q. What is Data Definition Language?

Data Definition Language (DDL) allows us to create, alter, and delete database objects such as schemas, tables, views, sequences, catalogs, indexes, and aliases.

Q. What is Data Manipulation Language?

DML is a language which enables users to access and manipulate data.

Data Manipulation Language is used to Perform below Operations:
•    Insertion of data into the database
•    Retrieval of data from the database
•    Updating data in the database
•    Deletion of data in the database 

What is Data Control Language?

Data Control Language (DCL) allows us to control access to the database. ‘DCL’ commands include-
‘GRANT’ to allow specific users to perform specified tasks
‘REVOKE’ to cancel previously denied or granted permissions

Q. What is Database?

A database is a systematic collection of data, Databases support storage and manipulation of data, and Databases make data management easy.

Q. What is Table?

A Table in a Relational Database is a predefined format of rows and columns that define an entity.
Each column contains a different type of attribute and each row corresponds to a single record.
Each table is provided with a name.

Q. What is Database Management System?

> A database management system, or DBMS, is software designed to assist in maintaining and utilizing large collection of data.

> The alternative to using a DBMS is to store the data in files and write application-specific code to manage it.

Using a DBMS to manage data has many advantages like:

•    Data independence
•    Efficient data access
•    Data integrity and security
•    Data administration
•    Concurrent access and data recovery

Q. What is Database Engine?

Software that stores and retrieves data in a database. It may be self-contained program or the part of DBMS that performs the storage and retrieval operations.

Q. What is Database Server?

Database Management Systems provide Database server functionality, database server provides database services to other computer programs or computers.

What is MS Access?

MS Access was launched in 1992 by Microsoft Corporation as part of MS Office.
Microsoft Access is entry-level database management software. It is not only an inexpensive but also powerful database for small-scale projects.
MS Access uses the Jet database engine which utilizes a specific SQL language dialect (sometimes referred to as Jet SQL).
MS Access comes with the professional edition of MS Office package. MS Access is user friendly database management system.

Q. What is Oracle?

Oracle is a relational database management system developed by ‘Oracle Corporation and launched in 1977.
Oracle supports all major Operating systems includes, MS Windows. NetWare, UnixWare, OS/2 and most UNIX flavors. 

Q. What is MS SQL Server?

MS SQL Server is a Relational Database Management System developed by Microsoft Inc. Its primary query languages are T-SQL and ANSI SQL. 

Q. What is Sybase?

Sybase is a computer software company, their primary product is Sybase DBMS, which is a relational database management system based upon structured query language. 

Q. What is MySQL?

MySQL is open source Database Management System, developed by Swedish company MySQL AB.
MySQL Supports many different platforms including Microsoft Windows, the major Linux distributions, UNIX, and Mac OS X.
MySQL has free and paid versions, depending on its usage (non-commercial/commercial) and features. MySQL comes with a very fast, multi-threaded, multi-user, and robust SQL database server.

Q. What is DB2?

DB2 is the short name used for DATABASE 2. It is relational database product developed by IBM. in 1983 

Q. What are the categories of operators available in SQL?

•    Arithmetic operators
•    Comparison operators
•    Logical operators

Q. What are Arithmetic operators in SQL?


Operator Description
+ (Addition ) Adds values
– (Subtraction) Subtracts Right side value from Left side value
* (Multiplication) Multiplies values on either side of the operator
/ (Division) Divides left hand operand by right hand operand
% (Modulus) Divides left hand operand by right hand operand and returns remainder

Q. What is a Data Relationship and What are they?

Database Relationship is the connection between the tables in a database. There are 4 types of relationships, and they are:

•    One to One Relationship
•    One to Many Relationship
•    Many to One Relationship
•    Many to Many Relationship

Q. What are the Data Definition Language Commands and Operations?

Important Data Definition Language Commands

1) Create
2) Alter
3) Drop
4) Truncate
5) Rename

Important Data Definition Language Operations

1) Create a Database
2) Use Database
3) Rename a Database
4) Drop Database
5) Create a Table
6) Rename Table
7) Add a Column to exiting Table
8) Add multiple columns to existing Table
9) Modify an existing column
10) Rename a Column
11) Drop a Column
12) Truncate a Table
13) Drop a Table

Q. How to Create a Database?


Create Database databaseName;


Create Database gcreddyDB;

Q. How to Select a Database?


Use databaseName;


Use gcreddyDB;

Q. How to Rename a Database?


Alter Database databaseName Modify Name = newdatabseName;


Alter Database gcreddyDB Modify Name = hyderabad


Alter Database gcreddyDB
Modify Name = hyderabad

Q. How to Drop a Database?


Drop Database databaseName;


Drop Database gcreddyDB;

Q. How to Create a Table?


Create Table tableName
column1_name dataType(size),
column2_name dataType(size),


Create Table Students
STID int,
STName char(50),
View Table info
Select * from Students

View Table Schema
Select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ‘Students’;

Q. How to Rename a Table?


EXEC sp_rename ‘old_tablename’, ‘new_tablename’;


EXEC sp_rename ‘Students’, ‘newStudents’;

Q. How to Add a Column to an existing Table?


Alter Table table_name add column_name dataType(size);

Alter Table newStudents add City char(50);

Q. How to Add multiple columns to an existing Table?


Alter Table table_name add column1_name dataType(size), column2_name dataType(size);

Alter Table table_name add
column1_name dataType(size),
column2_name dataType(size),


Alter Table newStudents add add1 char(100), add2 char(70);


Alter Table newStudents add
add3 char(100),
add4 char(70),
add5 char (100),
phone int;

Q. How to Modify an existing column?


Alter Table table_name Alter Column column_name dataType(size);


Alter Table newStudents Alter Column add1 varchar(150);

Q. How to Rename a Column?


EXEC sp_rename ‘table_name.old_column_name’, ‘new_colum_name’;

ExEC sp_rename ‘newStudents.phone’, ‘mobile’

Q. How to Drop a Column?


Alter Table table_name Drop Column column_name;


Alter Table new Students Drop Column City;

Q. How to Truncate a Table?

Truncate Table command is used to delete complete data from an existing table


Truncate Table table_name;


Truncate Table newStudents;

Q. How to Drop a Table?

Drop Table command is used to delete complete Table (Data and Table Structure) from the Database.


Drop Table table_name;

Q. What is the parameter substitution symbol used with INSERT INTO command?

The parameter substitution symbol used with INSERT INTO command is &.

Q. What are the various uses of database triggers?

Database triggers can be used to enforce business rules, to maintain derived values and perform value-based auditing.

Software Engineer(java)

Job Description
* Design, coding and unit testing for enhancement of Hydra projects respectively.
* Develop the code for the requirements assigned referring the product requirement documents
* Fixing the issues (Internal or External) with in the defined SLA
* Writing DB scripts for data fixes
* Unit testing
* Preparing and updating the necessary technical documents before, during and after coding
* Reports Development using Reporting tools (Like Jasper)
* Willing to work on additional tasks and responsibilities that will contribute towards team,
* department, and company goals.
* Work collaboratively within a team of other engineers
* Should have excellent attention to high quality
* Good written and oral communication Skills
* Good programming and debugging skills.
* Good experience in Java, Java EE
* Spring basics and Hibernate (or any ORM)
* Good SQL knowledge
* Knowledge of repository tools such as GitHub & SVN

Skills Set Required: JEE, Core Java, JSP, Servlet, Web Services, Java Script and PL/SQL, JDBC, EJB, Spring, Hibernate

Qualification :Any UG/PG

Experience :0 yrs.

Salary :2,00,000 – 7,00,000 P.A.

Walkin on 10th Mar

Walkin Time: Between 11AM and 12PM

Blujay Solutions India Pvt Ltd ,
#6th Floor , 2A Building Maximus Towers ,
Raheja IT Park Hitech City ,

Indian institutes consistently fare poorly on global rankings

Indian educational institutions continued to lag behind their Asian and global peers in the QS World University Rankings 2018. This was a repeat of their performance in the Times Higher Education World University Rankings 2018 released a few weeks ago, where Indian institutes’ performance deteriorated from 2017.

In the QS World University Rankings 2018, Massachusetts Institute of Technology (MIT), followed by Stanford University and Harvard University topped the list, thereby putting United States at the top of the league table.

Indian Institute of Technology (IIT), Delhi (rank 172), followed by IIT Bombay (179) and Indian Institute of Science (IISc) (190) were the only Indian educational institutes to feature among top 200 globally. No institute from India has been able to make it to the top 100.

QS World University Rankings 2018 (India): Long road ahead to the top

2017 (Rank) 2018 (Rank)
Indian Institute of Science (=152) Indian Institute of Science (190)
IIT Delhi (=185) IIT Delhi (172)
IIT Bombay (219) IIT Bombay (=179)
IIT Madras (=249) IIT Madras (=264)
IIT Kanpur (=302) IIT Kanpur (=293)
IIT Kharagpur (313) IIT Kharagpur (=308)
IIT Roorkee (399) IIT Roorkee (431-440)
IIT Guwahati (481-490) IIT Guwahati (501-550)
University of Delhi (501-550) University of Delhi (481-490)
University of Calcutta (651-700) University of Calcutta (751-800)
Banaras Hindu University (701+) Banaras Hindu University (801-1000)
Panjab University (701+) Panjab University (801-1000)
University of Mumbai (701+) University of Mumbai  (801-1000)

RPA Online Training Institute in Hyderabad

About RPA

Robotic Process Automation (RPA) handles the screens of application systems to process work, and execute tasks just as people execute them. With no application integration required, simplified training, scaling, and auditing, RPA offers low-risk, high-value Automation.

How & What Does Robotic Process Automation do?

RPA Technology has the capability to rapidly automate Standard Operating Procedures of existing business processes without any changes or intrusion to the server side of the applications used by the Operations team to complete business transactions.