DataStage Developer with over 5+ years of ETL and Data Integration technical experience in Banking domain as a developer in System Analysis, Design, Development, Testing and Support of projects using Datastage client tools like Designer, Director, Administrator, SQL and Unix.
Looking for an IBM ETL DataStage Developer position in an organization which gives an opportunity to utilize technical and analytical skills to build solutions and deliver expectations thereby can put forth effective contribution to the organizations growth.
Overview
5
5
years of professional experience
Work History
Consultant
HCL Tech
Bengaluru, KA
08.2021 - Current
Loading of all data from various sources into database.
Extensively using DataStage designer to develop parallel and sequence jobs.
Developed Parallel jobs using different stages like transformer, aggregator, sort, join, lookup, funnel, remove duplicates, copy, modify, filter, row generator.
Developed sequence jobs using different activities like Execute command, Job, Sequencer, User Variable, Nested Condition, Loop, Exception Handler and Terminate etc.
Written SQL queries with sub queries, joins, Where clause, aggregated functions , Union, Group by, Having Clause, Null handling etc. and created views.
Developed Unix scripts to run DataStage jobs and performed operation on files.
Actively participating in technical discussion, decision making meetings and regularly interacting with Product owner and architect to gain a better understanding of the business process, requirements & design.
Involved in all phases including requirement analysis, design, coding, testing, support, and documentation.
Used Azure pipelines to deploy code.
Used MI Tool and ETL Framework for Scheduling jobs.
Systems Engineer
Tata Consultancy Services (TCS)
01.2019 - 07.2021
Fixed warnings in parallel jobs.
Support to senior associates in development.
Developed parallel jobs, sequence jobs as per requirement.
Experience in fixing/resolving bugs/issues in aborted jobs.
Experience in UNIX scripting to run jobs, pass parameter values to jobs and etc.
Experience in writing SQL queries to fetch records from multiple tables and sub-queries as well.