Merger-Accounting Project• Create Impact Analysis Documents for Mainframe and/or DataStage Jobs.• Create/Update ETL jobs using DataStage 8.7.• Create/Update Mainframe jobs and components.• Create/Update Unix Scripts.• Promote jobs to PROD environment.• Schedule jobs using ESP Workload Manager.• Prepare test data.• Perform Unit Tests.• Monitor and resolve Incident Tickets related to project.

Duties and Responsibilities: IFW (InfoSphere Foundation Warehouse) Project• Participate in problem analysis and system design in preparation to development of programs.• Create ETL jobs using DataStage for RM files.• Create Tables and Sequences for RM Files.• Test and debug programs.• Revise and refine programs as directed.• Prepare test data.• Help design batch flow.• Run and monitor batch of IFW in SIT and UAT.• Extract data and create Excel files for validation.• Validate the result of the batch against the Source-to-Target Mapping.• Update Source-to-Target Mapping based on revisions.• Manage the migration of IFW from SIT to UAT. This includes the DataStage Jobs and all the DB Object related to the project. BDV (BPI Data Vault) Project• Technical Team Lead.• Solve technical issues encountered by the project.• Create Databases, Tables, Sequences, Stored Procedures, and Indices for the project.• Create ETL jobs using DataStage for RM files.• Test and debug programs.• Revise and refine programs.• Help design the batch flow.• Run and monitor batch in SIT.• Monitor batch in UAT.• Provide technical support to batch abends for datastage jobs.• Manage the migration of BDV from SIT to UAT. This includes the DataStage Jobs and all the DB Object related to the project.