*Hi, **Please find brief profile of our excellent* *Sr. ETL Informatica Consultant for your requirements.*
*Please e**mail me your requirements at k...@delightconsulting.com<kris...@dconinc.com> * *or call me @ 248-875-2277* *Name: SG * *Location: NJ* *Relocation: Open* *Availability: Immediate Communication Skills: 10/10.* *PROFESSIONAL SUMMARY**:* * * · Over 8.5 years of experience in analysis, design, development, design and development of enterprise level data warehouses using Informatica. Knowledgeable and experienced on current data warehousing concepts and methodologies. Experience in complete Software Development Life Cycle (SDLC) (Requirement Analysis, Design, Development and Testing). · Extensive use of SQL for database development on MS SQL Server, Oracle, Teradata, DB2, and Netezza. Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Flat files (Fixed width & Delimited), COBOL files, VSAM, IBM DB2, Excel, Oracle, MS SQL Server, Teradata and Netezza. · Experienced in loader utilities including SQL Loader, Fast Load and MultiLoad. Good knowledge in data migration from Oracle to Teradata RDBMS. Experienced in PL/SQL scripts and extensively used bulk load concept. Experienced in UNIX shell scripting and VI Editor Usage. · Ability to document warehousing designs and clearly communicate alternatives to the client and business. Designed complex Mappings and have expertise in performance tuning and experience working on slowly-changing Dimension Tables and Fact tables. · Knowledge of different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements. Understands Data Warehouse Change Data Capture (CDC) processing and challenges. Experienced in data modeling both in 3rd normal form and dimensional techniques. · Expertise in UNIX shell scripting and automation of ETL processes using IBM Tivoli (Maestro). Experience in PL/SQL Programming and in writing Stored Procedures, Functions etc. - Knowledge of Informatica Pushdown Optimization. Experience in Business analysis in developing plans and processes to accurately solicit and capture project requirements and goals. Designed the Informatica Mapping Technical specification on the basis of Functional Requirements. · Experience in working closely with the project management to ensure timely delivery of solutions and learning business concepts quickly and relate them to specific project needs. · Designed, developed and implemented data warehouse applications utilizing Informatica power center and Teradata BTEQs. · Worked as a Data modeler in creating and logical and physical database design. Involved in reviewing changes to data model and analysis of enterprise data model. *TECHNICAL SKILLS:* UNIX, MS Windows 2000/98/95/XP, MVS OS/390/AS400, SQL, PL/SQL, BTEQ, COBOL, Shell, PERL, Oracle, DB2, Teradata, Netezza, MS SQL Server, Informatica Power Center 8.X/7.X/Power Exchange 8. X/Workflow Manager/Workflow, Monitor/Repository, Manager, SAS, MicroStrategy, Cognos, Visio, ERWIN, Mercury Quality Center. IBM Clear Quest, CDC, Data, Modeling (Dimensional, 3rd normal form), MS Office, FTP, NDM (Network Data Mover),** VSAM, COBOL Sequential and XML Files -- Regards Santosh Delight Consulting Services LLC. 2565 S. Rochester Road, Suite# 107A, Rochester, MI 48307. Phone: 248-680-6684 ext 307 Cell: 248-875-2277 Fax: 248-498-6195 Email:k...@delightconsulting.com <email%3a...@delightconsulting.com> kakulasr.deligh...@gmail.com Note: We respect your Online Privacy. This is not an unsolicited mail. Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a "remove" in the subject line and mention all the e-mail addresses to be removed with any e-mail addresses which might be diverting the e-mails to you. -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To post to this group, send email to sap-ba...@googlegroups.com. To unsubscribe from this group, send email to sap-basis+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sap-basis?hl=en.