Summary
Overview
Work History
Education
Skills
Strengths
Hobbies
Languages
Timeline
Generic
Rajendra Patil

Rajendra Patil

Bengaluru,KA

Summary

  • 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.
  • Requirements Analysis, Technical Design document preparation.
  • Creates integration testing strategy for jobs and participated in integration testing in development/testing environment.
  • Deployed jobs into higher environment using bitbucket and Jenkins tool.
  • Support to production deployment and load.

Education

Bachelor of Engineering - E & C

BLDE College of Engineering And Technology
Vijayapur, Karnataka, India
07.2017

12th - Science Education

S.B. ARTs & K.C.P. Science College
Vijayapur, Karnata, India
05.2013

10th -

Government High School
Baradol, Karnataka, India
04.2011

Skills

  • ETL DataStage v117 (Primary)
  • SQL (Secondary)
  • Unix Shell Scripting (Secondary)
  • ETL Informatica v96 (Secondary)
  • Python v3 (Secondary)

Strengths

  • Strong Analytical and Problem-solving skills.
  • Quick learner & Open to explore new technology and Domain.
  • Pro-active, Flexible, Enthusiastic, and Results driven.
  • Ability to work well with the team as well as to ensure best individual performance.

Hobbies

Swimming,

Listening to music,

Reading books,

Playing cricket.

Languages

Kannada
Bilingual or Proficient (C2)
English
Advanced (C1)
Hindi
Advanced (C1)

Timeline

Consultant

HCL Tech
08.2021 - Current

Systems Engineer

Tata Consultancy Services (TCS)
01.2019 - 07.2021

Bachelor of Engineering - E & C

BLDE College of Engineering And Technology

12th - Science Education

S.B. ARTs & K.C.P. Science College

10th -

Government High School
Rajendra Patil