SUMMARY

• Informatica ETL Developer with over 7 Years of IT experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica Power center 10,9.X.
• Expertise in Informatica Match and Merge Rules, Batch Jobs and Groups and Proactive Monitoring tool.
• Extensive experience in Data warehousing, Data Analysis, Reporting, Development, Maintenance, Testing and Documentation.
• Expertise in System Analysis, Design, coding and testing of Data Warehousing implementations across multiple domains.
• Expertise in design, develop and maintaining Data Warehouses and Data Marts using Informatica 9.5.1/8.6.1/8.1 , Oracle, DB2, SQL Server, Teradata, Toad.
• Expertise in Creation, Modification and Testing of Informatica Mappings, Mapplets, Workflows, Worklets and debugging and performance tuning of Mappings and Sessions.
• Extensively worked on various transformations such as Lookup, Joiner, Router, Union, Sorter, Aggregator, Expression, Web Services Consumer Transformations etc.
• Strong experience in coding using SQL, PL/SQL Procedures/Functions.
• Extracted data from various Data sources like Oracle, Teradata, DB2, SQL Server, Greenplum and Worked on integrating data from flat files and XML files, COBOL Files and Web Services using Informatica.
• Extensive Experience in unit testing, User Acceptance Testing ( UAT) testing and integrated testing of entire process flow.
• Expertise in Deploying Informatica jobs from Development environment to Test environment and Test to Production Environment using Informatica export/import methodology.
• Extensive experience in Production Support environment using Autosys, Informatica, Oracle, DB2, UNIX.
• Familiar in designing Dimensional models for Landing, Cleansing and Staging areas.
• Excellent knowledge and experience in data warehouse development life cycle, requirements analysis, Implementation of star and snowflake schemas; Incremental loads, Change Data Capture and slowly changing dimensions.
• Expertise on Data Warehouse methodologies like Bill Inman, Ralph Kimball.
• Work Experience in Data Modeling Tool Erwin and knowledge on Agile.
• Knowledge on Informatica Data Quality (IDQ) and Master Data Management (MDM).
• Good Knowledge on Software Developement Life Cycle (SDLC): Requirement Gathering, Design Phase, Development Phase, Testing, Pre - Production, Production.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 10/9.x/ 8.6.1/8.5.1/8.1.1/8.0/7.1 , Power mart 6.1/5.1/4.7.

RDBMS: Oracle 11g/10g/9i/8i, SQL, PL/SQL, Teradata, SQL*Plus, SQL*Loader, MS SQL Server 2000/7.0/6.5 , MS Access 7.0/2000.

Programming Skills: Oracle SQL Developer 1.5.5, Unix Shell Scripting, SQL, Transact SQL, SQL*Plus, Java, OBIEE

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Operating Systems: Windows, UNIX, LINUX, Sun Solaris 2.7.

Scheduling tools: AutoSys, Informatica Scheduler, Unix.

PROFESSIONAL EXPERIENCE

Confidential, West Chester, PA

Informatica Developer

Responsibilities:

• Very strong ETL Development experience using Informatica PowerCenter 10.1.
• Used Informatica PowerCenter 10.1 and Power Exchange to migrate the data from DB2 (Mainframes) to SQL Server.
• Experience in Designing and Developing ETL Mapping, sessions and Workflows using Informatica PowerCenter tool.
• Worked in Oracle, SQL Server and experience using SQL Developer/AQT/SQL management Studio.
• Experience on SQL Language and worked on creating ad-hoc SQL queries for Oracle and SQL Server DB.
• Experience with Unix Shell Scripting and strong SQL knowledge.
• Quick learner, Individual Contributor and very flexible to work on developing a new application.
• Tools such as Advanced Query Tool ( AQT ) to execute SQL queries, WinSCP, etc., are used in the project.
• Experience with web services (SOAP & REST)

Confidential, Seattle, WA

ETL Developer

Responsibilities:

• Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectation.
• Used Informatica PowerCenter 9.1 and its all features extensively in migrating data from OLTP to Enterprise Data warehouse.
• Extracted data from different sources like Oracle, flat files, XML, DB2 and SQL Server loaded into DWH.
• Created complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 9.1
• Handle slowly changing dimensions (Type I, Type II and Type III) based on the business requirements.
• Automated the jobs thru scheduling using Maestro scheduler, which runs every day by maintaining the data validations
• Involved in creation of Folders, Users, Repositories and Deployment Groups using Repository Manager.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Involved in scheduling the informatica workflows using Autosys.
• Migrated mappings, sessions, and workflows from development to testing and then to Production environments.
• Involved in Performance tuning for sources, targets, mappings and sessions.
• Performed unit testing on the Informatica code by running it in the Debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum performance.
• Wrote PL/SQL stored procedures & triggers, cursors for implementing business rules and transformations.
• Worked extensively with different caches such as Index cache, Data cache and Lookup cache (Static, Dynamic, Persistence and Shared).
• Created deployment groups, migrated the code into different environments. Worked closely with reporting team to generate various reports.

Confidential, Bloomsburg, PA

Senior Informatica Developer

Responsibilities:

• Responsible for guidance on installation of PMPC software (version 3.0).
• Good knowledge on Informatica Proactive Monitoring for PowerCenter Governance and Operations.
• Familiar with events, topics, rules, watchlist, analytics, etc. in PMPC.
• Good working knowledge on PMPC.

Confidential

ETL Designer/Developer

Responsibilities:

• Successfully design and deployed ETL solutions to meet DOL requirements using Informatica 9.x.
• Designed & developed advanced applications such as Parallel loading, Pushdown optimization, Performance Tuning, End to end design & implementation of data warehousing using PowerCenter.
• Designed & developed multiple cleanse function, Graph function and standardization scenarios using AddressDoctor using IDQ.
• Involved in integrating the change in the workflow to both test and allow error handling using Informatica IDQ 9.5 and developed solutions based on the data governance.
• Extensively used Full Pushdown Optimization in Informatica to performance for DB loads.
• Worked on SQL queries, including creating the sub-queries, minus/union, and inline queries.
• Designed and developed Oracle PL/SQL scripts for Data Import/Export.
• Designed and developed data models and data processing and transformation rules for proper data representation.
• Developed dimensional modeling (e.g., Kimball, Inmon, etc.), including slowly changing dimensions, historic data capture, error capturing and reporting.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, and Indexes.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, variables and dynamic Cache.
• Performance tuning using round robin, hash auto key, Key range partitioning.
• Designed and Deployed UNIX Shell Scripts.
• Responsible for Error handling, bug fixing, Session monitoring and log analysis.
• Involved in unit testing, UAT testing and integrated testing of entire process flow.

Environment: Informatica- Power Center 9.5.1, Oracle 11g, Teradata, IDQ, Toad, Business Objects, Unix, Toad, Windows, Tidal, Autosys, Agenity Workbench.

Confidential

Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification.
• Created Informatica mappings using the transformations like Source Qualifier, Union Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Normalizer and Joiner transformations.
• Involved in Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions.
• Involved in Tuning critical Informatica jobs & database loader jobs.
• Integrated the change in the workflow to test and allow error handling using Informatica IDQ and developed solutions based on the data governance.
• Involved in data analysis and created reports using SQLs.
• Created Common objects for the ETL team to maintain the Common Code and Documented standards for Informatica code development.
• Created deployment groups and worked closely with DBAs to migrated Informatica
• Performed Unit Testing and Integration Testing and tuned ETL process for better performance.
• Transforming high-level design spec to LLDs. Designing mappings according to the mapping standards, naming standards and warehouse standards for future application development.
• Used Informatica to load data from one Oracle database to other Oracle database.
• Configured Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, Profiles using Hierarchy tool.

Environment: Informatica- Power Center 9.x, Oracle 11g, DB2, IDQ, UNIX, Toad, Windows, SQL Developer, Autosys, Shared Solutions.