* ETL/Informatica Developer Available Immediately* **
*REQUEST**: **please take a minute and add **[email protected] ** in your mailing list for current and future requisitions.*** * Please scroll down to know for other available consultant Technologies.* *Consultant* *Skills* *Exp* *Location* *Availability* Rohith * ETL* 7+ Years TX Immediately *Summary* · *7+ years of experience* in IT industry having extensively involved in analysis and design, testing, implementation, maintenance, production support and knowledge transfer. · 6+ Years of strong Data Warehousing ETL experience of using Informatica Power Center 8.6/8.5/8.1/7.1/7.0/6.2 Informatica Power Mart 6.2/5.1.2/5.0/4.7(Source Analyzer, Repository Manager, Data warehousing designer, Mapping Designer, Mapplets, Transformations, Workflow Manager, Task Manager), Power Connect, Power Analyzer, Power Exchange MS SQL Server 2005 Analysis Services, IDQ(Informatica Data Quality), IDE(Informatica Data Explorer), Informatica Real time Suite, Metadata Manager, OLAP,OLTP, Autosys 4.5, Control M,TWS(Tivoli Workload Scheduler), Maestro, OLAP, OLTP, MOLAP, ROLAP, ETL, ETI, Data marts, Data mining. · Over 5+ years of Database experience using *Oracle 11g/10g/9i/8i, DB2 UDB 8.0/7.0,Sybase, Teradata, MS Access 7.0/2000, PL/SQL, SQL Plus, SQL Server*. Strong Experience on database interfaces like PL/SQL Developer, SQL Plus and TOAD. · Experience in complete *Software Development Life cycle* (SDLC) including Requirement, Analysis, estimations, Design, Construction, Unit and System Testing and implementation. · Experience in Transforming the Sales Force data according to the business logic. · Extensive knowledge of *Data Modeling**, Data Conversions, Data integration and Data Migration* with specialization in Informatica Power Center. · Expert on *Slowly Changing Dimensions* Type 1, Type 2 and Type 3 for inserting and updating Target tables for maintaining the history. · Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files. · Experience with Data Extraction, Transformation and Loading from different data sources like *DB2, Oracle ,MS SQL Server, Teradata* etc. into a common analytical data model using Informatica , Power Center 6x/7x/8.1/8.5/8.6. · Extensive experience in designing and developing complex mappings from varied transformation logic like *Unconnected and Connected lookups, Normalizer, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy*. · Implemented data warehousing methodologies for Extraction, Transformation and Loading using *Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console *. · Experience in working with *UNIX Shell Scripts* for automatically running sessions, aborting sessions and creating parameter files. Written number of shell scripts to run various batch jobs. · Demonstrated expertise utilizing ETL tools, including* SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and Data Stage* and *ETL package design*, and RDBM systems like SQL Servers. · Experience on *Debugger* to validate the mappings and gain troubleshooting information about data and error conditions. · Experience on *post-session and pre-session shell scripts* for tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc. *Technical Skills:* * * Data Warehousing ETL Informatica PowerCenter 8.6x/8x/7.x/6.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) ETL, Datastage ,Repository, Metadata, DataMart, FACT & Dimensions tables. Data Modeling Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams Databases Oracle 10g/9i/8.0, MySQL 5.4, DB2,OLTP Programming SQL, PL/SQL, SQL*Loader, Unix, Shell Scripting, C, Java, HTML, Perl, PHP, JavaScript Tools TOAD, SQL*Plus, Dream weaver Environment UNIX, Windows XP/Vista, Linux Regards, Ritesh Doddle SVK Systems, Inc |Microsoft & Oracle Certified Partner Direct : 205-538-2350, Alt : 205-510-7424 x 530 Email:-*[email protected]* 11465, Johns Creek Parkway, Suite #180 Johns Creek,Georgia, 30097 *The King will reply, “I tell you the truth, whatever you did for one of the least of these brothers of mine, you did for me.”* *Matthew 25:37-40* -- You received this message because you are subscribed to the Google Groups "KNOW.IT" 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/know_it_az?hl=en.
