PRODESSIONAL SUMMARY:

• A Software Professional having ten plus yearsof IT experience with strong background in Data Warehousing with emphasis on Business Requirements Analysis, Application Design, Development, Testingand Implementation.
• Involved in all stages of Software Development Life Cycle (SDLC) from analysis and planning to development & deployment and followed the agile methodology & scrum process.
• Experience in analyzing the business needs of clients, developing effective and efficient solutions and ensuring client deliverables within committed timelines.
• Proficient in ETL (Extract, Transform and Loading data) process in analyzing, designing and developing Data Warehousing projects using Informatica Power Center.
• Expertise in designing and developing complex ETL mappings, reusable transformations and sessions to move the data at specific intervals using workflow manager and modified existing mappings for enhancements of new business requirements to load into staging tables and then to target tables in EDW.
• Vast experience in designing and developing mappings from varied transformations like Unconnected and Connected Lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure, Sequence Generator, Rank, Normalizer, SQL etc.
• Extensively used Mapping Variables &Parameters, Mapplets and Worklets for improvedperformance and increased flexibility.
• Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Involved in extracting data from different source systems and dumped into landing tables after performing ETL logic and then used MDM to perform match and merge rules to create golden records for the clients.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Participated in developedIDQ mappings using various transformation like Labler, Standarization, Case Converter, Match and Address validation.
• Involvedin Data Profiling using IDE - Informatica Data Explorer and IDQ-Informatica Data Quality to examine different patterns of source data. Proficient in developing Informatica IDQ transformations like Parser, Classifier, Standardizer and Decision.
• Created mappings which involved Slowly Changing Dimensions (SCD Type1 andType2) to implement the CDC logic so as to capture the changes and preserved historical data.
• Identified the bottlenecks in ETL Processes and improved the performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly using Partitioning, Index Usage etc.,
• Knowledge of optimization concepts and tuning objects for optimum execution timelines.
• Used Debugger utility of the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results.
• Taken part of Informatica administration and migrated Informatica objects from lower tohigher environment.
• Extensively worked with Lookup Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.
• Worked on data verification and validation to evaluate the data generated according to the requirements is appropriate and consistent.
• Data warehousing experience specializing in RDBMS, ETL Concepts to load data from different sources into data warehouse using Teradata Utilities (BTEQ, FLOAD, MLOAD, FEXPORT and TPUMP) and Informatica Power Center.
• Created and used various Teradata Set, Multi-Set, Global, Volatileand Temp Tables.
• Skilled in writing complex SQL queries to pull the required information from database using Teradata SQL Assistance, Oracle and IBM-DB2 etc.
• Written BTEQ, FLoad, MLoad scripts for loading the huge volume of data from legacy systems to target data warehouse.Developed T-Pump scripts to load low volume data into Teradata.
• Very good understanding of Teradata UPI and NUPI, Secondary Indexes and Join Indexes.
• Conversant in writing queries and proficient in Performance Analysis with query tuning using Explain Plan, Collect Statistics, NUSI and Join Indexes including Join and Sparse Indexes.
• Involved in writingUNIX Shell Scripts to automate applications, Schedule jobs, develop interfaces and Created pre-session and post-session shell scripts and mail-notifications.
• Created new Teradata tables and data replication process from Oracle to Teradata and created indexes on the tables for faster retrieval of the data to enhance database performance.
• Strong experience in Data conversion/integration from Legacy systems and external systems into Oracle Applications using PL/SQL.
• Handled millions of data and effectively running the queries against the database with no performance issues.
• Interacted closely with DBA to improvise the existing long running jobs and solving the issues and involved in peer reviews.
• Created and executed test plans for Unit, Integration, and System test phases.
• Versed in OLTP Modeling (2NF, 3NF) and OLAP Dimensional modeling (Star &Snow Flake).
• Good team player with excellent technical and interpersonal skills. Pro-active, self-motivated and able to work independently as well as in team.

TECHNICAL SKILLS:

ETL Tools: InformaticaPowerCenter 10.1/9.6/9.5 , Informatica MDM 9.7,Informatica IDQ 9.5Talend Open Studio

RDBMS: Teradata 15/14/13/12, Oracle 11g/10g, IBM-DB2, Postgress

Utilities: BTEQ, FLoad, MLoad, FExport, TPump, WinSCP, Tectia, Tortoise SVN,Visio

Languages: SQL Assistant, SQL, PL/SQL, PostgreSQL, UNIX shell scripting

PROFESSIONAL EXPERIENCE:

Confidential, Windsor Mill, MD

Informatica Developer

Environment: Informatica Powercenter 10.1/9.6,IBM-DB2, Oracle 11g, SQL and UNIX Shell scripting.

Confidential, Columbia, MD

Informatica/Teradata Developer

Environment: Informatica Powercenter 9.6/9.5, IDQ 9.5, MDM 9.7, Teradata 15/14, SQL Assistant, BTEQ, MLOAD, FLOAD, TPump, UNIX Shell scripting, Oracle 11g,SQL andPL/SQL

Confidential, Clarksburgh, MD

Software Developer

Environment: InformaticaPowercenter 9.1, Teradata 13, SQL Assistant, BTEQ, MLOAD, FLOAD, TPump, UNIX Shell scripting, Oracle 10g, SQL and PL/SQL

Confidential

Jr. Developer

Environment: Teradata 13, BTEQ, FLOAD, MLOAD, FEXPORT, UNIX, Oracle 10g, SQL and PL/SQL.

Responsibilities:

• Experience in analyzing the business needs of clients, developing effective and efficient solutions and ensuring client deliverables within committed timelines.
• Proficient in ETL (Extract, Transform and Loading data) process in analyzing, designing and developing Data Warehousing projects using Informatica Power Center.
• Expertise in designing and developing complex ETL mappings, reusable transformations and sessions to move the data at specific intervals using workflow manager and modified existing mappings for enhancements of new business requirements to load into staging tables and then to target tables in EDW.
• Vast experience in designing and developing mappings from varied transformations like Unconnected and Connected Lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure, Sequence Generator, Rank, Normalizer, SQL etc.
• Extensively used Mapping Variables &Parameters, Mapplets and Worklets for improvedperformance and increased flexibility.
• Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Involved in extracting data from different source systems and dumped into landing tables after performing ETL logic and then used MDM to perform match and merge rules to create golden records for the clients.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Participated in developedIDQ mappings using various transformation like Labler, Standarization, Case Converter, Match and Address validation.
• Involvedin Data Profiling using IDE - Informatica Data Explorer and IDQ-Informatica Data Quality to examine different patterns of source data. Proficient in developing Informatica IDQ transformations like Parser, Classifier, Standardizer and Decision.
• Created mappings which involved Slowly Changing Dimensions (SCD Type1 andType2) to implement the CDC logic so as to capture the changes and preserved historical data.
• Identified the bottlenecks in ETL Processes and improved the performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly using Partitioning, Index Usage etc.,
• Knowledge of optimization concepts and tuning objects for optimum execution timelines.
• Used Debugger utility of the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results.
• Taken part of Informatica administration and migrated Informatica objects from lower tohigher environment.
• Extensively worked with Lookup Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.
• Worked on data verification and validation to evaluate the data generated according to the requirements is appropriate and consistent.
• Data warehousing experience specializing in RDBMS, ETL Concepts to load data from different sources into data warehouse using Teradata Utilities (BTEQ, FLOAD, MLOAD, FEXPORT and TPUMP) and Informatica Power Center.
• Created and used various Teradata Set, Multi-Set, Global, Volatileand Temp Tables.
• Skilled in writing complex SQL queries to pull the required information from database using Teradata SQL Assistance, Oracle and IBM-DB2 etc.
• Written BTEQ, FLoad, MLoad scripts for loading the huge volume of data from legacy systems to target data warehouse.Developed T-Pump scripts to load low volume data into Teradata.
• Very good understanding of Teradata UPI and NUPI, Secondary Indexes and Join Indexes.
• Conversant in writing queries and proficient in Performance Analysis with query tuning using Explain Plan, Collect Statistics, NUSI and Join Indexes including Join and Sparse Indexes.
• Involved in writingUNIX Shell Scripts to automate applications, Schedule jobs, develop interfaces and Created pre-session and post-session shell scripts and mail-notifications.
• Created new Teradata tables and data replication process from Oracle to Teradata and created indexes on the tables for faster retrieval of the data to enhance database performance.
• Strong experience in Data conversion/integration from Legacy systems and external systems into Oracle Applications using PL/SQL.
• Handled millions of data and effectively running the queries against the database with no performance issues.
• Interacted closely with DBA to improvise the existing long running jobs and solving the issues and involved in peer reviews.
• Created and executed test plans for Unit, Integration, and System test phases.
• Versed in OLTP Modeling (2NF, 3NF) and OLAP Dimensional modeling (Star &Snow Flake).