SUMMARY:

• Have 8+ years of professional work experience in Data warehousing and informatica ETL data integration process with broad understanding of OLAP and Data Quality concepts.
• Strong knowledge in Requirement Analysis, Application Development and Maintenance, Functional Studies, Quality Reviews and Testing.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Good understanding of views, Synonyms, Indexes, Joins and Sub-Queries..
• Involved in creating detailed design documents and performing Proof of Concepts (POC).
• Created mapplets, common functions, reusable transformations, look-ups for better usability.
• Have wide knowledge in healthcare domain like provider, claims etc
• Experience in Performance tuning of ETL process. Reduced the execution time for huge volumes of data.
• Experience in UNIX commands and shell scripting .
• Experienced in working with Tivoli Job Scheduling tool.
• Worked withInformaticaData Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Responsible for providing temporary/permanent fixes and give status update on the defects raised to SQA Team in daily vendor calls.
• Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules. ExtensivelyworkedonData Extraction, Transformation, and Loading with RDBMS, Flat files, XML files
• Extensively worked with all powercenter client tools like Designer, Workflow Manager,Workflow Monitor
• Worked exclusively on implementing the types of Slowly changing dimensions (SCDs)-Type I II and III in different mappings as per the requirements.
• Experience in testing and fixing the bugs.
• Interact with Database, Informatica Administrators on environmental issues and work on fixing the issues
• Worked extensively in Informatica Power Center 8.6 & 9.1.
• Proficient in Oracle Database and UNIX Shell Scripting.
• Ability to work collaboratively and understanding of business requirements and system architecture.
• Been part in writing technical requirement documents and low level design documents.
• Hands on experience in tuning SQL queries, identifying and resolving performance bottlenecks.
• Conversant with Software Development Life cycle and SEI-CMMI level 5 Quality Processes while executing projects
• Good team player with good problem solving and communication skills.
• Received client appreciation award of the year 2013 for passion towards learning and effectively scaling up in Data Feed application.

TECHNICAL SKILLS:

Tools: Data Warehousing

Technology: Informatica Power Center 9.1.0/9.0.1 ,8.6.1,8,IDQ

Databases: Oracle 10g/9i, DB2,Teradata

Programming Languages: C, C++, SQL, PL/SQL, UNIX, XML

Other Utilities: PUTTY,TOAD

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Lead Sr.Developer

RESPONSIBILITIES:

• Understanding existing business model and customer’s new requirements.
• Conducted brainstorming sessions and system walk through and worked with SME’s to come up with Technical requirements document.
• Prepare ETL Design Documentation & Conducted Design walk-through sessions.
• ETL performance optimization.
• Extracted Claim data from Flat files, and populated into EDW(Oracle)
• Developed Complex transformations, Mapplets using Informatica Power Center 9.1.0 to Extract, Transform and load data into Enterprise Data warehouse (EDW) and Operational data store (ODS).
• Identified and eliminated duplicates in datasets thorough IDQ 8.6.1 components of Edit Distance, Jaro Distance and Mixed Field matcher, It enables the creation of a single view of customers, help control costs associated with mailing lists by preventing multiple pieces of mail.
• Prepared software requirement specifications, business rules interacting with business units and designed Star schema, logical and physical database design for Domains.
• Developed data Mappings, Transformations between source systems and warehouse
• Performed Type1 and Type2 mappings
• Effectively documented all Development work done. (LLD)
• Implemented Aggregate, Filter, Join, Expression, Lookup and Update Strategy, XML,Normalizer,transformations.
• Used debugger to test the mapping and fixed the bugs.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL
• Created Workflows with worklets, event wait, decision box, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Prepared Unix shell script as per business Requirement
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies.
• Used automated CBR script for Auditing.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations
• Extensively used dynamic parameter files
• Code development, UTC, testing different scenarios and documenting the result, working on defect fixes from System Testing & User Testing.
• Migration workbook creation and tracking the code versions.

Confidential, New Jersey

Sr. Developer

Responsibilities:

• Member and member reconciliation interface was handled.
• Coordinate with Team Lead and Client to understand and analyze business requirements.
• Created Expression, Lookup, Filter, Router, Aggregator Transformations were implemented to load the data from source to Target using Designer.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Involved data partitions and for the sessions having huge data and feeding set of data to the mapping pipeline.
• Developed transformation logic and designed various Complex Mappings using the Designer
• Extensively used SQL to analyze the data.
• Experienced in handling large volumes of data.
• Analyzing the requirement
• Code developed based on the business requirement
• Created Unit Test cases and captured Test logs

Confidential

ETL Developer

Responsibilities:

• Analyzed Customer requirements and prepared design/mapping documents.
• Designing and Development of Mappings using Informatica Power Center Designer Tool as well as involved in Application End to End ETL Testing phase.
• Created new ETL Informatica routines as per the business requirements.
• Created different mappings for loading the data into Oracle database e.g. Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Expressions, Aggregator, Sequence Generator and Normalizer.
• Created different mappings for loading the data into Oracle database. update on the defects raised to SQA Team in daily vendor calls. Interact with Database, Informatica Administrators on environmental issues and work on fixing the issues
• Prepared unit test cases for the created new ETL routines.
• Developed SQL queries for data reconciliation/Audit.
• Tested ETL code in Dev, SIT & UAT environments to ensure defect free code.
• Provided Development support for System Testing/User acceptance testing. activities like preparation of LLD (Low Level Design) Document, ETL (Extract Transform Load) build, plans and conducts ETL unit and development, tests, monitors results and takes corrective action, when necessary.
• Taken care of pre-production activities like Clear Quest tickets, Migration checklist, Run plan etc.
• Tracked Confidential status by submitting weekly/Monthly Confidential status report and participated in triage calls.
• Trained new joiners in understanding the business.

Confidential

ETL Developer

Responsibilities:

• Analyzed Customer requirements and prepared design/mapping documents.
• Worked on Data profiling to validate data related assumptions.
• Suggested data model changes as required.
• Prepared unit test cases for the modified existing ETL routines.
• Creating the SQL queries based on source to target mappings for Target tables.
• Prepared the alter scripts to alter the length and data type.
• Provided Development support for System testing.
• Created Expression, Lookup, Filter, Router, Aggregator Transformations were implemented to load the data from source to Target using Designer
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor
• Developed transformation logic and designed various Complex Mappings using the Designer
• Extensively used SQL to analyze the data.
• Experienced in handling large volumes of data.
• Analyzing the requirement
• Code developed based on the business requirement
• Develop an ETL mapping as per Business requirement, developing SQL queries to perform audit between source, staging and Target data.
• Responsible for identifying the error validations and generating the count statistics. Created re-usable Mapplet, transformations,
• Once components get migrated to production, it is necessary to involve in supporting process
• During the support it is necessary to share the daily status of load run and Incident Management tickets opened in SharePoint to business during daily calls.
• Created Unit Test cases and captured Test log

Confidential

ETL Developer

Responsibilities:

• Understanding existing business model and customer’s new requirements.
• Prepare ETL Design Documentation & Conducted Design walk-through sessions
• ETL performance optimization.
• Code development, UTC, testing different scenarios and documenting the result, working on defect fixes from System Testing & User Testing.
• Tested ETL code in Dev, SIT & UAT environments to ensure defect free code.
• Provided Development support for System Testing/User acceptance testing.
• Migration workbook creation and tracking the code versions

Confidential

ETL Developer

Responsibilities:

• Prepared UTC & UTR after completion of the development and provided results to client.
• Migrated Informatica code from one environment to other environment manually whenever necessary.
• Tested ETL code in Dev, SIT & UAT environments to ensure defect free code.
• Provided Development support for System Testing/User acceptance testing.
• Migration workbook creation and tracking the code versions