*Hi Please find below brief profiles of our ETL-Informatica consultants available for your contract projects nationwide. They are available on a C2C basis only. Please email me with the complete JD at k...@delightconsulting.com for complete resume and contact details.*
1) *Name :* SR *Location:* MI *Relocation: *Yes *Availability*: One week *Contact* # 248-680-6684 x 307 *Email:* k...@delightconsulting.com *EXPERIENCE SUMMARY* * * - *7+ years* of IT experience with a focus on *Banking, Telecom, Insurance and Health care* industries including designing, developing, implementing and *supporting Data Warehouses, data marts and data integration projects*. - Experience in interacting with business users to clarify requirements and translate the requirements into technical specifications. - Experience in Data Modeling & Data Analysis experience using Dimensional Data Modeling and Relational Data Modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling. - Expertise in developing standard and re-usable mappings using various transformations like expression aggregator, joiner, source qualifier, lookup and router. - Designed complex Mappings and have expertise in performance tuning and slowly-changing Dimension Tables and Fact tables. - Experience in PL/SQL Programming and in writing Stored Procedures, Functions etc - Involved in production support, resolving the production job failures, interacting with the operations support group for resuming the failed jobs. - Good team player, strong interpersonal and communication skills combined with self-motivation, initiative. *TECHNICAL SKILLS * *ETL Tools*** *Informatica 8.6/8.5/8.1.1/7.x/6.x/5.1 (Power Center), Power Exchange 8. X/ *(Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect) *Data Modeling*** Erwin 4.1/4.0,MS Visio, Star Schema Modeling, Snow Flake Modeling *Databases*** Oracle 11g/10g/9i/8i, Teradata, MS SQL Server 2000/2005, DB2 *Languages*** SQL, PL/SQL, Unix Shell Script, Cobol, Visual Basic *Tools* Toad, SQL* Plus, Teradata SQL Assistant *Operating Systems*** UNIX, Linux, MS Windows 2000/98/95/XP, *Data Sources* VSAM, COBOL Sequential and XML Files * 2) Name: DGK* *Location*: NY *Relocation:* Yes *Availability: *One week *Contact:* 248-680-6684 x 307 *Email: *...@delightconsulting.com *PROFESSIONAL SUMMARY* 7 years of IT experience in *Analysis, Design, Development, Maintenance and Documentation *for Data warehouse and related applications using ETL, BI tools, Client/Server and Web applications on UNIX and Windows platforms. Experience working in manufacturing, healthcare, finance, telecommunication and insurance sector. · Expert level experience in implementing advanced *ETL methodologies* for corporate wide – ETL solution using *Informatica Power Center* 8.6/7.x/6.x.* * · Data modeling knowledge of Ralph Kimball’s *Dimensional Data Modeling *using *Star Schema *and *Snow-Flake Schema.*** · Experience in user interaction to gather and analyze the project requirement. ** · Strong expertise* in design, development and integration of complex ETL processes.* · Experience with databases like *Oracle, SQL Server, Teradata* and *MS Access 2000* and excellent in writing, testing and implementation of * triggers*, *stored procedures*, *functions*, *packages, **dimensional loading* of tickets using *PL/SQL.*** · Strong Experience in designing and developing *complex mappings *using various transformations for implementing advanced ETL techniques such as *slowly changing dimension*, *change data capture and incremental loading*.** · Expertise in defining *Workflows and Tasks, Monitoring Sessions, load scheduling* and *automation* of Informatica workflows using *shell scripting *.** · Experience in *performance tuning *of ETL Mappings involving ETL Sources, Targets, Transformations, stored procedure and Sessions.** · Experience in upgrading Informatica Repository, making related changes to existing models, mappings to resolve upgrade issues and also responsible for Informatica server administration. · Expertise in working on the *releases*, providing *production*, * technical* and *onsite* release support.** · Excellent analytical, problem solving and communication skills, with ability to interact with individuals at all levels.** * * *TECHNICAL SKILLS* *ETL Tools: *Informatica Power Center 8.x/7.x/6.x, Informatica Power Mart 5.0, Data Stage, Informatica Power Connect, Informatica Power Exchange. *Databases:* Oracle 11g/10g/9i, MS SQL Server 2008/2005, My Sql, DB2. *Reporting Tools:* Business Objects 6.0/5.1/4.1, Cognos 8.0, BI. *Data Modeling:* Erwin 3.5/4.0, UML *Data Modeling Methodologies:* Logical/Physical/Dimensional, Star/Snowflake, ETL, OLAP, Complete Software Development Life Cycle. *Scripting:* UNIX Shell, Perl Scripts. *Programming Languages:* SQL, PL/SQL, C, C++, C#, Java 2.0 and Visual Basic *Operating Systems:* UNIX, Sun Solaris 8, Open Solaris, MS Windows 2000/NT/XP/VISTA/7. *Other Tools:* TOAD, VISIO, SQL * PLUS, SQL * PLUS Loader. -- Regards Santosh Delight Consulting Services LLC. 2565 S. Rochester Road, Suite# 107A, Rochester, MI 48307. Phone: 248-680-6684 ext 307 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.