SUMMARY:

• Informatica developer with 10 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 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
• 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/snow flake schema, Fact & dimension tables, physical & logical data modeling,
• 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 and Control M
• Production support, handling new enhancements and customer support.
• Exceptionally well organized, strong work ethics and willingness to work hard to achieve employer objectives.

TECHNICAL SKILLS:

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

Work Model: Agile.

Configuration Management Tools: Visual source safe

RDBMS: Oracle, Teradata, SQL Server

Operating Systems: Windows 7/2003/2013/Unix

Scheduling tools: Cron, Autosys & Control-M

Modeling: Erwin

PROFESSIONAL EXPERIENCE:

Confidential, New York, 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.

Confidential, New York, 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 also 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, Data Quality 9.1, Talend, 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, SQL Server 2005, UNIX

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.
• 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 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.1/7.1, Oracle9i, and UNIX.

Confidential

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.
• Created various Worklets
• Created and Monitor Sessions using Informatica Workflow Manager
• 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

Confidential

Informatica Developer

Responsibilities:

• The data was extracted from multiple source systems using Informatica Power Center 6.2, as an ETL tool.
• Loading data into the staging area.
• Used Source Analyzer and warehouse designer to import the source and target database schemas and the Mapping Designer to map the sources to the target.
• Developed Mappings and Mapplets.
• Used various transformations as part of mappings like Source qualifier, Filter, Aggregator, Expression, Lookup, Sequence Generator, Joiner, and Update Strategy.
• Using Informatica Designer designed Mappings that populated the data into the Target Star schema on Oracle 8i instanceu
• Used mapping designer and Mapplets to generate different mappings for different loads.
• Involved communication with Users, Managers, and Business Analyst along with Team Leader for understanding the business and database flow.

Technologies: Informatica 6.2, Oracle 8i and UNIX