Oracle Developer with PL/SQL

AskITConsulting

Harrisburg, PA, United States contract

Posted: July 21, 2015

Quick Summary

We are seeking a skilled Sr. Data Warehouse Developer/PL/SQL with expertise in Oracle PL/SQL programming language and experience with data warehousing and business intelligence. The ideal candidate will have a strong background in Oracle PL/SQL and experience with data warehousing and business intelligence. The successful candidate will be responsible for developing and maintaining complex data warehouse systems, as well as creating reports and dashboards to support business decision-making.

Required Skills

Job Description

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. ASK IT consulting is an equal opportunity employer, which is a global staffing, consulting and technology solutions company, offering industry-specific solutions to fortune 500 clients and worldwide corporations.

Position Description:

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

1. Required: 7+ years Oracle development experience that includes writing complex SQL and PL/SQL, and doing performance tuning

2. Required: 5+ years data warehouse development experience

3. Required: 5+ years of data modeling experience

4. Required: 2+ years dimensional modeling experience

5. Required: 3+ years experience using data integration/ETL software tool(s)

6. Required: Strong oral and written communication skills

7. Desired: 2 years Informatica PowerCenter ETL development experience

8. Desired: 2 years MS SQL Server and/or DB2 experience

9. 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

For immediate consideration send emails to vpsingh @ askitc.com

Why Apply Through MisuJob?

AI-Powered Job Matching: MisuJob uses advanced artificial intelligence to analyze your skills, experience, and career goals. Our matching algorithm compares your profile against thousands of job requirements to find positions where you have the highest chance of success. This saves you hours of manual job searching and ensures you only see relevant opportunities.

One-Click Applications: Once you create your profile, applying to jobs is effortless. Your resume and cover letter are automatically tailored to highlight the most relevant experience for each position. You can apply to multiple jobs in minutes, not hours.

Career Intelligence: Beyond job matching, MisuJob provides valuable career insights. See how your skills compare to market demands, identify skill gaps to address, and understand salary benchmarks for your experience level. Make data-driven decisions about your career path.

Frequently Asked Questions

How do I apply for this position?

Click the "Register to Apply" button above to create a free MisuJob account. Once registered, you can apply with one click and track your application status in your dashboard.

Is MisuJob free for job seekers?

Yes, MisuJob is completely free for job seekers. Create your profile, get matched with jobs, and apply without any cost. We help you find your dream job without any hidden fees.

How does AI matching work?

Our AI analyzes your resume, skills, and experience to understand your professional profile. It then compares this against job requirements using natural language processing to calculate a match percentage. Higher matches mean better fit for the role.

Can I apply to jobs in other countries?

Absolutely. MisuJob features jobs from companies worldwide, including remote positions. Filter by location or look for remote opportunities to find jobs that match your preferences.

Ready to Apply?

Join thousands of job seekers using MisuJob's AI to find and apply to their dream jobs automatically.

Interested in this position?