I have a very urgent DIRECT CLIENT requirement for Oracle Developer in
Harrisburg,
PA. Please Let Me Know If you have available candidate, please reply with
their word resume, location, rate and contact number.

Please send the resumes at su...@cncconsulting.com

Job Title: Oracle Developer
Location: Harrisburg, PA
Duration: 3 months

Position Description:  The position serves as a senior data warehouse
developer in PennDOT’s Bureau of Business Solutions & Services.  The
incumbent will perform new development and maintenance for an enterprise
data warehouse built on an Oracle 11g platform.  This individual will also
do analysis, design, and development of ETL using Oracle PL/SQL and
Informatica PowerCenter 9.5. The incumbent will develop and maintain
tables, create views, write queries, build PL/SQL packages, write stored
procedures, triggers and functions, and design and develop complex ETL
processes.  Responsibilities also include data modeling, primarily
dimensional modeling. Technologies leveraged include Oracle 11g, PL/SQL,
Informatica PowerCenter 9.5, and Erwin 7.3

Specific Duties:
Meet with end users and technical staff to gather data requirements
Perform intensive data analysis on source system data bases.  Analyze and
understand source system  database, find required data, and profile the
data.
Review and create dimensional and normalized data models.
Develop Oracle SQL and PL/SQL code, including packages, procedures,
functions, views and complex analytical queries.
Develop complex ETL using Oracle PL/SQL and Informatica PowerCenter
Diagnose, analyze, troubleshoot and choose appropriate solution to fix data
related issues.

Required Skills and Experience
Required:  7+ years Oracle development experience that includes writing
complex SQL and PL/SQL, and doing performance tuning
Required: 5+ years data warehouse development experience
Required:  5+ years of data modeling experience
Required: 2+ years dimensional modeling experience
Required: 3+ years experience using data integration/ETL software tool(s)
Required:  Strong oral and written communication skills
Desired:  2 years Informatica PowerCenter ETL development experience
Desired: 2 years MS SQL Server and/or DB2 experience
Desired:  1 year experience with Business Objects BI Tool suite or
comparable BI tool suite

Oracle development experience that includes writing complex SQL and PL/SQL,
and doing performance tuning Required 7 Years
Data warehouse development experience Required 5 Years
Review and create dimensional and normalized data models Required 5 Years
Dimensional modeling experience Required 2 Years
Experience using data integration/ETL software tool(s)  Required 3 Years
Strong oral and written communication skills Required
Informatica PowerCenter ETL development experience Desired 2 Years
MS SQL Server and/or DB2 experience Required 2 Years
Experience with Business Objects BI Tool suite or comparable BI tool suite
Desired 1 Years

Thanks,

Sunny Roy
(201) 588-9460  Phone
su...@cncconsulting.com

-- 
You received this message because you are subscribed to the Google Groups "SAP 
or Oracle Financials" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sap-or-oracle-financials+unsubscr...@googlegroups.com.
To post to this group, send email to sap-or-oracle-financials@googlegroups.com.
Visit this group at http://groups.google.com/group/sap-or-oracle-financials.
For more options, visit https://groups.google.com/d/optout.

Reply via email to