PROFESSIONAL SUMMARY:

• Informatica developer with 13 Years of strong experience in Data Warehousing Applications, Extraction, Transformation & Load (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center 10.x/9.x/8.x/7.x/6.x (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager and Informatica server), Informatica Power Exchange, Informatica Data Quality
• Strong experience in writing UNIX shell scripts for data file validation and working with Informatica components in Unix environment
• Strong experience in writing SQL using Oracle, SQL Server and DB2.
• Experience in PL/SQL development and SQL Query Tuning by analyzing Explain Plan for better performance.
• Experience in the Implementation of Informatica Data Quality (IDQ) profiling and scorecards.
• Familiarity with Informatica Administration like User Management, Folders / Project Management
• Good working knowledge in Data Modeling - dimensional data modeling, star schema/snowflake schema, Fact & dimension tables, physical & logical data modeling.
• Extensive experience in creating various Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, TCL, Update Strategy, Sequence Generator, Normalizer and Rank), Mappings, Mapplets, Sessions and Tasks (Command, Email, Decision, Event Wait, Event Raise, Timer, Assignment).
• Integrating REST/SOAP API or Web services with the application using HTTP or Web Service Consumer transformation.
• Experience include Banking, Insurance Domains
• Strong experience with Database objects, writing stored procedures, functions, triggers, DDL, DML SQL query performance tuning using Oracle 11g/10g/9i/8i, PL/SQL, SQL*Plus, SQL*Loader
• Experience in tuning Informatica Mappings and Sessions for optimum performance.
• Good experience working with Agile process
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Expert in implementing business rules by creating Re-Usable Transformations like Mapplets and Mappings
• Proficient in using Informatica Repository Manager to create & schedule sessions and batches.
• Good experience in Scheduling ETL Jobs tool like Autosys, Cron tab
• Production support, handling new enhancements and customer support.
• Hands on experience in handling/processing large volume of data in business-critical environments.
• Exceptionally well organized, strong work ethics and willingness to work hard to achieve employer objectives.
• Experience in handling defect tracking tools Service Now, JIRA/ALM.

TECHNICAL SKILL SET:

Technologies: Informatica Power Center 10.x/9.x/8.x, Informatica Power Exchange 10.x/9.x and Informatica Data Quality 9.x.

Work Model: Agile.

Other Tools: Visual source safe, Mainframe and Sales Force.

RDBMS: Oracle 11g/10g/9i/8i, SQL Server 2012/2008/2005/2000, DB2.

Operating Systems: Windows 7/2003/2013/Unix

Scheduling tools: Crontab, Autosys and Tivoli Workload Scheduler (TWS)

Modeling: Erwin

s Completed : AWS- Certified Developer Associate.

s Completed : Snowflake Data Warehouse - Hands On Essentials

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Informatica Lead Developer

Responsibilities:

• Interacted with Business partners for requirement analysis and implemented the same into a functional ETL design
• Creation of ETL design document and then ETL build.
• Involved in Project analysis Phase and Business discussion and coordination with different teams.
• Analyzed the business requirements and designed conceptual and logical data models Creation of Data models.
• Provided the Technical implementation estimates based on the functional requirements.
• Designing of data flows, process flows.
• Designed the ETL processes using Informatica to load data from XML, Oracle, SQL Server, Flat Files (Fixed Width), Excel files to staging database and from staging to the target Oracle database.
• Developed the ETL processes to handle complex business logic like to populate the clob data by using the XML generator transformation.
• Developed the ETL process to generate the HTML files for each client as per the business requirement.
• Developed the ETL processes to handle History and Incremental logic.
• Identifying performance bottle necks in informatica mappings, sessions and systems and eliminating it for better performance.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, XML Generator .
• Defined and used Mapping Parameters and Parameter files to provide values dynamically at session run time.
• Promote codebase to QA, UAT and one-time production deployment.
• Used Bitbucket, Bamboo and Release Automation tools to deploy the code to various environments.
• Error Handling: Handled in Informatica Mappings & sessions and through Validation Scripts
• Created Unix shell scripts to invoke the ETL’s.
• Created TWS job to schedule the jobs.

Technologies: Power Center 10.x/9.6, Oracle 11g, SQL Server, Unix, TWS.

Confidential, Minneapolis, MN

Informatica Lead Developer

Responsibilities:

• Interacted with Business partners for requirement analysis and implemented the same into a functional ETL design.
• Worked with Informatica power exchange to read CDC data from Mainframe source systems.
• Created Data maps in Power Exchange to fetch CDC data and Exported, imported the created data maps.
• Created Registration, Extraction groups to do the row test Power Exchange.
• Imported Mainframe source systems into Power Center through Power Exchange to get the CDC data.
• Designed the ETL processes using Power Exchange to load CDC data from Mainframe database to staging tables.
• Designed the ETL processes using Informatica to load CDC data from Oracle staging tables to the target Salesforce.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter.
• Extensively used Transformations like Expression, Aggregator, Router, Joiner, Lookup, Update strategy and Sequence generator.
• Setting up Batches and sessions to schedule the loads at required frequency using Autosys
• Estimate new requirements, enhancements and defects.
• Work with upstream systems to understand the changes on their system, doing an impact analysis on our system, provide estimations to make appropriate changes and implement the changes.
• Tuning SQL by understating explain plan and creating or dropping indexes as needed or using hints.
• Identifying performance bottle neck in informatica mappings, sessions and systems and eliminating it for better performance.
• Promote codebase to QA, UAT and one-time production deployment.
• Used Bitbucket, Bamboo and Release Automation tools to deploy the code to various environments.
• Error Handling: Handled in Informatica Mappings & sessions and through Validation Scripts
• Working with Business team to prioritize stories for sprint planning
• Manage and Co-ordinate Onsite & Off-shore teams

Technologies: Power Exchange 10.x/9.6, Power Center 9.6, Mainframes, Salesforce, Oracle 11g, Unix, TWS

Confidential, New York City, NY

Informatica Lead

Responsibilities:

• Interacted with Business partners for requirement analysis and implemented the same into a functional ETL design
• Creation of ETL Mapping Document.
• Involved in Project analysis Phase and Business discussion and coordination with different teams.
• Analyzed the business requirements and designed conceptual and logical data models Creation of Data models.
• Provided the Technical implementation estimates based on the functional requirements.
• Designing of data flows, process flows.
• Designed the ETL processes using Informatica to load data from Oracle, SQL Server, Flat Files (Fixed Width), XML and Excel files to staging database and from staging to the target Oracle database
• Developed the ETL processes to handle complex business logic for high volume data loads using various
• Developed the ETL processes to handle History and Incremental logic.
• Identifying performance bottle necks in informatica mappings, sessions and systems and eliminating it for better performance.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Stored Procedure.
• Defined and used Mapping Parameters and Parameter files to provide values dynamically at session run time.
• Promote codebase to QA, UAT and one-time production deployment.
• Created Unix shell scripts to invoke the ETL’s.
• Created AutoSys job to schedule the jobs.

Technologies: Power Center 10.x/9.6, Oracle 10g, Unix, Autosys

Confidential, New York City, NY

Informatica Lead Developer

Responsibilities:

• Interacted with Business partners for requirement analysis and implemented the same into a functional ETL design
• Participated in data modelling (logical and physical) for operational database for the review tool.
• Designed the ETL processes using Informatica to load data from Oracle, SQL Server, Flat Files (Fixed Width), XML and Excel files to staging database and from staging to the target Oracle database
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms
• Imported XML target definitions from an XML, DTD, and XML schema files
• Worked with Informatica power exchange to read the data from source systems
• Worked with ETL Web services to fetch the data from up-stream systems
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter.
• Created data profile and scorecards using IDQ to users to identify data outliers.
• Setting up Batches and sessions to schedule the loads at required frequency using Autosys
• Estimate new requirements, enhancements and defects.
• Work with upstream systems to understand the changes on their system, doing an impact analysis on our system, provide estimations to make appropriate changes and implement the changes.
• Tuning SQL by understating explain plan and creating or dropping indexes as needed or using hints.
• Identifying performance bottle neck in informatica mappings, sessions and systems and eliminating it for better performance.
• Promote codebase to QA, UAT and one-time production deployment.
• Work with Production support team to resolve/fix the job failures and deployments.
• Error Handling: Handled in Informatica Mappings & sessions and through Validation Scripts.
• Involved in preparing Test script documentation for Load Testing and involved in ping tests conducted on servers from different theaters across the globe
• Participated in weekly end user meetings to discuss data quality, performance issues, ways to improve data accuracy and new requirements, etc.
• Working with Business team to prioritize stories for sprint planning
• Involved in Capacity planning for Sprints
• Manage and Co-ordinate Onsite & Off-shore teams

Technologies: Power Center 9.1, Oracle 10g, Unix, Autosys

Confidential, NY

ETL Developer

Responsibilities:

• Designed and created Mappings, Sessions and Workflows using Informatica Power Center
• Developed the ETL processes to handle complex business logic for high volume data loads using various transformations such as Aggregator, Sorter, Filter, Normalizer, SQL Transformation, Lookup, Joiner, Router, Union etc.
• Processes to generate Daily, Weekly and Monthly data extracts were developed and the data files were sent across to the downstream applications.
• Used Source Qualifier & Lookup SQL overrides, Persistent caches, Incremental Aggregation etc for better performance.
• Implemented slowly changing dimensions to maintain current information and history information in dimension tables.
• Defined and used Mapping Parameters and Parameter files to provide values dynamically at session run time.
• Created sessions to use pre & post session SQL commands to drop & create indexes on tables for better performance.
• Used Event wait Task, Control Task, Email Tasks, Command Tasks and Link conditions in workflows.
• Write PL/SQL procedures which are called from Stored Procedure transformation to perform database actions such as truncate the target before load, delete records based on a condition, rename the tables etc.
• Created & modified Unix Shell scripts.
• Provided data loads for QA testing and worked on resolving the defects.
• Performed Informatica code migrations.

Technologies: Informatica Power Center 8.1.1, Oracle 10g, UNIX, Autosys

Confidential

ETL Developer

Responsibilities:

• Analyzing the source data and working with business users for requirements/design/development.
• Used Informatica Power Exchange for Change Data Capture in Source Tables.
• Worked with Informatica power exchange to read CDC data from Mainframe source systems.
• Created Data maps in Power Exchange to fetch CDC data and Exported, imported the created data maps.
• Extracted data from Oracle Sources and loaded them into Stage tables in SQL Server.
• Applied business logic with transformation rules in Power Center to load in to SQL Server Warehouse.
• Developed Design documents and Mapping documents.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer.
• Created Registration, Extraction groups to do the row test Power Exchange.
• Imported Mainframe source systems into Power Center through Power Exchange to get the CDC data.
• Created reusable transformations and mapplets and used them in mappings.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented slowly changing dimensions to maintain current information and history information in dimension tables.
• Wrote many SQL/PLSQL scripts to verify data in the DB.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Stored Procedure.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Created deployment groups, migrated the code into different environments.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Provided support to develop the entire warehouse architecture and plan the ETL process.

Technologies: Informatica Power Center 8.1, Power Exchange 8.1, Oracle9i, and UNIX.

Dean Health Plan

ETL Developer

Responsibilities:

• The Data has extracted from data sources using Informatica Power center as an ETL tool.
• Developed Mappings and Mapplets for implementing the Business logic.
• Used various transformations as part of mappings like Source Qualifier, Filter, Aggregator, Expression, Lookup, Sequence Generator, Joiner, and Update Strategy.
• Used Informatica Designer designed Mappings that populated the data into the Target Star schema on Oracle 8i instance
• Used mapping designer and Mapplets to generate different mappings for different loads.
• Created various Workflows, Worklets
• Created and Monitor Sessions using Informatica Workflow Manager
• Loaded data into the staging area.
• Involved in Bug Fixing for Test Defects
• Developed Pl/Sql Procedures
• Involved in Shell Scripting.
• Unit Testing using test data

Technologies: Informatica 7.1.2, Oracle, HP-UNIX 11.0