Welcome to Simply Hired!

Like what you see here? Check out more Computer Occupations, All Other like this one.

Show Me More

Sr. DW Architect - Oracle and Informatica

Apply Now

Company: Hire IT People

Location: Harrisburg, PA

Date Posted: August 21, 2014

Source: Hire IT People, LLC

The position serves as a senior Oracle and Informatica architect for DW/BI solutions within the Bureau of Business Solutions & Services. The candidate will lead and provide architecture support for DW/BI projects and initiatives related to the expansion of the enterprise data warehouse and development of new BI applications. Responsibilities will include Informatica architecture support, leading the Informatica ETL development and troubleshooting, dimensional modeling, pl/sql development, Oracle performance tuning, and support for BI developers among other duties. Technologies leveraged include Oracle 10g/11g, PL/SQL, Informatica PowerCenter 9.5 and Business Objects XI.

Specific Duties:

1.Lead the full SDLC for DW/BI projects and initiatives, including business analysis, project leadership as well as technical design and development leadership.

2.Provide Informatica Architecture and Troubleshooting support

3.Perform data architecture duties, including leading OLAP and OLTP modeling efforts.

4.Lead Oracle and Informatica ETL development efforts.

5.Hands-on ...

The position serves as a senior Oracle and Informatica architect for DW/BI solutions within the Bureau of Business Solutions & Services. The candidate will lead and provide architecture support for DW/BI projects and initiatives related to the expansion of the enterprise data warehouse and development of new BI applications. Responsibilities will include Informatica architecture support, leading the Informatica ETL development and troubleshooting, dimensional modeling, pl/sql development, Oracle performance tuning, and support for BI developers among other duties. Technologies leveraged include Oracle 10g/11g, PL/SQL, Informatica PowerCenter 9.5 and Business Objects XI.

Specific Duties:

1.Lead the full SDLC for DW/BI projects and initiatives, including business analysis, project leadership as well as technical design and development leadership.

2.Provide Informatica Architecture and Troubleshooting support

3.Perform data architecture duties, including leading OLAP and OLTP modeling efforts.

4.Lead Oracle and Informatica ETL development efforts.

5.Hands-on DW development required, not only lead/architect duties.

6.Perform intensive data analysis on source system databases. Analyze and understand source system database, find required data, and profile the data.

7.Oracle Performance tuning and troubleshooting

8.Support BI development with Business Objects XI suite (including Crystal reports, WebI, Xcelsius).

Skills:

Overall Database experience.

Required 10 Years

Data Warehousing experience (with at least 3 years as Architect or Lead).

Required 5 Years

Oracle 9i,10g,11g experience (SQL, PL/SQL, Tuning, DDL, etc.).

Required 7 Years

Data Modeling experience.

Required 7 Years

Dimensional Modeling experience

Required 3 Years

Informatica Powercenter 8.x,9.x experience.

Required 3 Years

Data Warehouse Architect level experience.

Required

Experience leading a team of 4+ Developers.

Required

Excellent oral and written communication.

Required

Experience with Business Objects XI or similar BI tool.

Desired

DB2 and SQL Server experience.

Desired

Show more

Other jobs you might like

  • Senior Informatica ETL Developer

    NEW

    Domino Technologies

    - Harrisburg, PA

    Domino Technologies is seeking Senior Informatica ETL Developer. If you have the right experience and looking to increase your compensation in the technology job market, these...

    18 hours ago from Dice
  • Informatica Developer

    Technocentra

    - Danville, PA

    ONLY GC,EAD,US Citizens are accepted Participates in the development and maintenance of ETL processes that move data from operational systems to a Data Warehouse. uuml...

    4 days ago from Dice
  • Access/VBA Developer - MSPA AV73

    Cygnus Professionals

    - Harrisburg, PA

    Job Role: Access/VBA Developer Location: Harrisburg, PA Duration: 1 Year Position Type: Contract Interview Type: Webcam or In-Person Required Skills: Access Database (XP/2002 and...

    4 days ago from Tech Fetch
  • Data Warehousing Architect

    Professional Technology Integration

    - Harrisburg, PA

    Position: Data Warehousing Architect Ref 304598 Location: Harrisburg, PA 17103 Salary: $75 / hr Duration: 10+ Months Contract Description Data Warehousing DW Architect will be...

    30+ days ago from Jobs.ResumeSpider
  • Data Quality Assurance Specialist

    Professional Technology Integration

    - Harrisburg, PA

    Position: Data Quality Assurance Specialist Ref 316890 Location: Harrisburg, PA 17101 Salary: $30 /hr. Duration: 3+ Months - Contract The Data Quality Assurance Specialist will...

    30+ days ago from Jobs.ResumeSpider
  • MicroStrategy 9.x Developer

    Professional Technology Integration

    - Camp Hill, PA

    Position: MicroStrategy 9.x Developer (Ref: 15259) Location: Camp Hill, PA Salary: $90,000 /yr. Duration: Permanent, Full Time Position with Benefits Visa Status Accepted: US...

    30+ days ago from Jobs.ResumeSpider
  • ETL Developer

    Hire IT People

    - Pennsylvania

    Apply Now Engagement Type: Contract Location: King of Prussia, PA Duration: 6 Months Our client is embarking on a strategic project to build a next generation Business...

    6 days ago from Hire IT People, LLC
  • SQL Data Transformation Consultant

    Hire IT People

    - Harrisburg, PA

    The Department of Health, Bureau of Information Technology seeks a highly skilled resource in SQL Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) to...

    6 days ago from Hire IT People, LLC
  • PTC Voice/Data Engineer

    Hire IT People

    - Harrisburg, PA

    Preferred Education: 4 year college degree or equivalent technical study CCNP or equivalent technical knowledge Required Experience/Skills: Experience/Expertise in the following...

    6 days ago from Hire IT People, LLC
  • Sr. DW Architect - Oracle and Informatica

    Hire IT People

    - Harrisburg, PA

    The position serves as a senior Oracle and Informatica architect for DW/BI solutions within the Bureau of Business Solutions & Services. The candidate will lead and provide...

    6 days ago from Hire IT People, LLC

Show Me More

Were you satisfied with these results? Yes | No
Thank you for your feedback!