*Hi Partner* How are you doing today? We are looking to fill the below position with one of our CLIENT. If you have a matching candidate, please send it across with their updated resume, rate and contacts at [email protected] / * 856-673-0301** *and add me in your database *Gtalk* - * [email protected]** */ Yahoo- *[email protected]*<[email protected]>
* * *Position 1*** *Position - Data Warehouse Consultant * *Location: Wisconsin prefer IL PA* *Duration: 1-3 years contract* *Rate: Good* *In Person Interview will be required on final round.*** * * This position is needed for advanced data warehouse business analysis, database design, ETL design, and data warehouse support. Best-qualified candidates will have strong experience using *Oracle, Erwin and Business Objects* in a data warehouse environment. This position will do the following: work with advanced-level accountants and other business customers to understand their data analysis and reporting requirements; design data warehouse table structure to satisfy business requirements, identify data source, develop strategies for data extraction from source systems, design transformation and loading into data warehouse target systems; develop, implement, and follow technical and process standards; develop strategies for system fault tolerance, data recovery and purge; work to improve the efficiency of data warehouse applications through the use of indexes, compression, and other techniques; work within both formal and “agile” application development project management methodologies; function as a database liaison on the data warehouse team. Qualified candidates must have prior experience in data warehouse design and construction. Preference given to qualified candidates familiar with State of Wisconsin application systems, procedures and development standards. Preference will also be given to candidates with experience with insurance and accounting data and data warehouses. Hardware/Software Environment: Oracle 10g or 11g Business Objects XI 3.1 (Designer, Deski, WebI) Informatica 8.1.1 PL/SQL ERWin SQLNavigator MS-Team Foundation Server Distributed Control-M job scheduler *Position -**2* *Position - Data Modeler* *Location - Wisconsin Prefer IL, * *Duration -1-3 years contract* *Rate -Good* In Person Interview required on final round. · Develops conceptual, logical, and physical data models for the EC LDS project and other DCF efforts. · Responsible for leading and facilitating communication with business customers, IT staff, and other stakeholders, incorporating business requirements into data model design. · Translates technical aspects of data modeling (facts, dimensions, “snowflaking”, etc.) into language that non-technical users can understand. Works with both technologists as well as non-technical users with ease and approachability. · Assures that all relevant aspects of data model (granularity, etc.) are taken into account. · Makes recommendations on data maintenance tactics for slowly changing dimensions, data roll-off / archival planning, etc. · Works with DBAs to coordinate instantiation of tables and other relevant database objects. · Designs models optimized for both storage (warehouse) and query / retrieval (end user marts). · Works with the team lead and manager to determine a detailed and prioritized list of objectives and activities for current and future projects. · Understands and balances business requirements and user expectations. · Experience with Human Services business intelligence is desirable. · Data modeler capabilities with 5 or more years of experience, relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks. Skills Required: · General Competencies · Excellent organization, analytical, and communication skills * · Conceptual, Logical and Physical Data Modeling * · Erwin Data Modeling Software * · Create database objects * · Data analysis * · Database design * · Data Warehouse - Experience in data warehouse design and development * · Informatica * · Metadata tools * · ODBC/JDBC * · Oracle 10g * · Oracle 11g * · Oracle data dictionary views * · SQL with Oracle 8i or higher * · Knowledge of Kimball data warehouse design principals * · PL / SQL * · SQL * · Experience with Oracle PL/SQL * * * *---* *Thanks & Regards* *Prem Thakur*** *Premium Information Technology,Inc.*** *Tel*: 856-673-0301 *Email* - *[email protected] <[email protected]>*** *Yahoo* -* [email protected] <[email protected]>* *Gtalk* - *[email protected]* *Linkdin* -*www.linkedin.com/pub/prem-thakur/5a/681/b/*<http://www.linkedin.com/pub/prem-thakur/5a/681/b/> * * -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/oracle-projects. For more options, visit https://groups.google.com/groups/opt_out.
