Satheesh Adupa

Experience

• 

  Infinite Computer Solutions

  Dec 2011 - Aug 2014

  Etl Developer

   Interact with client in order to understand the functionality and provide technical solutions.  Develop new job designs based on technical specifications provided by the client using DataStage 8.7 and DB2 9.7  Co-ordinate with QA and provide inputs in Integration Testing.  Used DataStage Designer to design DataStage jobs to extract, transform and load the data from source to target  Used DataStage Manager to export, import the Metadata of tables and DataStage jobs.  Used DataStage Director to run and monitor the jobs.  Designed various Job Sequences for the set of jobs developed.  Developed and executed the Unit Test Cases.  Scheduling ETL job flow in DataStage Director.  Prepared the ETL Specifications, ETL Manual Operations and Data Dictionary documents in implementing the changes. Show less

• 

  IBM India Private Limited

  Sept 2014 - now

  ETL Developer

  Working with the development team to build the change requests, from the business, on top of existing application.  Understood the client requirements by reviewing by the functional documents.  Analyze the Hyperion Interactive Reporting (Brio) files and converted the Hyperion Brio logic's to ETL.  Using Data Stage Designer to design Data Stage jobs to extract, transform and load the data from source to target.  Using Data Stage Designer to Export, Import the Data Stage Jobs and Metadata of tables.  Used the various Stages like copy, Modify, Lookup, Transformer, Sort, Funnel, Row/Column Generator, Join, Dataset, Merge, Aggregator, Sequential file, Remove duplicates and Surrogate Key Generator.  Using Data Stage Director to run and monitor the jobs.  Designed various Job Sequences for the set of jobs developed to send out email notifications to the team members.  Scheduled ETL jobs through Data Stage Director to run on Monthly basis.  Developed both parallel & server ETL jobs as per the requirements and automated them.  Read the unstructured data (Excel) with the implementation of new stage called Unstructured File stage in Data Stage Parallel jobs.  Implemented performance tuning options like Sparse Look-up, partition technique, and sorted data to joins, removing unnecessary columns and handling the nulls.  Error tracking and Error Monitoring using DS director.  Co-ordinate with QA and provide inputs in Integration Testing.  Develop and execute the Unit Test Cases.  Prepare the ETL Specifications, ETL Manual Operations and Data Dictionary documents while implementing the changes. Show less