Dipanjan G.

Dipanjan G.

Informatica Developer with Informatica skills

Kolkata , India

Experience: 7 Years

Dipanjan

Kolkata , India

Informatica Developer with Informatica skills

11142.9 USD / Year

  • Immediate: Available

7 Years

Now you can Instantly Chat with Dipanjan!

About Me

Ø  7 Years of experience in IT.

Ø  An Informatica Certified Developer.

Ø  Experience in ETL Development using Informatica and SQL end-to-end Data warehouse Development experience. Have decent exposure to ETL performance tunin...

Ø  Have working experience on Full Lifecycle Darwarehousing projects and production support for the same.

Ø  Have good analytical skills and also has the knowledge on performance enhancement of informatica mappings and involved in various phases of a project like Requirements Gathering/Analysis, High level Design, Detail level design, Development, Testing, and Documentation etc.

Ø  Good experience in ETL Designing and Implementation.

Ø  Have experience of loading data from variety of source systems like DB2, ORACLE, Flat Files etc.

Ø  Experience in client meetings, Off-shore Co-Ordination, Handling small teams, meeting project goals, deliverables and objectives.

Ø  Strong analytical and problem solving skills coupled with excellent communication and inter-personal skills.

Show More

Portfolio Projects

Amex

Company

Amex

Description

Ø   Participated in analysis of the specifications provided by the clients.

Ø  Analysis and developing new mappings to pull and load the data.

Ø  Contributed in preparing Technical design documents, Business requirement document.

Ø  Analysis and developing new mappings for which push and pull the data and load in data warehouse.

Ø  Working on the balancing mechanism including financial controls which would be applied to ensure the data integrity throughout the event flow.

Ø  Designing and implementing the ETL Mappings and Sessions in Informatica

Ø  Involved in preparing test cases, test suit for all the modules.

Ø  Involved in Coordinating UAT, migration and support on-boarding activities.

 

Ø  Involved in preparing test cases, test suit for all the modules.

 

Ø  Mentoring the new joiners in the project.

Show More Show Less

Skills

Informatica

Massachusetts Mutual

Company

Massachusetts Mutual

Description

Ø   Reviewed the technical design documents prepared based on requirements.

Ø  Analyzed Sources, Targets and designed the ETL strategy.

Ø  Extensively used Power Center/Mart to design multiple mappings with embedded business logic.

Ø  Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.

Ø  Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache

Ø  Involved in unit testing.

Ø  Implemented End-to-End Auditing and Reconciliation of records

Ø  Tuned Informatica Mappings and Sessions for optimum performance.

Ø  Performed data gap analysis from source systems to target elements and also from target elements to reporting elements.

Ø  Setting up defect triage calls, consolidating day’s work, reviewing newly developed mappings.

Show More Show Less

Skills

Informatica

lululemon Athletica

Company

lululemon Athletica

Description

Ø  Contributed in preparing Technical design documents, Business requirement document.

Ø  Analyzed Sources, Targets and designed the ETL strategy.

Ø  Extensively used Power Center/Mart to design multiple mappings with embedded business logic.

Ø  Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.

Ø  Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache

Ø  Involved in unit testing.

Ø  Analysis and developing new mappings for which push and pull the data and load in data warehouse.

Ø  Working on the balancing mechanism including financial controls which would be applied to ensure the data integrity throughout the event flow.

Ø  Involved in preparing test cases, test suit for all the modules.

Ø  Involved in Coordinating UAT, migration and support on-boarding activities.

Ø  Performed code review by using internal tool (platinum code reviewer).

Ø  Implemented CDC mappings through Informatica Powerexchange

Ø  Prepared LLD, Technical Design Documentation, and Review Checklist for project purpose.

Ø  Mentoring the new joiners in the project.

Ø  Batch monitoring.

Show More Show Less

Skills

Informatica

The University Grants Commission of India

Company

The University Grants Commission of India

Description

Ø   Contributed in preparing Technical design documents, Business requirement document.

Ø  Analysis the existing procedures for which pull the data and load in data warehouse.

Ø  Working on the balancing mechanism including financial controls which would be applied to ensure the data integrity throughout the event flow.

Ø  Involved in preparing test cases, test suit for all the modules.

Ø  Prepared LLD, Technical Design Documentation, and Review Checklist for project purpose.

Show More Show Less

Skills

Informatica
Share:

Verifications

  • Profile Verified

  • Phone Verified

Preferred Language

  • English - Fluent

  • Hindi - Fluent

  • Bengali - Fluent

Available Timezones

  • Eastern Daylight [UTC -4]

  • Central Daylight [UTC -5]

  • Pacific Daylight [UTC -7]

  • Mountain Daylight [UTC -6]

  • Eastern European [UTC +2]

  • Greenwich Mean [UTC ±0]

  • Further EET [UTC +3]

  • Eastern EST [UTC +3]

  • Australian EDT [UTC +11]

  • Australian CDT [UTC +10:30]

  • Dubai [UTC +4]

  • New Delhi [UTC +5]

  • China (West) [UTC +6]

  • Singapore [UTC +7]

  • Hong Kong (East China) [UTC +8]