SUMMARY:

• 7+ Years of professional experience in IT in the areas of Application Software Development, Design, Testing, Implementation and understanding the client requirements, Business analysis, Resource management, gap analysis.
• 6+ Years extensively involved in developing ETL Transformations, Informatica Designer (joiner, expressions, lookups, filters, routers, stored procedures etc.,), Informatica Workflow Manager (Sessions, sources, targets, transformations etc., & direct, indirect sources), Informatica Workflow Monitor, Informatica Administration Console and Repository Manager.
• 6+ Years of IT experience in Informatica Design and Development of ETL (Extract, Transformation and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL solution.
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts, Data warehouse using Informatica Power Center 9.5/9.1/8.6.1/8.1.1/7.1/6.2 Designer, Source Analyzer, Target Designer, Transformation Developer, Mapplets Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Experienced in Extraction, transformation and loading of data from various file formats like .csv, .xls, .txt, .xml and various delimited formats using talend open studio and sql loader.
• Strong Data Warehousing ETL experience of using Informatica Power Center Client tools - Mapping Designer, Repository Manager, Workflow Manager/Monitor and Server tools- Informatica Server, Repository Server Manager.
• Hands on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, system integration and user acceptance testing.
• Worked extensively with complex mappings using different transformations like Source Qualifier, Expressions, Filter, Joiners, Routers, Union, Unconnected & Connected Lookups, Aggregators, Java Transformations, Web Services, XML transformations etc.
• Extensive Experience in developing Stored Procedures, Functions, Views and Triggers, SQL Queries using SQL Server and Oracle PL/SQL. Expertise in Administration tasks including Importing/Exporting mappings, managing users, Groups, associated privileges and performing Back-ups of Repository.
• Strong experience in developing Session tasks, Worklets, Workflow using Workflow Manger tools- Task developer, Workflow worklet Designer. Experience in debugging mappings, Identified bugs in existing mappings by analyzing the data flow and evaluating transformations using debugger.
• Hands on experience in Performance Tuning of Sources, Targets, Transformations and Sessions. Strong Knowledge in OLTP/OLAP systems, normalized (OLTP), De-normalized (DW and ODS) models, Dimensional Strategies, Surrogate - Key, Star Schema, Snow-flake Schema.
• Data modeling experience in creating Conceptual Data models using Erwin Data modeler. Well experienced in doing Error handling and Troubleshooting using various Log files.
• Experience in Unit Testing and Integration testing and Data validation for developed informatica mappings.
• Proficiency in Data warehousing techniques for Data cleansing, Surrogate key assignment and Change Data Capture (CDC).
• Expertise in working with various database systems such as Netezza, Teradata, Oracle and SQL Databases.
• Experience in using Teradata utilities like Fast Load, Multi Load, TPump, Fast Export, Teradata Parallel Transporter (TPT) and BTEQ.
• Experience in working with UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process.

TECHNICAL SKILLS:

ETL TOOLS: Informatica Power Center 9.5.0/9.1.0/8.6/8.5/8.1/7.1, Informatica Power Center 8.6.0/8.6.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manger), Informatica Power Exchange, Informatica Administration Console, Informatica Data Quality 9.1, Talend Open Studio

Operating System: IBM AIX, UNIX, WINDOWS 2000/XP, 7

Database: Oracle 11g/10g, 9i, MS SQL Server 2008/2005,DB2 V8.1, Teradata

Data Modeling: Star Schema Modeling, Snow-Flake Modeling, Facts and Dimensions, Physical and logical data modeling using Erwin, Netezza

Database tools: SQL PLUS, TOAD, SQL Developer

Languages: SQL, PL\SQL, Unix Shell scripting, C

PROFESSIONAL EXPERIENCE:

Confidential, RI

Sr. Informatica Developer

Responsibilities:

• Responsible to meet with business stakeholders and other technical team members to Gather and analyze application requirements.
• Involved in development of Logical and Physical data models that capture current state Developed and tested all the Informatica Data mappings, sessions and workflows - involving several Tasks.
• Expertise in analyzing data throughout each project phase, and provide relevant outputs and results from the data quality procedures, including any ongoing procedures that will run after project end.
• Expertise in partnering with data analyst’s to provide summary results of data quality analysis, which will be used to make decisions regarding how to measure business rules and quality of the data.
• Worked on source analyzer, Target Designer, Mapping and Mapplet Designer, Workflow manager and Workflow Monitor.
• Created mappings for initial load in Power Center Designer using the transformations Expression, Router and Source Qualifier.
• Created complex mappings for full load into target in Power Center Designer using Sorter, Connected Lookup, Unconnected Lookup, Update Strategy, Router, Union etc.
• Created Mapplets to reuse all the set of transformations for all mappings.
• Created work flows and sessions for each mapping that we are extracting from source systems to staging area; staging area to target.
• Responsibilities include creating the sessions and scheduling the sessions.
• Created various tasks to give various conditions in the workflows.
• Extensively created Re-usable Transformations and Mapplets to standardized Business logic.
• Mappings, Mapplets and Sessions for data loads and data cleansing. Enhancing the existing mappings where changes are made to the existing mappings using Informatica Power center.
• Involving in extracting the data from Oracle and Flat files. Developed and implemented various enhancements to the application in the form of Production and new production rollouts.
• Extensively worked on confirmed Dimensions for the purpose of incremental loading of the target database.
• Excellent experience working on Talend ETL and used features such as context Variables, Database components like tMSSQLInput, tOracleOutput, tmap, tFileCopy, tFileCompare, tFileExist components, ETL components etc.
• Worked on Fast Load, MultiLoad, Tpump and FastExport loading techniques through Informatica into Teradata.
• Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.
• Involved in fixing invalid Mappings, Testing of Informatica Sessions, Worklets and Workflows.
• Created parameters and variables for the reusable sessions.
• Analyzed the various bottlenecks at source, target, mapping and session level.
• Tuning of the mappings and SQL Scripts for a better performance.
• Developed complex mappings using various sources data which includes Flat files, DB2 & Netezza database to load data into Netezza tables and to generate reports.
• Experience in working with UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process.
• Used Talend components such as tmap, tFileExist, tFileCompare, tELTAggregate, tOracleInput, tOracleOutput etc.
• Assign work and responsible for providing technical expertise for the design and execution of ETL projects to onshore and offshore developers.

Environment: Informatica Power Center 9.1/Power Exchange/Informatica Cloud, Teradata, Oracle 11g, PLSQL, DB2, XML, MS SQL Server 2005,SQL* PLUS,MS Excel, Netezza, Talend, UNIX Shell.

Confidential, Mc Lean, VA

Informatica Developer

Responsibilities:

• Interacted with various business people and gathered the business requirements and translated them into technical specifications.
• Prepared Technical Design Documents based on the Functional/Business requirements from the business users on the mapping Documents.
• Created Users and groups, Configured profiles and privileges, Configured shared folders for re-useable objects.
• Extensively worked on Informatica Power center - Designer, Workflow Manager and Workflow Monitor.
• Designed the ETL processes using informatica Power Center 9.1 to extract, transform and load data from multiple input sources like oracle, Flat files and XML to target Oracle database.
• Created complex mappings using various transformations Such as Rank, Joiner, Expression, Lookup (Connected/Unconnected), Aggregator, Filter, Update Strategy, Sequence Generator etc. to implement the user requirements.
• Worked with Autosys Scheduler to run the Informatica session on Daily/Weekly/Monthly basis.
• Involved in loading the data from Source Tables to ODS (Operational Data Store) and XML files using Transformation and Cleansing logic using Informatica.
• Used Shortcuts (Global/Local) to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Performed Unit and Integration Testing of Mappings and Workflows.
• Wrote UNIX shell scripts & PMCMD commands for FTP of files from remote server and backup of the repository and folder.
• Analyzed complex workflow in workflow manager.
• Extensively work on the performance tuning of Informatica Power Center Mappings as well as the tuning of the sessions by creating multiple sessions on primary key values by using partition query.
• Involved in informatica admin activities like migrating the code from lower environment to testing model, restarting the Informatica Services, creating new users and granting the permission for the same.
• Used Informatica features to implement Type I, II and III changes in Slowly Changing Dimension tables.

Environment: Informatica Power Center 9.1 Oracle 11g, UNIX, Oracle, DB2, Flat files, XML files, Autosys, Teradata V2R6, and MS Excel.

Confidential, Columbus, OH

Informatica Developer

Responsibilities:

• Actively involved in understanding business requirements, analysis and design of the ETL process.
• Used Informatica Power Center to extract, transform and load data from various source systems to staging and target data warehouse.
• Identified the Sources, Targets and developed ETL mappings using Informatica 7.1.
• Attended multiple requirements gathering discussions and created source to target Detailed Designed Document and also developed Mapping Architect Diagram using Informatica Visio.
• Worked on several transformations such as Filter transformation, Joiner transformation, Rank transformation, Sequence Generator transformation, Stored Procedure transformation, Lookup and Expression transformation in Informatica.
• Created batches to run several sessions sequentially and concurrently.
• Involved in performance tuning of Informatica mappings and sessions
• Tuned performance of Informatica session by increasing block size, data cache, sequence buffer length and target based commit interval, and mappings by dropping and recreation of indexes.
• Used Power Center Workflow Manager for session management, database connection management and scheduling of jobs to be done in batch process.
• Created fact and dimension tables based on specifications provided by managers using Star Schema.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of Workflow.
• Extensively worked on Mapping Variables, Mapping parameters and Session parameters

Environment: Informatica 7.X, Flat files, SQL, PL\SQL, DB2, IBM AIX 5.2, UNIX, Windows 7

Confidential, Trumbull, CT

Informatica Developer

Responsibilities:

• Designed the ETL process using Informatica tool to load data from Oracle into the target database.
• Developed number of complex Informatica mappings, mapplets, re-usable transformations to implement business logic and to load data incrementally.
• Developed Informatica mappings by usage of Aggregator, SQL overrides in Lookups, Source filter in Source Qualifier and Data flow Management into multiple targets using Router transformations.
• Used Debugger to test the mappings and fixed the bugs.
• Used various transformations like Filter, Expression, Sequence generator, Update strategy.
• Created sessions, configured workflow to extract data from various sources, transformed data and loading into data warehouse.
• Used Power Center server manager/Work flow manager for session management, database connection management and scheduling of jobs to be run in the batch process using control-m auto scheduling tool.
• Migrated mappings, sessions and workflow from Development to testing and then to production environments.
• Created multiple Type-II mappings for both dimensional as well as fact table, implementing both date based and flag based versioning logic.
• Monitor troubleshoots batches and sessions for weekly and monthly extracts from various data sources across all platforms to the target database.
• Given production support to resolve the issue.
• Used Informatica Power Connect to connect external databases.
• Involved in performance tuning at source, target, mappings, sessions and system levels.

Environment: Informatica Power Center 7.1, DB2, Oracle 9i, MS SQL Server 2005,UNIX, Control-M,IBM (AIX), TOAD, PL/SQL, Windows XP, MS Word, Excel

Confidential

 Informatica Developer

Responsibilities:

• Analyzing the requirements and having discussion with onsite and business team to understand the requirements.
• Created the mapping design documents for business requirements.
• Worked with various active transformations in Informatica Power Center like Normalizer Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, Sequence generator Transformation and Update Strategy Transformation.
• Extensively worked with various Passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator, Sorter Transformation, and Lookup Transformation.
• Extensively worked with Slowly Changing Dimensions (SCD) Type1, Type2, and Type3 for Data Loads.
• Extensively worked with both Connected and Un-Connected Lookups and Look up Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.
• Extensively worked with Incremental Loading using parameter files, mapping variables, and mapping parameters.
• Created Pre/Post Session SQL commands in sessions and mappings on the target instance.
• Created numerous simple to complex queries involving self joins, correlated sub-queries.
• Scheduled the new mappings using ESP scheduler by creating the ESP Scripts.
• Created and Documented ETL test plans, test cases, test scripts, expected results, assumptions and validations for unit, integration and system tests for mappings developed.
• Involved in post production support and monitoring the activity in various environments.
• Worked on waterfall methodology.

Environment: Informatica Power Center 8.6 (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Flat Files, Oracle10g, Teradata, UNIX Scripting, Putty, Visio, ESP.