Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Oracle PLSQL ETL Developer
(Jobs in Boston, MA)
 
Requirement id 10433
Job title Developer
Job location in Boston, MA
Skills required OWB 11g, OWB 11gR2, Oracle, PLSQL ETL
Open Date 05-Jul-2012
Close Date
Job type Contract
Duration 3 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: Sudhir Bhagtani
Job Description Developer: OWB 11g, OWB 11gR2, Oracle, PLSQL ETL

[Note: Submission Deadline : 07/19/2012 03:00PM]

[Note: The engagement is expected to last a minimum of 90 days]

Description:

Responsibilities:

* Design and implement OWB Extract, Transformation and Load (ETL) processes, programs and scripts. Design of data warehouse tables, including source to target mappings, configuration of OWB, mdl migrations…etc.
* Develop and document the OWB ETL process. Help in Creation and maintenance of the source to Client data mappings, ETL specifications and complex transformation rules and technical documentation.
* Strong development experience in OWB, Oracle SQL and PL/SQL. Must have the ability to write Stored Procedures, Functions, Packages. Support testing, deployment and ongoing support of data warehouse system.
* Knowledge of database indexing and tuning in Oracle Database. Ability to interpret requirements and technical specifications and translate them into visual representations of information.
* Assist in developing and publishing data management standards, policies and procedures, including the management and maintenance of related tools and environments. Collaborate with Oracle Database Administrators for the Warehouse database design, data model, storage, security, performance and data environment requirements.
* Perform maintenance and support of existing applications. Establish, Maintain and Adhere to ETL and Data Integration Standards.
* Participate in peer reviews on specifications, design and code. Validate the data in the database and also responsible for testing the routines developed. Work closely with QA and Operations to ensure smooth QA and deployment of applications. Work with project teams to plan integration and implementation strategies.
* Experience performing Unit, Functional, Regression, Integration and User Acceptance Testing (UAT).
* Should have a strong verbal and written skills

Skills:

* Minimum 8 plus years hands on experience in Knowledge of Data Warehousing such as dimensional modeling, Star and Snowflake schemas, Data mart and Fact, Dimension tables, Slowly Changing Dimensions -Type I & II & III.
* 5+ years experience with OWB 11g or OWB 11gR2. Candidate should be fully proficient in writing scalable, high volume ETL jobs using SQL for large volume data warehouses.
* Solid Experience in OWB, Oracle 11g and PL/SQL is a must. Experience in OMB plus or tcl scripts is plus.
* Design and develop the architecture for all data warehousing components (e.g. source system data ETL strategy, data staging, movement and aggregation; information and analytics delivery; and data quality strategy)
* Setting up, debugging and implementing end-to-end ETL jobs. Do performance tuning of OWB ETL Mappings. Develop unit, system, and integration test plans
* Ability to analyze existing database schema DDL/Instance layout and make changes where required.
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 10433 while calling.
 
Other jobs in MA: Boston (103), Burlington (1), Cambridge (1), Canton (3), Chelsea (9), Franklin (1), Lexington (2), Malden (10), Marlborough (2), Maynard (2), Newton (1), Quincy (6), Sharon (1), Waltham (1), Welesley (1), Wellesley (6), Westborough (1), Westbourough (1),
 
 
 
 
(Developer: OWB 11g, OWB 11gR2, Oracle, PLSQL ETL in Boston, MA)
   
 
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
    About Us     Services    Privacy policy    Legal     Contact us     Copyright JobsInHand.com All Rights Reserved