Hi all, we are looking for a *“SQL Server Developer”* with conversion experience
*Location:* Richmond, CA *Duration:* one year Start: ASAP Prior work experience with large-scale data conversion effort from multiple systems into a single system Locals-great plus! Certifications are a plus. *RESPONSIBILITIES: * The developer will be responsible for design, development and testing of data conversion from legacy source systems (SQL) to target systems (SQL Server 2005 Database). *Specific tasks include: * • Analyze source system database structures, identify potential data quality issues • Interact with client source system SME’s to discuss requirements • Determine appropriate mapping of fields from source to target database and required transformation logic • Write technical conversion specifications including required data elements, transformations, and business rule validation requirements • Write SQL scripts to extract the data into the pre-defined file format • Assisting with test scenario definition, script development, and test execution * * *REQUIRED SKILLS: * • At least 4 years of experience writing *SQL scripts* • Prior work experience with large-scale data conversion effort from multiple systems into a single system *QUALIFICATIONS: * • Prior work experience with large-scale data conversion effort from multiple systems into a single system • Prior work experience preparing *SQL scripts and data mappings* • Prior work experience developing data dictionaries • Prior work experience in *SSIS (SQL Server 2005 Integration Services)* • At least 7 years of work experience with Microsoft SQL Server • Excellent communication and analytical skills. *Responsibilities: * *•Design & development: * - Responsible for design, development and testing of data conversion from legacy source systems (SQL) to target systems (SQL Server 2005 Database) - Analyze source system database structures, identify potential data quality issues - Interact with GDSP source system SME’s to discuss requirements - Determine appropriate mapping of fields from source to target database and required transformation logic - Write technical conversion specifications including required data elements, transformations, and business rule validation requirements - Write SQL scripts to extract the data into the pre-defined file format - Assisting with test scenario definition, script development, and test execution - Update and maintain the functional and detailed design documents based on the changes identified during conversion development - Develop the unit test scripts for the assigned components - Develop the conversion components - Successfully execute the unit test script and record unit test results - Execute the integration test scenarios and record results - Resolve integration issues * * *Status reporting and communication: * - Accurately report the status of the assigned tasks to the conversion functional lead on a daily basis - Raise issues during the design and development of the conversion components, to the conversion functional lead, including potential delays in the development schedule *Deliverable Quality: * - *Code:* Adhere to coding standards - *Design:* Follow project design standards and adhere to defined best practices - *Unit and Integration Test:* Develop components that will pass the unit test scripts and the integration test scripts by the end of the development phase for each development wave - *Design Documentation:* Maintain design documents throughout the project to reflect the current design of the application and conversion components Please reply to [email protected] *With regards,* *Nanda** Amtex Systems Inc.* *50 Broad Street, Suite 801**, New York**, NYC-10004** **www.amtexsystems.com* <http://www.amtexsystems.com/>* ** Direct: 646-200-7233* *Fax: 866-330-0589* “Certified Minority Business Enterprise firm" Amtex Systems Inc is rated among the top privately held Technology companies in New York. Business Verticals: Infobuild India ( Webfocus, iWay) | BPO Division | Offshore development | Independent Software Testing | Healthcare practice | Technology Infrastructure Office Locations: New York, New Jersey, Austin, Dallas, Jacksonville, Los Angeles and London *"Should employment follow the receipt of this Resume/Contract, whether directly, or at an end-client site, you hereby acknowledge that such employment of the Consultant's services will not cause displacement of any U.S. workers similarly employed by the Company, 90 days before and continuing 90 days after the date of commencement of said services. Please forward this attestation along with this Resume/Contract."* -- Introduce business in 3800 cities. How? ===================================================== Thanks for using group. Moderator 1) This group is managed by www.BRCIndex.blogspot.com 2) Post your message with your linkedin Profile (Visit linkedin.com) to confirm your identity and refer business. 3) Visit www.BRCIndex.blogspot.com (3800 Business Referral Club) 4) Reply to two message before posting new one. 5) Donot post same message in all 3800 business Referral Club. You received this message because you are subscribed to the Google Groups "Outsource" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Outsource To unsubscribe, reply using "remove me" as the subject.
