SUMMARY

• Over 7 years of professional experience in Informatica PowerCenter in all phases of analysis, design, development, implementation and support of Data warehousing applications using Informatica PowerCenter 9.6/9.x/8.x.
• Experienced in Data warehouse development, working with Data migration, Data conversion and Extraction/Transformation/Loading using Informatica PowerCenter and Informatica cloud platform.
• Solid and extensive knowledge in understanding Software Development Life Cycle (SDLC), requirement, analysis, design and implementation, review specification, testing and maintenance of applications in Agile Methodology and Agile Scrum meeting for creative work.
• Worked with various PowerCenter components like Informatica Server and client tools like Repository service, Designer, Workflow Manager and Workflow Monitor.
• Expert in dimensional Data Modeling, Fact and Dimensional tables and Slowly Changing Dimensions (SCD).
• Worked withInformatica Power Exchangeas well asInformatica cloudto load the data into Data warehouse.
• Fluidly worked on Star Schema, Snowflake Schema and Data Normalization used in Relational, Dimensional and multidimensional modeling.
• Strong knowledge in all the Informatica PowerCenter Transformations like Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator to name a few and their implementation in various scenarios in ETL process.
• Used Parameters and Variables in the Mapping to transfer the data between mappings and sessions.
• Experienced in Tuning Mappings, identifying and resolving the Performance Bottlenecks in various levels like Sources, Targets, Mappings and Sessions.
• Analyzed and efficiently developed Error Handling methods and implemented throughout the mappings and sessions in various projects.
• Worked with Oracle Stored Procedure, Table Partitions, Triggers, SQL Queries, PL/SQL Packages and loading data into Data warehouse, Data marts using Informatica.
• Hands on experiences in UNIX base operating system with the ability of writing/ debugging/ enhancing UNIX shell scripts.
• Familiar with Business Intelligence tools as Cognos, Micro Strategy, SSRS and SSAS.
• Proficient in understanding business process/requirements and translating them into technical requirements.
• Excellent communication skills, technically efficient, ability to handle pressure to meet the deadline and a good team person with ability to work independently as well.

TECHNICAL SKILLS

Email Clients: Informatica PowerCenter 9.6/9.x/8.x, Informatica Power Analyzer, Power mart, Crystal reports.

ETL Tools: Windows 10/XP/Vista, Windows 08/07, Unix, Linux, Putty, WinScp.

Operating System: Oracle 11g/10g/9i, MySql, SQL Server 2008/2012, Teradata, DB2

Databases: Dimensional Data Modeling, Star Join Schema Modeling, Snow - Flake Modeling, Erwin, Fact and Dimensional modeling, Physical and Logical Data Modeling, Oracle Designer and Power Designer

Dimensional Data Modeling: SSRS, SSAS, SAP BO, Cognos

Reporting Tools: Oracle SQL Developer, SQL Plus, Toad, MS office, Microsoft Visio, SharePoint, WinScp, Putty

Database Tools: SQL, PL/SQL, XML, Unix Shell Scripting

Languages: Outlook Express, IBM Lotus Note.

PROFESSIONAL EXPERIENCE

Confidential, Littleton, CO

ETL Informatica Developer

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Analyzed the Requirement for ETL Design and Development for extracting the data which is stored in different sources like Oracle, SQL Server, Sybase, and DB2.
• Participated in designing and developing an environment that would facilitate the use of Informatica to transform data coming from oltp into data marts.
• Used Agile Methodology for SDLC and utilized scrum meetings for creative and productive work.
• Developed complex Informatica Mappings with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Worked withInformatica Cloudto createSource /Target connections,monitor,synchronize the data in the data warehouse
• Worked withInformatica cloudfor creating source and target objects, developed source to target mappings.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created sessions, worklets, workflows for the mapping to run daily, bi weekly based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Implemented Slowly Changing Dimension type2 methodology in Informatica.
• Handled the performance issues of Informatica Mappings, evaluating current logic for tuning possibilities.
• Participated in unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly and monthly reports.
• Tuned SQL, PL/SQL Queries in Source qualifier Transformation for better performance.
• Created and executed unit test cases for various scenarios for all the mappings, workflows and scripts.
• Worked on modification of UNIX shell scripts.
• Always involved in weekly and monthly team status meetings.

Environment: Informatica PowerCenter 9.6, Oracle 11g, SQL, PL/SQL, Teradata. CDW, Erwin, MS Visio, Windows 10, UNIX, WinScp, Putty

Confidential, MADISON, WI

ETL Informatica developer

Responsibilities:

• Analyzed the business requirements, designed and developed the ETL mappings involving complex business rules.
• Developed Dimensional data modeling of the data warehouse projects by using star schema also developed Data mapping and filtering procedures.
• Used Waterfall model to extract the data in sequential non-iterative way.
• Designed and developed ETL complex mappings.
• Scheduled and Managed Informatica sessions.
• Extracted large volumes of data from Mainframes systems to target Oracle database.
• Greatly worked on Performance tuning of queries. Complex SQL queries are used for data retrieval.
• Designed, Developed and Deployed UNIX shell scripts.
• Development & Implementation of a data warehousing project and also production support for enhancements and maintenance.
• Reconciled and worked closely with architects, operations, and business units to build and deploy.
• Configured and managed Informatica servers.
• Implemented data quality management solutions that manage millions of customer transactions.
• Performed systems, data quality assurance, system testing, ensuring that software and systems perform to specification
• Established test environments and test data and advocate the use of common re-usable functions, services and data
• Engaged in quality assurance activities like reviews, walkthroughs etc.

Environment: Informatica PowerCenter 9.5, Oracle SQL, DB2, MSSQL, Cognos, SAP BO, Erwin, Putty, WINSCP, SSRS, TOAD.

Confidential, SAN FRANCISCO, CA

Informatica Developer

Responsibilities:

• Developed all data warehouse models and prepared reports for all metadata integration into systems and draft all ETL scripts and prepare required reports for all end users
• Involved in building data model for OPWR & PFC third party extracts.
• Extracted Incremental data (Change Data Capture) from Source Systems is done using the last update field on table.
• Created Mapplets to use them in different mappings.
• Scheduled all the job plans through UC4 tool.
• The tables had to be populated for use in daily load for the initial load ‘inserts’ and then updated using incremental loads and update strategy transformation.
• Wrote and tuned SQL queries for better performance.
• Developed and perform tests on all ETL codes for system data and analyze all data and design all data mapping techniques for all data models in systems.
• Monitor all business requirements and validate all designs and schedule all ETL processes and prepared documents for all data flow diagrams.
• Performed tests and validated all data flows and prepared all ETL processes according to business requirements and incorporated all business requirements into all design specifications.

Environment: Informatica PowerCenter 9.1, Oracle 9i, Toad, SQL Developer, Erwin 7.2, XML, HP Quality Center, Windows XP, UNIX

Confidential, LOS ANGELES, CA

Informatica Developer

Responsibilities:

• Developed logical and physical data models that capture current/future state data elements and data flows using ERWIN.
• Maintained the data coming from the OLTP systems.
• Developed and maintained complex Informatica mappings.
• Involved in analyzing and development of the Data Warehouse.
• Created complex mappings in Informatica PowerCenter Designer using Aggregate
• Expression, Filter, Sequence Generator, Update Strategy, Rank, Sorter, Lookup, Joiner transformations etc.
• Performed data validation tests using complex SQL statements.
• Worked with data warehouse staff to in corporate best practices from Informatica.
• Worked with Business Analysts, using work sessions, to translating business requirements into technical specifications, including data, process and specifications.
• Implemented Type II slowly changing dimensions using date-time stamping.
• Created database structures, objects and their modification as and when needed.
• Investigating and fixing the bugs occurred in the production environment and providing the on-call support.
• Performed Unit testing and maintained test logs and test cases for all the mappings.
• Testing for Data Integrity and Consistency.

Environment: Informatica PowerCenter 8.6, Power Exchange, Windows, IBM DB2 8.x, Mainframes, SQL Server 2009, Enterprise Architect, ER studio, Oracle, SQL Plus, PL/SQL, Windows 7, ERWIN.

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Analyzed source systems, business requirements and identified business rules for building the data warehouse.
• Developed Technical Specifications of the ETL process flow.
• Designed and developed Informatica mappings, workflows to load data into Oracle ODS.
• Installed and Configured Informatica PowerCenter client tools and connected with each database in Data Warehouse using repository server.
• Extensively used Informatica to load data from Oracle, XML and Flat Files to Oracle.
• Used Informatica workflow manager, monitor, and repository manager to execute and monitor workflows and assign user privileges.
• Fluently worked with Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations.
• Used debugger to test the mapping and fixed the bugs.
• Involved in tuning the performance of sessions and mappings.
• Used the Workflow manager to create workflows and tasks, and also created worklets.
• Worked on SQL stored procedures, functions and packages in Oracle.
• Scheduled and executed batch and session jobs in Autosys.
• Created and maintained UNIX shell scripts for pre/post session operations and various day-to-day operations.
• Developed unit and system test cases, using System Procedures to check data consistency with adherence to the data model defined.
• Involved in developing reports using Business Objects.

Environment: Informatica Power Center 8.6/, Oracle 9i, PL/SQL, Business Objects, Windows NT, Erwin, Autosys.