Senior Datastage Developer

from 7 to 12 year(s) of Experience
Bengaluru, Chennai, Delhi, Hyderabad, Mumbai, Pune, Noida, Gurgaon

Job Description

7 years to 10 yrs of hands on experience in IBM DataStage version 11.5.

Experience in fixing Datastage Job Failures

Hands on experience in SQL / PL - SQL,

Hands on experience in Enterprise Data Warehouse environment

Actively participating in decision making and QA meetings and regularly interacting with the Business Analysts and development team to gain a better understanding of the business process, requirements & design.

Using DataStage as an ETL tool to extract data from sources systems, loaded the data into the Oracle,MSSQL, DB2, Netezaa etc.

Designing and developing a data stage jobs to extract data from heterogeneous sources applied to transform logic.

Creating Datastage 10.0 and above jobs using different stages like the transformer, aggregator, sort, join, merge, lookup, data set, funnel, remove duplicates, copy, modify, filter, change data capture, change apply, column.

Extensively using the Datastage for extracting, transforming and loading databases from sources including flat files.

Good knowledge in the design of complex data transformation and expert in the use of lookup, filter, aggregator and transformer.

Strong knowledge in developing and implementing strategies for performance tuning.

Should be good in communication and handle the stakeholders effectively.

Should be able to work independently and possess leadership skills

Sr. DataStage Developer with over 7 years of ETL and Data Integration technical experience in Finance domain as a developer in System Analysis, Design, Development, Testing and Support of projects using Datastage in Banking, Retail and Insurance and Automobile verticals. Experience in Software Development Life Cycle requirement gathering, client interaction. Experience in reading and loading high-volume Type 2 dimensions by implementing SCD (Slowly Changing Dimensions).

Salary: Not Disclosed by Recruiter

Industry:IT-Software / Software Services

Functional Area:IT Software - DBA, Datawarehousing

Role Category:Programming & Design

Role:Database Architect/Designer

Key Skills

Desired Candidate Profile

Please refer to the Job description above

Company Profile

Harjai Computers Pvt Ltd

Harjai Computers Pvt. Ltd. is the preferred partner of top IT and Multinational companies all over INDIA and around the world for providing the best talent via Staff Augmentation (Temp Staffing / Subcontracting). Over the years, we've assisted our numerous clients scale new heights by deploying top professionals.
View Contact Details+

Contact Company:Harjai Computers Pvt Ltd