Hello Friends, * Please submit matching Resume and Contact Number. * * Locals to Chicago area only please. * *
* * Start date: within 2 days * * Duration: 6 months plus * * Location: Chicago * *Job Title: *Informatica ETL Developer *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 Regards, Sanjay Kumar COMNet Group Inc. Phone: 847-458-8281 Email: [email protected] http://www.comnetgroup.com -- Introduce business in 3800 cities. How? ===================================================== Thanks for using group. Moderator 1) This group is managed by www.BRCIndex.blogspot.com 2) Post your message with your linkedin Profile (Visit linkedin.com) to confirm your identity and refer business. 3) Visit www.BRCIndex.blogspot.com (3800 Business Referral Club) 4) Reply to two message before posting new one. 5) Donot post same message in all 3800 business Referral Club. You received this message because you are subscribed to the Google Groups "Outsource" 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/Outsource To unsubscribe, reply using "remove me" as the subject.
