SUMMARY

• 9+ years of IT industry experience in Requirements gathering, Analysis, ETL Design, Development, Testing and Implementation of Data warehousing systems using Informatica Power Center 9.5, 9.0.1, 8.6.1 and 7.1.2.
• Extensively worked on Informatica Power Center Components - Power Center Designer, Workflow Manager to create workflows and sessions, Workflow Monitor and Repository Manager.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
• Experience in working with Informatica Data Quality, Master Data Management and Informatica Data Analyst tools.
• Designed developed and implemented Master Data Management Solution Customer Party MDM Domain using MDM 9.6.1
• Good experience in working with various Data Sources like XML, CSV, Flat Files, Oracle, IBM AS400, DB2, Mainframe VSAM Files, Salesforce, PeopleSoft, SAP and SQL Server.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
• Good expertise in Performance Tuning at Database and Informatica side like Source, Target, Mapping, Transformation and Session to make them more efficient in terms of session performance.
• Good experience in Unix Shell Scripting and ETL Process Automation using Shell Programming, Informatica and Automation Scheduling tools like CA7, Autosys and Control-M.
• Extensive experience in writing complex SQL queries, PL/SQL, Stored Procedures, Packages, Views, Synonyms, and Triggers.
• Experience in documenting High Level Design, Low Level Design, Source to Target mappings (STM's), Unit test plan, Unit test cases and Deployment documents.
• Experience in working with BI reporting tools Cognos, Business Objects, Hyperion, SSRS, OBIEE.
• Experience in working with Waterfall & Agile SCRUM methodologies.
• Knowledge on Java and Talend Tool.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.5/8.6.1/7.1.0 and Informatica PowerExchange, SSIS

Databases & Tools: Oracle 11g/10g, Hbase, IBM AS/400, DB2, MS SQL Server 2008/2005, Teradata, IBM DB 2 9.5/8.0/7.0 , MS Access, Toad, Erwin and SQL Plus

Languages: Unix Shell Scripting, SQL, Java, PL/SQL, MapReduce, RPG, Visual Basic 6.0/5.0, C, XML, HTML, Sed, Grep, Ksh, Python

Reporting Tools: Cognos, Business Objects, Hyperion Essbase, SSRS, OBIEE

Scheduling & Versioning Tool: Autosys, MKS, Control-M, Ca7, SVN Subversion, Serena Dimensions and Serena Business Manager, Remedy, UC4

Environment: UNIX, Linux, Cloudera Hadoop, IBM AS/400, IBM AIX 4.2/4.3, Win 7

PROFESSIONAL EXPERIENCE

Confidential, VA

ETL / Informatica Lead

Responsibilities:

• Interacting with business owners to gather both functional and technical requirements.
• Documenting the business requirements and framing the business logic for the ETL process.
• Developing Technical specifications, System design documents and Data flow and Architecture diagrams and other helpful ETL documents following standards.
• Estimated the development effort and defined resource requirements to prepare the project plan.
• Involved in designing of Data Model, ETL Design, Data Validation for accurate data loads and working with SME’s to design the source to target design flow in business.
• Load historical and incremental data intoOracledata warehouse to enable business analysts to better understand, monitor, and analyze the trend.
• Design, develop, and testInformaticamappings, workflows, worklets, reusable objects, SQL queries, and Shell scripts to implement complex business rules.
• Analyzed the data requirements in detail with the business & technical stakeholders by conducting Joint Requirements & Development sessions and created dimensional model for the membership and enrollments DataMart by identifying required dimensions and facts using ER-Studio.
• Working on performance tuning of data feeds, implement data partitioning on ETL loads.
• Monitoring all the feed timings to understand the current performance and impact to each enhancement.
• Took the lead in Peer reviews such as code review and design review before and after the development.
• Creating test plans, test strategy after reviewing the project scope documents.
• Test the mappings and workflows developed by the developers. Creating of Test cases, test scripts, test result documents.
• Cleanse and Scrub the Data in uniform data type and format applying MDM Informatica and IDQ tools and Load to STAGE and HUB tables and then to the EDW and Finally to Dimension and rollup/aggregate the data by the business grains into the FACT tables. deploying SSIS packages and scheduling jobs in Control-M tool
• Created the Production deployment plans and deployed multiple projects into production using sub version tool.

Environment: Informatica 9.5, Informatica PowerExchange, Erwin 4.5, Oracle, PL/SQL, Autosys, Flat Files, SQL Server, UNIX Shell Scripting, Sub Version, Serina Business Manager, CA7, FTP, Python, HP Quality Cente, SQL Developer

Senior ETL Developer

Confidential

Responsibilities:

• Gather the requirements from business users and translate them into technical specifications and document it as per the standards.
• Involved in designing Informatica mappings by understanding Business Requirements and writing Technical Design Document (TDD).
• Understanding the project requirements from the ETL Specifications.
• Analyzed the existing Informatica ETL code for Business requirements towards technical architecture
• Involved in all phases of SDLC and specifically worked on Define, Build, Test, Deploy and Post Production Phases.
• Involved in tuning the existing mappings, targets, sources and SQL queries to improve the performance.
• Preparing Test plan with different scenarios based on the requirement and sharing with team members to execute the same.
• Working with metrics analysis on incidents to Ensure the projects are meeting deadline and are in right phase.
• Reviewing the code and test results to ensure the zero defect code in projects before the code moves to UAT
• Developed Unit/Integration Test Cases to ensure successful execution of the data loading processes and Performed extensive unit and Integration testing.
• Involved in debugging of the mappings using Informatica Debugger by creating breakpoints to gain troubleshooting information about data and error conditions.
• Evaluated Informatica Power exchange for CDC (Change Data Capture).
• Performance tuning of the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Used type I and type II dimensions to update and insert the information in the data warehouse.
• Developed FTP/SFTP process to move data in Flat files to receive/send from/to various systems.

Environment: Informatica 9.1, Informatica 8.6.1(Power Exchange, Power Center), AS400, DB2/400, Hyperion Essbase, DB 2 9.5/8.0/7.0 , Oracle 10g, Python, Toad for Oracle 11

ETL Developer

Confidential

Responsibilities:

• Understanding of the business requirements and enhancing the existing data warehouse architecture design for a better performance.
• Responsible for Design, Development and automation of ETL processes using Informatica PowerCenter.
• Created new mappings and modified the existing mapping specification documents in order to fit the changes made in the staging and target data model.
• Established modular development strategies to expedite development and simplify maintenance.
• Extensively/Efficiently used different Informatica transformations (connected/unconnected Lookups, Filter, Router, Sorter, Aggregator, Joiner, Expression, Stored procedures, Normalizer, Update strategy and Rank) in loading data effectively into Warehouse.
• Extensively created and used Source/Target definitions and their shortcuts, Mapplets, Worklets and Reusable Transformations to prevent redundancy of transformation usage and to help increase reusability and maintainability.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation (SCD Type-2).
• Involved in tuning of the mappings with audit, error design and reprocessing strategies.
• Created UNIX program to preprocess data in files before loading into Data Warehouse tables.
• Tuned existing mappings, targets, sources and SQL queries to improve the performance.
• Ensured timely completion of development projects within estimated standards.
• Involved in Writing Shell scripts in performing data validations on input data files.
• Resolved Production issues as and when assigned.
• Participated in weekly end user meetings to discuss data quality, performance issues, ways to improve data accuracy and new requirements.
• Involved in QA Testing and User Acceptance testing to ensure that all the business requirements are delivered.

Environment: Informatica PowerCenter 8.6, Teradata 12, Oracle10g, DB2, AutoSys, Toad 9.5 and Linux.

Informatica Developer

Confidential

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data
• Consolidation, standardization, matching Trillium for the unstructured flat file data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.5.
• Experience in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Copied/Exported/Imported the mappings/sessions/worklets/workflows from development to Test Repository and promoted to Production.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX

Environment: Informatica Power Center 8.5, Oracle 10g, PL/SQL, SQL Server 2005, DB2, SQL*Plus, SQL Loader, SQL Developer, Autosys, Flat files, UNIX, Windows 2000

Informatica Developer

Confidential

Responsibilities:

• Developed various mappings, which extracts data from OLTP server, Flat files into target tables to simplify business process across organization via single platform.
• Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Used various transformations like Source Qualifier, Lookup, Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
• Used Debugger and Analyzed session logs, bad files and error tables in troubleshooting the mappings and sessions.
• Generated Reusable Transformations, Mapplets and used them extensively in various mappings.
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, Batch jobs/Worklets and Workflows.
• Created several mappings using various Informatica Transformations: Lookups, Update Strategy, Aggregator, Source Qualifier, Joiners, Ranks, Sorter, Expression, Filter etc.

Environment: Informatica PowerCenter 7.1, AS/400, DB2, Oracle 10g, Cognos, Toad 7.1 and UNIX, VSS, SQL