*Send the profile to j...@tekatlantis.com * * *
*ROLE:* SQL Conversion Developer *LOCATION:* Richmond, CA (must be local to CA) *DURATION:* 12+ months *RATE: *$6,200 Corp to Corp (4 week all inclusive pay cycle) *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 * * -- Alex Sr.Recruiter a...@tekatlantis.com Atlantis Technologies Inc. 5745 Weddington Dr, Cumming, GA 30040 www.tekatlantis.com -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To post to this group, send email to citrix-and-sap-probl...@googlegroups.com. To unsubscribe from this group, send email to citrix-and-sap-problems+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/citrix-and-sap-problems?hl=en.