Profile

• 10 years of expertise in Information Technology, which encompasses complete SDLC, design, development, Maintenance, application development in Data Warehousing environment, Online Analytical Processing and ETL Extract, Transform, Load solutions.
• Implemented business solutions in Customer Credit Profiling, Fraud Analytics and Regulatory projects for Banking Domain.
• Extensive knowledge in full life cycle of Data Warehouse projects involving data analysis, data extraction, conversion, cleansing and loading.
• Highly skilled and experienced in Agile Development process for diverse requirements.
• Having strong background in Data warehousing projects development and solid exposure to diversified technologies like Informatica Power Center 9.1, Oracle, Teradata 13 and Control M v8 BMC Workload Automation in reputed IT companies.
• Proficient and sound in performance tuning of mappings, sessions and workflows including partitioning, Index optimization maintaining and enhancing ETL code.
• Experience in Loading and Extracting Data using Teradata Utilities like Fast Load, Multi Load, TPUMP, Fast Export, Teradata Parallel Transporter as services in Informatica.
• Having Sound knowledge on Teradata Architecture and Data Distribution techniques. Experience in developing Integration layer of data from different sources and Line of Business.
• Hands on experience on a Data Warehousing migration project moving from EDW Enterprise Data Warehouse to ICDW BDW Model from IBM .
• Designed and developed Load automation framework to schedule the ETL loads using Control M v8 BMC Work Load Automation .
• Well versed with Data Warehousing Architecture on the Design, Development, and Extraction of Data and in the Reporting structure from a Data Warehouse.
• Solid hands on experience with Data warehousing tools, Data Analysis, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Knowledge on Master Data Management Tool Informatica MDM .
• Experience with Version Control System SVN Tortoise Subversion Control .
• Good knowledge in RDBMS concepts, data models, Star/Snow Flake Schemas.
• Having strong Technical and Communication skills and good experience in Functional Analysis in the Banking domain.
• Excellent debugging and troubleshooting skills, with an enthusiastic attitude to support and resolve customer problems.

Technical Skills

• ETL Tools:
• Informatica Power Center 9.1, Informatica Power Exchange, Ab Initio
• Languages:
• Java, SQL, C
• RDBMS:
• Teradata 13.0, Oracle 9.2, MS Access
• Operating Systems:
• Windows 7, Windows XP, Windows 2003/2000 Server, UNIX
• Data Warehousing:
• Data marts, OLTP, OLAP, Normalization, Dimensional Modeling, Facts, Dimensions, Star schema, Snowflake schema, slowly changing Dimensions
• Scheduling Tools:
• Control M 6.4.1, Control M v8 BMC Workload Automation
• Data Merging Tool:
• MDM Informatica Master Data Management
• Defect Tracking Tool:
• HP Application Lifecycle Management 11.00, Quality Center
• Change Management Tool:
• ITSM Remedy 7.0
• Reporting Tool:
• Business Objects XI R2
• Testing Tool:
• HP Quick Test Professional

PROJECT EXPERIENCE DETAILS

Confidential

Lead Application Developer

Environment:

Teradata DB 13.0, Informatica Power Center 9.1, UNIX, Control M v8, Flat Files.

Responsibility:

• Analyze the Ab initio ETL Graphs and Develop requirements from EDW.
• Develop Technical specification documents, Unit Test Cases.
• Development of Informatica sessions with Push Down Optimization in Informatica Power Center 9.1.
• Development of Informatica mappings Transformations and Mapplets using Source Qualifier, Filter, Lookup, Aggregator, Union, Router, Update Strategy etc.,
• Created Workflows to run these Informatica mappings.
• Perform Push Down Optimization tuning to enable faster data loads to Teradata.
• Involved in Data profiling of Flat files in EDW and build physical model for Teradata using IDQ Informatica Data Quality tool.
• Analyze the Tivoli Work Scheduler and gather the scheduling and SLA requirements from EDW.
• Created and Scheduled Control M jobs to automate the ETL jobs.
• Interfaces are built and automated with Control M, Bteq scripts and Unix Shell Scripting
• Loading process was done, using ETL tool, Bteq scripts and Teradata utilities like Fast Load, Multi Load and TPUMP
• Leverage FastExport utility to extract data from Tables.
• Performance tuning of Queries based on the Explain Plan from Teradata optimizer.
• Collecting statistics of Index columns, Join Columns and Partition columns to improve query performance.
• Unit Testing of Informatica Code
• Participate in Daily Status meetings and providing detailed Status Reports.
• Worked on ALM testing tool to execute test cases and Defect fix.
• Participate in Daily Scrum call with all the stake holders.
• Support User Acceptance Testing and resolve the issues identified.
• Assist in debugging performance related challenges.

Confidential

ETL Lead

Environment:

Teradata DB 11.0, Informatica Power Center 9.1, UNIX, Control M v8, Flat Files.

Responsibility:

• Provided training to all the team members on ICDW architecture and SOR Factory Model.
• Reviewed RE document and understood the Business logic requirement for SOR.
• Developed, tested migrated BALFD, RWRDS DCAP applications to higher environments for Staging layers.
• Prepared DEM sheet, Tech-Spec documents.
• Conducted all types of code Reviews.
• Helped team in Resolving technical issues.
• Coordinated with QA team for closure of defects.

Confidential

ETL Lead

Environment:

Teradata DB 11.0, Informatica Power Center 9.1, UNIX, Control M v8

Responsibility:

• Responsible for delivering RDM module for Integration layer.
• Involved in Mapping document design discussions.
• Developed Run-book, Playbook for Production migration.
• Managed 7 members team for RDM module out of total team members 30 .
• Conducted all types of code Reviews.
• Migrated code to QA, UAT PROD within the time-lines. followed client's ITSM process
• Interacting with on-site team in various ways by attending architecture meetings, project meetings, business analysis meetings, team meetings etc..
• Provided Training to new members in the project on ICDW Architecture.

Confidential

ETL Developer

Environment:

Teradata, Oracle, Informatica, Unix Control M

Responsibility:

• Creating reusable and non-reusable mappings/transformations, sessions, workflows using source as Oracle and target as Files and Teradata.
• Involved in complete development and Unit testing.
• Query tuning and optimization.
• Worked on code reusability and shortcut objects in Informatica.
• Developed Technical specification document.
• Interacting with team in various ways by attending architecture meetings, project meetings, business analysis meetings, team meetings etc.

Confidential

ETL Developer

Environment:

Teradata, Oracle, Informatica, Unix Control M

Responsibility:

• Creating new mappings, sessions, workflows using source as SQL Server and target as Files and Teradata.
• Involved in complete development and Unit testing.
• Worked on reusable transformations, reusable mappings and sessions
• Fixing TTs bugs and Implementation of CRs change request
• Worked on mapping parameters and variables.

Confidential

ETL Developer

Environment:

Teradata, Oracle, Informatica, Unix Control M

Responsibility:

• Creating new mappings, sessions, workflows and enhancements in the existing mappings.
• Loaded data from Collection Server flat files into INC tables and target tables using appropriate business rules.
• Prepared Support Transition documents and successfully transitioned to L3 support.
• Involved in complete development and testing Unit Testing, DIT, SIT, UAT
• Discussed with Client during the development of GCH
• Implemented Joiner, Expression, Aggregation, Sorter, Rank, Lookup, Filter, Stored procedure, Router Transformations.
• Developed reusable transformations.
• Implemented mapping variables in mappings.

Confidential

ETL Developer

Environment:

Teradata, Oracle, Informatica, Unix Control M

Responsibility:

• Creating new mappings, sessions, workflows and enhancements in the existing mappings.
• Loaded data from Collection Server flat files into INC tables and target tables using appropriate business rules.
• Prepared Support Transition documents and successfully transitioned to L3 support.
• Involved in complete development and testing Unit Testing, DIT, SIT, UAT
• Discussed with Client during the development of GCH
• Implemented Joiner, Expression, Aggregation, Sorter, Rank, Lookup, Filter, Stored procedure, Router Transformations.
• Developed reusable transformations.
• Implemented mapping variables in mappings.

Confidential

ETL Developer

Environment:

Teradata, Oracle, Informatica Control M

Responsibility:

• Creating new mappings, sessions, workflows and enhancements in the existing mappings.
• Loaded data from Oracle to LRF flat files to INC tables and target tables Teradata using appropriate business rules.
• Prepared Support Transition documents and successfully transitioned to L3 support.
• Created Change Request using Remedy tool to move the code to Production.

Confidential

ETL Developer

Environment:

Teradata, Oracle, Informatica Control M

Responsibility:

• Creating new mappings, sessions, workflows and enhancements in the existing mappings.
• Loaded data from Oracle to LRF flat files to INC tables and target tables Teradata using appropriate business rules.
• Prepared Support Transition documents and successfully transitioned to L3 support.
• Created Change Request using Remedy tool to move the code to Production.

Confidential

Programmer

Environment:

VB Script, MS Access

Responsibility:

• Developed modules for Examination Branch.
• Developed Frontend pages for all modules.
• Responsible to troubleshoot the technical problems.
• Responsible to manage the database.