PROFESSIONAL SUMMARY:

• 7+ years of Informatica ETL and data integration experience in developing ETL Mappings, Mapplets, Workflows, Worklets and Scripts using Informatica Power Center 9.x/8.x
• Extensive experience in Analysis, Design, Development, Testing, Implementation and Maintenance of Data Warehousing projects across different domains like order management, manufacturing, healthcare and pharmaceutical.
• Extensively used ETL methodologies for supporting data Extraction, Transformation and Loading (ETL) process in a corporate - wide-ETL solution using Informatica Power Center.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, complex SQL queries using SQL Server.
• Expert in Unix Shell Scripting
• Proficient in the Integration of various data sources with Oracle, SQL Server, Flat Files, DB2, COBOL files and XML files into the staging area, Data Warehouse and Data Mart
• Expertise in Data Modeling using Star and Snowflake Schema, Fact and Dimensions tables.
• Experience in integration of various data sources like Oracle, DB2, Sybase, SQL server and MS access and non-relational sources like flat files into staging area.
• Solid Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions, creating parameter files and running batch jobs.
• Experience in creating reusable transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Strong experience in performance tuning, debugging and error handling of mappings, sources and targets for better performance.
• Strong experience in performing unit testing.
• Experience in writing stored procedures.
• Experience in dealing with various relational and dimensional data models like star schema.
• Extensive experience in creating Mapplets, Worklets, used tasks such as event wait, event raise, decision box and command tasks in Workflows.
• Proficient in various RDBMS databases including Oracle, DB2, SQL Server and Teradata
• Experienced in using Stored Procedures.
• Developed and Utilized Ad-Hoc SQL Queries to analyze the data before and after the data was loaded into Target database (Data Integrity Check)
• Strong knowledge in writing efficient & complex SQL Queries in Oracle 11g/10g/9i and in PL/SQL for stored procedures, triggers, indexes, cursor, and functions.
• Experienced in Agile /Scrum based system development.
• Proficient working with Unix/Linux environments and writing UNIX shell scripts
• Worked with different data sources non-relational Databases such as Flat files, XML files, and other relational sources such as Oracle, SQL Server, AS 400 and DB2.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling
• Strong experience in Oracle database Performance Tuning and extensive experience in SQL * Loader Imports/Exports
• Optimizing the SQL to improve the performances.
• Good experience with UNIX Shell Scripting.
• Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly with good communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/8.6 (Designer, Workflow Manager, Workflow Monitor, Repository manager)

Databases: MS Access, SQL Server 2000, Oracle 9i &10g

Database Tools: Toad, SQL Developer, Interactive SQL

Program Languages: SQL, PL/SQL, UNIX, C, C++, .NET, C#.

Operating systems: Windows 95/98/NT/2000/XP, UNIX

Web technologies: HTML, CSS, XML

Test Management Tools: HP Quality Center (QC), Microsoft Team Foundation Server (TFS)

Project Management & Data Modelling Tools: MS-Project, Microsoft Visio

Methodologies: Agile/ Scrum, Waterfall, Rapid Application Development (RAD), UML, Business Modeling, Process Modeling, Data Warehouse and Data Modeling.

PROFESSIONAL EXPERIENCE:

Confidential, Danville, PA

Sr. ETL/Informatica Developer

Responsibilities:

• Collaborated with Business analysts for requirements gathering, analysis, ETL design and development for extracting data from the heterogeneous source systems like MS SQL Server, Oracle, flat files, XML files and loading into Staging and Data Ware House Star Schema.
• Prepared technical design/specifications for data Extraction, Transformation and Loading. 
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy, Sorter and Sequence generator and Stored Procedure.
• Experience in preparing reports on the performance of the UNIX operating systems and applications run on these systems.
• Maintain the daily ETL schedule and recover the daily failures and generate the daily reports for users.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Generated standard and ad-hoc SQL reports based on complex requirements defined by clients using SQL Server 2005
• Involved in massive data cleansing prior to data staging.
• Designed and developed ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Java,XML, Ranking, Mapplets, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Developed Adhoc reports using an internal reporting tool, writing internal procedures and maintaining issues in an internal MS Access database.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre & Post Session SQL Script to meet business logic.
• Wrote complex SQL Queries using multiple joins for creating Adhoc reports using Report builder based on the requirements.
• Extracted data from a wide variety of sources like flat files, XML files, Relational Databases (Oracle, SQL Server) and from the legacy mainframe systems by using Informatica Power Exchange.
• Created UNIX shell scripts and processes to extract data from various sources such as DB2 and Oracle
• Utilized Ad-Hoc SQL Queries to analyze the data before and after the data was loaded into SQL Server 2005.
• Developed customized routine (ETL system) to capture and load data from external (Oracle 8.x,Flat files) data sources into Oracle database.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
• Created complex Cognos reports using calculated data items, multiple lists in a single report.
• Perform code reviews and executing unit testing.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Used SQL tools like Query Analyzer and TOAD to run SQL queries and validate the data.
• Create UNIX shell scripts in ksh for calling dsjobs/sequences, crons jobs for scheduling, and some other ksh scripts on an Adhoc basis.
• Worked in Agile/Scrum environment and utilized Microsoft Team Foundation Server (TFS) to manage the team's software development lifecycle including deriving product backlog items, assigning sprint work items to developers and conducting sprint review meetings.
• Prepared test scenarios and test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.

Environment: Informatica Power Center 9.1, Oracle 11g, Toad, Adhoc SQL 2012, Control-M, Teradata 12.0, Flat Files, UNIX, Windows XP, HP Quality Center, Agile/ Scrum, .NET, Unix shell scripting, SQL

Confidential, Pleasanton, CA

Informatica Developer

Responsibilities:

• Worked with Data Modeler to understand the business requirements and business rules
• Prepared ETL Specifications to help develop mapping.
• Extracted data from various sources (Flat files, SQL Server, DB2 Databases).
• Designed and developed Informatica Mappings and sessions based on business user requirements and business rules.
• Worked extensively on Source Analyzer, Mapping Designer, and   Warehouse Designer Developed several Mappings using corresponding Sources, Targets and Transformations.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Developed Shell Scripts and SQL Queries.
• Analyzed source systems (SQL server and Oracle) from Andesa third party vendor, these files were the source to the Informatica interfaces used to load data to the target downstream systems.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the Process of loading, pulling and pushing data from & to different servers.
• Created new Test plans and test queries using Auto-Recon and SQL on an ongoing basis. Assisted in data migration from ETL system to Oracle data warehouse.
• Worked for data integration between different sources to the EMC Greenplum.
• Created mappings to read from Flat files, RDBMS and to load into RDBMS tables.
• Based on business Rules Debugged code, tested and validated data after processes are run in development.
• Used PMCMD, PMREP and UNIX shell scripts for workflow automation and repository administration.
• Used PL/SQL procedures and functions in mappings to do complex database level operations with Oracle 10g.
• Developed shell scripts to automatically Email the error files to users, pre process Flat Files and to fulfill adhoc data requests.              
• Prepared and maintained mapping specification documentation.
• Modified the existing mappings for the updated logic and better performance.
• Developed Logical Data Flow Diagrams in Visio for every mapping that is developed.   Assisted QA Team to fix and find solutions for the production issues.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Environment: Informatica 9.1, DB2, ERWIN, Oracle 10g, SQL Server 2005, Visual Basic.Net, MS Access, MS Visio, Business objects 6.5,Toad, SQL, UNIX, Windows 2000, HP Quality Center, Unix shell scripting

Confidential, Chicago, IL

ETL/Informatica Developer

Responsibilities:

• Gathered business scope and technical requirements.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files and Oracle (source) to Oracle (target).
• Created different transformations for loading the data into targets using various transformations.
• Created reusable transformations and Mapplets to use the transformation logic in multiple mappings.
• Used PL/SQL procedures and functions in mappings to do complex database level operations with Oracle 10g.
• Worked on Repository manager to create and manage user profiles.
• Wrote Data loading stored procedures, functions using PL/SQL from Source systems into operational data storage.
• Scheduled Sessions on the Informatica Server using Informatica workflow Manager.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in fine tuning queries for better performance (includes indexing and pre-joining and materializing views).
• Created views and altered some of the dimensional tables to satisfy their reporting needs.
• Created reports like, Reports by Department, Reports by Supplier, Reports by Period, Demographic reports and Comparative reports.
• Created different types of reports such as Master/Detail, Cross Tab and Chart.
• Used Analyzer and Explorer to view reports from different prospect like Slice and Dice and Drill down.
• Involved in Unit testing, System testing to check whether the data loading into target is accurate, which was extracted from different source systems.

Environment: Informatica 9.1, XML, DB2, Workflow Manager, Informatica Power Connect, Workflow Monitor, Ms-Access 2007,Ms-Visio, Teradata, Oracle 9i, SQL Server 2000, PL/SQL Developer,VB.Net, Business objects 6.5,Toad, Windows 2000, UNIX, C#.

Confidential, Wayne, PA

Jr. Informatica Developer

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Developed various transformations, mappings and sessions in Informatica to load data from source to target database.
• Used various Transformations like Aggregator, Joiner, Expression, Filter, Update, Lookup, Sorter and Stored Procedure transformations to develop robust mappings in the Informatica Designer.
• Created Reusable Transformations and Mapplets to use in Multiple Mappings and also worked with shortcuts.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Dimensional modeling to Design and develop STAR Schemas by using ERWIN 4.0, identifying Fact and Dimension Tables.
• Used Debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Scheduled the sessions to extract, transform and load data in to warehouse database on Business requirements.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.

Environment: Informatica 7.1, Cognos XML, DB2,ERWIN, Oracle 9i, SQL Server 2005, Visual Basic.Net, Ms-Access, Business objects 6.5,Toad, SQL, UNIX, Windows 2000.