*Location:* Horsham, PA (near Philadelphia, PA)
*Role:* Sr. Informatica Developer – *PowerCenter Real Time Edition* Need GC/USC *Engagement:* 6 Month+ Assignment *Technical Skills (From Manager):* · ETL: Advanced Informatica: *MUST HAVE* *specific experience with PowerCenter Real Time Edition including Change Data Capture (CDC) from external data sources including mainframes with delivery to non-database targets such as a message queue or web service* · Database: Oracle (PL/SQL) · Shell Scripting · XML Schemas (a plus would be Acord Schema, the XML standard of choice) *Job Duties:* - Responsible for logical dimensional data model and use ETL skills to load the dimensional physical layer from various sources including SQL Server, Oracle, Flat file etc. - Leading Informatica onsite-offshore team, coordinating with various group to understanding requirements, test code, migrate code and involved in production support. - Worked on complete data warehouse development life cycle from requirement specifications to delivering the test product. - Involved in Testing, Debugging, Validation and Performance Tuning of ETL Architecture, help develop optimum solutions for Informatica deliverables. - Experience in writing SQL, PL/SQL codes, stored procedures and packages. - Used pmcmd to run workflows and Tidal to automate their schedules. - Extracted data from flat files, XML and oracle database to load them in the central oracle 11g database. - Successfully moved the Sessions and Batches from the development to production environment. - Developed complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy etc… - Create Slowly changing dimension type 1 and 2. - Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance. *Environment:* Informatica Power Center 9.1/8.6, Oracle 11g, SQL Server 2008 r2, PL/SQL, SQL*Plus, SQL*Loader, SQL Developer, Windows, Linux, Erwin 7.5, Tidal . Regards, Shivani Asthana Phone: 614-664-7661 Email: shiv...@technocraftsol.com Website: www.technocraftsol.com Yahoo ID: shivani.pheno...@yahoo.com <harshit...@ymail.com> Gtalk ID: shivani.pheno...@gmail.com <harshit...@ymail.com> Linked In: in.linkedin.com/pub/shivani-asthana/63/641/6a9 -- You received this message because you are subscribed to the Google Groups "SAP Resource Center" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-resource-center+unsubscr...@googlegroups.com. To post to this group, send email to sap-resource-center@googlegroups.com. Visit this group at http://groups.google.com/group/sap-resource-center. For more options, visit https://groups.google.com/d/optout.