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.
