Job Description :
1. Perform full software development lifecycle, including requirements analysis, architecture definition, design, testing, integration and post-installation support.
2. Perform DB2 database development, analysis, testing and warehousing.
3. Provided technical architectural solutions based on business requirements and prepare documents, including Technical Design documents, Mapping Specifications, Data Transformation rules and Test plans.
4. Analyze and document functional and technical requirements for business critical projects.
5. Analyze the existing legacy systems and suggest suitable technical solutions.
6. Develop detailed requirements for Interfacing, and Upstream-downstream Applications and Data Warehouses.
7. Code programs and document the unit test results and schedule events. In addition, define test plans, test cases for unit, integration and system testing.
8. Write Stored Procedures, and define and maintain procedures.
9. Analyze data stored in Database Objects, designed ETL processes, and performed data cleansing/data mining.
10. Design and develop online conversations and user interfaces.
11. Test web-based Java and J2EE front-end applications that interact with back-end DB2-IMS databases.
12. Coordinate with offshore team in order to lead, execute, and monitor the project to completion.
13. Mentor developers and Testers, provide guidance to programmers, review code, integrate application modules for system testing, and ensure that standards are followed.
14. Develop and use quality assurance procedures to assure high quality software.
15. Provide status reporting and collaborate with Project Managers, Technical Architects, Business Analysts.
16. Perform Data mapping, create data transformation rules, develop detailed business requirements for interfacing, and perform data warehousing.
17. Analyze, develop, and implement complex functionality according to business requirements.
18. Develop DB2 database objects including tables, views, indexes, schemas, stored procedures, sequences and load/unload utilities. Perform DB2 database development, testing, migration and optimization.