SUMMARY:

• Around 7+ years of IT experience in Design, Analysis and development of software applications and implementation of Data warehousing using Informatica ETL with Oracle, MS SQL, DB2 databases on windows and UNIX platforms.
• Experience in developing and maintaining Data Warehouse applications using Informatica Power Center.
• Experience in all the phases of the Data warehouse life cycle involving analyzing, developing, designing, testing, maintaining Software applications and implementing Data Mart, Data Warehouse applications and Data integration using Informatica ETL.
• Have a clear understanding of Data Warehousing concepts with emphasis on ETL and life cycle development.
• Extensively worked with data warehousing, ETL methodologies, technologies, using Informatica - Power Center Client tools - Designer, Repository manager, workflow manager/monitor and Server tools - Informatica Server, Repository Server manager.
• Developed complex mappings in Informatica using different transformations - Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, Stored Procedure transformation etc.
• Strong knowledge in Data warehousing concepts, dimensional Star Schema and Snowflake Schema methodologies.
• Excellent understanding of Software Development Life Cycle (SDLC).
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings and sessions.
• Experience in Informatica Power Center Administration and Informatica server installation, repository configuration and debugging.
• Hands on experience in tuning mappings, identifying and resolving performance in various levels like sources, targets, mappings, and sessions.
• Extensively worked with XML files as the Source and Target, used transformations like XML Generator and XML Parser to transform XML files, used Oracle XMLTYPE data type to store XML files.
• Used forInformaticadata replicators for loading the data from source to landinginto various target systems.
• Experienced in performing unit testing and to prepare testcase documents on mappings.
• Highly proficient in the integration of various data sources involving multiple relational databases like Oracle 11g/10g/9i,MS SQL Server,DB2,COBOL Files and Flat File.
• Experienced in supporting end - user reporting needs using Informatica. Competence to Manage and deliver results on multiple tasks by effectively managing time and priority constraints. Ability to address any ongoing or changing Business needs.
• Demonstrates excellent troubleshooting and analytical abilities. Ability to work in both independent and team-oriented environments.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.x/8.x/7.x (Repository Manager, Designer, Work Flow Manager, Work Flow Monitor), SSIS (SQL Server Integration Services),B2B Data Transformation,Informatica PowerExchange, Informatica Data Replication

Data Modeling Tools: Erwin, TOAD

Databases: Oracle 11g/10g/9i, MS SQL Server 2000/2005/2008

Other Tools: Oracle BI, SQL * Loader, SQL * Plus, TOAD 8.6, Autosys, DAC.

Internet Technologies and Microsoft tools: HTML, XML, MS Office toolset (Word, Excel, Visio, Power point, Share point, outlook)

Programming Languages: C, C++, Java, SQL, PL/SQL, T-SQL and UNIX Shell Scripting.

Operating Systems: Windows XP/NT/2000, Windows Vista, UNIX

Webservices: SOAP UI, Webservice Hub(WSH)

WORK EXPERIENCE:

Informatica Developer

Confidential, Pennington, New Jersey

Responsibilities:

• Mainly Involved in Informatica ETL Developing.
• Wrote SQL procedures for data extraction, transformation and loading.
• Good hands on experience in SCD Type 1 and SCD Type 2
• Tuned SQL statements and stored procedures.
• Interacted with business users and source system (OLTP) IT teams to define, agree and document incoming data mapping specifications.
• Extensively involved in ETL code using Informatica tool in order to meet requirements for extract, transformation and loading of data from source to target data structures.
• Specialized in creating Informatica ETL Mappings, Sessions and Workflows using various transformations like Update Transformation, Lookups, Filters, and Routers etc.
• Involved in identifying data discrepancies and data quality issues and worked to ensure data consistency and integrity.
• Worked on various issues on existing Informatica Mappings to produce correct output and used ETL debugger extensively to identify the performance bottlenecks within the mappings.
• Involved in migration/conversion of ETL processes from development to production environment.
• Did performance tuning of Informatica components for daily and monthly incremental loading.
• Perform the Unit testing whether the data is loading based on the business logic or not.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables

Environment: Informatica Power Center 9.1, Oracle11gR2, Flat files, UNIX shell scripting, Autosys

Informatica Developer

Confidential, Pittsburgh, PA

Responsibilities:

• Mainly Involved in Informatica ETL Developing.
• Using Informatica PowerCenter as an ETL tool to pull data from source systems, trans - forms, and load data into targets.
• Creating the mappings based on the mapping specification document and creates sessions and workflows for respective Mappings.
• Working on Power Center client tools like Source Analyzer, Target designer, Mapping Designer.
• Importing Sources and Targets from Shared Folder and used Shortcuts in Mappings.
• Prepared Pre and Post SQL Queries used in the Session Level.
• Working on the transformations such as Source Qualifier, Expression, Lookups, Filter, Router, Sorter, Joiner, Sequence Generators, Aggregators, Union, and Rank.
• Wrote detailed design specs for ETL and converted the functional specs written by Data Modelers into the detailed design spec for ETL.
• Populated slowly changing dimensions tables using SCD Type 2 to maintain full History of data.
• Checked and tuned the performance of Informatica Mappings and Involved in Defect Fixing.
• Create Sessions and Workflows and run the Workflows through Third Party tool Autosys.
• After Successful the workflows, Execute the Row Count Validation queries to check the count match between Source and Target.
• Analyzed tables, Indexes and Hints to tune the performance on long running mappings
• Creating mapplets, reusable transformations and using them in mapping.
• Create documents including data quality plan design, mapping specifications, change request form, test cases.
• Involved in Informatica data replication team and documented the PWX real time process andIDRand worked closely withInformaticaTechnical support on some of the issues.
• Perform the Unit testing whether the data is loading based on the business logic or not.
• Create and test ETL processes based on specifications.
• Support testing and Production issue resolution on newly developed or existing ETL processes.
• Troubleshoot data loading and transformation procedures for functionality and performance problems.

Environment: Informatica Power Center 8.6, Oracle 11g, SQL Developer, flat file, UNIX, PWX,IDR,Autosys.

Confidential, New York City

Responsibilities:

• Experience working in Agile Environment.
• Worked closely with business analysts to gather the requirements.
• Developed and maintained Informatica ETL (Data Extract, Transformation and Loading) mappings to extract the data from multiple source systems and loaded into staging tables.
• Worked on Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems and flat files, which includes fixed - length as well as delimited files.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, and Aggregator Transformation.
• Performed performance tuning of source level, target level, mappings and session.
• Responsible for creating and modifying the PL/SQL procedures, functions according to the business requirement.
• Designed Mappings using B2B Data Transformation Studio.
• Used Data Transformation Studio to transform unstructured to structured forms.
• Used major components like Serializer, Parser, Mapper and Streamer in Data Transformation Studio for conversion of XML files to other formats.
• Worked on optimizing PL/SQL procedures.
• Used Informatica debugger in finding out bugs in existing mappings by analyzing data flow and evaluating transformations and done unit testing for the individual developed mappings.
• Involved in IDR team to configured SQL server source for transactional replication to be used byIDRin doing Change Data capture (CDC).
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Informatica Power Center 8.6, Oracle11gR2, Flat files, XML, SQL, PL/SQL, IDR

Informatica Developer

Confidential, Dublin, OH

Responsibilities:

• Involved in gathering requirements and source system analysis and involved in data modeling.
• Involved in Designing and development of End - to-end ETL process for Sales Data Warehouse.
• Worked on Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems and flat files, which includes fixed-length as well as delimited files.
• Developed Informatica mappings, sessions and workflows to load data from various sources into respective database as per the requirement.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, and Aggregator Transformation.
• Developing several complex mappings in Informatica.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Involved in the preparation of Technical design documents, Source to target (S2T) document, Review checklist and Program Specifications or Technical Specifications.
• Involved in production support to make sure all issues are fixed in the respective turn-around times.

Environment: Informatica Power Center 8.6, Business Intelligence, SQL, Oracle11gR2, Autosys and TOAD 10.5.

Informatica Developer

Confidential, Coraopolis, PA

Responsibilities:

• Interacted with business users and source system (OLTP) IT teams to define, agree and document incoming data mapping specifications.
• Involved in leading onsite and offshore resources.
• Provided project estimations to client and upon agreement with client delivered project accordingly.
• The objective was to extract data from Flat Files and Oracle database and to initially load it into a single data warehouse repository, which was in Oracle.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.
• Designed and developed complex mappings using Aggregate, Join, Router, Look up and Update strategy transformations based on the business rules.
• Created Dynamic lookup transformation to increase the session performance.
• Extensively used ETL to load data from wide range of sources such as flat files, XML files, Oracle, Sybase.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
• Checking the data flow and extensively using SQL Queries to extract the data from the Database and conducted data quality profiling and Oracle explain plan.
• Implemented slowly changing dimensions according to the requirements, Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
• Continuously monitor the accuracy of the data and the content of the delivered reports.
• Responsible for to provide production support and resolve issues.

Environment: Informatica Power Center 8.6.2/5.1, Oracle 10g, SQL, PL/SQL, DB2, Windows XP, TOAD and UNIX.