Hi,


Greetings!!!!!



Here is urgent requirement. Please check the requirements and get to back me
with up dated profiles as soon as possible.



Title: ETL/Java/SQL programmer



 Location: *NYC, NY*



* *

Duration: *6 months*







Description:



·         We need an additional resource (ETL/Java/SQL programmer) that can
perform the following tasks. Items 1 and 2 are the highest priority and need
to happen simultaneously. I think a strong ETL resource with solid
relational db/SQL skills and some java skills is all we need. The TQL tasks
are well documented.

·         Create a process to regularly extract uCMDB data and load it into
our SW Governance Repository

·         Write code (Java/.Net) to make TQL calls against uCMDB data
sources replicating current extract reports.

·         Read attached for specifics

·         Automate extracts to align with the frequency of data updates
(Daily/Weekly)

·         Make basic transformations before data is loaded

·         Efficiently load extracts into SWG Repository (currently MS Access
mdb) with an extract date and total record count

·         Output will be either temp csv files or uploaded directly into
repository (via informatica?)

·         Apply needed indexes

·         Transform raw data extracts and excel spreadsheets into Usage,
Inventory and Entitlement data

·         Work with IT Asset Analysts to determine how raw data can be
transformed into Reconciliation information

·         Relational Db skills: SQL, inner and outer joins, multiple table
joins, finding duplicates, group by, like syntax

·         Can create cross reference tables to translate raw values into
normalized names.

·         Can communicate with Analysts to understand the data challenges
and create queries to normalize raw data, join and transform data into SW
Usage, Entitlement and SW inventory reports.

·         Can convert raw upload files into fact tables and reporting
dimensions in MS Access

·         Ability to learn MS Access VBA (I can teach and I have samples if
they know how to code) to transform data

·         Add controls to current data transformations (Counts, Sums,
Exceptions, Feed History)

·         Develop a process ensuring rows aren’t lost when multiple uploads
are staged and converted to fact tables.

·         Build exception tables to report on data that can’t be
transformed.

·         Migrate our MS Access mdb into either SQL Server or Oracle db to
improve stability and scalability

·         Work with our DBAs to estimate tasks and effort

·         Conduct migration without hindering reconciliation

·         Link tables back from db to MS Access so reporting and
transformations can be done in MS Access







Thank you,
Rajesh.P,
Technichal Recruiter
Zeninfotech, LLC
5949 Nieman Rd, Suite B, Ist Floor,
Shawnee, KS 66203.
Tel:  913-441-1888 Ext. 1100
Fax: 913-441-4434
[email protected]
www.zeninfotech.com

-- 
You received this message because you are subscribed to the Google Groups 
"KNOW.IT" 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/know_it_az?hl=en.

Reply via email to