OBJECTIVE

• Having 8+ years as an ETL/Database analyst in an Organization that has a challenging environment giving scope to enhance my abilities and also use my knowledge and academic skills towards achieving the goal of the organization.

TECHNICAL SKILLS

Database: SQL Server 2010/2008R2, Oracle 10g, 11g SAP HANA, Netezza.

Database Tools: SQL Server Management Studio/Visual Studio, HANA Studio, TOAD, Aginity Workbench

Data Modeling Tools: CA Erwin, MS Visio.

Programming Language: C, C++, PL/SQL, Shell Scripting, Oracle

Operating Systems: Windows Server 2003/ 2008, Windows XP, Windows 7, MS - DOS, UNIX, Linux.

Others: Adobe Dreamweaver, Microsoft Office, CA WA workstation(ESP), IBM Clear quest, Clear Case, Tivoli Workflow scheduler, HPs ALM, Version 1

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica MDM Consultant

Responsibilities:

• Design and development new system modules based on the client end-user business requirements and with focus on application stability and performance.
• Experience designing and developing ETL solution using Informatica Power Center 10x versions.
• Created Informatica MDM hub console configurations like stage process configuration, load process configuration.
• Done match and merge setups like match path, match columns, match rules and tuning of match rules.
• Created cleansing functions for effective consistent master data records.
• Implemented cleansing functions such as predefined function (string functions, logic functions, math functions)
• Developed Informatica mappings using various complex transformations in Power Centre.
• Experience in Informatica performance tuning.
• Worked on different subject areas like Claims, Line item, Subscribers, Contracts and Eligibility.
• Used Jaro-Winkler Similarity algorithm logic in joining tables with fuzzy strings.
• Increased performance, Speed, Error Handling significantly by rewriting long queries.
• Developed Unit Test Cases to ensure successful execution of the data loading processes.
• Experience in maintaining EDW code base and supporting Informatica jobs after Production Deployment.
• Worked on Database Replication tasks Golden gate to replicate production data to testing environment.
• Updated legacy EDW Informatica jobs by rewriting the Oracle Queries in Source qualifier for better performance.
• Used Kan-Ban board for sprints and to track dev activities
• Self-manage time and task priorities to meet project timelines.

Environment: Informatica Power Center 9.x/10.x, Informatica MDM 10x, Microsoft Visio, SQL server, SQL Developer Management Studio/ Visual Studio, Oracle 11g, TOAD, Kanban

Confidential, NC

ETL consultant

Responsibilities:

• Attended Workshops with Users for requirements gathering, business analysis and designing of the Enterprise Data warehouse.
• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like Oracle, SQL server, flat files, and mainframe files and loading into Data Landing Zone (DLZ) and eventually to SAP HANA Database.
• Worked with 3 types of views in HANA. Attribute views, Analytical views and Calculation Views
• Lead an offshore development team in India with 5 developers.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Monitored and solved performance related issues.
• Created Excel mapping documents using Macros with the information gathered from DAW (Data Acquisition Worksheet).
• Used Informatica DVO for unit testing
• Used IDQ for data profiling and data cleansing.
• Created complex UNIX Wrapper scripts to call Workflows from UNIX to execute Informatica mappings.
• Extensively worked on Control files (Handshake with data files) as they are required for data validation.
• Scheduled UNIX scripts using CA Workload Automation ESP edition scheduler to run daily/monthly jobs.
• Loaded data into SAP HANA from Data landing zone (DLZ) for downstream teams who were trying to load data into bank analyzer.
• Used HP ALM to track defects during System Integration testing and User Acceptance testing phases.
• Created Technical Specification documents for ETL code that has been designed and developed.
• Supported Informatica jobs after Production deployment for one month with 24*7 support until warranty period.

Environment: Informatica Power center 8.8/9.1, Informatica DVO, Informatica IDQ, SAP HANA, HANA Studio, Share-point, MS Visio, CA Workload Automation ESP, TOAD, HP ALM.

Confidential, IL

Informatica MDM Consultant

Responsibilities:

• Configured and installed Informatica MDM hub server, cleanse resource kit and address doctor.
• Handled MDM console configurations like stage process configuration, load process configuration, Hierarchy manager configuration.
• Created Matcha and merge setups.
• Created cleansing functions for effective result set of mapping results.
• Configured workflows with Email Task, which would send mail with session, log for Failure of a sessions and for Target Failed Rows.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre & Post Session SQL Script to meet business logic.
• Used IBM Clear-quest tool for defect tracking.
• Scheduled Informatica workflows using Tivoli Workflow scheduler (TWS) to run workflows as per the requirement.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.

Environment: Informatica Power Center 8.5/8.6/9.1, Informatica MDM, Oracle 10g/11g, SQL, TOAD, Tivoli Workflow Scheduler (TWS), Clear-quest.

Confidential, NJ

ETL Developer

Responsibilities:

• Developed strategy for and performed ETL to populate data in OLTP database from various sources. Designed developed and optimized complex ETL mappings and stored procedures.
• Worked with Repository Manager for deploying folder from developer environment to higher environments.
• Developed SCD Type1 and Type2 Informatica mappings.
• Created complex mappings with shared objects/Reusable Transformations/ Mapplets using mapping/ Mapplets/ Parameters/Variables.
• Worked on data quality and data profiling using Informatica IDQ.
• Created test cases and documentation for unit, system, integration and system acceptance testing to ensure data quality.
• Created Source to Target Document working along BA’s