Mr Deepak Kumar (TutorId:1405)-Home Tutor from Palam Colony, New Delhi

About Me

? A dynamic professional with nearly 3 years have relevant experience out of 4 years of total IT experience and rich exposure in handling DWH software projects using tool like Informatica 9.5 and Oracle Database like 9i/10g implemented through SQL & PL/SQL and Shell Scripting encompassing oNSITe & offsite planning.<br>? Expert Level skills in developing Strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica Power Centre 8.X.<br>? Well Versed with the Designing and Development as Extraction, Transformation and Loading of Data in structured format to Data Warehouse.<br>? Strong Data warehousing experience using ETL Tool-Informatica Power Center, (Source Analyzer, Warehousing Designer, Mapping Designer, Mapplet, Transformations).<br>? Worked with different data sources like Flat Files, Oracle Database definition.<br>? Knowledge of Data Warehousing Life Cycle.<br>? Knowledge of Data Warehousing concepts; like Star Schema, Snowflake Schema, Dimensions and Facts.<br>? Implementing CDC techniques like Slowly Changing Target (Type1 and Type2), SGT, SGD and SPT.<br>? Developed mappings by extensively using Informatica Transformations like Lookup, Filter, Sorter, Rank, Union, Aggregator, Source Qualifier, Expression, Joiner, Router, Stored procedure, Normalizer and Java transformation etc….<br>? Optimized the ETL process using performance-tuning methods.<br>? Used text files, relational and XML files as sources and targets.<br>? Good interpersonal skills and a good team player.<br>? Hands of experience on SQL, PL/SQL languages.<br>? Having experience of testing.<br>? Knowledge of UNIX.

Categories

Computer and IT Courses

Courses

Oracle Teacher

Subjects

<strong>Oracle Informatica 9.5</strong> up to Masters sql, pl/sql <br> <strong>Unix </strong> up to Masters <br> <br><p>

Hourly Price

Rs 100

Tutoring Mode

At Student's Home : Yes

At Tutor's Home : No

At Institute : No

Online Tuition : No