PROFESSIONAL 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.
• Had Experience on working on ICD 9 and ICD 10 Logics.
• Worked On Scheduling Informatica Jobs Scheduling using Tivoli Scheduling Tool
• 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 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
• 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.
• 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 the year 2013 for passion towards learning and effectively scaling up in Data Feed application.

TECHNICAL SKILLS:

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

Confidential, New Jersey

Programming Languages: SQL, Unix Shell Scripting

Tools: Informatica 9.1

Databases:Oracle

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).
• 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.

Sr. Developer

Confidential, New Jersey

OS: Windows, Unix

Skills used: Informatica, Oracle BI Apps,DAC

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

ETL Developer

Confidential

Operating Systems: Windows/UNIX

Programming Languages:SQL

Tools: Informatica 9.1

Databases: Oracle

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 project status by submitting weekly/Monthly project status report and participated in triage calls.
• Trained new joiners in understanding the business.

ETL Developer

Confidential

Operating Systems: Windows XP,UNIX

Tools: Informatica 8.6

Database: Oracle

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

ETL Developer

Confidential

Operating Systems: Windows/UNIX

Programming Language: SQL

Tools: Informatica 8.6

Databases: Oracle

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