Goutham Jaganathan

Experience

• 

  Object Arena Solution Pvt.

  Jan 2010 - Jan 2011

  ETL Developer

   Preparing of Analysis and Design documents. Preparing and validation of Source to Target Mapping sheet. Understanding the Business requirement. Used Data stage Designer to develop ETL jobs based on new request. Used Data Stage Manager to Export and Import the jobs. Experience in running jobs using Job Sequencers. Developed Data stage jobs to Extract, Transform and Load the data from source to target. Worked extensively on different types of stages like Dataset, Lookup, Join, Merge, Funnel, Copy, etc.  Fine-tuned Transformations and mappings for better performance. Show less

• 

  Object Arena solutions Pvt.

  Jun 2011 - Sept 2012

  ETL Developer.

  Preparing of Analysis and Design documents.Preparing and validation of Source to Target Mapping sheet.Understanding the Business requirementUsed Data stage Designer to develop ETL jobs based on new request.Used Data Stage Manager to Export and Import the jobs.Experience in running jobs using Job Sequencers.Worked extensively on different types of stages like Dataset, Lookup, Join, Merge, Funnel, Copy, etc. Fine-tuned Transformations and mappings for better performance. Show less

• 

  Wipro

  Oct 2012 - now

  Information System-BI-Data Mart Implementation

   Implementation of data modeling for building the Warehouse Designed and implemented the ETL required for the development Testing the data, as it involved the migration of straight flat report into model Designing and modeling the base level data necessary for report development in ETL (Data stage) Preparation of People Supply Chain Dashboard in OBIEE-10g for the analysis of Employee Availability to match with the skills required. Migrated the Data stage jobs from V7.5.2 to V8.7 and tested. Built Security framework, Capacity planning in the Data Stage. Providing extended support (24X5) as L3 SME and also maintaining the environment. Suggesting best approached to the team for the effective design of DS jobs. Show less

• 

  First Advantage India

  Jun 2016 - now

  Background Investigator