Hello, We are looking for a suitable consultant for the following requirement, kindly go through it and please send your replies with qualified matching resume, contact details, current location, visa status, ASAP.
Title :- Informatica ETL Developer Duration :- State:- Chicago IL Job Description: • Worked closely with business analysts to understand business needs and requirements for DNC and RingBack tone project and designing ETL processes using Informatica Power Center. • Created mappings using Informatica for extracting data from sources like Flat Files, Oracle, SQL Server and DB2 loading them into CIS Data Mart on DB2 (UDB) using various transformations (Source Qualifier, Aggregators, Filters, Router, Joiners, Sequence, Lookups, Update Strategy) to build Business rules. • Point of contact for the DNC project and Coordinate betweens different teams. Created Technical ETL document from functional requirements. • Created mappings using various transformations like Sequence Generator, Lookup, Joiner, Source qualifier etc. in Informatica Designer. • Created Mapplets and resuable used them in different mappings. o Developed ETL constructs to send Third-Party Subscriptions(TPS) Data from the CARES source system to Enterprise Data Hub(Inbox) and implemented business rules to transform the EDH data to Outbox(Outperform) in the form of Flat files to the Vendor Synygy . o Extensively used Post Session, Pre session, Decision and Event tasks as part of SDF methodology using informatica for Data Loading. • Wrote PL/SQL stored procedures as needed. • Developed various sessions, batches containing parameters files, indicator files and multiple sources files. • Optimized query performance, session performance. • Used Unix Shell scripts using automate the process of running jobs/ batches. • Coordinate tasks between different groups. • Created a production migration work plan. Coordinate tasks between different groups. • Extensively used Post Session, Pre session, Decision and Event tasks as part of SDF methodology using informatica for Data Loading. • Maintained the design and release documents and their versioning using Clear Quest and Clear case for the Configuration Management. Job Req: Informatica (most important) Unix shell scripting (most important) Perl Strong SQL in Oracle Thanks & Regards, Tapan Moore JIVA InfoTech Inc. Contact Number - 732-579-8165 Fax Number - 732-653-0291 Email: - [email protected] -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sap-basis?hl=en.
