We have an Urgent opening .Please see the Job Description Below and let me know if you have any consultant available. *Position: ETL / Data Analyst* *Location: Minneapolis, MN* *Duration: 8 months* Our client seeks an ETL/Data Analyst to assist in the data migration effort from a legacy land management system to a new land management system whose implementation is in flight. The components as a deliverable of this scope will be: • 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- document accurate code to load the data into the target databases. • Data Cleansing Requirement - Define data integrity/cleansing requirements for the transform process. Primary Responsibilities: • Gather requirements to create data mapping specifications and scripts for the conversion of data from legacy systems to new transactional system • Create accurate code using documented conversion specifications or using specification derived using reverse engineering techniques to load the data into the target database. • 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. • Writing or enhancing SQL queries to convert data into the target databases. • Create and update data verification plans, and expected outcomes, to be used for script runs. • Test all conversion programs in succession (assembly test) in order to identify and document programmatic dependencies. • Identify and resolve risks and issues related to data conversion activities. • Develop field mapping from the legacy system data sources to the target transactional databases. Review and understand existing ETL code. • Modify ETL code to repair defects & bugs. • 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. • 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. • 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 PL/SQL • Experience in TSQL • Technical writing skills for business audiences • Experience with InfoSphere Information Server • Public Sector experience *Thanks * *Wasim AhmedUnited Software Group Inc.. 565 Metro Place South. Suite # 110 Dublin, OH 43017 Phone: 614-588-8477Fax: 1-866-764-1148 * *wasimah...@usgrpinc.com* <wasimah...@usgrpinc.com> *www.usgrpinc.com* <http://www.usgrpinc.com/> To unsubscribe from this mailing, please reply to this email with the word UNSUBSCRIBE <techsupp...@usgrpinc.com,pan...@usgrpinc.com?subject=UNSUBSCRIBE%E2%80%9D.>in the subject line, or click here. *_______________________________________________________________________________* *USG is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law* -- You received this message because you are subscribed to the Google Groups "Resumes" group. To unsubscribe from this group and stop receiving emails from it, send an email to resumes+unsubscr...@googlegroups.com. To post to this group, send email to firstname.lastname@example.org. Visit this group at https://groups.google.com/group/resumes. For more options, visit https://groups.google.com/d/optout.