Job Seekers, Please send resumes to resumes@hireitpeople.com Int. type- Either Go To Meeting Web Cam or In Person interview.
The position serves as a senior data warehouse developer in PennDOT’s Bureau of Business Solutions & Services.
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:
1. Meet with end users and technical staff to gather data requirements2. Perform intensive data analysis on source system data bases.  Analyze and understand source system         database, find required data, and profile the data.3. Review and create dimensional and normalized data models.4. Develop Oracle SQL and PL/SQL code, including packages, procedures, functions, views and complex analytical         queries.5. Develop complex ETL using Oracle PL/SQL and Informatica PowerCenter6. Diagnose, analyze, troubleshoot and choose appropriate solution to fix data related issues.
Required Skills and Experience
1. Required:  7+ years Oracle development experience that includes writing complex SQL and PL/SQL, and doing        performance tuning2. Required: 5+ years data warehouse development experience3. Required:  5+ years of data modeling experience 4. Required: 2+ years dimensional modeling experience5. Required: 3+ years experience using data integration/ETL software tool(s)6. Required:  Strong oral and written communication skills7. Desired:  2 years Informatica PowerCenter ETL development experience8. Desired: 2 years MS SQL Server and/or DB2 experience9. Desired:  1 year experience with Business Objects BI Tool suite or comparable BI tool suite


SkillRequired / DesiredAmountof ExperienceOracle development experience that includes writing complex SQL and PL/SQL, and doing performance tuningRequired7YearsData warehouse development experienceRequired5YearsReview and create dimensional and normalized data modelsRequired5YearsDimensional modeling experienceRequired2YearsExperience using data integration/ETL software tool(s)Required3YearsStrong oral and written communication skillsRequired  Informatica PowerCenter ETL development experienceDesired2YearsMS SQL Server and/or DB2 experienceRequired2YearsExperience with Business Objects BI Tool suite or comparable BI tool suiteDesired1Years