Venkata R.

Total Exp: 11.6 on Datastage in Development and Production support environments.

Hyderabad ,

Experience: Year

Venkata

Hyderabad ,

Total Exp: 11.6 on Datastage in Development and Production support environments.

1 USD / Year

Immediate: Available

Year

Now you can Instantly Chat with Venkata!

Chat Now

Skills

- 11 Years

Advanced

Positions

Software Engineer

Business Analysts

Technical Writer

Systems Analysts

Technical Specialists

Portfolio Projects

Description

Understood the requirement for the project and done the analysis on the requirement.
Prepared Technical design documents to build the code in the development environment by communicating with Business Analysts.
Worked on DataStage client components DataStage Designer, Director, Administrator.
Prepared ad hoc extraction queries to extract data from multiple tables, Unix scripts for file validation, and archive the processed files.
Used the various types of stages like Sequential File, Dataset, Sort, Database connector, Transformer, Lookup, Change capture, Copy, Joiner, Funnel, etc.
Built Extraction jobs, Transformation jobs, loads Jobs, and Final sequencers jobs for the execution of all jobs as per the jobs’ execution dependency.
Prepared Unit test case templates, and done unit testing based on jobs and scripts execution.
Done peer reviews on Jobs, sequencers, Unix scripts, and done reconciliation by executed the jobs.
Lead the team by assigning the work to team members and done follow-ups to deliver the code to the concerned environment within timelines.
Applied performance tuning techniques while building Jobs to avoid the delay of code execution.
Find the dependencies and scheduled the DataStage sequencer jobs based on the frequency of loading.
Worked on code migration from DataStage lower version code to the higher version code by doing the required modification in jobs’ level and by thorough testing.
Prepared the code release planning document to deliver the code to the concerned environment.
Provided Knowledge Transfer to the testing team and provided big support while testing the code.
Fixed the defects and delivered the correct code to the testing environment within timelines.
Attended meetings without fail and explore the work status as per the work completed or work in progress on daily basis.
Worked on multiple CRs and deliver quality code within timelines to the concerned environments.
Created the change request and got the approval for code deployment according to the first-time deployment and code change deployment based on enhancement.
Product ionized the code after a thorough test in System testing, System Integration Testing, and User acceptance testing.
Given big support while testing the code execution and batch execution in the concerned environments.