Hi Associate,

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 resumes@googlegroups.com.
Visit this group at https://groups.google.com/group/resumes.
For more options, visit https://groups.google.com/d/optout.

Reply via email to