I’m sourcing* "**Senior data warehouse developer**"* for one of my precious client in *"**Harrisberg PA**" *please share me the matching profiles to *shash...@softsages.com <sh...@softsages.com>* or call me at *484-772-8256,*
Position ID - PennDOT- Programmer 4-PL-SQL/DW (418549) *CAI MANAGER* – SCOTT EDWARDS *NEED INPERSON* RATES – 50-54$/hr *Short Description:* The position serves as a senior data warehouse developer in PennDOT’s Bureau of Business Solutions & Services. *Complete Description:* 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 requirements 2. 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 PowerCenter 6. 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* Oracle development experience that includes writing complex SQL and PL/SQL, and doing performance tuning Required 7 Data warehouse development experience Required 5 Review and create dimensional and normalized data models Required 5 Dimensional modeling experience Required 2 Experience using data integration/ETL software tool(s) Required 3 Strong oral and written communication skills Required Informatica PowerCenter ETL development experience Desired 2 MS SQL Server and/or DB2 experience Required 2 Experience with Business Objects BI Tool suite or comparable BI tool suite Desired 1 *Thanks & Regards* *Shashank Dubey* (Technical Recruiter) *Direct:-** 484-772-8256, **Desk:-** 484 402 7869 x 105 ,* *Softsages Technology, www.softsages.com <http://www.softsages.com/>**,* 17-Mystic Ln, Malvern, PA 19355 *G-talk: *shash...@softsages.com -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to citrix-and-sap-problems+unsubscr...@googlegroups.com. To post to this group, send email to citrix-and-sap-problems@googlegroups.com. Visit this group at http://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.