Sr. SQL Developer Jobs in Delhi - Iris Software Inc.

Sr. SQL Developer

Iris Software Inc.

0 to 3 Years

Not disclosed

Expired

Posted: 01 Jul 20

Job Description

Tools & Technologies

Database: 1) SQL Server 2) Oracle

Tools : 1) Visual Studio SSDT 2) Microsoft Azure 3) JIRA 4) ERWIN

Programming: 1) SQL

Responsibilities

Responsible to analyze existing data base and come up with design and development for the Data warehouse to support business process.
Create Data Mapping document after each Source to Target assignment and write the transformation rules for each field as applicable.
Responsible to provide accurate metadata, which allows full understanding of the project data components.
Designing logical, physical data models and generate DDL (Data Definition Language) for creating Tables, Views, Indexes, data partitions using ERWIN tool for all new Datawarehouse projects.
Identify the level of granularity each business module is needed and work on normalized/de-normalized table structures in dimensional modelling and created aggregate tables using data warehousing concepts according to each module/system.
Use Erwin for reverse engineering to connect to existing database to create graphical representation in the form of Entity-Relationships Diagram and elicit more information.
Responsible to create Data Dictionary for all the Data elements with proper Definition, type, null or not null, foreign Key and Primary Key, Business name, Technical name.
Excellent Communication skills ( written and verbal )
Should be able to work independently

10 Strong logical and Analysis Skill

ETL Development and remediation activity

Responsible to draw data from various sources including flat files, XML, SQL Server for analytical reporting.
Responsible for all ETL design and architecture activities Including data extraction, profiling,

implement various transformations, loading, error handling, Audit and archiving data in data warehouse with historical and delta load strategy.

Responsible to implement performance tuning based on volume of data.
Responsible for ETL mapping and transformation logic coding including document all database schema, table names and roles.
Coordinate with the users and facilitate the use acceptance testing Responsible for executing the test cycles and data availability.
Responsible to enter, update, and close defects/change requests in JIRA.

Btech/MCA/MBA

Primary Location

INDIA

Organization

Iris Software

Schedule

Regular

Shift

Standard

Job Type

Full-time

Job Level

Evening Job