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
Role Category:Programming & Design
Desired Candidate Profile
Harjai Computers Pvt Ltd
Contact Company:Harjai Computers Pvt Ltd