*Hi,* *We have an urgent requirement for one of our client. Let me know if you can go further.*
*Please respond ASAP.* *Please send your resumes to [email protected]* ** * * *Location: New York City * *Duration: 6 months – 1 year* *Rate - $45/hour* * * Below is a detailed list of DB2 topics that the candidate should know about. *DB2 Questions* 1. DB2 common SQL codes: -805, -803 2. DB2 Stored Procedures What is Result Set, Defining SPs, Calls to SPs, Communication (receive and send data) 3. Global Temporary Tables 4. SQLs: Joins, Co-related sub queries, Functions, Group by, Delete SQLs 5. DB2 Explain: PlanTable and its function, common columns 6. DB2 Access path 7. Bind Parameters: Package Bind, Plan Bind, Consistency tokens, Packages Collections 8. Common DB2 Catalog tables, SYSPLANS, SYSPACKAGES, SYSTABLES etc.. 9. DB2 Load and Unload utilities - All Load and Unload parameters * * * * *Job Overview:* Opening in NYC, NY for a data conversion initiative of Our Client Performance Unification Platform System, which is primarily written utilizing COBOL/DB2 Mainframe stored procedures and MF scripting routines. The successful candidate should have a good track record in designing and development and be prepared to spend time in understanding the existing routines and leverage them to develop the conversion routines and finally take ownership of them. They will be required to demonstrate a mature and constructive approach to identify technical gaps (if any) from the current state to the future state of converting the data to the target platform. *Duties & Responsibilities:* Duties will include - Lead the design and development of the data conversion utilities as per the functional requirements - Communication with functional folks to analyze/address any technical constraints or issues. - Understand the current code components and appropriately leverage them for future development activities/ Participating in test execution cycles - Understand the current infrastructure landscape and appropriately lead and implement code components to handle huge volumes of data/Regression & Performance testing - Interact with other technology groups, as needed - Coordinate with developers located in different geographic regions and review the deliverables for quality - Able to lead teams and manage schedule, tasks and activities remotely. - Able to interact with customers and appropriately provide status as and when required. *Skill, Experience & General information Required:* Basic Technical Requirements - COBOL/Mainframe/DB2 (8-10 years plus). - Mainframe scripting (8-10 years plus). - Strong programming skills (8-10 years plus) - Able to understand the existing code components and appropriately leverage them for the current conversion requirements. Desirable Skills - Exposure to the Wealth Management Industry/ Fund Investment Performance. - Excellent written and verbal communication skills. -- Best Regards, Amit ________________________________________________________ Amit Kumar | Deegit Inc |Sr. IT Recruiter | 1111 Plaza Drive, Suite 370 | Schaumburg, IL 60173 | Ph: 847.874.7081 | 7082 |3615 ext - 311 | Fax: 847.330.1987 | e-Fax: 847.416.4898 | [email protected] | www.deegit.com | "Certified Minority Business Enterprise (MBE)" “Winner – Deloitte Technology Fast 500 for 2008” “Winner – Inc. 5000 fastest growing firm for 2008” "Right Person for the Right Job in the Right Time" The information transmitted in this email is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this transmission is prohibited. If you have received this transmission in error, please contact the sender and delete the material from your system.
