SUMMARY

• Over 7 years of experience in Data warehousing using Informatica as an ETL tool.
• Exposure to various domains like Health care, Insurance, Banking, Retail Industry and Financing.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving System Analysis, Design, Development and Implementation.
• Good at Relational Database Management System (RDBMS) concepts.
• Working Knowledge on Kimball/Inmon Methodologies.
• Experience in Data Extraction, Transformation and Loading data using Informatica Power Center 9.5.1/9.1.1/8. x/7.x.
• Worked on tools like Repository Manager, Workflow Manager, Workflow Monitor, Designer consists of objects like Mapping Designer, Transformation Developer, Mapplet Designer, Source Analyzer and Target Designer, Admin console and Data Administration.
• Experience in designing complex mappings using Source Qualifier, Update Strategy, Expression, Sequence Generator, Aggregator, Filter, Joiner, JAVA, Router, Connected Lookup, Unconnected Lookup, Normalizer, Rank, XML, Sorter, Transaction Control and Union to load data into different target types from different sources like Flat files (Delimited files and Fixed width files) like text files or CSV files, XML, Oracle, IBM Mainframe, Cobol files, SQL server, DB2, Teradata, Netezza.
• Experience in managing Slowly Changing Dimensions (SCD) Type 1, Type 2 and Type 3, Data Marts, OLAP, OLTP and Change Data Capture (CDC).
• Good at Pre - SQL and Post-SQL at session level in Informatica.
• Knowledge on Data Cleansing, Data Staging, Data profiling, Error Handling, Session log files, Workflow log files and Performance optimization like Pushdown Optimization (PDO), session partitioning, which troubleshoots the bottleneck problems at different levels like source, target, mapping, session and system.
• Worked on different databases like Teradata, Oracle, DB2, Sybase, SQL Server, and MS Access.
• Good Knowledge of Data Warehousing/Data Modeling using ERwin, staging tables, stored procedures, Functions, cursors, Dimension tables, Fact tables, Surrogate Key, Primary keys, Foreign Keys, Star Schema, Snow Flake Schema, Triggers and Normalization/Denormalization.
• Experienced in performance tuning like creating indexes at database level.
• Experience in Scheduling Tools like Autosys, Control-M, and Workload manager.
• Worked with versioning tools like Clearcase, SVN, PC Based version control
• Good Knowledge on Teradata utilities like Multi Load, Fast Load, TPump, FastExport, and BTEQ scripts.
• Good Knowledge of writing PL/SQL procedures.
• Experience in using Oracle Development tools such as Tool for Oracle Application Development (TOAD).
• Good Knowledge on Oracle utilities like SQL Loader.
• Hands on experience in writing Simple/Complex SQL Queries sing Sub queries and multiple table joins using left, right, inner joins.
• Experience in UNIX Shell Scripting and batch scripting for parsing files.
• Experience in using the Informatica command line utilities like PMCMD, PMREP to execute workflows.
• Good communication skills both verbal and written, hardworking, self-motivated, ability to work independently or co-operatively in a team, eager to learn and ability to grasp quickly.
• Good experience in ETL technical documentation.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.5.1/9.1.1/8. x/7.x

Databases: Oracle 11g/10g, SQL Server 2012/2008/R2/2003/R2, DB2/UDB, MS Access, Teradata V13/V2R12, Sybase

Methodologies: Star schema and Snowflake schema

Languages: SQL, PL/SQL, C and data structures, C++, JAVA, UNIX shell scripting, Batch scripting, Perl Scripting

Operating system: UNIX, Windows Server, Linux

Tools: Putty, WinSCP, Toad, AQT, Autosys, Control-M, Workload Manager, Clearcase, SVN, PC Based version control, Erwin

Web Design: PHP, HTML

Utilities: SQL Loader, Multi Load, Fast Load, Fast Extract, TPump, BTEQ, PMCMD, PMREP, SQL Assistant

PROFESSIONAL EXPERIENCE

Confidential, Century City, CA

Informatica Developer

Responsibilities:

• Interacted with Business Analyst to understand the requirements and translated them into appropriate technical requirement document.
• Coordinating with the client team on daily basis for issues and status update.
• Conducting technical design presentation to the client and getting the sign off.
• Designed mappings using different transformations like Lookup’s (connected, Unconnected, Dynamic), Expression, Sorter, Joiner, Router, Union, Transaction Control, Update strategy, Normalizer, Filter, Rank, and Aggregator using Informatica Power center designer.
• Analyzed different data sources like Oracle, Flat files including Delimited and Fixed width like text files, XML files from which the contract data and billing data is coming and understand the relationships by analyzing the OLTP Sources and loaded into Teradata warehouse.
• Worked on Slowly Changing Dimension (SCD) Type 1 and Type 2 to maintain the full history of customers.
• Responsible for performance optimization by writing SQL overrides instead of using transformations, implementing active transformation like filter as early as possible in the mapping, selecting sorted input when using Aggregator or Joiner transformations .
• Implemented performance tuning at all levels like source level, target level, mapping level and session level.
• Created and configured workflows, worklets and sessions using Informatica Workflow Manager.
• Created command task at the workflow level by writing the commands to get the Flat files having same structure i.e. Indirect File Loading and at the end of the task moving all the Flat files using command task to an archive directory.
• Used workflow level variables for the reusability of the code.
• Used Mapping Parameters and Variables to implement Object Orientation techniques and facilitate the reusability of code.
• Worked with SQL sub queries and joins between multiple tables.
• Worked on Design Error Handling process in ETL.
• Created reusable tasks at workflow level.
• Created reusable transformations at mapping level in power center designer.
• Worked with version control tool using clearcase.
• Scheduled job using Control-M.
• Worked with Oracle tool like TOAD.
• Worked with Teradata utilities like Fastload, Tpump.
• Closely moved with the Micro strategy reporting team and helped them to get the data for creating report.
• Have performed code promotion from development level to production level.
• Worked on agile methodology.
• Prepared an ETL technical document maintaining the naming standards.

Environment: Informatica PowerCenter 9.5.1, Oracle 11g, Teradata v13, Teradata utilities Windows server 2012.

Confidential, St. Louis, MO

ETL/Informatica Developer

Responsibilities:

• Interacted with the Data Analyst to know the requirements & Created Business Specification Documents. Analyzed the approach Documents/Templates and suggested few corrections. Analyzed source to target mapping document.
• Worked on data cleansing, data Extraction, Transformation and Loading design, development, source to target mappings, data warehouse transformations, performance tuning, testing and documentation.
• Used Informatica Power Center to extract/transform and load data from different operational data sources like Oracle, Flat files like CSV files, XML files, COBOL files, SQL server from which customer’s data is coming and is loaded into Teradata warehouse.
• Worked on complex mappings using transformations like Aggregator, Expression, Joiner, Filter, Sequence Generator, Connected and Unconnected Lookup, Dynamic Lookup, Filter, Router, Union, and Update Strategy using Informatica Power Center Designer.
• Implemented Type 2 Slowly Changing Dimension (SCD) for accessing the full history of accounts and transaction information.
• Implemented Change Data Capture (CDC) using MD5 function.
• Worked on Informatica command line utilities like PMCMD, PMREP.
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level.
• Responsible for troubleshooting the bottleneck problems by creating the indexes at database level.
• Created and configured workflows, worklets, and sessions using Informatica Workflow Manager.
• Worked on session log files and workflow log files.
• Good knowledge on writing post SQL and pre SQL at session level.
• Good Knowledge in writing simple/complex SQL queries, unions and Joins
• Used Mapping Parameters and Variables for the reusability of code.
• Worked with version control tool like SVN and scheduler tool like autosys.
• Worked with Teradata utilities like Multiload, FastExport, and BTEQ scripts.
• Created a shell scripting in UNIX platform and used UNIX tool like WinSCP.
• Supported testing team, UAT team and production support teams.
• Had a good interaction with the data analyst and with the micro strategy reporting team.
• Worked on waterfall methodology.
• Prepared an ETL technical documentation.

Environment: Informatica Power Center 9.1.1, Oracle11g, Teradata V2R12, SQL Server 2008/R2, UNIX, Teradata utilities.

Confidential, NY

ETL/Informatica Developer

Responsibilities:

• Worked with Business Analyst to know the requirements of the project.
• Prepared design document for customer review.
• Coordinated with Informatica Administrator to setup the environment and to move objects to different repositories and folders.
• Worked on Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer, Workflow Manager, Workflow monitor, Mapplet Designer and Transformation Developer.
• Created the complex mappings, sessions and the workflows as per the Functional and Technical Specifications.
• Extracted the data from Flat files (Delimited and fixed width) like CSV files or text files, XML files, Oracle 11g, SQL server, IBM mainframe, Sybase and load into Oracle data warehouse.
• Worked extensively on different types of transformations like source qualifier, joiner, filter, router, expression, Aggregator, Router, filter, XML, JAVA, Update strategy, lookup, Normalizer, stored procedure transformations etc.
• Implemented Slowly Changing Dimensions methodology to keep track of historical data.
• Implemented Change Data Capture (CDC).
• Designed complex mappings using connected/Unconnected/Dynamic Lookups taken from source and target level, Filter, Expression, Aggregator, Normalizer, Joiner and Router transformations for populating target tables.
• Involved in Relational and Dimensional Data Modeling Techniques to design data models. Using ERwin tool.
• Used Informatica PDO (Push Down Optimization) as performance tuning which pushes all the transformation logics to the underlying target database and hence achieves maximum performance offered by the database.
• Worked with the Data warehousing methodology of Snow Flake schema of Ralph Kimball.
• Worked with different kinds of Code migration like XML import and XML export.
• Worked with PL/SQL procedures, functions, cursors, stored procedures and triggers.
• Worked on ETL design, development, administration, and source to target mappings, data warehouse transformations, on call support, troubleshooting and documentation.
• Implemented mapping parameters and variables for the reusability of the code.
• Involved in Performance Tuning at various levels including Target, Source, Mapping and Session for large data files.
• Worked on Oracle utilities, scheduler tools and versioning tools.
• Worked on waterfall methodology.

Environment: Informatica Power Center 8.6.1, Oracle 11g, SQL Server 2008, Sybase, XML, linux, ERwin, Shell scripts, SQL loader, SQL assistant, Autosys, PC based version control. .

Confidential, Seattle, WA

ETL/Informatica Developer

Responsibilities:

• Participated in collecting user requirements.
• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Involved in drafting Software Requirement Specification for the project.
• Co-ordinated with Informatica Admin to setup the environment and to move objects to different repositories and folders.
• Worked on Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer, Workflow Manager, Mapplet Designer and Transformation Developer.
• Designed and created mappings, sessions and workflows and schedule the workflow as per the Functional & Technical specifications.
• Extracted the data from Oracle10g, Netezza, XML, Flat files, DB2 load the data in to Oracle warehouse.
• Worked on batch scripting.
• Designed mappings using connected/Unconnected Lookups, Filter, Expression, Aggregator, Update strategy, Joiner, Normalizer, Transaction Control, Source Qualifier, Union, Rank and Router transformations for populating target tables as per business requirements.
• Developed Index Cache and Data Cache in cache using transformation like Rank, Lookup, Joiner, and aggregator Transformations.
• Worked with Change Data Capture (CDC).
• Worked with Shortcuts across Shared and Non Shared Folders.
• Created and Executed workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Worked on scheduling tool and versioning tool.
• Worked on Oracle utilities.
• Analyzed Session log files to resolve errors in mapping and managed session configuration.
• Created, configured, scheduled and monitored the sessions and workflows on the basis of run on demand, run on time using Informatica Power Center Workflow Manager.
• Worked on performance tuning at various levels including Target, Source, Mapping and Session for large data files.
• Used mapping variables and parameters for the reusability of the code.
• Maintained naming standards and warehouse standards for future application development, and also created functional and technical specification documents.
• Involved in designing snow flake schema, star schema, dimension tables, fact tables.
• Worked with Surrogate keys, primary keys, foreign keys, triggers, normalization/DE normalization types.
• Worked on agile methodology.

Environment: Informatica Power Center 8.6.0,Oracle10g, DB2, PL/SQL, SQL loader, Toad, PL/SQL Developer tool, workload manager, clearcase, Windows server 2008, AQT, batch scripts, FTP.

Confidential

ETL Developer

Responsibilities:

• Worked with data analyst to know the requirements of the project.
• Worked with various data sources like oracle, flat files, Sybase data coming as customers data and load into Oracle warehouse.
• Involved in designing of Informatica mappings by using transformations like source qualifier, expression, update strategy, router, joiner, connected lookup, unconnected lookup, dynamic lookup, transaction control, rank, sequence generator, Aggregator.
• Implemented Slowly Changing Dimensions (SCD) Type 1 and Type2.
• Created reusable transformations and Mapplets and used them in mappings.
• Worked on shared folder.
• Worked on oracle utility, scheduling tool and versioning tool.
• Worked on perl scripting.
• Created PL/SQL procedures for certain Business Requirements
• Designed SQL overrides in source Qualifier according to business requirements
• Created sessions and workflows for designed mappings and created Sequential Workflow using
• Monitoring the session logs to check the progress of data load.
• Supported testing team, UAT team and production team.
• Worked on ETL document.

Environment: Oracle 10g, Informatica Power Center 7.1, Sybase, Toad, SQL loader, Autosys, Control-M, Perl scripts, Windows server 2003/R2.