PROFESSIONAL SUMMARY:

• 8+ years of working Experience on ETL and Databases like Oracle 10g/9i, SQL Server 2005/2008, MS Access.
• ETL and data integration experience in developing ETL mappings using Informatica Power Center 9.x/8.x.
• Experience in writing SQL queries, functions, creating Views and Stored Procedures and using them in Relational databases such as Oracle and SQL server.
• Good understanding of data warehousing, ETL architecture, waterfall and agile software development methodology.
• Experience in all phases ofSoftware Development Life Cycle (SDLC)Project Analysis, Requirements, Design
• Experience working with Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Good knowledge of OLAPandOLTP, Data modeling principles (Kimball/Inman) - Star Schema, Snowflakes, Surrogate keys, Normalization/De normalization.
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server.
• Thorough knowledge in creating DDL, DML and Transaction queries in SQL for Oracle database.
• Experience in integration and transforming of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and formats like flat-files, COBOL files, XML, etc.
• Sound knowledge of views, Synonyms, Indexes, Partitioned Tables, Joins and Sub-Queries.
• Experience in Performance Tuning, Error Handling, Production Support and debugging mappings.
• Experience with managing ODBC connections.
• Experience in Installation, Configuration, Administration, & Support of Informatica Power Center on Client or Server environment
• Strong analytical and logical programming skills long with good presentation & interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.x/8.x - Repository Admin console, Repository Manager, Designer, Workflow Manager, Workflow Monitor

Data Modeling Tool: Star Schema Modelling, Snow Flake Modelling, MS Visio, Argo UML, Erwin

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2012, MS Access, DB2, Teradata 14

Languages: SQL, PL/SQL, UNIX, HTML

Other Tools: Oracle SQL developer, TOAD, Putty, IBM Tivoli Maestro, Control-M, Rational ClearCase, Rational ClearQuest

Operating Systems: Windows, LINUX, SUN Solaris

WORK EXPERIENCE:

Confidential, Minneapolis, MN

Sr ETL/Informatica developer

Responsibilities:

• Co-ordinated with business users to understand with functional requirements. This included creating ETL Specification Document, participating in review meetings.
• Responsible for UAT team meetings for Release Sign Offs.
• Responsible for creating/review of Business Requirement documents and analysis with Business team on the given requirements.
• Participated in code review meetings.
• Worked on Informatica Power Center tool-Source Analyzer, Data Warehousing Designer, Mapping Designer, Transformation Developer, Informatica Repository Manager.
• Implemented Type II slowly changing Dimension to maintain all historical information in Dimension Tables.
• Extensively worked with Salesforce UI and imported SFDC objects into Informatica for data transformation.
• Development, Coding and Unit testing for new enhancements, maintenance work and defect fixing.
• Peer reviews.
• Migrated mappings to testing and production environments from development.
• Worked on resolving post deployment issues in test and Prod.
• Ensured quality deliverable. Maintained project timelines and deliverables.
• Implemented Slowly Changing Dimensions (SCD).
• Created complexity mappings using Aggregator, connected, unconnected and dynamic lookup, Joiner and created reusable transformations and mapplets in the mappings.
• Altered mappings to implement enhancements as part of new business requirements.
• Used Sequence generator for Surrogate keys in the dimensions to reduce the complexity and to improve the performance of composite keys.
• Brief exposure to Business Objects and Tableau to generate several on-demands and scheduled reports.
• Created E-mail notification tasks using post-session scripts.
• Used Workflow Manager to Schedule workflows and run sessions according to job dependency.

Environment: Informatica 9.1, Oracle SQL Assistant, UNIX, Google Drive, Putty, FileZilla, SQL Plus

Confidential, Dallas, TX

Sr ETL/Informatica developer

Responsibilities:

• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental load mappings to provide data for enterprise data warehouse.
• Worked on Informatica Power Center tools-Source Analyzer, Data Warehousing Designer, Mapping Designer, Transformation Developer, Informatica Repository Manager.
• Worked on SAS data conversion via Informatica and loaded it into Flat files.
• Developed Data Mappings between source systems and warehouse components using mapping designer.
• Extensively used Designer to manipulate source definitions, create Mappings, Mapplets.
• Converted procedures into mappings using various transformations like Source Qualifier, Expression, sorter, Update Strategy, Filter, Lookup, Aggregator, etc.
• Altered mappings to accommodate new business requirements due to single instance impact at the source.
• Created workflows using Session, Command, Decision, Timer and Email tasks.
• Involved in writing, Defining, Designing, modifying, and testing modules using SQL.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Conversions.
• Involved in all stages of Software Testing Life Cycle and Waterfall Model of Software Development Life Cycle (SDLC)
• Created E-mail notification tasks using post-session scripts.
• Solely responsible for the daily loads and handling the reject data.
• Created procedures to drop and recreate the indexes in the target Data Warehouse before and after the sessions.
• Migrated mappings to various environments like development, testing and production etc.
• Created Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.

Environment: Informatica Power Center 9.1/9.5,Oracle 11g, PL/SQL, HP-Unix, Erwin 4.5, Unix Shell Scripting, XML, Teradata V2R5, MS PowerPoint, SDLC,Agile,Oracle SQL Developer, TOAD 8.5, Unix, Sun Solaris 2.7.

Confidential, Richmond VA

ETL Developer

Responsibilities:

• Gathered requirements from end users, involved in analysis of source systems, business requirements and identification of business rules.
• Involved in the Data Warehouse Data modeling based on the client requirement.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Extracted sources from flat-files, Oracle, SQL Server and load them into Oracle.
• Responsible for creating system design and detail design documents based on the requirement document provided by the business users.
• Provides strategic thinking, leadership pertaining to new ways of leveraging information to improve business processes.
• Used PMREP list object commands to list associated workflows, sources, targets, mapplet, transformations, stored procedures etc.
• Experienced in database design, data analysis, development, SQL performance tuning, data warehousing ETL process and data conversions.
• Based on the logic, developed various Mappings & Mapplets to load data from various sources using different transformations like Source Qualifier, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner in the mapping. Also developed Error Processing to capture the error records and loads them into Message Log table.
• Created UNIX scripts to automate the activities like start, stop, and abort the Informatica workflows by using PMCMD command.
• Fine-tuned mappings by analyzing data flow and worked with memory cache for static and dynamic cache for the better throughput of sessions containing Lookup, Joiner and aggregator transformations.
• Addressed and tracked requests for system enhancements, improvements from end users/customer and also resolved production issues.
• Extensively used Debugger Process to modify data and applying Break Points while Session is running.
• Used various Informatica Error handling techniques to debug failed session.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data.
• Responsible for migrating the folders or mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to other Environment.

Environment: Informatica 8.6, UNIX, Windows, Oracle 10g, PL/SQL, MSSQL 2008R2, SQL, Flat Files and CSV, Putty, PL/SQL Developer.

Confidential, St Petersburg, Florida

ETL Developer

Responsibilities:

• Designed and created complex source to target mappings using various transformations including Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator and Router Transformations.
• Implemented Slowly Changing dimension type 2 methodology for accessing the full history of accounts and transaction information.
• Used built-in mapping variables/parameters and created parameter files for imparting flexible runs of sessions / mappings based on changing variable values.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Involved in error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Involved in writing Test cases and Test plans based on Source to Target Mapping documents and Data Model diagrams.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Loaded operational data from Oracle, MySQL, Mainframes, Sql server, flat files, Excel Worksheets into various data marts.
• Created Tasks and Workflows using Task Manager and Workflow Designer.
• Participated in weekly status meetings to get project updates.

Environment: Informatica PowerCenter 8.6, MySQL, Oracle 11g, SQL, PL/SQL, TOAD.

Confidential, Dallas,Texas

ETL Developer

Responsibilities:

• Participated in requirements gathering sessions with Business Analysts to understand business needs.
• Extracted data from flat files and other RDBMS databases into staging area and populated into Data Warehouse.
• Created ODBC connections to import objects from various databases such as Oracle, DB2.
• Developed mappings, sessions and workflows using Mapping Designer and Workflow Manager to perform data transformation and data loading into Oracle database.
• Created reusable transformations to clean the data, which were used in various mappings.
• Extracted data from sources like MS SQL Server 2008, DB2, flat files and loaded into the Oracle database.
• Implemented slowly changing dimensions SCD Type 1 and Type 2 to update current information and maintain history in dimension tables.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads.
• Responsible for monitoring scheduled, running, completed and failed sessions. Involved in debugging failed mappings and developing error-handling methods.
• Worked with Quality Assurance team to build test cases to perform unit, Integration, functional and performance Testing.
• Wrote Pre and Post SQL commands in session properties to manage constraints that improved performance and wrote SQL queries and PL/SQL procedures to perform database operations according to business requirements.
• Migrated mappings and workflows from Development to Test and to Production Servers.
• Performed Version Control to check in, checked out versions of objects used in creating the mappings and workflows to keep track of the changes in the development, test and production environment.
• Created E-mail notifications tasks using post-session scripts.

Environment: DataStage, Windows XP, Oracle 11g, TOAD, SQL Plus.