SUMMARY:

• Over 5+ years of IT experience in Informatica PowerCenter in all phases of Analysis, Design, Development, Implementation and support of datawarehousing applications.
• Maintenance and Enhancements in Data Warehousing and Data Integration.
• Extensively worked in Repository configuration using transformation, creating Mapping, Mapplets, Workflow, Sessions, Worklets, and processing tasks using Designer/ Workflow Manager to move the data from multiple Source system to Targets.
• Excellent in designing ETL procedures to extract data from different heterogeneous source systems like Oracle 11g/10g, SQL Server, DB2, Netezza, Flat files, XML.
• Worked exclusively in implementing the types of slowly changing dimensions (SCDs) - Type I and II in different mappings as per the requirements.
• Experience in Kimball data warehouse design and implementation methodologies
• Strong experience on understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL and SDLC (Software Development Lifecycle), Quality analysis.
• Enhancements of Data warehouse and ODS systems using Informatica Power Center 10.x/ 9.x/8.x/7.x/6.x, Oracle, DB2, SQL, PL/SQL and well versed with Data Warehousing Architecture, Technology, Operational Data
• Used features like pre-session/post-session commands/SQL, fine-tuned databases, mappings, and sessions to get optimal performance .
• Implemented slowly changing dimensions Type1, Type2 and Type3, slowly growing targets, and simple pass through mapping's using Power Center.
• Extensively involved in creating Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers
• Experience in UNIX Shell scripting .
• Experience in documenting High Level and Low-level Design , Source to Target Mapping (STM), Macro and Micro Documents, Unit test plan, Unit test cases and Code Migration Report.
• Extensive experience with relational databases Oracle 10g/11g, DB2, SQL Server,
• Working and worked in Agile methodology with sprints.
• Extensive understanding in standards of finance domain.
• Experience working with Health Industry standards HIPAA, HL7, ANSI-834/837, NCPDP.
• Possess excellent interaction, communication and problemsolving abilities.
• Strong experience in offshore and onsite coordination.

TECHNICAL SKILLS:

ETL Tools: Informatica Power center 9.6.1/8.x/7.x, Informatica Power Exchange 9.6.1/8.x, DataStage, Pentaho, Oracle Data Integrator (ODI)

Data Modeling Tools:: ERWIN, Microsoft Visio Professional, SQL Developer

Reporting Tools:: OBIEE, Cognos, Crystal reporting, Qlikview, Micro strategy

Databases: /Languages: Oracle 12/11/10/9i/8i, Microsoft SQL Server, MySQL, UNIX shell scripting, SQL/PLSQL, Netezza, Teradata, Hadoop

Other Tools: Rally, Jira, control M, Autosys, Toad, Automic.

PROFESSIONAL EXPERIENCE:

Confidential, SFO, CA

ETL/Informatica Developer:

Responsibilities:

• Designed and Developed mappings by using Lookup transformation, Expression, Sequence generator, Update, Aggregator, Stored Procedure to implement complex logics while create mappings.
• Designed ETL process using Informatica Tool to load from Sources to Targets through data Transformations.
• Worked on Informatica 10.2 and 9.6.1 Power center tools- Designer, Repository Manager, Workflow Manager and workflow monitor. Subject Matter Expert for conversion and data mapping to Netezza
• Extensively worked on SQL override in Source Qualifier Transformation for better Performance.
• Scheduled jobs using Automic tool.
• Created events, call objects to generate jobs in Automic
• Installed and configured Informatica Power Exchange CDC and for Oracle on UNIX platform.
• Designed and developed mapping using various transformations like Source Qualifier, Expression, Lookup, Aggregator, Router, Rank, Filter and Sequence Generator transformations.
• Used Informatica partitions like the Database and Pass-through for performance tuning.
• Designed and developed stored procedures using PL/SQL and tuned SQL queries for enhancing Performance.
• Involved in Reviews & Unit Testing of Mappings and Workflows.
• Used UNIX shell scripts to FTP the source files from EDI servers using the config files.
• Performed unit testing and created documents with the test cases using SQL scripts.
• Used various transformations like the Source Qualifier, Joiner, Expression, Filter, Lookup, Sequence Generator and Router to develop complex mappings using Power Center Designer.
• Worked on various types of flat files i.e. fixed width and delimited.

Environment: Informatica 9.6.1, Oracle, Teradata, Power Exchange, Flat Files, Passport, Harvest, Windows XP, UNIX and Control - M, Git.

Confidential, Madison, Wisconsin

ETL/Informatica Developer:

Responsibilities:

• Instrumental in Analysis, Requirements Gathering and documentation of Functional and Technical specifications.
• Involved in Dimensional modeling to Design and develop STAR Schemas using ERwin to identify Fact and Dimension Tables.
• Work extensively on Informatica client tools such as Designer, Workflow manager, Workflow Monitor.
• Used ETL to load data from sources such as Flat Files, Oracle to Oracle, Teradata Target Database. Based on the business requirements Reusable transformations are created in transformation developer and Mapplets in the Mapplet designer.
• Having experience in development, maintenance, support and enhancement in Informatica Power Center, Teradata, Oracle.
• Involved extensively on Linux scripting to calls a job in informatica.
• Develop complex mappings to transform the data using Rank, Sorter, Stored Procedure, Joiner, Aggregator,
• Extracted data from CDW to create delimited and fixed width flat file data feeds that go out to external sources.
• Created re-usable objects and shortcuts for various commonly used flat file and relational sources.
• Extensively used ETL for new development by applying business rules and loading data in to Teradata and Oracle based operational data store sourcing from many feeds (XML, flat files, EDI). Trickle feed to Teradata using TPT.
• Created mappings to read parameterized data from tables to create parameter files.
• Used ETL for new implementation and loading data into Teradata from multiple feeds (EDI, XML, flat files).
• Used workflow manager for creating, validating, testing and running the Sequential and Concurrent batches.

Environment: Informatica PowerCenter 9.6.1/8.6, Data Exchange (B2B), Oracle 10g, DB2, AutoSys, SQL Server 2008, PL/SQL, Teradata, Toad, ERwin 3.5, Unix

Confidential

ETL/Informatica Developer:

Responsibilities:

• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time.
• Studied the existing environment and accumulating the requirements by querying the Clients on various aspects.
• Data modeling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Used various transformations like Joiner, Aggregator, Expression, Lookup, Filter, Update Strategy and Stored Procedures.
• Created and scheduled workflows using Workflow Manager to load the data into the Target Database.
• Designed and developed data validation, load processes, test cases, error control routines, audit and log controls using PL/SQL, SQL.
• Created UNIX shell scripting and automation of scheduling processes.
• Used Update strategy and Target load plans to load data into Type-2 /Type1 Dimensions.
• Used Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability.
• Created and used reusable Mapplets and transformations using Informatica PowerCenter.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, testing of Informatica Sessions, and the Target Data.

Environment: InformaticaPowerCenter 7.1.3, MS-SQL Server 2005, PL/SQL, Stored Procedures, Informatica Data Quality, Unix (Solaris), HP Quality Center