SUMMARY

• Sr. Informatica Developer with 7+ years of experience in Information Technology and Informatica Power Center 9.1/8.6/8.5./8.1.1 with expertise on Design, Development, Administration and Implementation of various Database and Data Warehouse Technologies. Experience in writing complex SQL queries and PL/SQL, including the use of stored procedures, functions and triggers to implement business rules and validations in Microsoft SQL, Oracle 11g/10g/9i.
• Involved in all phases of SDLC from requirement gathering, development, and support for finance, banking and retail industries using Informatica PowerCenter.
• Extensively worked on creating the Mappings, Mapplets, Reusable transformations, Workflows and scheduling the Workflows and Sessions using Informatica PowerCenter.
• Full lifecycle exposure to Data Warehouse projects and Data marts with Star and Snowflake Schemas.
• Interacted with business users, IT Managers in analyzing business requirements and translating them into functional and technical specifications.
• Proficient in using Informatica Workflow Manager and Workflow Monitor to create and control workflows and tasks.
• Extensively worked on Dimensional modeling, Data migration, Data cleansing and Data Staging of operational sources using ETL processes and providing data mining features for data warehouses.
• Strong expertise in Relational data base systems like Oracle, SQL Server, DB2 and Teradata.
• Worked extensively with Slowly Changing Dimensions. (SCD Type1, Type2, Type3).
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.
• Good knowledge in developing SQL and PL/SQL code through development of procedures, functions, and packages to implement the business logic in the database server.
• Profound Experience in working with both waterfall and agile methodologies to meet regular business needs as well urgent PROD fixes or integrated business releases.
• Worked on Performance Tuning of Informatica Targets, Sources, Mappings and Sessions.
• Provided production support during client warranty period, troubleshot and resolved any production issues that have aroused.
• Sound experience in Autosys scheduling job tool to automate and schedule Informatica workflows to run with specified criteria.
• Knowledge of Database architecture for OLTP and OLAP applications, Data Analysis, ETL, Reporting processes in developing Data marts and Enterprise Data Warehouse.
• Hands on experience in creatingReusable Transformations(Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks usingWorkflow Managerto move data from multiple sources into targets.
• Hands on experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions
• Extensively usedSource Qualifier Transformationto filter data. Created different transformations such asSource Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Expertise in implementing the business rules by creating transformations (Expression, Aggregate, Source qualifier, connected and Unconnected Lookup, Router, Rank, Update Strategy) and in developing Mapplets and Mappings.
• Expert in developing complex test cases and performing unit and integration testing.
• Extensively used Informatica Power Center to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouses.
• Involved inUnit testing, System testingto check on the accuracy of data which is loaded into target from multiple sources.

TECHNICAL SKILLS

Data Warehousing/ETL: Informatica Power Center 9.1.0/8.6/8.5/8.1.1

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimension Tables, Physical and Logical Data Modeling, MS-Visio

Databases: Oracle 11g/10g/9i, Teradata, Sybase, MS SQL Server, My SQL, DB2, MS-Access

Programming: SQL, PL/SQL, SQL Plus, MS SQL, UNIX Shell Scripting, C, C++, Java, HTML, XML, CSS.

Environment: Win 2000, Win XP/Vista/7, UNIX, LINUX

Other tools & Utilities: SQL*Loader, SQL Developer, Business Objects 6.5, Teradata SQL Assistant, Erwin, IDQ, Toad, Autosys, MS-Office, DAC 11g/10g/9i.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. ETL Consultant - Informatica

Environment: Informatica Power Center 9.1.0, Informatica Data Quality, TOAD 11.6, Oracle 11g, LINUX, WinSCP, Flat files, Unix Shell Scripting.

Responsibilities:

• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Designed and customized data models for Data warehouse, supporting data from multiple sources on real time.
• Developed ETL jobs to extract information from Enterprise Data Warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data consolidation, standardization, matching Trillium for the unstructured flat file data.
• Responsible for developing the mappings from given technical document specs.
• Experience in making changes to existing mappings according to the user requirements.
• Worked with different sources from various databases like SQL server, flat files and Oracle. Loaded the data into Target table stored in an Oracle database. Done extensive Testing and developed queries in SQL to ensure the loading of the data.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Developed workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Extensively used Expression, Joiner for heterogeneous sources, look-up, filter, aggregate, and update strategy transformations to transform data before loading into the target tables.
• Implemented Slowly Changing Dimension methodology which include SCD Type 2 to keep track of historical data.
• Used Informatica debugging techniques to debug the mappings and also used session logs and bad files to trace errors occurred while data loading.
• Created stored procedures, sequences and triggers to insert key into the database table.
• Involved in fixing the Invalid Mappings, testing of stored procedures and functions, Unit and Integration testing of Informatica Sessions, Batches and Target Data.
• Developed PL/SQL programs and Informatica mappings to extract incremental data from different sources to the EDW using Informatica.
• Coordinated with the Data Architect to support data model changes or new tables design for developing new modules.
• Worked extensively for parameterizing the workflows, configuring the reusable success and failure mails, command tasks etc.
• Used UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in monitoring the workflows and in optimizing the load times.
• Interacted with Development Team daily basis and discussed on the project requirements based on the business needs and helped them with the analysis.
• Implemented and documented all the best practices used for the data warehouse.
• Worked on integration of Workday with Informatica for the data processing.
• Responsible for identifying bugs in existing mappings by analyzing data flow, evaluating transformations and fixing bugs.
• Prepared Functional Specifications, System Architecture/Design, Implementation Strategy, Test Plan & Test Cases.
• Used workday for profiling and data analysis with Informatica Power Center and the standardized data is used for reporting purpose.
• Prepared the Design documents and provided the test data characteristics.
• Played a key role in resolving the ETL issues faced during System Integration Testing (SIT).
• Performed Code review to ensure that ETL development was done according to the company's ETL standard and that ETL best practices were followed.

Confidential, Downers Grove, IL

Sr. Informatica Developer

Environment: Informatica Power Center 9.1, Oracle 10g, Teradata, IDQ, SQL* Plus, Toad, Microsoft SQL Server, DB2, Windows 7, UNIX.

Responsibilities:

• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defined ETL standards.
• Worked on Informatica tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Created Entity Relationship (ER) diagrams based on requirements.
• Created ETL mapping documents for each mapping and Data Migration documents for smooth transfer of project from development to testing environment and then to production environment.
• Created mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
• Implemented audit process to ensure the Data warehouse is matching with the source systems in all reporting perspectives.
• Profiled the data usingInformatica Data Explorer(IDE) and performed Proof of Concept forInformatica Data Quality (IDQ).
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Created various tasks like Session, Command, Timer and Event wait.
• Monitored cube backups, ETL loads, cube performance, server health checks and trouble shot issues those arise during monitoring process and provided solutions.
• Worked with Shortcuts across Shared and Non Shared Folders.
• Worked on Performance tuning of Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation logic.
• Worked on splitting the input file into multiple output files dynamically based on a key field through a table base.
• UsedTeradata utilities FastLoad, MultiLoad, TPumpto load data.
• Used PL/SQL, created Stored Procedures to delete existing data from the tables before loading.
• Worked extensively with the Teradata SQL Assistant to interface with the Teradata database.
• Created Test tables and work tables during development and production on Teradata platform.
• Collected the Stats in Teradata for all the queries after every refresh of the DB for improving the query performance.
• Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data is loaded into target is accurate, which was extracted from different source systems according to the user requirements.
• Prepared and used test data/cases to verify accuracy and completeness of ETL process.
• Created and Documented ETL test plans, test cases, expected results, assumptions and validations.
• Involved in the Production support and also transferred knowledge to the other team members.
• Wrote unit test cases, test scenarios, unit test documents and also verified the test scenarios of the QA team. Unit tested for all the possible test scenarios.

Confidential, Charlotte, NC

ETL/Informatica Developer

Environment: Informatica Power Center 9.0.1, Oracle 11g, Teradata 12.0, IDQ, LINUX, MS SQL Server, ERWIN, Autosys, WinSCP,, XML, Unix Shell Scripting and Windows 7.

Responsibilities:

• Designed ETL processes using Informatica Power Center 9.1 such as mappings, sessions and workflows to load data from CRMS Files to staging tables and then to the Final Care Gaps Database.
• Involved in all the phases of Software Development Life Cycle (SDLC), from requirement gathering to deployment.
• Created reusable transformations based on the business rules to ease the development.
• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Involved in daily scrums to understand the existing issues and gather requirements.
• Used Workflow manager for session management, database connection management and for scheduling the jobs which need to be run in the batch process.
• Worked on debugging Mappings, Mapplets, Reusable Transformations, Workflows, Worklets, and Sessions using Informatica Power Center to fix the existing defects.
• Created Checklists for Coding, Testing and Releases for a smooth, better & error free project flow.
• Responsible for Evaluation, Analysis, Design, Development and Delivery of Interfaces (ETL) using Informatica Power Center.
• Handled User Acceptance Testing & System Integration Testing apart from Unit Testing with the help of Quality Center as a bug logging tool.
• Built a re-usable staging area in Oracle for loading data from multiple source systems using template tables for profiling and cleansing in IDQ.
• Created & Documented Unit Test Plans (UTP) for the code and fixed the defects found in System Integration Testing.
• Developed Autosys JIL file to automate the task of executing the different workflows and sessions associated with the mappings on the application server as well as file control checks process on Landing Zone Utility server.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server.
• Co-ordinated the tasks between offshore and onsite on daily basis during the project life cycle.
• Reviewed the code developed by offshore and provided the necessary inputs on fixes.
• Involved in gathering suit of business requirements, prepared Source to Target Mapping specifications and Transformation rules.
• Involved in the system study and Interacted with the client in completely analyzing the requirements to design the system model.
• Implemented various loads like Daily Loads and Monthly Loads using Incremental Loading Strategy.
• Ensured the Data Marts loads, run on time accurately.
• Researched on business impact caused due to the change or any modification in the already existing ETL code.
• Written complex SQL queries in Teradata for testing the Informatica mappings.
• Involved in regular meetings with architect, DBAs and TDL to identify correct approach.
• Parameterized all Informatica codes and created Autosys jobs to run through Autosys scheduler.
• Improved performance of long running batch processes by implementing new mappings and modified existing SQL queries.
• Experience in UNIX shell scripting for Informatica pre & post session operations and database administration activities.
• Full lifecycle exposure to Data Warehouse projects and Data marts with Star and Snowflake Schemas.
• Extensively interacted with business users, IT Managers in analyzing business requirements and translating requirements into functional and technical specifications.

Confidential

ETL Consultant - Informatica

Environment: Informatica Power Center 8.6.1, Oracle BI Apps 7.9.6.1, Oracle 10g, Teradata, DAC 7.9.6, Toad, Linux.

Responsibilities:

• Created various mappings using Router, Joiner, Expression, Update Strategy, Lookup transformation, Stored Procedure and other transformations.
• Used Workflow Manager to schedule and monitor different sessions for loading data.
• Used Informatica to extract, transform and load data from multiple input sources like XML files, Flat files, and ORACLE and CSV files to Oracle 10g.
• Created different target definitions using Mapping Designer of Informatica Power Center.
• Created different transformations for loading the data into Oracle database.
• Responsible for querying data from different database tables as per the requirement.
• Responsible for implementation of standard Filters, Calculations, prompts and conditions, Formulation of Join Strategy and adding columns in catalog after they are added in already existing tables.
• Worked extensively on transformations such as the Source Qualifier, Expression, Aggregator, Connected & Unconnected lookups, Filter, Router, Sequence Generator, Sorter, Joiner, and Update Strategy.
• Worked extensively with utilities of Teradata like Multi-Load, T-Pump and BTEQ to populate the target data.
• Attended meetings to finalize strategies for handling various issues. Worked on Error Handling and slowly changing dimensions.
• Troubleshot problems by checking sessions/error logs in the Workflow Monitor and also used debugger in Mapping Designer to debug complex mappings.
• Tuned the performance of workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Enhanced performance for Informatica session using large data files by using partitions, increasing block size, data cache size, sequence buffer length and target based commit interval.
• Developed UNIX Shell scripts for data extraction and file transfers. Assisted the support team for transactional data loads.
• Performed Unit and System Testing for developed mappings.
• Documented program development, logic, coding, testing, changes and corrections.
• Worked with pmcmd to interact with Informatica Server from command mode and executed the shells scripts.

Confidential

Jr. Informatica Developer

Environment: Informatica Power center Designer 8.6, Workflow Manager, Workflow monitor, Repository manager, Oracle 10g, Toad for Oracle, SQL, UNIX.

Responsibilities:

• Developed pseudo codes and understood the technical requirements.
• Gathered all business requirements by frequently arranging meetings with BA, Source System team and Data Analyst.
• Implemented Informatica mapping logic and codes using Informatica Power Center.
• Used Aggregators, sorter, router, connected lookups transformations in developing Informatica logic.
• Parameterized all Informatica codes using generic UNIX script and automated the job run using shell script.
• Performed testing for the developed Informatica code and documented all results in spreadsheet.
• Worked with Admin in Migration of tested codes to different environment.
• Provided full-length offline support during any job failures.
• Used Update Strategy transformation to effectively migrate data from source to target.
• Moved mappings from development environment to test environment.
• Imported and created source definitions for both Relational database and flat files.
• Created Informatica mappings using various transformations like Joiner, Aggregate, Expression, Filter and Update Strategy.
• Involved in designing of testing plan (Unit testing and System testing).
• Used persistent caches whenever data from workflows were to be retained.
• Used connected and unconnected Lookups wherever appropriate, along with the use of cache option.
• Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.