*Hi Friends,* Hope you are doing great!!!
Send me profile to s...@vivayana.com Please go through the below position and send me your updated resume along with details and billing rate ASAP. * * *Job title: Data warehousing ETL Architect * *Duration: Long term* *Location: White Plains, NY and Minster, OH* *Immediate Interview* *Must's (Technical)* * Extensive Data Warehouse experience using Informatica PowerMart/ PowerCenter v8.6.1, Power Exchange, * Strong ETL experience using Informatica PowerCenter (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Mappings, Mapplets, Transformations). * Experience in integration of various data sources like Oracle, SQL Server, Flat Files, SAP IDOC-very strong plus, XML files,Teradata, and MQ Series. * *Extensive knowledge of PL/SQL and SQL server programming with as much of the following as possible*- *PL/SQL programming experience (Stored Procedures) *-Packages -Procedures -Functions *Oracle Object Creation *-Views -Indexes -Primary Keys -Synonyms -DB Links -Tables Database Normalization Database Architecture Knowledge of Oracle Jobs *SQL Queries *-Complex Nested Cursors -Complex Nested SQL statements -Union statements * Experience in writing UNIX Shell Scripts and automated the entire processes using UNIX Shell Scripting. * Experience in Informatica Production Support. * Experience in TOAD or SQL Navigator * Expertise in Performance tuning (Both Oracle and SQL Server). * Experience in up-grading the system from Informatica version. *Must's (Data Architecture)* * Can document, build, and interpret business requirements and technical mapping specs. * Data Modeling experience using Dimensional Data Modeling tools, Schema Modeling,, Physical and Logical Data Modeling, in a tools like Erwin 4.x. * CPG - ERP application experience (SAP preferably but Oracle APP application experience) * Experience in Data Architecture and Enterprise Architecture projects. * Experience in the identification of facts, measures, dimensions and hierarchies for building OLAP (Online analytical processing) data structures. * Sales, Supply Chain, and Manufacturing Experience. * Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills. *Plus's* * Experience in working with Reporting Qlikview, Microstategy, and Business Objects. * Experience in utilizing Oracle Utility tools like SQL*Loader, Import and Export. * Experience using CRON as Job Scheduling tool to schedule UNIX Shell Scripts, PL/SQL scripts, SQL Loader and Informatica jobs Regards, Sam Technical Recruiter Ph: (630) 444-7007, http://www.vivayana.com|| Email: s...@vivayana.com -- *************************************************************************************** For all SAP related tutorials,Articles,Faqs,Tips www.sapbrainsonline.com **************************************************************************************** You received this message because you are subscribed to the Google Groups "sapbrains" group. To post to this group, send email to sapbrains@googlegroups.com To unsubscribe from this group, send email to sapbrains-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sapbrains?hl=en
