Note: This email is not intended to be a solicitation. Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list.
*Excellent Senior ETL Developer/ ETL Architect with 9+ Yrs of Experience is available immediate. Please respond with requirements to ** [email protected] / **916-646-2080 x 212* *Consultant Name: Prabhakar * *Status: Available Immediate * *Skill Set: Informatica Developer * *Status: Own H1 * *Consultant Contact Cell: 916 646 2080 x 212* *Current Location: San Jose, CA* *Preferred Location: Open * *Availability: Immediate* * * - Around* 9+* years of *IT experience* with 8+ years in *Data Warehousing * in analysis, design, development of software applications. - Expertise in Data warehousing solutions using *Informatica Power Center, Power Mart*, building Data Marts and data warehouse. - Having hands on experience in migrating the Informatica Repository from Vs 7.1.3 to Vs 8.5. - Possess complete domain and development Life Cycle knowledge of *Data Warehousing*. - Currently Working on *ETL* tool *Informatica *Vs* 8.5* - Solid experience in Informatica Power Center (versions 8.5/8.1.2/ 7.1.5/ 6.2/ 6.1/ 6.0) including Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Admin console. - Possess around 2+ years of *Senior ETL Developer* experience. - Optimizing the SQL to improve performance. - Involved in tuning the Oracle table scripts and queries by using Indexing techniques, Hints and Parallel execution process. - Optimizing Informatica Mappings and Sessions to improve the performance. - Experience in *performance tuning* of sources, transformations, targets, mappings*,* worklets, workflows, and sessions. - Extensively worked on Session partitioning techniques using different * Informatica* *Partitioning* techniques to optimize the load times. - Involved in the estimation for time it takes to complete the tasks and distributing the work to the Team members and assigning the peer reviewers for the developed work. - Proven Experience in Complete life cycle of Design, Development, Documentation and Maintenance of the Datamarts and Datawarehouse. - Strong knowledge in Dimensional Data Modeling Technique, E-R modeling, Multi Dimensional Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables), and handling SCD's. - Strong experience with UNIX Shell Scripting, SQL, PL/SQL Coding. - Proficient in using Informatica workflow manager, workflow monitor, server manager*, PMCMD* (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.* * - Having hands-on Banking, Finance, Insurance and Health Care domain knowledge. - Working knowledge with large number of development tools. - Have also worked in an Onsite – Offshore model have carried out the different phases of the projects effectively by excellent co-ordination activities. - Excellent problem solving skills with strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure. Technical Skills * * *ETL Tools :* *Informatica 8.5/8.1.2/ 7.1/ 6.2/ 6.1/ 6.* *OLAP Tools : *Business Objects *Programming Skills : *SQL, PL/SQL, UNIX Shell Programming *DB Tools : *ORACLE 8/8i/9i/10g *Version control Tools : *VSS and Wincvs *Operating Systems : *MS-DOS, WINDOWS 2000, Windows NT, UNIX, Linux *Scheduling Tools : *Redwood Chronacle and Maestro job scheduler *Loading Utilities* *:* Toad, PL/SQL Developer *Education* · *Master of Computer Science(M.Sc)* *Professional Experience* * * *Cisco Systems Inc, San Jose, CA Mar 2008 to Till Date* *ASBI (**Advanced Services Business Intelligence)** (Synergy BI)* *Senior ETL Developer/** ETL Architect* Advanced Service BI team is restructuring the Data Mart based on the Source System changes with respect to the Oracle Projects, which merged the sources for Account 4 and Advanced Services Account Portal and the corresponding Data Marts are merged into one OP data mart. The Functional Hierarchy (Theater-Area-Operation-Region-Department Geographical restructring) was separated out from the old Project and Resource Dimension tables. Likewise, the newly introduced Financial Hierarchy to enable the financial reporting for the Projects and the Resource metrics . * * *Responsibilities * - Designed the *Mapping Technical Specifications* on the basis of Functional Requirements. - Deployed Informatica Objects from TCA to TCB and TCC. - Created ETL mappings using *Informatica** Power Center* to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts. - Created reusable *mapplets* and *transformations* starting concurrent batch process in server and performed backup, recovery and tuning of sessions. - Used *Workflow Manager* for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time. - Tested the Informatica mappings with *manual testing* and assisted QA team. · Performed Code and Technical Review with team members. - Created logical dimensional STAR, SNOWFLAKE schemas (Kimball),Entity Relationships diagrams, Normalization, physical schemas. - Involved in writing *UNIX Shell scripts to run informatica workflows*. - Administer the repository by creating *folders and logins for the group members and assigning necessary privileges.* - Extensively used Informatica client tools – *Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager*. - The Objective is to extract data stored in different databases such *as Oracle 9i, SQL server, Flat files and to load data into staging tables*first and then into Oracle. - Developed different mappings by using different Transformations like *Aggregator, Lookup, Expression, update Strategy, Joiner, Router *etc to load the data into staging tables and then to target. *Aggregator, Lookup, Expression, update Strategy, Joiner, Router, processes, test cases, and error control routines* Sequence generator etc transformations in the mappings. - Involved in *performance tuning* by optimizing the sources, targets, mappings and sessions. - Monitored transformation processes using Informatica Workflow monitor. - Used SQL tools like *TOAD to run SQL* queries and validate the data loaded into the target tables. - Used Oracle *Stored Procedures, Functions, and Packages.* - *Prepared test scripts and Unit test the mappings* and checked for data validation and data integration. - Responsible for raising the Migration requests and cross checking the migrated code in Production with read only access to confirm the successful migration of all objects. ------------------------------------------------------------------- Regards, John || Phone: 916 646 2080 Ext 212 || Fax: 916 646 2081 || Email: [email protected] || Website: www.key-soft.com || Note: This email is not intended to be a solicitation. Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "jobinusa" 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/jobinusa?hl=en -~----------~----~----~----~------~----~------~--~---
