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.
*Environment*
UNIX, Windows XP, Oracle 10g, Informatica Power Center 8.5, Toad, $U,
Business 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
-~----------~----~----~----~------~----~------~--~---
