ETL Developer

• Develop the middleware components using C,C++ and Unix Shell Scripting

• Worked in developing Ad-hoc Shell scripting and Sql Queries based on business user reporting needs.

• Developed re-usable Shell scripts for data Manipulation

• Supported Applications in C++, Unix Shell scripting worked extensively in migration of data Extraction from shell scripting to Data stage.

• Worked with version controlling tools like Star team, RTC, Windows visual source safe

• Created re-usable components using shared containers for local usage/shared usage.

• Worked with DBA team for better production support and performance.

• Used the Data Stage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse.

• Created Design Documents and Unit Test cases with test Results Documents.

• Good Experience Working with Autosys & TWS for scheduling daily and monthly ETL’s Jobs.

• Developed automated notification of Emails to the operations/prod support team in case of job failures

• Performed Import and Export of Data Stage jobs using Data Stage Designer / Manager for migrating jobs across environments such as Dev, UAT and PROD etc.

• Coordinating with Offshore teams for Code Delivery

• Conducted Knowledge Transfer session both on functional Level and Technical Aspects

• Introduced Autosys Scheduler for better Batch handling

• Introduced automated batch alerting process for Effective addressing of Nightly batch issues

• Participated many Discussion about migration of batch process from Unix shell programming to New data Stage Environments

• Acted as a Bridge Between Business users and Technical team during root cause analysis

• Implemented Documentation for the existing batch issues, in order to make smooth handling of re-occurring issues.

• Implemented Disaster recovery test procedures.

• Actively involved and Became Point of contact for all the batch scheduling procedures

• Represented and participated in all Disaster recovery testing process.

• Worked on Many Ad hoc Report requests from Clients.

• Acted as a point of contact for Maintaining Lower environments like QA,UAT,PRE-PROD

• Developed technical documentation such as deployment instructions and production steps to enable the production support personnel better understand the production process.

• Daily production support of distributed application systems, design/analysis and coding functional enhancements Involved in day to day user interaction, work in DB2/Oracle performance tuning to maximize efficiencies and optimal.

• Developed technical documentation such as deployment instructions and production steps to enable the production support personnel better understand the production process.

• Created reusable Shell Scripts for data quality process and automated alerting purposes.

• Active