Sr.Informatica Developer
Resume:
Dileep Kumar LV
ac1cmv@r.postjobfree.com
Professional Summary:
Over 10+ years of IT experience in all phases of software development life cycle, with forte at successful project implementations - analyzing systems, understanding & defining requirements, development, technical designs & reviews and project planning.
Extensively strong Data Warehouse experience using Informatica PowerCenter 9.x/8.x/7.x, Informatica MDM 10.x/9.x, IDD, Oracle.
Proficient knowledge and hands-on experience in building Data Warehouses, Data Marts, Data Integration and ETL processes.
Extensive experience in Extraction, Transformation and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using Informatica PowerCenter tools (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
Expertise in implementing complex business rules by creating robust Mappings, Mapplets, Sessions, Worklets and Workflows using Informatica PowerCenter.
Experience in integration of various data sources like Oracle, SQL Server, SAP and Flat Files into Data Warehouse and also experienced in Data Cleansing.
Experience in Dimensional Data Modeling, Slowly Changing Dimensions Type I, II & III, Star/Snowflake Schema, Fact & Dimension tables, OLTP, OLAP & ODS Systems.
Experience in the configuration of Informatica MDM Hub which includes Data modeling, Data mappings, Data validation, Match and Merge rules, Tokenization, Hierarchy Manager and customizing/configuring Informatica Data Director.
Experience in defining and configuring landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
Experience in configuration of Informatica Data Director (IDD) to meet data governance objectives in various project life cycles and MDM hierarchies development.
Expertise in creation of match paths, match rules, match rule sets, system trust scores and trust score decay with Validation rules.
Good knowledge on Data modeling concepts like Conceptual, Logical and Physical database models to design OLAP systems.
Extensively strong work experience on SQL, PL/SQL and UNIX.
Extensively used SQL and PL/SQL, good knowledge on Stored Procedures, Functions, Packages, Cursors, Triggers, Views and Indexes.
Excellent expertise with different types of data load strategies and scenarios like Historical Dimensions, Surrogate keys, Summary facts, Incremental Logic etc.
Experience in performance tuning of Informatica mappings and sessions to improve performance of the large volume projects.
Experience in SDLC and AGILE methodology including analysis, design, development, testing and implementation of software applications.
Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
Business experience with Oil & Natural Gas, Asset Management, Investments, Portfolio Management, Risk & Insurance.
Excellent analytical, problem solving skills with strong technical background and interpersonal skills.
Education:
Bachelor of Engineering in Computer Science Engineering from University of Madras in the year 2003.
Technical Skills:
Operating System
Windows 2000/2003/2007, Windows–NT, Unix
Languages
SQL, PL/SQL, UNIX Shell Scripting, JCL
Tools
Informatica PowerCenter 9.x/8.x/7.x, Informatica MDM 10.x/9.x, Informatica Data Director, Tableau
RDBMS
Oracle 11g/10g/9i, IBM DB2, SQL Server 2008
Database Tool
TOAD, SQL Plus
Other Tools
WinSCP, FTP, Clear Case, Clear Quest, Erwin, HP Quality Center, SoapUI, TortoiseSVN, Putty
Scheduling Tool
Informatica Scheduler
Contact this candidate