SUMMARY:

• Over 12 years of experience in IT Industry with proven track record of success across industries.
• 10+ years of experience with Data warehousing / ETL development with Informatica.
• Proven history of building large - scale data processing systems and serving as an expert in data warehousing solutions while working with a variety of database technologies.
• Possesses impeccable written and verbal communication skills and analytical skills to maximize operational efficiency.

TECHNOLOGY SKILLS:

DWH: Dimensional Modeling, Data Profiling, Data Cleansing, ETL

BI: Informatica Power Center and IDQ, Tableau

Databases: Oracle, SQLServer, Teradata

Scripting: Python, UNIX

Big Data Tools: Familiar with Hadoop(YARN,HDFS,Map Reduce), Sqoop, Hive, PIG,Oozie,Hbase,Spark

Methodologies: Agile, Water Fall Model

WORK EXPERIENCE:

Senior Software Engineer

Confidential

Responsibilities:

• Worked as Lead for the project, involving in all the phases of SDLC.
• Worked with Data Architect in designing the data mart, defining, designing and building FACTS and DIMENSIONS using Star Schema model.
• Preparation of HLD, project plan based on the business functional spec.
• Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents.
• Developed Informatica workflows/worklets/sessions associated with the mappings across various sources like RDBMS, XML,flat files, Webservices, Salesforce.
• Worked exclusively on performing the ETL to Level 1 as is staging, Level 2 staging, DW load based on the business rules and transformation specifications.
• Created Informatica mappings that involved best practices, client naming conventions, Error Handling and Responsible for Performance Tuning at the Source, Targets, Transformations, Mappings and Sessions. Worked on database connections, SQL joins. Optimized Query Performance, Session Performance and Reliability .
• Designed Incremental strategy, Created Reusable Transformations, Mapplets, Mappings/Sessions/Workflows etc.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Created mappings to handle ABC (Audit, Balancing and Control) process .
• Involved in Unit Testing, Integration Testing, and User Acceptance Testing to verify the data loaded into target systems is accurate as per requirements by evaluating test scripts and Data validation rules.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the ETL defects
• Provided detailed technical, process and support documentation like daily process and detailed specifications document for DW load and Data Extracts with the workflows and their dependencies.
• Identified and eliminated duplicates in datasets thorough IDQ components
• Integrated Informatica Data Quality (IDQ) with Informatica PowerCenter and Created POC data quality mappings in Informatica Data Quality tool and imported them into Informatica power center as mappings, mapplets
• Used various Informatica Power center and Data quality transformations such as - source qualifier, aggregator, update strategy, expression, joiner, lookup, router, sorter, filter, web services consumer transformation, XML Parser, labeler, parser, address validator (Address doctor engine), standardizer, merge to perform various data cleansing, standardization and transformation

Data Warehouse Lead

Confidential

Responsibilities:

• Responsible for Designing and build data structures on MPP platform Teradata to provide efficient reporting and analytics capability.
• Involved in the ETL technical design discussions and prepared ETL high level technical design document.
• Involved in the analysis of source to target mapping provided by data analysts.
• Involved in ETL low level design and prepared design document for each of the target table
• Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, dynamic Lookup and Router transformations to extract, transform and loaded data to ODS.
• Created re-usable transformations/mapplets and used across various mappings.
• Created completed informatica mappings to load dimensions and facts to EDW area.
• Involved in performance tuning of Informatica code using standard Informatica tuning steps.

Data Migration Specialist

Confidential

Responsibilities:

• Design and Development of ETL Informatica Mappings to support Data Migration for a leading Life Insurance Provider in Japan.
• Involved in code Reviews as per ETL/Informatica standards and best practices.
• Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and load data to Cleansing area.
• Involved in Data Validation and Data Integrity checking.

Data Warehouse Developer

Confidential

Responsibilities:

• Handling of CR's (Change Requests) and enhancements for existing application and followed change management process.
• Understanding the business requirement specifications provided by the client.
• Involved in Data Quality, Data profiling, Data Cleansing and metadata management.
• Performing impact analysis and handling ETL change requests based on the business rules.
• Created design specifications for ETL coding and mapping standards.
• Created complex mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and load data to staging area.
• Wrote PLSQL procedures/Functions and called from Informatica
• Involved in test data preparation for all releases.
• Wrote Test cases and executed test scripts in Data warehouse.
• Scheduling of Informatica workflows using Autosys Scheduler.
• Establish performance and tuning methods for mappings, workflows.
• Distribution of work to onsite and offshore team and follow-ups.
• Reviewing the work and submitting the work to client with sufficient documentation.
• Created timelines for project completion and cost estimation.

ETL Developer

Confidential

Responsibilities:

• Involved in requirement analysis and development based on the business transformation specifications.
• Created Informatica mappings and sessions using Informatica.
• Wrote PLSQL procedures/Functions and called from Informatica.
• Transformed data using the Informatica Power Center transformations.
• Scheduled and executed Informatica mappings.
• Did performance tuning at mapping and session level in order to improve performance.
• Written Shell scripts to create parameter files update process.
• Created test plan, and implemented test plan and analyzed test failure.