*Subject : DataStage Developer Location : Cincinnati Ohio Duration : 6+ months
Job Description:* Design and populate dimensional model (star and snowflake schema) for a data warehouse and data marts Create source to target mapping Documents Prepare detailed design documents Design Templates for the Parallel Jobs and Sequencers Develop various jobs using ODBC, Hashed file, Aggregator and Sequential file stages Import data from flat files, transform and place in target databases Developed SQL scripts for data dump in various databases Build Datastage jobs to FTP the data file for loading into various databases Use DataStage Director and the runtime engine to schedule running the jobs, monitoring, scheduling and validating its components Create templates for job parameters to be used throughout the project and be responsible for maintaining and updating the parameters Develop job sequences to run jobs in parallel and in series taking into consideration the interdependencies Assist the organization in performing data compiling, mining and analysis required to evaluate the given data Provide flexible resources to users as per the business requirements by exporting Universe and BO reports. Perform code review for the jobs build and prepared the Unit testing Document for future review. Performance tunings on Data stage jobs *Environment:* Infosphere DataStage EE 8.5 and Oracle 11g *Thanks & Regards, -- Ranadheer Technical recruiter Sriven Technologies LLC .., E-Mail: ranadh...@sriventech.com Web: www.sriventech.com Ph: 703-842-4812 ext 303 Fax: 1866 725-2860 * -- You received this message because you are subscribed to the Google Groups "USITCV" group. To post to this group, send email to usitcv@googlegroups.com. To unsubscribe from this group, send email to usitcv+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/usitcv?hl=en.