Ravi Kumar V.

WORK HISTORY

EDUCATION

ABOUT RAVI KUMAR V.

15+ Years of Informatica development experience including Mappings, Mapplets, Transformations, Shortcuts, Workflow, Worklets, Sessions/Tasks Reusable components. • Presently working on Informatica Big Data Management to load the data. • Key strengths are a detailed understanding of Data Warehousing ETL Techniques, Dimensional Data Modeling techniques, Excellent knowledge on Informatica 8.x/9.x B2B DX, B2B DT,Metadata Manager,Talend,Data Stage,SSIS, Oracle 10g/11g,Teradata SQL SERVER,Greenplum,Vertica Effective use of UNIX Shell Script/Batch scripts in ETL Operations. • Data extraction/loading from Data Sources like XML Files, Oracle/DB2/Sybase/SQLServer Tables, Flat Files, SAP R/3 and SFDC sources/targets. • Exposure on Informatica B2B DX (Data Exchange), B2B DT (Data Studio). • Working knowledge on Informatica Metadata manager Service • Advanced Informatica - Performance Tuning, Partitioning, Pushdown Optimization. • Data Staging and Cleansing using business rules and/or transformational rules validation. • Loading Facts & Dimension Tables, Handling slowly changing dimensions. • Dimensional Modeling (Star/Snowflake Schema) & Data warehouse architecture • Working Knowledge on Teradata utilities(BTEQ, MLOAD, FASTLOAD, TPUMP). • Development of database objects such as Procedures, Functions, Packages, Triggers, Synonyms, Views, Indexes, Constraints and tables. • Strong work experience in UNIX Shell Scripting (bash/ksh) for job automation/data cleansing/text processing. • Good understanding of job scheduling through Informatica, or by using Shell Scripts and Cron/Control-M/ESP. • Excellent communication, presentation, project management skills and a very good team player and self-starter with the ability to work independently and as part of a team. • Direct customer-facing experience and has demonstrated excellent communication skills for coordinating with project managers, business analysts, architects, DBA\'s, Developers.