SUMMARY

• 8+ years of IT experience in Data Warehousing technology and all phases of Software Development Life Cycle (SDLC) including Business Requirement Analysis, Application designing, Development, Implementations and Testing of Data warehousing and Database business systems for Retail, Healthcare, Financial, Insurance domains.
• 8+ years of experience in designing and development of ETL Methodology using Informatica Power Center 9.0.1/8.x/7.x/6.x.
• 8+ years of experience in working with ORACLE 11g/ 10g/ 9i/ 8i.
• 5+ years of Experience in Designing ER & Dimensional Data Models using ERWIN 7.2/4.5, ORACLE Designer.
• 5+ years of experience in Change Data Capture (CDC) Methodology using Power Exchange 9.0/8.x.
• 2+ years of experience in Teradata utilities like MLOAD, FLOAD.
• Interacted with end - users and functional analysts to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.
• Worked extensively in design and analysis of Requirements, Development, Testing and Production support
• Worked on documentation of requirements, Test data, Data movement schema and Mapping between applications.
• Extensive knowledge of Informatica tuning and SQL/PL SQL tuning.
• Experience in integration of various data sources like Oracle, SQL server and sequential files into staging.
• Conducted System, UAT and Functionality testing and investigated software bugs.
• Created and modified UNIX Shell Scripts for ETL jobs.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from Multiple Sources.
• Worked on data integration from various sources such as flat files, CSV files, COBOL files, Relational Databases into a common analytical Data Model.
• Production support experience. Extensive understanding of Production issues and Data issues.
• Excellent communication skills, ability to communicate effectively with different levels of management, strong analytical, problem solving skills.
• Working experience in Agile and Waterfall methodologies.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and PL/SQL stored procedures.
• Extensively used Slowly Changing Dimension (SCD) technique in banking application.
• Conducted Unit tests, Integration tests and Customer Acceptance tests (UAT).
• Expertise in OLTP/OLAP System Study, Analysis, E-R modeling.
• Developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Hands on experience in writing, testing and implementation of the triggers, stored procedures, functions, packages at database level and form level using SQL, PL/SQL, SQL PLUS and TOAD Extensive.
• Reference Data Management Testing experience with HP Quality Center with full SDLC, STLC understanding.

PROFESSIONAL EXPERIENCE

Confidential, North Bergen, NJ

Sr. ETL Developer

Responsibilities:

• Gathered report requirements with Business Users and converted them into project documentation.
• Arrived at the dimension model of the OLAP data marts in ERwin.
• Optimized/Tuned mappings for better performance and efficiency. Performance tuning of SQL Queries, Sources, Targets and sessions.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Understand the business needs and implement the same into a functional database design.
• Maintain Development, Test and Production mapping migration Using Repository Manager.
• Also used Repository Manager to maintain the metadata, Security and Reporting.
• Modeling and populating the business rules using mappings into the Repository for Meta Data management
• Worked on System Analysis & Design of process/data flow.
• Worked as ETL developers Lead.
• Worked on Teradata SQL and Utilities like MLOAD, FASTLOAD.
• Populating the business rules using mappings into the target tables.
• Translated the PL/SQL logic into Informatica mappings. Extensively Worked on Database stored procedures and views.
• Configured Informatica Real time workflows to capture CDC.
• Used Workflow manager to create and configure workflow and session task to load data.
• Used Informatica workflow monitor to create, monitor workflow in case of process failures. Performed testing as per UTC.
• Implemented optimization techniques for performance tuning and wrote necessary Pre & Post session shell scripts.
• Configured the sessions using workflow manager to have multiple partitions on source data and to improve performance.
• Involved in end-to-end system testing, performance and regression testing and data validations.
• Worked on Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis.

Environment: Informatica Power Center 9.0.1, Power Exchange 9.0, Teradata 13, Oracle 11g, SQL Server 2008, DB2 Mainframe, Erwin 7.5, Sun Solaris.

Confidential, Columbus, OH

Sr. Informatica Developer

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs and incorporated identified factors into Informatica mappings to build Data Marts.
• Designed and developed complex mappings using Mapping Designer to load data from various sources.
• Created Informatica Power Exchange Data Map and Registration on Mainframe source files and tables and importing them to Informatica shared folder.
• Designed and developed complex mappings (Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy) from varied transformation logics in Informatica.
• Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.
• Locate data rapidly with flexible object filtering techniques to reduce errors and speed development with a point-and-click interface using Power Exchange.
• Extensively created mapplets for reusable business rules.
• Used Pipeline partitioning and External Loader to improve Session performance, created indicator files for event driven sessions.
• Used the update strategy to effectively load data from source to target.
• Involved in Data Quality Assurance, created validation routines, unit test cases and test plan.
• Created tasks, workflows and worklets using workflow manager.
• Used pmcmd to run workflows and Autosys to automate their schedules.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business needs.
• Handled Incremental loading using mapping variables and Implemented versioning of folders in the Informatica Designer tool.
• Used Parameter files to specify DB Connection parameters for sources.

Environment: Informatica Power Center 8.6, Power Exchange 8.6, Business Objects XI, Oracle 10g, PL/SQL, SQL*Plus, SQL Server, MS Access, XML files, UNIX Shell Scripting, Linux, Windows NT/2000.

Confidential, Grand Rapid, MI

ETL Developer

Responsibilities:

• Gathering business and technical requirements for the project
• Participating in business/technical discussions to understand the report requirements, which involve client’s technical team to help us understand existing, design.
• Designing reporting environment (database) based on the reporting technical requirements.
• Develop technical design documents and mappings specifications to build Informatica Mappings to load data into target tables adhering to the business rules.
• Design and develop Extract Transform and Load (ETL) and Data Integration (ETL) solutions for complex functional and technical requirements using Informatica Power Center and Power Exchange.
• Design and develop CDC and DataMap using Power Exchange 9.1.
• Creating Power Exchange Registration and Customizing power Exchange connection property and creating restart token.
• Involved in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Slowly Changing Dimensions, Fact and Dimensional tables, Physical and Logical data modeling using Erwin.
• Hands on experience with Complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy and many more.
• Involved in migration of objects in all phases (DEV, QA and PRD) of project.
• Maintain existing code and fix bugs

Environment: Informatica Power Center 9.0.1, Informatica Power exchange 9, Oracle 10g, Toad, DB2, UNIX Shell Scripting, Flat Files, Microsoft Office

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Extensively used Informatica to transfer data from different source system and load the data into the target database.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.
• Developed number of complex Informatica mappings, mapplets and reusable transformations to implement the business logic and load the data incrementally and fine-tuned them to process millions of input records with estimated throughput.
• Used Debugger to track the path of the source data and to check the errors in mapping.
• Handled slowly changing dimensions of Type 1 and Type 2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.
• Developed Informatica mappings by usage of aggregator, SQL overrides in lookups, source filter and source qualifier and data flow management into multiple targets using router transformations.
• Extensively involved in performance tuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better session performance.
• Document the process for further maintenance and support. Worked on test cases and use cases.
• Provided production support by running the jobs and fixing the bugs.
• Taking the backup of the repository at regular interval depending on the amount of work done.
• Aided in migrating the code across various environments.
• Worked on test cases and test plans.
• Documented the process for further maintenance and production support.

Environment: Informatica Power Center 8.1, Oracle 10g, SQL Server 2005, JIRA, Harvest, Toad, Oracle 9i, UNIX, Autosys.

Confidential, Bridgeport, CT

ETL Developer

Responsibilities:

• Worked with business analyst for requirement gathering, business analysis, and testing and project- coordination.
• Created the Detail Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, shell scripts etc. and conducted meetings with the clients for the Approval of the process.
• Developed ETL mappings, Transformations and Loading using Informatica Power Center 8.6.
• Developed mappings and workflows as per business logic, quality and coding standards prescribed for the module using Informatica Power Center 8.6.
• Conducted performance tuning to increase performance of the mappings, sessions & workflows.
• Responsible to write complex SQL queries and PL/SQL procedures to perform database operations according to business requirements.
• Analyzed the existing mapping logic to determine the reusability of the code.
• Handled versioning and dependencies in Informatica.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Performing ETL & database code migrations across environments.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
• Created Unit test plans and did unit testing using different scenarios separately for every process.
• Involved in System test, Regression test & supported the UAT for the client.

Environment: Informatica Power Center 8.6, Toad, UNIX Shell Scripting, Oracle 11g, SQL Server 2005, Remedy, Jira, BO XI, Flat Files, MS Project, NCA Mainframes for CA7 Job Scheduler, Linux.