Please respond to [email protected]
Location: *Philadelphia, PA* Duration: *8 Months* *Face to face interview will be required after the intial phone screen.* *MAJOR RESPONSIBILITIES:* * * · Create and modify high performance Extract, Transformation, and Load processes (ETL) using Informatica, Oracle PL/SQL and Unix shell scripting. · Data Warehousing and ETC Architecture, Data Modeling, Data Migration and Oracle application development · Informatica (PowerCenter 8.6) Server and Client tools like Repository Manager, Mapping Designer and Workflow · Manager to extract data from disparate data sources (Oracle and SQL Server) and load into ODS and Data Warehouse on an incremental basis. · Structured design and development skills in the area of Oracle PL/SQL database packages, stored procedures, functions, exception handling and batch job scheduling. Extensively used Oracle table partitioning (Range and List),, Oracle analytical functions and hints in SQL queries to attain optimum performance. * * *POSITION REQUIRED SKILLS:* * * · BA/BS degree with seven plus years of relevant experience. · Informatica (PowerCenter 8.6) Server and Client tools like Repository Manager, Mapping Designer and Workflow · Extensive work with data from disparate data sources (DB2, Oracle, SQL Server, flat files, etc) and load into ODS and Data Warehouse on an incremental basis. · Strong analytical skills. · Vast experience with ETL processes used to create extract databases. · Working knowledge of Autosys 11 including scripts design, dependency management and notification processes. · Proven background improving process quality and providing system automation recommendations and strategies to manage solutions and data efficiently. · Strong SDLC process knowledge. · Effective oral and written communication skills. · Work in a collaborative office environment with other developers, business analysts, and a project management team. *POSITION PREFERRED SKILLS (NOT REQUIRED):* * * · Structured design and development skills in the area of Oracle PL/SQL database packages, stored procedures, functions, exception handling and batch job scheduling. · Data Warehousing and ETC Architecture, Data Modeling, Data Migration and Oracle application development · Knowledge of Daily Defined Contribution Plan record-keeping (401(k) annuity based product preferred). · Good understanding of operating procedures of investment products. Thanks N' Regards, Vikram M** Revosys IT Inc.** 108-31, 47th Avenue, Corona, NY 11363 Ph: 347 468 7163 | Fax: 347 649 2053 [email protected] | www.revosysIT.com -- You received this message because you are subscribed to the Google Groups "IT RECURITER" 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/it-recuriter?hl=en.
