Over all 7+ years of experience in Information Technology with emphasis on Data Warehouse/Data Mart development using developing strategies for extraction, transformation, and loading (ETL) through Informatica Power Center 9.5/9.1/8.6/8.1 & Data Quality and Talend Open Studio from various sources.
• Experience working with Data Warehousing Concepts like OLAP, OLTP, Star Schema, Snow Flake Schema, Logical/Physical/ Dimensional Data Modeling.
• Extensively used ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and Loading using Informatica Power Center and designed data conversions from wide variety of source systems including Netezza, Oracle, SQL server, Teradata and non- relational sources like flat files, XML and SFDC.
• Strong experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Normalizer, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Extracted data from multiple operational sources for loading staging area, Data warehouse, Data Marts using SCDs (Type 1/Type 2/ Type 3) loads
• Good experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files using control-m scheduler.
• Experience in monitoring and scheduling using Control M& Job Conductor (Talend Admin Console) and using UNIX (Korn& Bourn Shell) Scripting.
• Good experience in writing number of Shell scripts to run various batch jobs.
• Worked extensively on Error Handling, Performance Analysis and Performance Tuning of Informatica ETL Components, Teradata Utilities, UNIX Scripts, SQL Scripts etc.
• Proven track record in troubleshooting Informatica Sessions and addressing production issues like performance tuning and enhancement.
• Excellent knowledge on Informatica Data Quality Transformations such as: Labeler, Parser, Address Validator, Standardizer, etc., along with general transformations like Lookup, Expression, Filter, Router, Normalizer Etc.
• Involved in import /export of existing mappings into different environments including Development, QA and Production.
• Experience on post-session and pre-session Shell Scripts for tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc.
• Intensively worked for client ETL code migration from Informatica to Talend Studio.
• 6 months of experience using Talend Open Studio (6.3.1) and 6 months of experience with Talend Admin Console (TAC).
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Responsible for Unit testing and Integration testing of mappings and workflows.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Detail oriented with good problem solving, organizational, analysis and requirement gathering skills.
• Articulate with excellent communication and interpersonal skills with the ability to work in a team as well as individually