SUMMARY:

• Certified Informatica power Center (V.9.x) Developer with good experience in IT industry having extensively involved in designing, developing, installing, implementing and supporting Data Warehouses, data marts and data integration projects.
• Followed ETL best practices and standards in implementing ETL mappings using different transformations like Source Qualifier, Expression, Connected / Unconnected Lookup, Aggregator, Sorter, Router, Filter, Update strategy, etc.,
• Experience in full lifecycle design & Implementation of Star and Snowflake Schemas. Hands on Experience in Performance Tuning techniques and Implemented Advanced Features/properties of Power Center including Partitioning, Concurrent Execution, Creating Indexes and Workflow Recovery.
• Experience in Integrating the Informatica power center 8.x/9.xwith Legacy systems
• Extensively worked on Informatica power exchange 9.6.0 End to End Installation / up gradation / User Roles creation / group’s creation / migration activities / Repository & Integration services creation / Repository Backup and restore.
• Sourced Data from various source systems like Oracle, SQL Server, DB2, Flat files, Accesses databases with the help of ODBC and native connections.
• Experience in complete Software Development Life cycle (SDLC) including Requirement, Analysis, estimations, Design, Construction, Unit and System Testing and implementation.
• Expert on Slowly Changing Dimensions Type 1, Type 2 and Type 3 for inserting and updating Target tables for maintaining the history.
• Worked extensively in preparing Unit test cases (UTC) documents, Design documents, for data validation and migration purposes.
• Experience on Post / pre SQL scripts for performing any DML operations on the table after the session run or before the session run depending on the requirement. Also, archiving the source files with the help of configuring the post session variables.
• Created Rule based files (RBL) files for custom based linking in Informatica metadata manager for generating data linage.
• Created custom modals in Informatica metadata manager for data governance and impact analysis.
• Experience in Data Warehouse Administration Console (DAC) / Control - M scheduling tools for Monitoring ETL jobs.
• Good knowledge on OBIA 7.9.6.3 seeded ETL vanilla mappings& Customizing vanilla mappings as per the customer requirements. Good understanding of Reporting tools like OBIEE &Tableau.
• Strong experience in Production support environment at all levels including releases and change requests. Also, well management capabilities in resolving the tickets with in the SLA time lines.
• Excellent problem solving skills with strong technical background, Excellent Team Player with interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica power center/Exchange7.x/8.x/9.6.1, Informatica data quality IDQ, Informatica Metadata Manager v 10.x.

Reporting Tools: OBIEE, Tableau

Version control: Microsoft visual studio, Peregrine, Tortoise SVN

Databases: Oracle 11g/10g, SQL Server 2005/2008 R2, Ansi SQL/ Netezza

Languages: T-SQL, PL/SQL, basic Unix Shell Script, C#.

DB Tools: Toad, SQL* Loader, SQL server management studio

Scheduling Tools: DAC, Control-M, Autosys

ERP Systems: SIEBEL, EBASE, PEOPLESOFT

Operating Systems: Windows 2003/08, UNIX, LINUX - UBUNTU

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Sr. Informatica ETL Developer

Responsibilities:

• Analyzed requirements to load Party and its counter party details into party modal and build Hierarchy relationships. For example, Business unit (BU) to Sub Business Unit (SBU) to Legal Entities.
• Created multiple ETL mappings to source data from SIEBEL in to Party modal for various business requirements based on the source data and the warehouse design.
• Worked on creating MDM Landing tables and loading them using ETL Informatica power center and scheduled them using Autosys scheduler.
• Created Custom modal in Informatica Meta data manager for data governance and impact analysis.
• Loaded Business glossary in Informatica metadata manager tool for business dictionary and created rule based linking between resources for generating data linage.
• Worked on Data profiling and data analysis using Informatica data quality IDQ analyst tool to analyze the data patterns.
• Worked as in sprint developer and develops the code with in the sprint time and migrate the code to Out of sprint environment for Integration testing (SIT).
• Extensively used Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Expressions, Aggregator, Xml and Sequence Generator
• Worked on Jenkins for Continuous integration continuous deployment (CICD).
• Scheduled Workflows using Autosys by using JIL files and scheduled them as per the requirements.
• Data profiling using custom SQL to analyze the data patterns and redundant data
• Last but not least, prepared sprint completion deck and presented to Business leads at the end of every sprint work.
• Worked on Informatica Metadata manager for creating Data linage using custom modal and RBL’s.
• Worked on creating business glossary using Informatica metadata manager.

Environment: Informatica Power Center 9.x, Informatica Metadata manager 9.x, Oracle, Unix, Autosys, Jenkins, Informatica Analyst, SVN, DB2, Informatica Master data management 9.x, Tibco, BOXI reports, Netezza

Confidential, Houston, TX

Sr. Informatica ETL Developer

Responsibilities:

• Created open interface and EPMA dimension tables based on the source data and the warehouse design. Created various mappings using different transformations like filter, Router, lookups, Sorter, joiner, update strategy, expressions and aggregator transformations.
• Creating Sessions and workflows and written custom sql’s as part of performance improvements.
• Used FDMEE & Hyperion Essbase application for planning and ARM reconciliations.
• Also have good knowledge in Performance Tuning at both Database Level and Informatica.
• Extracted data from multiple operational sources for loading staging area, Data warehouse, Data Marts.
• Created open interface tables for data loading into FDMEE tables and for Hyperion reconciliations.
• Worked closely with cross-functional business and stack holders for gathering requirements and converting them in to design documents and ETL code.
• Created Deployment groups for package deployment activities.
• Used AWS services to read data from cloud.
• Written SQL queries for data validation and data promotions.
• Prepared Unit Test Cases (UTC), Design documents, Deployment plan, Deployment checklist

Environment: Informatica Power Center 9.x, Essbase, Hyperion ARM, Oracle, Unix, visual studio

Confidential, Tampa, FL/ New York, NY

Sr. Informatica ETL Developer

Responsibilities:

• Worked on gathering Public/private Data for Analysis and to build Applications/Interfaces such as Global Growth Radar, Demand Estimator, Company Performance, Cost Quality apps using Informatica salesforce.com.
• Data Catalogue Created with respect to the available datasets and understanding of Source Data and Creation of ETL interface documents.
• Created low level design documents, review log documents, unit test cases, Issue logs, Impact Analysis and validated the data against the source.
• Integrated the power center tool with MS SQL and Oracle PL/SQL Database systems.
• Installed Informatica power Exchange 9.5.1 and successfully upgraded to version 9.6.1. Activities like creation of Users and assigning privileges for accessing the repository.
• Created one to one mappings to load data from Temp tables to Main stage tables.
• Migrated data from one environment to other environment. This process involved data conversion, data cleansing, and data migration activities.
• Created Indexes in order to increase performance. Also, implemented Partition techniques at Informatica level such as pass through, key range etc.
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Sorter, Xml, stored procedure and Router etc.
• Also have good knowledge in Performance Tuning at both Database Level and Informatica.
• Created Standardizer, match, key generator, parser transformation using Informatica data quality tool (IDQ) for Standardizing the data.
• Created the deduplication process to eliminate the duplicate records in Informatica data quality IDQ.
• Worked extensively on loading and formatting data by writing SQL scripts. This involves lot of conversion, cleansing, dicing, slicing the data using both excel and SQL scripts.
• Worked as offshore Coordinator for frequent interaction with onsite Team for requirement clarifications.
• Created data linage using Meta data manager for impact analysis and data governance.
• Created custom resources to load external meta data into Informatica metadata manager repository for end to end application linage.
• Repository back up and object migration/Data Replication to other environment.
• Prepared weekly deck, time sheets, and presented SMR (Senior Management Review) presentation to the top officials.

Environment: Informatica Power Center 9.x, Informatica Metadata manager 9.x, Informatica Data quality 9.x, Oracle, SQL server, xml files, Tableau Confidential, Minneapolis, MN

Sr. Informatica ETL Developer/ Lead

Confidential

Responsibilities:

• Developed complex mappings in Informatica to load the data from source tables using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, stored procedure, Joiner, Xml, Filter, Sorter and Router.
• Installation of Informatica 9.0.1 hotfix 2 environments and 7.8.4 contents back up.
• Sand box environment created for regression/Load testing.
• Informatica 7.8.4 Repository Backup and restore.
• Unit test case creation along with test data creation for testing the code
• Folder migration from old repository to upgraded repository.
• OBIEE Reports creation and user prompts creation.
• DAC Scheduler monitoring.
• End to end ware house upgrade from Siebel analytics 7.8.4 to OBIA apps 7.9.6.3
• Work assignment to the offshore team and regular status monitoring.
• Data migration to upgraded tables from obsolete tables. Using vanilla UPG Informatica repository.
• Configuring Infa sequence generator.bat file during data migration
• Unit test case preparation and data validation.
• Retro fixing Informatica mappings in order to replace obsolete tables
• Data ware house full load using DAC scheduler, load monitoring and fixing issues if any.
• SCD type mappings creation using different transformations.
• Worked on Data Masking from hiding the original data by encrypting, using alias names at the object level.
• Data analysis from SIEBEL source to ware house to BI front end.
• Unit testing, surface testing, integration testing and sandbox testing.
• Dry run activities before go live and support activities.
• Developed Mapplets to implement business rules that involved complex logic.
• Tuned the mappings and sessions for better performance by eliminating various performance bottlenecks.

Environment: Informatica Power Center 9.0.1, SQL, PL/SQL, Toad, MS SQL 2008, DAC 10.1.3.4.1, OBIA apps 7.9.6.3

Confidential, Phoenix, AZ

Sr. ETL Informatica Developer

Responsibilities:

• Created Staging, Dimension’s & Fact tables based on the source data and the warehouse design.
• Worked with the Informatica Designer and created various mappings using different transformations like filter, Router, lookups, Sorter, joiner, update strategy, expressions and aggregator transformations.
• Participated in build of the Data Warehouse, which includes the Design of Data mart using Star schema.
• Created repository using Informatica Power Center - Repository Manager.
• Extracted data form DB2tables/ Oracle tables and applied business logic to load them in the central oracle database.
• Created and ran sessions/workflows using Workflow Manager to load the data into the Target Database.
• Optimized/Tuned mappings for better performance, example - the SQL override in source qualifier, lookup overrides in lookups, and other fixes based on the bottlenecks identified.
• Created reusable transformations and Mapplets and used them in mappings.
• Extensively used Shell scripts to automate the Pre-session and Post-sessions processes.
• Performed data manipulation using basic functions and Informatica transformations.
• Used session partitions, dynamic cache memory and index caches for improving performance of Informatica services/ server.
• Extensively worked on SQL tuning process to increase the source qualifier throughput by analyzing the queries with explain plan, creating new indexes, partitions and Materialized views
• Created Tpump, fast export and Mload loaders for loading the data into TERADATA tables.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing rank, lookup, joiner and aggregator transformations
• Created various tasks like Event wait, Event Raise, E-mail and command etc.
• Troubleshoot problems by checking Sessions and Error Logs. Also used Debugger for complex problem troubleshooting.

Environment: Informatica 8.6, UNIX, CSV Files, DB2, SQL, PL/SQL, Unix Shell scripting, Oracle 11g, Toad, Teradata.

Confidential

Sr. Informatica ETL Developer/ Support

Responsibilities:

• Created different types of Transformations, mapplets, for different business logics.
• Migrating into Production systems. Batch Monitoring and Production issue resolutions.
• Hyperion report to Informatica mapping conversion work request and development.
• Resolving data issues and sending mails to DBA teams to data base change request.
• Created different transformations for loading the data into Oracle database e.g. Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.
• Informatica mappings enhancements, monitoring log information in batch run times.
• Breaks fix works for already implemented Mappings.
• Kalido BEID error resolution and Hyperion out of memory Issue aspects.
• Informatica mapping design for loading the data into extract schema from source schema.
• Performance tuning on Informatica maps.
• Production based ticket management and follow up’s using peregrine tool

Environment: Informatica 8.6, PL/SQL Oracle 11g, Toad, Hyperion, Peregrine, Teradata, Control - M

Confidential

Informatica/ ETL Developer

Responsibilities:

• Preparation of the mapping document like Design/UTC/Impact/Issue log.
• Worked on Importing DB2 tables into Informatica ETL power center.
• Preparation of Mappings and Mapping review.
• Creating Different types of transformations and applying different business logics to load data into warehouse.
• Extensively used Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Expressions, Aggregator, Xml and Sequence Generator
• Creating Sessions and workflows.
• Worked on Production issues, Database change request
• Sending communication emails to production coordinator and team with data load status
• Communication with Control-M team for any job failures
• Resolution of Production issues which may include development activities in Informatica.
• Identifying redundancy and taking steps to control it.

Environment: Informatica 8.x, PL/SQL Oracle 9i, DB2, Toad, UNIX, csv files, java, pl/sql, T-SQl