What is the job description? What is the length of the contract? What are the chances of the contract being extended? What kind of tools I will need to you in this project?

SQL is data oriented language for selecting and manipulating data but PL SQL is a procedural language to create applications.SQL executes one statement at a time whereas in PL SQL block of code could be executed.SQL is declarative where as PL SQL is procedural.SQL is used to write Queries, Data Manipulation Language (DML) and Data Definition Language (DDL) whereas PL SQL is used to write Program blocks, Triggers, Functions, Procedures, and Packages.

T-SQL and PL/SQL are two completely different programming languages with different syntax, type system, variable declarations, built-in functions and procedures, and programming capabilities.The only thing they have in common is direct embedding of SQL statements, and storage and execution inside a database

1.SQL is a programming language while T-SQL is an extension to SQL.2.T-SQL is proprietary while SQL is an open format.3.T-SQL containsprocedural programming, local variable, and such while SQL does not.5.T-SQL has a different implementation of DELETE and UPDATE than SQL

SQLstands forStructuredQueryLanguage. Its a standard language for accessing and manipulating databases. MySQL is a database management system, like SQL Server, Oracle, Informix, Postgres,etc. MySQL is a RDMS (Relational Database Management System).

Master data management (MDM) is a methodology that identifies the most critical information within an organizationand creates a single source of its truth to power business processes.It delivers:A single view of the data or A 360-degree view of the relationships

Informatica is a software tool designed to simplify Data Warehouse design and routine tasks related todata transformation and migration i.e ETL -> Extract,transform and Load.

Informatica ETL product, known as Informatica Power Center consists of 3 main components.1. Informatica Power Center Client Tools: these are the development tools installed at developer end. These tools enable a developer to Define transformation process, known as mapping2. Informatica Power Center Repository: Repository is a kind of data inventory where all the data related to mappings, sources, targets etc. is kept.3. Informatica Power Center Server: Server is the place, where all the executions take place.

Talend Open Studio is a powerful and versatile open source solution that addresses main organizations data integration needs: Synchronization or replication of databases Right-time or batch exchanges of data ETL (Extract Transform Load) for BI or analytics Data migration Complex data transformation and loading Basic data quality. Talend Open Studio comprises three major applications (Business Modeler, Job Designer, and Metadata Manager) within a single graphical development environment based on Eclipse, which is easily customized to specific corporate needs

Transact-SQL is the SQL Server extension of the SQL query language. T-SQL have most of the programming concepts like variables, loops, conditions, etc. T-SQL uses variables and data types similar to other coding languages, but the syntax is a bit different..