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 teh 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 teh execution time for huge volumes of data.
• Experience in UNIX commands and shell scripting .
• Experienced in working with Tivoli Job Scheduling tool.
• Experience in UNIX shell scripting, job scheduling and communicating with server using pmcmd.
• Responsible for providing temporary/permanent fixes and give status update on teh 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
• Worked exclusively on implementing teh types of Slowly changing dimensions (SCDs)-Type I II and III in different mappings as per teh requirements.
• Experience in testing and fixing teh bugs.
• Have good knowledge in developing Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Interact with Database, Informatica Administrators on environmental issues and work on fixing teh issues
• Worked extensively in Informatica Power Center 8.6 & 9.1.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitors
• Proficient in Oracle Database and UNIX Shell Scripting.
• Developed mappings with XML as source and target in Informatica.
• 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 teh year 2013 for passion towards learning and TEMPeffectively scaling up in Data Feed application.

TECHNICAL SKILLS

Technology Tools: Data Warehousing Informatica Power Center 9.1.0/9.0.1,8.6.1,8

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

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

Other Utilities: PUTTY,TOAD

PROFESSIONAL EXPERIENCE

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 Data integration to Extract, Transform and load data (ETL) into Enterprise Data warehouse (EDW) and Operational data store (ODS).
• Used Oracle as database to load teh Tables .
• 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
• TEMPEffectively documented all Development work done. (LLD)
• Implemented Aggregate, Filter, Join, Expression, Lookup and Update Strategy, XML,Normalizer,transformations.
• Used debugger to test teh mapping and fixed teh 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 teh 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 teh target instance.
• Prepared Unix shell script as per business Requirement
• Develop database triggers, packages, functions, and stored procedures using PL/SQL and maintain teh scripts for various data feeds.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all teh projects with teh 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 teh result, working on defect fixes from System Testing & User Testing.
• Migration workbook creation and tracking teh code versions.

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 teh data from source to Target using Designer.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Involved data partitions and for teh sessions having huge data and feeding set of data to teh mapping pipeline.
• Developed transformation logic and designed various Complex Mappings using teh Designer
• Extensively used SQL to analyze teh data.
• Experienced in handling large volumes of data.
• Analyzing teh requirement
• Code developed based on teh business requirement
• Created Unit Test cases and captured Test logs

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 teh business requirements.
• Created different mappings for loading teh data into Oracle database e.g. Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Expressions, Aggregator, Sequence Generator and Normalizer.
• Extensively used SQL and PL SQL for resuable scripts in teh mapping level.
• Created different mappings for loading teh data into Oracle database.
• update on teh defects raised to SQA Team in daily vendor calls. Interact with Database, Informatica Administrators on environmental issues and work on fixing teh issues
• Prepared unit test cases for teh 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 project status by submitting weekly/Monthly project status report and participated in triage calls.
• Trained new joiners in understanding teh business.

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 teh modified existing ETL routines.
• Creating teh SQL queries based on source to target mappings for Target tables.
• Prepared teh alter scripts to alter teh length and data type.
• Provided Development support for System testing.
• Created Expression, Lookup, Filter, Router, Aggregator Transformations were implemented to load teh 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 teh Designer
• Extensively used SQL to analyze teh data.
• Experienced in handling large volumes of data.
• Analyzing teh requirement
• Code developed based on teh 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 teh error validations and generating teh count statistics. Created re-usable Mapplet, transformations,
• Once components get migrated to production, it is necessary to involve in supporting process
• During teh support it is necessary to share teh 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

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 teh 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 teh code versions

ETL Developer

Responsibilities:

• Prepared UTC & UTR after completion of teh 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 teh code versions