Hello Partners,
Greetings from *Aim Computer Consulting*
We have the following requirement; please revert back to us with 100%
matching profiles Only
*Send Profiles to: [email protected]** *
Position : Data Warehouse Systems Analyst
Location : SC
Duration : 9 Months
Rate : $40/hr
The successful candidate will have, at minimum, the following skills:
• Experience and expertise in gathering and analyzing business user
requirements.
• Proficiency in Java development.
• Experience and expertise in SQL, including development of T/SQL queries
and data manipulation. Expert knowledge of databases and relational
database
concepts. Experience with *SQL Server 2005* required.
• *Experience with Windows XP operating system and the Windows 2003/2008
server environment.*
• Familiarity with Data Warehouse concepts, including the use of Extract,
Transform, and Load (ETL) tools and creation of data marts.
• Ability to learn new applications and skills sets.
• Ability to communicate clearly and concisely, both orally and in
writing.
• Ability to establish and maintain good working relationships with
business users, management, vendors, and peers.
• Strong organizational, multi-tasking, and time-management skills.
Ability to complete assignments on time.
• Understanding of deployment methodology concepts including design,
build, testing, and deployment.
*{TEAM SEND THIS COMPLETE INFO TO CONSULTANT}*
Job Description :
The following application tasks are expected to be executed by the Data
Warehouse systems/application analyst. All tasks will involve some degree
of up front analysis prior to development or execution, as well as several
phases of system testing.
These tasks/skills do not include database administration support or
technical infrastructure support tasks, as these are assumed to fall under a
different support area within the SCDOR IRM organization.
• Preparing and loading of data into the Data Warehouse using the Extract,
Transform, and Load (ETL) tool.
• Setting up and running the DiscoverTax Associate and Grow (A&G) offline
process for data cleansing and matching. This includes configuring the A&G
match keys.
• Development of tax calculations via the DiscoverTax “Tax Calc”
component. There is a user interface that supports creation of the tax calc
routines, however, complex calculations may require the development of
external Java objects that are called by the tax calc process.
• Creating and executing “views” to be utilized by the DiscoverTax audit
selection process.
• Maintaining all application level configurations and parameters for the
DTAX, Audit Workbench, and TaxMaster products. In addition to items listed
above, these include various system reference codes, workflow rules, scoring
parameters, correspondence templates, as well as configuration of various
3rd party products such as Group 1, SSA, and DT Studio.
• Monitoring of DiscoverTax offline processes. These include primary
indicator, legacy system gateway, nightly data refresh process, and
collections scoring.
• Performing ad hoc queries using T/SQL and stored procedures for data
maintenance
• Supporting installation of new DiscoverTax, Audit Workbench, and
TaxMaster releases
• Supporting 3rd party reporting tools Hummingbird and Clementine
• Maintaining custom offline routines such as legacy system Gateway,
Primary Indicator, etc based on business rule changes
• Performing database utility functions, such as *SQL Server Analytical
Services for OLAP , DTS, etc for loading and analysis of data.*
The individual will operate with very limited supervision, within standards
and processes established for the SCDOR Data Warehouse and over-all Agency
and IRM procedures. SCDOR systems include extremely sensitive and
confidential information; position requires complete discretion and
trustworthiness. The individual must be customer oriented, and attentive to
the needs of Data Warehouse users.
*Thanks & Regards** *
* *
*Naga Raj*
*Sr. Technical Recruiter*
*Aim Computer Consulting*
*17197 N .Laurel Park Drive | Suite 513 | Livonia MI 48152*
*Phone :** 734-591-3562 EXT 1+214 | **Fax:** 734-418-2603 *
*www.aim-cc.com* <blocked::blocked::http://www.aim-cc.com/>* **|**
[email protected]* <[email protected]>* **|**
**[email protected]*<[email protected]>
* | **[email protected]* <[email protected]>
-------------------------------------------------------------------------------------------------------------
Please visit www.NRIYP.com <http://www.nriyp.com/>
New generation Yellow pages for NRI’s
Classifieds<http://www.nriyp.com/Classifieds/Classifieds_Home1.aspx?Country=>
*|* Yellow Pages <http://www.nriyp.com/>* |
*Travel<http://www.nriyp.com/Travel/TravelHome.aspx>
* | *Classmates <http://www.nriyp.com/Classmates/Classmates_HomePage.aspx>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"ORACLE DWH DBA" 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/oracle-dwh-dba?hl=en
-~----------~----~----~----~------~----~------~--~---
