SUMMARY:

• Over EIGHT Years of professional experience in designing and implementing Data Warehouse applications using Informatica Power Center 9.x/8.x/7.x in different business domains like finance, banking, Insurance and health care industries.
• Involved in different phases of Data Warehouse Life Cycle including business requirements gathering, source system analysis, ETL design/development, project deployment, production support, maintenance of client/Server Data warehouse and Data mart systems.
• Extensively worked with various components of the Informatica Power Center tools - Power Center Designer, Repository Manager, Workflow Manager, and Workflow Monitor to create mappings for the extraction of data from various source systems.
• Worked on various types of transformations like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Aggregator, Rank, Router, Normalizer, Sorter, External Procedure, Sequence Generator, and Source qualifier.
• Experience in upgrading from Informatica Power Center 9.1 to Informatica Power Center 9.5.
• Experience in monitoring the environments and suggesting improvements for stability and performance tuning using Database Tuning, Partitioning, Index Usage, and Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning.
• Worked on integration of multiple data sources and targets like Oracle, SQL Server, flat files, COBOL files and XML.
• Good understanding in database, data warehousing concepts (OLTP & OLAP) and code management tools.
• Implemented the concept of slowly changing dimensions (SCD) Type I and Type II to maintain current, historical data in the dimension.
• Implemented Data Cleansing, Data Analysis, Data Profiling, Transformation Scripts, Stored Procedures/Triggers and necessary Test plans to ensure the successful execution of the data loading processes.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Extensive experience in using Informatica tool for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys.
• Experience in Dimension Data modeling concepts like Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Basic knowledge of Master Data Management (MDM) concepts.
• Developed UNIX Shell scripts to archive files after extracting and loading data to Warehouse and also wrote UNIX shell scripts to automate manual tasks.
• Experience in Scrum, Agile and Waterfall models.
• Full Software Development Life Cycle (SDLC) experience including Analysis, Design and Review of Business and Software Requirement Specifications.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x, Power Exchange 9.1/8.1, Talend Big data, Infomratica 10.2.

Languages: SQL, PL/SQL, C, C++, XML, HTML, Visual Basic 6.0.

Operating Systems: UNIX, Windows XP/2007 .

Tools: PL/SQL, SQL, Developer 2000, Oracle Developer Suite, SQL Plus, TOAD 8.x/9.x/10.x, SQL *Loader, Multi-Load, Teradata 12/13.

Databases: Oracle 11g/10g, SQL Server 2000, Teradata 14/12, DB2.

Job Scheduling: Autosys.

BI Tools: Tableau.

PROFESSIONAL EXPERIENCE:

Confidential, Fremont, CA

Sr. Informatica Developer

Responsibilities:

• Working on a project entitled iHUB (Integrated HUB) which serves as the base for Oracle Financial Services Analytical Applications (OFSAA).
• The project is on to develop integrated system between upstream and downstream systems which delivers current, conformed and consolidated data to downstream systems.
• Serving a core member of an engineering team that designs and develops software applications. Writing code and unit tests, conducting code reviews and testing.
• Gathering business requirements from customers using Glimmer then understand the requirements and perform data analysis. Then work on ETL design using Informatica and AB-initio tools.
• Working on code refactoring using more Informatica transformations like Expression, User defined Join in Source Qualifier, Aggregator, Normalizer, Lookup, Filter, Joiner, Rank, Router etc. to migrate code from Informatica to AB-initio. Defined mapping parameters and variables in Paramater file in UNIX.
• Scheduling jobs using UNIX based Autosys job scheduler tool.
• Extracted data from various centers with the data in different systems like Oracle Database and SQL Server and loaded the data into Oracle staging using Informatica Power Center 10.2.
• Creating the tickets for defects and issues in JIRA and assign it to related teams. Track the defect using JIRA and releasing the code on monthly basis.
• Check-In the code using Build Automation Control to GIT for different versions and deploying the code from GIT to higher environments.
• Using Deployment Group (DG) to deploy the code from lower environment to higher environment in Informatica Power center.
• Working with offshore teams to discuss the daily activity and track the issue based on their assigned JIRA.

Environment: Informatica Power Center 10.2, Oracle, SQL Server, UNIX, Autosys, JIRA, Build Automation, Glimmer, GIT, Putty.

Confidential, Santa Monica, CA

Sr. Informatica Developer/Production Support Engineer

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Working on Agile Methodology. Needs to report our daily activity to scrum master. We have one week Confidential . We have JIRA to track all our activities like design, testing and migration.
• Working on Hive database using Talend Big data platform. Migrating user information from Data Lake to Salesforce Marketing Cloud using Talend Jobs.
• Generated tsv file for user migration using talend jobs and provided to external vendor. External vendor will load user data into sales force data extension.
• Once migration is done, perform Unit testing between Source data and Sales force Marketing Cloud.
• Working on Real time order management to pull the real time data for the reporting purpose using Informatica Power Center.
• Created jobs to load the data from csv files to Oracle staging using Informatica Power Center 9.6. Files are coming from external source and loading them into Oracle database. Working on data integration, using various sources of data and combining them and loading into Oracle data warehouse system.
• Worked on data conversion for different systems. Completed unit testing after data conversion.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, Lookup, Filter, Joiner, Rank, Router and Update Strategy.
• Working with Data migration Team to migrate Orders from one system (Bydesign) to another system (Oracle EBS).
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Migrating code from Dev to QA, QA to UAT and UAT to PROD. Maintaining the version control and release notes in GIT.
• Involved in Production Support activity.
• Creating the tickets for bugs and issues in JIRA and assign it to related teams.
• Extracting the user data from EBS and loading into Data Ware house.
• Wrote complex SQL Queries involving multiple tables with joins and also generated queries to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Used Debugger to test the mappings and fixed the bugs. Performance tuning of the mappings and sessions. Schedule the workflows using Informatica Scheduler.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used UNIX Shell Scripts to automate pre-session and post-session processes.
• Reviewed the defects raised by the UAT team and following up on the critical defects with the team to ensure to fix the defects.
• Basic Knowledge of Talend, Hadoop and Tableau. Hands on experienced on Tableau to create the reports.

Environment: Informatica Power Center 9.6, MySQL, Oracle EBS, Oracle 11g, UNIX, PL/SQL, SQL, UNIX Shell Scripts, TOAD 10.1.1, Putty, Erwin 8.0, SQL *Loader, GIT, JIRA, Tableau, Hadoop, Talend, Sales force Data Extension.

Confidential, Atlanta

Sr. Informatica Developer

Responsibilities:

• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Translate requirements and high-level design into detailed functional design specifications.
• Extracted data from various centers with the data in different systems like My SQL, SQL Server and loaded the data into Oracle staging using Informatica Power Center 9.5.
• Involved in Migration from Informatica Power Center 9.1 to Informatica Power Center 9.5.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Normalizer, Lookup, Filter, Joiner, Rank, Router and Update Strategy.
• Implemented the concept of slowly changing dimensions (SCD) Type I and Type II to maintain current and historical data in the dimension.
• Developed complex Informatica mappings to implement Change Data Capture (SCD) mechanism by using Type-2 effective date and time logic.
• Created critical re-usable transformations, mapplets and work lets wherever it is necessary .
• Integrated IDQ mappings, rules as mapplets within Power Center Mappings.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Wrote complex SQL Queries involving multiple tables with joins and also generated queries to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Extensively used SQL tools like TOAD, Rapid SQL and Query Analyzer, to run SQL queries to validate the data.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used UNIX Shell Scripts to automate pre-session and post-session processes.
• Developed Oracle PL/SQL Package, procedure, function and trigger.
• Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts.
• Reviewed the defects raised by the UAT team and following up on the critical defects with the team to ensure to fix the defects.

Environment: Informatica Power Center 9.5/9.1, Oracle 11g, UNIX,PL/SQL, SQL, MySQL, UNIX Shell Scripts, TOAD 10.1.1, Putty, Erwin 8.0, SQL *Loader, SQL, PL/SQL.

Confidential, Arizona

Informatica Developer

Responsibilities:

• Interacted with Business Analysts for Requirement gathering, understanding the Requirements, Explanation of technical probabilities and Application flow.
• Developed ETL mappings, transformations using Informatica Power Center 9.1.
• Extracted data from flat files, DB2 and loaded the data into Oracle staging using Informatica Power Center.
• Designed and created complex source to target mapping using various transformations inclusive of but not limited to Sorter, Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
• Extensively used Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions (SCD) and also performed reading and loading high-volume Type 2 dimensions.
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Implemented Incremental loading of mappings using Mapping Variables and Parameter Files.
• Experienced in designing and developing Informatica IDQ environment.
• Used Mapping Parameters and Mapping Variables based on business rules provided.
• Wrote PL/SQL Procedures for data extractions, transformation and loading.
• Assisted in Data Modeling and Dimensional Data Modeling.
• Involved in Performance Tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Scheduled workflow daily basis for incremental data loading.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the data load processes to target.
• Developed MLOAD scripts to load data to Teradata Data mart.
• Accomplished data movement process that load data from databases, files into Teradata by the development of Korn Shell scripts, using Teradata SQL and utilities such as FASTLOAD, FASTEXPORT, MULTILOAD.
• Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Scheduling jobs using Autosys to automate the Informatica Sessions.
• Provided Production Support at the end of every release.

Environment: Informatica Power Center 9.1, Oracle 10g, SQL Server2000/2008, UNIX, COBOL, ERWIN 3.5, Shell script, Rapid-SQL, TOAD, Teradata 12, Visio, Autosys.

Confidential, Hartford, CT

Informatica Developer

Responsibilities:

• Used Informatica Power Center 8.6 for migrating data from various OLTP databases and other applications to the Radar Store Data Mart.
• Worked with different sources like Relational, Mainframe (COBOL), XML, flat files (CSV) loaded the data into Oracle staging.
• Created complex Informatica mappings with extensive use of Aggregator, Union, Filter, Router, Normalizer, Java, Joiner and Sequence generator transformations.
• Created and used parameter files to perform different load processes using the same logic .
• Extensively used PL/SQL for creation of stored procedures and worked with XML Targets.
• Filtered Changed data using Power exchange CDC and loaded to the target.
• Defined Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
• Used different Tasks (Session, Assignment, Command, Decision, Email, Event-Raise, Event-Wait and Control) in the creation of workflows.
• Utilized the new utility Informatica Data Quality (IDQ) that came up with Informatica Version 8.
• Performed performance tuning of source level, target level, mappings and session.
• Involved in modifying already existing UNIX scripts and used them to automate the scheduling process.
• Coordinated with testing team to make testing team understand business and transformation rules being used throughout ETL process.

Environment: Informatica Power Center 8.6, Informatica Exchange, Oracle 10g, XML, UNIX, PL/SQL, Windows 2000/XP.