Experience in using Informatica PowerCenter 9.6.1/9.5/9.1/8.6.1/8.1.1/7.1 - Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor, Repository Manager and Admin Console.
Extensive experience in developing complex mappings from varied transformations like Source Qualifier, Connected and Unconnected lookups, Router, Filter, Sorter, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, Stored Procedure and Sequence Generator etc.
Expertise in design and implementation of SCD - slowly changing dimensions types (1, 2 and 3) and CDC - Change data capture.
Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine-tuned Transformations to make them more efficient in terms of session performance.
Experience in implementing the complex business rules by creating re-usable transformations, developing complex Mapplets and Mappings.
Instrumental in setting up standard ETL Naming standards & BEST Practices throughout the ETL process (Transformations, sessions, workflow names, log files, input, variable, output ports).
Database experience using Teradata 14.10/14, PostgreSQL, H2 Database, Oracle 11g/10g/9i/8.x/7.x, MS SQL Server 2005/2000, AS400, DB2 and MS Access. Also used SQL Editors such as Teradata SQL Assistant, H2 Console, TOAD, SQL PLUS and SQL Analyzer.
Experience on using Teradata Parallel Transporter (TPT) load protocols like LOAD, UPDATE STREAM & EXPORT.
Experience in using Teradata Macros, Query banding and BTEQ Scripts on Linux/Unix.
Strong experience using T-SQL, PL/SQL Procedures/Functions, Triggers and Packages.
Experience in Unix/Linux Operating System and Shell scripting.
Experience in integration of various data sources like Teradata, Oracle, PostgreSQL, S3, HDFS, MS SQL Server, Flat Files, and XML Definitions.
Good understanding of Views, Synonyms, Indexes, Joins, and Sub-Queries.