Pages

Monday, November 28, 2011

(ETL/Informatica Developer)Available Consultant from 4CONSULTING, INC.

Send Resume to narendra@4ci-usa.com

Hi,

Please find Vipin`s profile for and let me know if he is suitable for your position.

 

CURRENT JOB TITLE

Sr. ETL/Informatica Developer

FULL NAME

Vipin Kata

CURRENT LOCATION

Camp Hill, PA

LEGAL STATUS

H1B

YEARS OF EXPERIANCE

 8

EXPECTED HOURLY RATE

60/HR.

 

 

PROFESSIONAL SUMMARY

 

·         8+years of professional IT experience in System analysis, design, development, Data Warehouse/Data Mart design, RDBMS and implementation of client server applications.

·         6 +yrs of technical hands-on experience in development of Data warehousing solutions using

·         Informatica Power Center 8.x/7.x /6.x /5.x, Power Exchange Navigator 8.1.1, and Power Mart 7.1.1 /6.2 / 5.x.

·         Experience in report tools like Business Objects, Cognos .

·         Good understanding of SDLC process.

·         Knowledge of full life cycle development in Data warehousing projects with data analysis, data extraction, cleaning and loading.

·         Excellent understanding and knowledge in sql server tools like SSIS,SSRS.

·         Good experience in extracting data from Oracle, DB2, Sybase, SQLSERVER, Salesforce, SAP R/3

·         and Siebel sources.

·         Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP, Cubes and normalizations.

·         Experience in creating database Stored Procedures, Triggers and Indexes. 

·         Worked as Informatica Production support member.

·         Experience in different Software development methodologies like Waterfall Model and Agile Software Development process.

·         Strong knowledge in OLAP Systems, Kimball and Inmon methodology and models, Dimensional modeling using Star schema and Snowflake schema.

·         Worked on databases Oracle 11g/10g, Teradata V2R6.2, SQL Server 2000/2005, DB2.

·         Extensive experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center Tools (Repository Manager, Designer, Workflow manager, Workflow Monitor and Informatica Administrator Console).

·         Experience in integration of various data sources like Oracle, Teradata, SQL Server, IBM MQ-Series, Flat Files, XML files, Cobol files, Legacy Systems (Mainframe, AS400) into the data warehouse.

·         Implemented Performance Tuning at various levels such as Source, Target, Mapping, Session and Partitioning.

·         Extensively used SQL, Transact SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.

·         Good experience working with Informatica, Teradata utilities like MultiLoads, Fast load as well other Data warehousing components.

·         Performed Backend Testing manually on UNIX using SQL queries.

·         Experience in database administration activities like installation and creation of database, database objects, backup & recovery.

·         Excellent knowledge and experience in Technical Design and Documentation.

·         Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.

·         Expertise in developing and maintaining overall Test Methodology and Strategy, Documenting Test Plans, Test Cases and editing, executing Test Cases and Test Scripts.

·         Performed data validation by Unit Testing, System Testing, Integration Testing and Regression Testing.

·         Strong data modeling experience with ERWIN 7.3/4.0/3.5.2 and UML.

·         Experience in PERL and UNIX Shell Scripting (Korn & Bourne) on UNIX & Linux platform.

·         Excellent experience in using Power Exchange to Change Data Capture (CDC).

·         Good knowledge and understanding of Scheduling tool Autosys, ESP, and Apwrox.

·         Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.

 

Kind Rgds

Narendra Singh

 

 

4CONSULTING, INC.

IT consulting | staffIng | bpo

 

 

Walnut Abrams Plaza

1221 Abrams Road

Suite 326

Richardson, Texas 75081-5589

 

(214) 295-7386

(214) 698 8630 F

narendra@4ci-usa.com

www.4ci-usa.com

 

TEXAS I CALIFORNIA I FLORIDA I DELAWARE I MARYLAND I MICHIGAN I ATLANTA

Confidentiality Note: The information in this email is confidential and may be legally privileged. Access to this email by anyone other than the intended addressee is unauthorized. If you are not the intended recipient of this message, any review, disclosure, copying, distribution, retention, or any action taken or committed to be taken in reliance on it is prohibited and may be unlawful. If you are not the intended recipient, please reply to or forward a copy of this message to the sender and delete the message, any attachments, and any copies thereof from your

system. If you wish to be removed from the supplier list please reply to 4ci@4ci-usa.com with REMOVE in the subject line.

--
You received this message because you are subscribed to the Google Groups "Frontier Knowledge Group" group.
To post to this group, send email to frontier-knowledge-group@googlegroups.com.
To unsubscribe from this group, send email to frontier-knowledge-group+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/frontier-knowledge-group?hl=en.

No comments:

Post a Comment