Wednesday, March 2, 2011

~~ Technical Recruiters Network ~~ ** Sr. ETL Informatica Developer Experience with Informatica PowerCenter 8.1/8.6, WebFocus, Maestro,Oracle 10g,SQL Server 2000,COBOL Files,AS/400, DB2, SQL, PL/SQL (Stored Procedure, Trigger, Packages),Toad, Erwin, MS Visio, Business Objects- Available Immediately.

Dear Partner:  
 

We have  Prashanthi an excellent Sr. ETL Informatica Developer. She has 7 years of experience in IT.  She is available immediately for a new project on contract basis only.  She is willing to relocate anywhere in USA.

 

PROFESSIONAL SUMMARY:

·         7 years of IT experience includes Analysis, Design, Development and Maintenance of various software applications in client-server environment.

·         Six plus (6+) Years of strong Data Warehousing ETL experience of using Informatica Power Center 8.6/8.5/8.1/7.1 Informatica Power Mart, Power Connect, Power Analyzer.

·         Strong experience using Business Objects with expertise in data cleansing, matching, reporting and data quality monitoring.

·         Worked extensively with Dimensional modeling, Data migration, ETL Processes for Data Warehouses.

·         Experience in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources systems into data warehouse using Informatica Power Center.

·         Expert in ETL process using Informatica Power Center Designer (8.6.1), Workflow manager, Workflow monitor, Informatica server and Repository Manager.

·         Strong Experience and knowledge in creating Stored Procedure and Trigger using Oracle 10g/9i.

·         Widely used Informatica designer tools – Source Analyzer, Transformation Developer, Mapplet designer and Mapping designer.

·         Strong in Source to Target data Mapping and CDC (Change Data Capture) using   Slowly Changing Dimension Mapping, incremental aggregation etc..

·         Highly Skilled with the Integration of various data sources like Oracle 10g, DB2, SQL Server, Flat Files, Teradata, XML and IBM Mainframe COBOL files.

·         Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.

·         Strong experience in writing UNIX Shell scripts, SQL Scripts for Development, Automation of ETL process, error handling and reporting purposes

·         Good experience in dealing with complex dimensions like customer Dimension with slowly changing dimension type2 (scd type2) for updating and inserting new rows.

·         Worked Experience in Getting the data from Mainframe and AS/400 System

·         Strong experience in Data warehousing concepts, Star Schema and Snowflakes Schema methodologies used in relational, dimensional modeling and multidimensional modeling, Data Profiling and Data cleansing.

·         Actively involved in Performance Tuning, Error handling, Product support on various Platforms.

·         Worked in Development, Production and Maintenance Support Projects

·         Skilled in Unit Test, System Integration Test.

·         Excellent analytical and problem solving skills.

·         An efficient Team Leader and a Team Player. Efficient in Task assignment and mentoring the team members.

 

TECHNICAL SKILLS:

ETL Tools

Informatica PowerCenter  8.6/7.1/6X

Business intelligence

Crystal reports 8,OBIEE,Business Objects

Databases

Oracle 10g/9i/8i, SQL, SQL*Plus, SQL*Loader, Oracle10g/9i/8i, IBM DB2 UDB 8.1/7.0, MS SQL Server 2000/2005,Teradata, Sybase, MS Access 7.0/2000.

Data Modeling

Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 3/ 4

Tools

Toad, PL/SQL developer, Dbvisualizer, Microsoft Visio, Autosys, Tivoli Work Scheduler.

Languages

SQL, PL/SQL, UNIX Shell Scripting,perl, C, Visual Basic, XML.

Operating Systems

Windows NT/2000/2003, UNIX(AIX, Sun Solaris)

Protocols

HTTP, TCP/IP

 
Rate: Open                                 Available : Immediately
 

Relocation: Open                        Current Location: Columbus, OH

 

E-Mail Link:mailto:radhika@1stobject.com?Subject=Resume_of_Prashanthi

 

Rate would not be a constraint in getting a project for this candidate and would be depending upon duration and location of the project.   Please get back to me if you need his complete resume, rate and contact info.

 

Feel free to contact me for additional information.

 

Thanks

 

Radhika

First Object, Inc

1750 N Collins Blvd

Suite # 216

Richardson, TX-75080

972 699 1818 x 102

 

 
eMailed To: tech_recruiters@googlegroups.com

No comments:

Post a Comment