*Hello Folks, Kindly find the job description and confirm me with your available candidates on my email id*
*[email protected]* <[email protected]> *Job Title: ETL Developer* *Location: Minneapolis, MN* *Interview Type: Phone + In-person* *Candidate must be local !!* - Data Mapping Documents – Field mapping from the legacy system data sources to the staging database and the data store, if necessary, then the target transactional database of the new Land Management System. - ETL Code - Documented, accurate code to load the data into the target databases. - Data Cleaning Requirement - Define data integrity/cleansing requirements for the transform process. *Primary Responsibilities:* 1. Create accurate code using documented conversion specifications or using specification derived using reverse engineering techniques to load the data into the target database. 2. Conduct on site analysis of legacy system(s) and database(s) with the goal of producing the Data Mapping for the Extract process to support the Data Store and new system. 3. Writing or enhancing SQL queries to convert data into the target databases. 4. Work with users to ensure successful data conversion to the new system; may assist in user quality testing. 5. Create and update data verification plans, and expected outcomes, to be used for script runs. 6. Test all conversion programs in succession (assembly test) in order to identify and document programmatic dependencies. 7. Identify and resolve risks and issues related to data conversion activities. 8. Participate in routine meetings and documentation reviews. 9. Provide input for defining data integrity/cleansing requirements for the transform process. 10. Develop field mapping from the legacy system data sources to the target transactional databases. Review and understand existing ETL code. 11. Modify ETL code to repair defects & bugs. 12. Communicate and finalize solutions with the user on decisions for data that may not be converted or may be altered in form, to the new system. 13. Identify new fields that may need to be created in new system for data not identified in the original configuration. *Required Experience/Knowledge:* - 5+ years of IT Delivery Experience, including a recent role in data conversion. - 5 + years of experience supporting mission-critical implementation projects. - Solid knowledge and expertise in data conversion methods, tools, and procedures. - Strong communication skills with ability to effectively present information to technical and business audiences. - Proven experience with performing data analysis, data mapping and reporting data issues. - Experience in Microsoft SQL Server, Access, and other data sources. *Preferred Experience/Knowledge:* - Experience in Oracle SQL - Experience in TSQL - Technical writing skills for business audiences - Experience with InfoSphere Information Server - Public Sector experience *Regards,* *Ankur Dixit* *Mobile**Comm** Professionals Inc.* *465 W Pres George Bush Hwy, Ste 200* *Richardson, TX 75080* *Desk: 949-793-7570* -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.
