PROFESSIONAL SUMMARY:

• 8 years of IT experience in design, analysis, development, documentation, coding, and implementation including Databases, Data Warehouse, ETL Design, Oracle, PL/SQL, SQL Server databases, SSIS, Informatica Power Center 10.x/9.x/8.x/7.x, Informatica Data Quality etc...
• Strong Data Warehouse experience in using Informatica Power Center client tools like Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Well expertise on Software Development Life Cycle including requirement analysis, data mapping, build, unit testing, system integration and user acceptance testing.
• Design and implementation of Data Mart/Data warehouse using Informatica and developed transformations, mapping/mapplets, Sessions and workflows.
• Integrated various data sources like Oracle, flat files, XML, MS SQL Server and Teradata into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in designing/developing complex mapping using transformations like Connected and Unconnected Lookup, Router, Filter, Expression, Aggregator, Normalizer, Joiner, Union and Update Strategy.
• Created and maintained Informatica users and privileges.
• Strong Knowledge on E - R modeling and Dimensional Data Modeling Methodologies like Star schema and Snowflake Schema used dimensional and multidimensional modeling.
• Experience in using Informatica Utilities like Pushdown Optimization, partition and implemented SCD (Slowly Changing Dimension) Type 1, Type 2, Type 3 methodologies.
• Hands on Experience in Performance Tuning Techniques on various levels like source, target, mapping, session and databases.
• Conducted System, UAT and Functionality testing and investigated software bugs.
• Extensive experience in conducting Requirement-gathering sessions, writing Business Requirement Document (BRD), Functional Requirement Document.
• Experience in using SQL, PL/SQL, SQL*Loader, SQL*Plus, Import/Export utilities.
• Worked with Oracle Stored Procedures, Triggers, Indexes, DML, DDL, Database Links, Sequences.
• Experienced in Data Profiling, Data Mining and Cleansing.
• Worked on UNIX shell scripts used in scheduling Informatica pre/post session operations.
• Excellent communication and documentation skills using tools like Visio and PowerPoint.
• Have excellent analytical, problem solving & interpersonal skills and can work as a part of a team as well as independently.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center (10.1/9.x/8.x/7.1/6.x/5.x), Power Exchange (Power Connect), Data Quality(IDQ), Informatica Data Explorer, SSIS, Data stage, Abinitio etc.

Databases: Oracle 12c/11g/10g/9i, MS SQL Server 2008/2005/2000 , MS Access, IBM DB2, Teradata, Sybase, Netezza, DB2, etc.

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimension Tables, Physical and Logical Data Modeling.

Environment: s: UNIX, Windows 2000/XP/7, Windows server 2000/2003, HP-Unix, Linux

Languages: C, C++, Java, SQL, PL/SQL, T-SQL, HTML, DHTML, XML, UNIX, Shell Scripting, Visual basic, ASP, JSP, XML, Macromedia Software, JCL.

Tools: Toad, Visio, SQL developer, ERWIN, MS Office Suite

EXPERIENCE:

ETL Informatica Developer

Confidential, Minneapolis, Minnesota

Responsibilities:

• Interactive collaboration with business analysts and gathered functional requirements and designed technical design documents for ETL process.
• Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Operated Informatica Power Center to load data from different sources like flat files and Oracle , Teradata into the Oracle Data Warehouse .
• Worked on CDC (Change Data Capture) to implement SCD (Slowly Changing Dimensions).
• Hands On experience creating, converting oracle scripts (SQL, PL/SQL) to TERADATA scripts .
• Configure rules for power center operations team, no file monitoring, process not started, reject records and long running jobs.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Assisted the QC team in carrying out its QC process of testing the ETL components.
• Created pre-session and post-session shell scripts and email notifications.
• Involved in complete cycle from Extraction, Transformation and Loading of data using Informatica best practices.
• Involved in Data Quality checks by interacting with the business analysts.
• Performing Unit Testing and tuned the mappings for the better performance.
• Maintained documentation of ETL processes to support knowledge transfer to other team members.
• Systemized in writing UNIX Shell Scripts for scheduling various data cleansing scripts and automated execution of workflows.
• Developed ETL mappings, transformations using Informatica Power Center 9.6.
• Developed data Mappings between source systems and target system using Mapping Designer.
• Developed shared folder architecture with reusable Mapplets and Transformations.
• Extensively worked with the Debugger for handling the data errors in the mapping designer.
• Created events and various tasks in the work flows using workflow manager.
• Responsible for tuning ETL procedures to optimize load and query Performance.
• Implemented pushdown, pipeline partition, persistence cache for better performance.
• Setting up Batches and sessions to schedule the loads at required frequency using Informatica workflow manager and external scheduler(Autosys).
• Applied Business rules that identify the relationships among the data using Informatica Data Quality .
• Developed Unit test cases and Unit test plans to verify the data loading process and Used UNIX scripts for automating processes .
• Tested the mapplets and mappings as per Quality and Analysis standards before moving to production environment.
• Taken part of Informatica administration. Migrated development mappings using Deployment groups as well as hot fixing them in production environment.
• Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.

Environment: Informatica Power Center 9.6, Informatica IDQ 9.5, Power Exchange, Teradata, Data Quality Oracle12c, MS Access, UNIX Shell Scripts, Windows NT/2000/XP, SQL Server 2008, Netezza, DB2.

Informatica Developer

Confidential, Saint louis, Missouri

Responsibilities:

• Drafting the requirements, implementing design and development of various components of ETL for various applications.
• Data extraction from oracle database and spreadsheets, CSV files and staged into a single place and applied business logic to load them in the central oracle database.
• Designed and developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Informatica Designer to create complex mappings from Business requirements.
• Designed and Developed IDQ mappings for address validation / cleansing, doctor master data matching, data conversion, exception handling, and report exception data.
• Integration of various data sources like Oracle, SQL Server, Fixed Width & Delimited Flat Files, DB2.
• Involved in integration services SSIS creating packages that move data from a single data source to a destination with no transformations.
• Involved in the Unit Testing and Integration testing of the workflows developed.
• Extensively worked with Korn-Shell scripts for parsing and moving files and even for re-creating parameter files in post-session command tasks.
• Imported Source/Target Tables from the respective databases and created reusable transformations like Joiner, Routers, Lookups, Filter, Expression and Aggregator and created new mappings using Designer module of Informatica.
• Migration of code between the Environments and maintaining the code backups.
• Created different rules as mapplets, Logical Data Objects (LDO), workflows. Deployed the workflows as an application to run them. Tuned the mappings for better performance.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Developed shell scripts for running batch jobs and scheduling them.
• Handling User Acceptance Test & System Integration Test apart from Unit Testing with the help of Quality Center as bug logging tool. Created & Documented Unit Test Plan (UTP) for the code.

Environment: Informatica Power Center 9.6, Informatica Multi Domain MDM 9.1, Informatica Data Quality (IDQ) 9.5, Oracle 11g, SQL Server, PL/SQL, Unix and WINSCP, SSIS.

ETL Informatica Analyst

Confidential, Charlottesville, VA

Responsibilities:

• Analyzed the functional specifications provided by the data architect and created Technical System Design Documents and Source to Target mapping documents.
• Involved in Designing High Level Technical Documentation based on specification provided by the Manager.
• Developed the DW ETL scripts using BTEQ, Stored Procedures, Macros in TERADATA
• Integrated sources from different databases and flat files and development of scripts for loading the data into the base tables in EDW using Fast Load, Multi Load and BTEQ utilities of TERADATA.
• Extensively used ETL Tool Informatica to load data from Flat Files, Oracle, SQL Server, Teradata etc.
• Created all the Target Table DDLs and as well the Source table DDLs in Teradata.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Performance tuned ETL processes at the mapping, session and Database level by optimizing the SQL Query.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Independently perform complex troubleshooting, root-cause analysis, solution development
• Involved in end to end system testing, performance and regression testing and data validations and Unit Testing.
• Basic Informatica administration such as creating folders, users, privileges, server setting optimization, and deployment groups, etc.
• Designed Audit table for ETL and developed Error Handling Processes for Bureau Submission.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and automated execution of workflows.
• Managed Change Control Implementation and coordinating daily, monthly releases and reruns.
• Responsible for Code Migration, Code Review, Test Plans, Test Scenarios, Test Cases as part of Unit/Integrations testing, UAT testing.

Environment: Informatica Power Center 9.1.6/9.1.0 , Informatica Developer Client, Power Exchange, SAP, Oracle 11g, Teradata, PL/ SQL , TOAD, SQL SERVER 2005/2008, XML, UNIX , Windows XP.

ETL Developer / Analyst

Confidential, Warsaw, IN

Responsibilities:

• Involved in doing the Data model changes and other changes in the Transformation logic in the existing Mappings according to the Business requirements for the Incremental Fixes
• Worked with Business Analysts (BA) to analyze the Data Quality issue and find the root cause for the problem with the proper solution to fix the issue.
• Document the process that resolves the issue which involves analysis, design, construction and testing for Data quality issues.
• Worked widely with Informatica tools like Source Analyzer, Warehouse Designer, Transformation Developer, and Mapping Designer.
• Extracted data from various heterogeneous sources like DB2, Sales force, Teradata, and Flat Files using Informatica Power center and loaded data in target database.
• Defined the Match and Merge Rules in MDM Hub by creating Match Strategy, Match columns and rules for maintaining Data Quality
• Extensively worked with different transformations such as Expression, Aggregator, Sorter, Joiner, Router, Filter, and Union in developing the mappings to migrate the data from source to target.
• Used connected and Unconnected Lookup transformations and Lookup Caches in looking the data from relational and Flat Files. Used Update Strategy transformation extensively with DD INSERT, DD UPDATE, DD REJECT, and DD DELETE.
• Code walkthrough and Review of documents which are prepared by other team members.
• Developed Unix script to sftp, archive, cleanse and process many flat files
• Created and ran Pre-existing and debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager
• Extensively worked in migrating the mappings, worklets and workflows within the repository from one folder to another folder as well as among the different repositories.
• Extensively worked with session logs and workflow logs in doing Error Handling and trouble shooting.
• Used Mapping parameters and Variables and written parameter files.
• Implemented various Performance Tuning techniques by finding the bottle necks at source, target, mapping, and session and optimizing them.
• Extensively worked on SQL queries and database programming using PL/SQL (writing Packages, Stored Procedures/Functions, and Database Triggers).
• Worked on Scheduling Jobs and monitoring them through Control M.
• Worked with the SCM code management tool to move the code to Production

Environment: Informatica Power Center 9.0.1, Erwin, Teradata, Tidal, SQL Assistance, DB2, XML, Oracle 9i/10g/11g, MQ Series, OBIEE 10.1.3.2, MDM Toad and UNIX Shell Scripts.

Informatica Developer

Confidential

Responsibilities:

• Actively analyzed with business analysts and data analysts to understand and analyze the requirement to come up with robust design and solutions.
• Converted business requirements into highly efficient, reusable and scalable Informatica ETL processes.
• Utilized dimensional and star-schema modeling to come up with new structures to support drill down.
• Created mapping documents to outline source-to-target mappings and explain business-driven transformation rules.
• Involved in standardization of Data like of changing a reference data set to a new standard.
• Dealt with massive data profiling prior to data staging.
• Generated Technical Specification Documents and Solution Design Documents to outline the implementation plans for the requirements.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.5 by using various transformations like Expression, Source Qualifier, Filter, Router, Sorter, Aggregator, Update Strategy, Connected and unconnected look up etc.
• Created Informatica components required to operate Data Quality (Power Center required)
• Designed best practices on Process Sequence, Dictionaries, Data Quality Lifecycles, Naming Convention, and Version Control .
• Developed scripts for creating tables, views, synonyms and materialized views in the data mart.
• Created PL/SQL programs like procedures, function, packages, and cursors to extract data from Target System.

Environment: Informatica Power Center 9.5, Oracle11g, Teradata, UNIX Shell Scripts.

Informatica Developer

Confidential

Responsibilities:

• Interacted with business analysts and translate business requirements into technical specifications.
• Using Informatica Designer, developed mappings, which populated the data into the target.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas and the mapping designer to map the sources to the targets.
• Responsibilities included designing and developing complex Informatica mappings including Type-II slowly changing dimension s.
• Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows, tasks, shell scripts .
• Developed complex mappings/sessions using Informatica Power Center for data loading.
• Enhanced performance for Informatica session using large data files by using partitions, increasing block size, data cache size and target-based commit interval.
• Extensively used aggregators, lookup, update strategy, router and joiner transformations.
• Developed the control files to load various sales data into the system via SQL *Loader.
• Extensively used TOAD to analyze data and fix errors and develop.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion .

Environment: Informatica Power Center, Oracle 9i, PL/SQL, TOAD, UNIX, Control-M.