Description
SUMMARY: Around 7 years of extensive IT industry experience in Requirement Gathering, Analysis, Design, Development, Testing, Implementation and Maintenance Support of ETL/Data warehouse solutions using Informatica PowerCenter. Strong experience with tools of Informatica PowerCenter suite (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Administration Console) Proficient in creating Mappings, Sessions, Workflows, Transformations, Mapplets, Worklets, Command Tasks and E-mail Tasks Knowledge in Full Life Cycle development of Data Warehousing. Extensively used Source Qualifier, Filter, Expression, Router, Joiner, Stored Procedure, Lookup, Aggregator, Sorter and Update Strategy transformations Sound knowledge of Data Cleansing, Conversion, Character, String, Date, Test, Numeric, Aggregate, Variable and Special Functions Worked with wide range of sources and targets like Oracle, Teradata, Salesforce, SQL Server, and Flat files Proficient in developing solutions for Slowly Changing Dimensions, Late Arriving Dimensions, Incremental Loading, Incremental Aggregation, Constraint-Based Loading Extensively used mapping parameters, mapping variables, session parameters, session variables Highly skilled in performance tuning of Mappings, Sessions, Source and Target systems Strong experience in creating Stored Procedures, Functions, Views, Triggers, Indexes and Partitions at database level Proficient with Data Modeling process of designing Dimensional Models (Star, Snowflake schemas) with respect to query and analysis requirements Strong experience with UNIX shell scripting Extensively worked on Scheduling jobs using Automation tools like CA Workload Automation ESP, IBM Tivoli Workload Scheduler (Maestro) and Autosys Extensively worked with end users on the UAT of the Data Warehouses and Data Marts Proficient in understanding business requirements and translating them into technical/mapping specifications, providing instantaneous and workable solutions to business problems * Worked in Agile environment. Familiar with Agile methodologies. Extensively worked in Windows and UNIX platforms
Accomplishments
Highlights:
Keywords
