Ask IT consulting
Direct SmartRecruiters career site

Oracle Developer with PL/SQL

Location
Harrisburg, PA
Listed
Yesterday
Free · No account needed

How well does your resume fit this job?

Upload your resume to see your score for this Ask IT consulting role, what matches, what's missing, and your best other matches.

Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.

Position

  • Sr. Data Warehouse Developer/ PL/SQL Database Developer
  • Location: Harrisburg PA
  • Duration: 2+ 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
  • Skill Required / Desired Amount Candidate exp last used
  • 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

About the Company

Ask IT Consulting Inc, backed by a $500 million Microtek group company, provides an industry leading blend of technology, business consulting, and outsourcing services. Ask IT is a minority-owned enterprise; it has been founded on providing the highest quality possible and on the devotion to customer satisfaction.

Additional Information: For immediate consideration send emails to vpsingh @ askitc.com

Read the original posting

From Ask IT consulting's careers page, first listed on Rolev.ai on November 20, 2026. Rolev.ai is not the employer.

How Rolev.ai helps with this application

Rolev.ai is a job search and application tool for US job seekers. For this Oracle Developer with PL/SQL role at Ask IT consulting, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.

  • See how you fit

    Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.

  • Tailor without inventing

    Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.

  • Draft the full kit

    Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.

  • 1-Click Extension Autofill

    The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.

Common questions

Where is the Oracle Developer with PL/SQL job at Ask IT consulting located?

This Oracle Developer with PL/SQL position at Ask IT consulting is located in Harrisburg, PA. Always check Ask IT consulting's application page for specific state eligibility or relocation policies.

How do I apply for the Oracle Developer with PL/SQL position at Ask IT consulting?

This listing links directly to Ask IT consulting's SmartRecruiters application page. You can apply directly on Ask IT consulting's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.