*Hi * * * * * - *Overall 7 years* of experience in the IT Industry with *Data Warehouse/DataMart design, ETL, System analysis, design, development, Reporting, SQL, PL/SQL Database programming.* - Extensive experience in using ETL utilizing Informatica * PowerMart/PowerCenter 8.6.1/7.1.4/6.2**(**SourceAnalyzer,TargetDesigner,RepositoryManager,Mapping/Mapplet/Transformations, Workflow Manager).** * - Strong business understanding in *Financial, Healthcare, manufacturing and insurance* sectors. - Expertise in implementing complex Business rules by creating robust mappings, mapplets, and reusable transformations using Informatica Power Center and Power Mart. - Working experience in using Informatica *Workflow Manager* to create and schedule *workflows and Worklets. * - Experience in using the *Informatica command line utility* to schedule and control *sessions and batches. * - Extensive Knowledge in architecture design of *Extract, Transform, Load * environment using Informatica Power Mart and Power Center. - Strong Knowledge of Data Warehouse Architecture and *Star Schema, Snow flake Schema, FACT* and *Dimensional Tables*. - Experience in identifying and resolving the *bottlenecks in Source, Target, Transformations, Mappings and Sessions for better performance.* - Worked on integrating data from heterogeneous sources like *Oracle ** 10g /9i/8i**, Tera Data, *
* SQL Server 200/2005/2008, flat files, VSAM files, COBOL and XML files*. - Comfortable of writing *UNIX shell scripts*. - Experience with *pre-session* and *post-session SQL commands* to drop indexes on the target before session runs, and then recreate them when the session completes. - Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions. - Very Good Exposure to the entire *Software Development Life Cycle* - Ability to work in different time shifts; cope up with a stressful environment - Excellent problem solving skills with a strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet tight deadlines and work under pressure. -- -- ------ -------- ( Please send resumes to nag...@d5inc.net Nagesh | D5 Tech Solutions Inc | nag...@d5inc.net | www.d5inc.net -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To post to this group, send email to sap-abap@googlegroups.com. To unsubscribe from this group, send email to sap-abap+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sap-abap?hl=en.