SUMMARY

• Over 10 + years of experience in all phases of software development life cycle including Analysis, Design, Development & Testing of data transfers for Finance, Insurance and Healthcare Industries.
• Technical and Functional experience in Decision Support Systems - Data warehousing implementing ETL (Extract, Transform and Load) using Informatica Power Center 7x,8x,9x,10x, Informatica Data Quality 9.5.1(IDQ)
• Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts.
• Good experience in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schemas.
• Extensive knowledge on the PowerCenter components as PowerCenter Designer, PowerCenter Repository Manager, Workflow Manager and Workflow Monitor.
• Handled high volume loads using Informatica and SQL Loader.
• Good experience working with Oracle and SQL-Server RDBMS.
• Strong experience with Shell Scripting in UNIX and LINUX, SQL, PL/SQL Coding & scripting.
• Experienced in Oracle database development using PL/SQL, Stored Procedures, Triggers, Functions and Packages.
• Expertise in creating and using database objects such as Tables, Views, Indexes.
• Extensive experience on tools like SQL Developer, SQL Navigator and Toad.
• Extensively documented STTM (mapping documents), TDD (Technical design documents), IDD (Interface design document) and UT docs (Unit test case documents).
• Very strong knowledge of Informatica Data Quality transformations like Address validator, Parser, Match, Exception, Association, Standardizer and other significant transformations.
• Handson experience with Informatica MDMhub configurations-Data Mappings (Landing, staging and base tables), Data validation, Match and Merge rules, customizingconfiguring Informatica data director (IDD) applications.
• Experience in MDM implementations including Data Profiling, metadata acquisition, data migration, validation, reject processing and prelanding processing
• Experience in performance tuning of Informatica mappings, capable in identifying and resolving performance bottlenecks at various levels.
• Expertise knowledge in improving Performance and Troubleshooting of the Informatica mapping and sessions and monitoring Informatica run time statistics.
• Experience in using the Informatica Utilities like Pushdown optimization, Partitions.
• Exposure to many Reporting tools like SAP Business objects, SSRS, Tableau
• Experience working with scheduling tools like Autosys, Tidal, Control M
• Experienced in integration of various data sources (DB2-UDB, SQL Server, PL/SQL, Oracle, Teradata, XML and MS-Access) into data staging area.
• Proficient in writing, implementation and testing of triggers, procedures and functions in PL/SQL and Oracle.
• Experienced in Data Modelling as well as reverse engineering using tools Erwin, Oracle Designer and MS Visio, SQL server management studio, SSIS and SSRS and store procedure.
• Expert in unit testing, system integration testing, implementation and maintenance of databases jobs.
• Effective in cross-functional and global environments to manage multiple tasks and assignments concurrently with effective communication skills.
• Experience with multiple software development methodologies including Agile/SCRUM.

TECHNICAL SKILLS

ETL: Informatica 7.x, 8.6.1, 9.1, 10.1 MS SSIS (SQL server 2008)

Data Modeling: Erwin

Database: Oracle 10g,9i/8i, SQL Server 2008, 2010, DB2, Teradata, Netezza

Domain Skills: Insurance, Investment Banking, Finance, Healthcare

Web technologies: HTML, XML, XSLT

Operating Systems: Windows Server 2003/Xp, HP-UX, IBM-AIX 5.3, Sun Solaris, Red-Hat Linux, MS Access

Development Tools: SQL*Plus 3.3/8.0, TOAD, Microsoft Visio, Putty, Text Pad, .csv files, Erwin, ER Model, Salesforce Integration

Business Intelligence Tools: Business Objects, SSRS (SQL Server 2008), IBM Cognos 8

Scheduling Tools: Tidal, Control M, Autosys

Programming Language: ABAP/4, C, Java, SQL, PL/SQL, UNIX Shell script

PROFESSIONAL EXPERIENCE

Confidential

ETL Lead Developer

Environment: Informatica 10.1.1, 9.5, Oracle 11g, XML, SQL Server 2008, Web services, DB2 Mainframe, Tidal (Scheduler), Gits (Defect Tracker), Unix, Cognos 8(Reporting Tool)

Responsibilities:

• Worked with ETL Developers in creating External Batches to execute mappings, Mapplets using Informatica workflow designer to integrate Shire’s data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
• Designed and created BO, staging tables, mappings, transformations as per business requirements.
• Created mappings to perform the tasks such as cleansing the data and populate that into staging tables.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Identified Golden Record for Customer Data by analysing the data and duplicate records coming from different source systems.
• Helped the testing team for data integrity and consistency.
• Defined and configured schema, staging tables, and landing tables, base objects foreign-key Relationships, look up systems and tables, packages, query groups and queries/custom queries.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records
• Used Hierarchies tool, for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.
• Created mappings using Informatica Powercenter and loading data into pre-landing tables.
• Created Unit Test Case Document, Detailed Design Document, Supplementary Document and Knowledge Transfer Document.
• Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.
• Did change data capture (CDC) by using the MD5 function of Informatica.
• Developed data models according to company standards. Used DB2 Connect to extract multiple database source systems to single analytical system for large databases and 24*7 Production support for data warehousing.

Confidential, Boston, MA

ETL Developer / Designer (Lead)

Environment: Informatica 10.1.1, 9.5, Oracle 11g, XML, SQL Server 2008, Web services, DB2 Mainframe, Tidal (Scheduler), Gits(Defect Tracker), Unix, Cognos 8(Reporting Tool)

Responsibilities:

• Involved as primary on-site ETL Developer during the analysis, planning, design, development, and implementation stages of project
• Prepared Data Mapping Documents and Design the ETL jobs based with required Tables in the Dev Environment.
• Active participation in decision making and QA meetings and regularly interacted with the Business Analysts & development team to gain a better understanding of the Business Process, Requirements & Design.
• Worked with data modelers to understand financial data model and provided suggestions to the logical and physical data model.
• Developed mappings for customers, Investments and Risk analysis.
• Developed reusable Transformations.
• Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
• Worked with Data Profiling Team in analyzing the source systems data for duplicative and quality issues.
• Performed data profiling of reference data for large data sets using Informatica Data Analyst tool.
• Performed Match and Merge Rules as per business requirement on source data.
• Configured IDD application for Party master data model required for data governance used by the Data Services and analysis team.
• Created queries, procedures and packages in MDM Hub for displaying and updating the data.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Developed many complex mappings and mapplets using various transformations (Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Router, Sorter, Expression, Normalizer, Sequence Generator and Update Strategy, data standardization, address validator etc.
• Implemented SCD Type 1 and SCD Type 2 for loading data into data warehouse dimension tables.
• Implemented error handling for invalid and rejected rows by loading them into error tables.
• Implementing the Change Data Capture Process using Informatica Power Exchange Aggregator) for loading the data into Data Warehouse.
• Coordinate with team members and administer onsite and offshore work and integrate packages.
• Analyze performance and monitor work with capacity planning.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Participated in weekly status meetings.
• Developed Test Plan that included the scope of the release, entrance and exit criteria and overall test strategy. Created detailed Test Cases and Test sets and executed them manually.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Did performance tuning to improve Data Extraction, Data process and Load time.
• Designed presentations based on the test cases and obtained UAT signoffs
• Documented test scenarios as a part of Unit testing before requesting for migration to higher environment levels and handled production deployments
• Recorded defects as a part of Defect tracker during SIT and UAT
• Identified performance bottlenecks and suggested improvements.
• Performed Unit testing for jobs developed, to ensure that it meets the requirements
• Handled major Production GO-LIVE and User acceptance test activities.
• Created architecture diagrams for the project based on industry standards
• Defined escalation process metrics on any aborts and met SLA for production support ticket