SUMMARY

• Around 6 years of IT Industry experience focusing on Requirement Analysis, Design, Development and Documentation and Testing. Focusing on Data Warehouse / Data Marts, Data migration using ETL Informatica Power Center, Oracle (SQL, PL/SQL) and SQL Server on Unix/Windows environments.
• Experienced in Full Lifecycle (SDLC) of various Data Warehouse / Data Mart Projects including large Integration and Migration projects.
• Responsible for all activities related to the development, implementation of ETL processes for large - scale data warehouses using ETL tool Informatica PowerCenter9.5/ 9.x/8.x
• Worked with various Informatica transformations like Source Qualifier, Sorter, Aggregator, Sequence, update strategy, Lookup, Joiner etc.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
• Extensively worked on Data Extraction, Transformation, and Loading with RDBMS, Flat files and XML. Extensively worked with SQL, UNIX Shell Scripting, Performance tuning to improve performance.
• Worked withInformaticaData Quality 9.5.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 9.5.1
• Good knowledge of Oracle Stored Procedures, Packages, Indexes, Views, & Materialized Views.
• Through knowledge in Teradata and Oracle RDBMS architecture
• Knowledge in OLAP/BI tool Cognos, Business objects.
• Experience with Data cleansing, Standardizing, Staging and Loading using ETL.
• Strong Analytical, Inter-personnel, Problem-solving and Proven ability to work under pressure.
• Good team player and ready to learn the Business Logic and new skills.
• Experienced in data analysis, data mapping, data migration, data integration, data validation.
• Worked on various globally implemented projects and multi cultured environments. Worked with testing teams and assisted them to cover all the business scenarios by preparing Test Data by applying all business rules.
• Worked with Business Users while doing User Acceptance Testing (UAT).
• Good knowledge in Data Warehousing concepts like Logical & physical Data Modeling, Star Schema, Snow flake Schema, Fact & Dimension tables, OLTP and OLAP.
• Developed Tasks/Sessions and workflows as required with session variables
• Involved in creating Reusable Transformations, Mapping Parameters, Mapping Variables and Workflow Variables.
• Expertise in developing and maintaining overall Test Methodology and Strategy, Documenting Test Plans, Test Cases and editing, executing Test Cases and Test Scripts.

TECHNICAL SKILLS

ETL Tools: Informatica 9.5/9.1//8.x/7.x (PowerCenter/Power Mart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)

Data Modeling Tools: Erwin, MS Visio, MS Office, Physical Modelling, Logical Modelling, Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams.

Databases: Oracle 11g10g/9i, MS SQL Server 2008/2005, Teradata V2R5, MS Access and DB2

Languages: SQL, PL/SQL, C, Data Structures, Unix Shell Script, Visual Basic

Web Technologies: HTML, XML, Java Script, Jquery, CSS

Tools: SQL plus, PL/SQL Developer, Toad, SQL* Loader, Active Batch API, IBM Cognos, Autosys, Erwin, SAS

Operating systems: Windows NT/2000/2003/XP/VISTA/7,UNIX,MSDOS and LINUX

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

ETL/Informatica Developer

Responsibilities:

• Worked as a Senior ETL Developer on the DLM (Dynamic Learning Maps) initiative.
• Worked with the Business Analysts to gather requirements from the business users and stakeholders.
• Involved in the process of creating Source to Target Mapping documents based on the Functional Specifications.
• Identified and created reusable pieces of code and implemented by creating Reusable Transformations and Mapplets.
• Worked with heterogeneous forms of source systems (flat files and Oracle 11g Database)
• Architected and designed a complete solution to load the DLM Data mart, created in Star Schema.
• Designed and implemented overall ETL Architect for the DLM project, including Error Reporting Strategies and Notifications.
• Created several mappings and workflows using Informatica Power Centre 9.5.
• Supported migration of ETL code from development to QA and QA to production environments.
• Worked with the QA Lead to oversee System / Functional Testing.
• Used JIRA for the maintenance and tracking of ETL bug fixes and defects.
• Worked with the Production Support team for the Migration of code between the Environments (Dev/Test and Test/Prod)
• Worked on different types of Stored Procedures to generate the mapping and batch numbers for the Informatica mappings and to update them in the target database.
• Created Production Support documentation for the client.
• Created Autosys JILs for scheduling the Informatica workflows in Production.

Environment: Informatica Power Center 9.5, Oracle 10g/9i, PL/SQL, Flat files, XML, MS Access, SQL Server 2008, VSS, Autosys, FTP client.

Confidential, Libertyville, IL

ETL/Informatica Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
• Used Informatica Power Center 9.5 for extraction, loading and transformation (ETL) of data in the datamart.
• Designed and developed ETL Mappingsto extract data from flat files, MS Excel and Oracle to load the data into the target database.
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica PowerCenter.
• Extensively used ETL processes to load data from various source systems such as DB2, SQL Server and Flat Files, XML files into target system applying business logic on transformation mapping for inserting and updating records when loaded.
• Created complex mappings to load the data mart and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.
• Ran the workflows on a daily and weekly basis using Active Batch Scheduling tool.
• Examined the workflow log files and assigning the ticket to the Informatica support based on the error.
• Experience in developing Unix Shell Scripts for automation of ETL process.
• Performed operational support and maintenance of ETL bug fixes and defects.
• Maintained the target database in the production and testing environments.
• Supported migration of ETL code from development to QA and QA to production environments.
• Migration of code between the Environments and maintaining the code backups.
• Designed and developed Unix Shell Scripts, FTP, sending files to source directory & managing session files
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Developed PL/SQL code at the database level for the new objects.

Environment: Informatica Power Center 9.5, Oracle 10g/9i, PL/SQL, Flat files, XML, MS Access, SQL Server 2008, SAS, VSS, Active Batch API.

Confidential, Eagan, MN

ETL Informatica Developer

Responsibilities:

• Responsible for Data requirements gathering, Design, Development, Unit Testing and Implementation.
• Interacted with Business users to analyze the business process and requirements. Worked with the Business Analyst and Data Modeler during the functional design and technical design phases.
• Prepared High Level (HLD) and Detail Level Documents (DLD).
• Designed and developed various Informatica Mappings using Active & Passive Transformations.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and Router.
• Implemented Slowly Changing Dimensions (Type 2) to update the dimensional schema.
• Monitored workflows and collected performance data to maximize the session performance. Unit Testing and debugging of ETL objects. Involved in reviewing the Test Cases written by the peers.
• Data quality checking and interacting with the business analysts.
• Created Task Session, Email and Workflow to execute the mappings. Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Worked on performance tuning of mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Facilitated team and client meetings effectively and held regular status meetings with project team. Resolved/ elevated issues and ensured communication of relevant project information to all stake holders.
• Used tools like TOAD and Aqua studio to run the queries and validate the data loaded into power center and different other layers like Data Warehouse.

Environment: Informatica Power Center 9.5, Cognos, Oracle 11g, SQL, PL/SQL, Toad 9.1, Netezza, UNIX, SQL Server 2008,SAS,Autosys.

Confidential, Pleasanton CA

ETL Informatica Developer

Responsibilities:

• Designed and Implemented the ETL Process using Informatica power center.
• ETL flows are developed from Source to Stage, Stage to Work tables and Stage to Target Tables.
• Worked in developing Mapplets and Re-usable Transformations for reusability and reducing effort.
• Created Work Flows with Command Tasks, Worklets, Decision, Event Wait and Monitored sessions by using workflow monitor.
• Migrated Informatica Folders from Development Environment to Test and System Test Environment and Worked with Admins to migrate the same to Production environments.
• Wrote PL/SQL procedures for reconciliation of financial data between source and target to automate testing phases and help business for preliminary validation.
• Wrote UNIX scripts, environment files for Informatica.
• Developed Metadata driven code for effective utilization and maintenance using technical metadata, business metadata and process metadata.
• To externalize the business logic instead hard coding in the mapping I have used Parameter file in Informatica.
• Generated Cognos reports to test standardized reports as per business requirements.
• Tuned Mappings and Mapplets for best Performance on ETL Side and Created Indexes and Analyzed tables periodically on Database side.
• Organized the data flow and developed many Control M jobs for Scheduling Jobs and moved to production.
• Primary resource in Production support team so, involved in emergency calls when application outage occurred and resolved defects when raised.

Environment: Informatica PowerCenter 8.6.0, SQL Server 2005, Oracle 10g, MS Excel, MS Access, Flat Files, Cognos 8.0, SQL Dev, Toad, Unix, Windows XP, Erwin, Control M.

Confidential, Hartford, CT

ETL Developer

Responsibilities:

• Used Informatica Designer for developing mappings using transformations, which includes aggregation, update strategy, lookup, and stored procedure.
• Requirement understanding from business point of view.
• Preparing the high level and low level design documents.
• Mapping Development using Informatica PowerCenter8.6.
• Developed and Monitored Tasks and Workflows using Informatica Workflow Manager.
• Preparing Unit test cases and doing unit testing.
• Solving any technical issues arising during development and integration phases.
• Bug fixing and executing Ad-hock Requests.
• Coding Data Quality edit checks.
• Defect assignment, resolving escalated issues proactively.
• Defect tracking & maintaining defect log.
• Prepare weekly/monthly status reports.
• Deployment of code in QA and Production.

Environment: Informatica Power Center 8.6, Power Mart 6.1, Power Exchange, Power Connect, Oracle 10g, DB2, MSSQL Server 2005 PL/SQL, SQL*Plus, SQL*Loader, PLSQL Developer, TOAD, UNIX, Windows XP

Confidential 

Software Engineer

Responsibilities:

• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure and Sequence Generator transformations.
• Implemented Slowly Changing Dimensions of type 1 & type 2 to store history according to business requirements.
• Used Parameter files to pass mapping and session parameters to the session.
• Tuned the Informatica mappings to reduce the session run time.
• Developed PL/SQL procedures to update the database and to perform calculations.
• Worked with SQL*Loader to load data into the warehouse.
• Developed reports in Cognos Reportnet.
• Contributed to the design and development of Cognos framework model.
• Wrote UNIX shell scripts to work with flat files, to define parameter files and to create pre and post session commands.
• Performed Unit testing and System testing of Informatica mappings.
• Involved in migrating the mappings and workflows from Development to Testing and then to Production environments.

Environment: Oracle, SQL, PL/SQL, SQL*PLUS, HP-UX 10.20, Informatica Power Centre 8.1, DB2 Cognos Report net 1.1, Windows2000