Job Duties :
- Under limited supervision, perform complex software analysis, design and development using Datastage tools.
- Responsible for all phases of SDLC.
- Gather and interpret functional and user requirements, and create technical design.
- Create high level and low level design documents; store, retrieve, and manipulate data for analysis of system capabilities and requirements; perform system study and document the process flow.
- Design and implement end-to-end data warehouse.
- Coordinate design and customize for client.
- Perform data analysis, coding and implementation of data conversion modules.
- Perform migrations and write server routines; write SQL queries.
- Profile applications for performance optimization.
- Coordinate risk analysis and mitigation plans.
- Create integration test strategy for ETL jobs and assist testing team with integration testing.
- Design and develop master controlling sequencer jobs.
- Automate exception and summary reports; perform code reviews.
- Mentor/assist lower level programmers with the above, as necessary.
Accomplish above tasks utilizing the following tools:
Sun Solaris, Windows, UNIX, Oracle, Sybase, SQL Server, TOAD, DataStage, DMP, Quality Stage, DataStage Job Sequencer, Erwin, Work Bench, SAP BW, Informatica, PL/SQL, SQL Plus, SQL Loader, SSIS, Java, JSP, J2EE, XML, XSLT, Shell Scripting and related tools.