Greenplum Developer Job in Kastech Software Solutions at Bangalore

Worked on implementing DWH solution on Greenplum database (MPP architecture) hosted on VM’s for

• VMware Inc, one of leading organization in virtualization.
  
• Development of mappings, sessions and workflows for relational, application and flat file sources and targets.
  
• Extensive use of various ETL transformations like Router, Filter, Joiner, Aggregator, Lookup, Update Strategy, Sequence Generator, Sorter and Stored procedure.
  
• Worked on ETL designs and data modelling using Erwin data modeler.
  
• Performance tuning for mapping and executing/scheduling workflows using workflow manager and workflow monitor.
  
• Strong experience in writing SQL, PL SQL, Postgree SQL procedures, functions and packages.
  
• Prepared the test case for the mapping testing and prepared the naming tag document.
  
• Development of Job Information Language Scripts (JIL) in Autosys for Scheduling Jobs.
  
• Innovative in Approach, enjoy learning new methods and ideas and putting them into daily practice.
  
• Development of Unix wrapper and shell scripts to assist the scheduling of jobs
  
• Development of YAML (Control files) for extraction of data from files using GPload utility of the
  
• Greenplum appliance.