We provide IT Staff Augmentation Services!

Sr. Programmer Analyst - Informatica Resume

New, JerseY

SUMMARY:

  • Strong credentials in designing, implementing and supporting technical solutions for Product based and Service based IT services.
  • Received multiple appreciations organization wide for delivering cost effective solutions as per business requirements and track record of on - time delivery.Dynamic and accomplished professional with around 8 years of experience in Information Technology and Services industry.
  • Having 8 yrs. of experience in IT industry.
  • Undergone professional training in Oracle 9i form.
  • Worked Extensively on Informatica Power Center tool.
  • Worked on Java, JSP, HTML, Informatica 8.6.1, PL/SQL programming, SQL, Querying & Stored procedures and D2K.
  • Good self-learning capabilities and quick learner in new technologies and proved productive within short period of time.
  • Good communication skills and excellent team player.
  • Managed team of 10-15 resources.
  • Dimensional Data Modeling experience on Data modeling, ERwin 4.5/4.0/3.5.5/3.5.2 , Dimensional Modeling, Ralph Kimball Approach, Star Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modelling
  • Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
  • Experience in preparing the ETL Design Documents like High Level and low level Design documents. Involved in the Unit testing, integration testing, System testing and UAT using Quality Center.

TECHNICAL SKILLS:

Languages: Java,PL/SQL,SQL, Shell Scripts

App/Web Servers: Tomcat

Databases: Oracle 9i,Oracle 10g

Web Technologies: Java Script, HTML, XML

Tools: Informatica Power Center 8.1.18.6.0 and 9.0.1, FCI (Reporting tool), Actuate 8, BIRT and TOAD

Operating Systems: UNIX, Linux, Windows

PROFESSIONAL EXPERIENCE:

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Sr. Programmer Analyst - Informatica

Responsibilities:

  • Dimensional Data Modeling experience on Data modeling, Conceptual, Physical & Logical data modeling.
  • Doing Changes in LLD (Low Level Design) PDM (Physical Data Model) and new CR.
  • Requirement Analysis through business model and functional model.
  • Developed Informatica 9.0.1 mappings/Workflows using various transformations like Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc and having files as a source and targets along with database objects.
  • Create the store procedures.
  • Developed test cases and unit testing, conducting peer reviews of all my mappings before moving it to production.
  • Effectively involved in test data preparation and code review.
  • Attending Daily client calls for Project discussion.
  • Actively involved in Defect solving in SIT and UAT testing phase

Environment: 2 Tier Architecture.

Tools: Used: Informatica Power Center 9.0.1,SQL Developer, Shell Scripts.

Database: Oracle 10g

Confidential

Technical lead for ETL / Informatica and Oracle

Responsibilities:

  • Developed Informatica 8.1.1 mappings/Workflows using various transformations like
  • Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc and having files as a source and targets along with database objects.
  • Developed test cases and unit testing, conducting peer reviews of all my mappings before moving it to production.
  • Alter the store procedures and packages.
  • Effectively involved in test data preparation and code review.
  • Attending Daily client calls for Project discussion.
  • Actively involved in Defect solving in SIT and UAT testing phase.
  • Attending Daily client calls for Project discussion.
  • Monitoring the Dashboard DAC

Environment: 3 Tier Architecture.

Tools: Used: Informatica Power Center 8.6.1, OBIEE(reporting Tool), SQL DeveloperShell Scripts.

Database: Oracle 10g

Confidential

Technical lead

Responsibilities:

  • Dimensional Data Modeling experience on Data modeling, Conceptual, Physical & Logical data modeling.
  • Prepare the HDL (High level Design) and LLD (Low Level Design)
  • Create PDM (Physical Data Model).
  • Requirement Analysis through business model and functional model.
  • Done the Data Profiling in informatica Power Center 9.0.1.
  • Developed a Metadata as per the data model for Project work.
  • Developed Informatica 8.6.1 mappings/Workflows using various transformations like Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc and having files as a source and targets along with database objects.
  • Create oracle functions and procedures.
  • Developed test cases and unit testing, conducting peer reviews of all my mappings before moving it to production.
  • Effectively involved in test data preparation and code review.
  • Attending Daily client calls for Project discussion.
  • Actively involved in Defect solving in SIT and UAT testing phase

Environment: 2 Tier Architecture.

Tools: Used: Informatica Power Center 8.6.1, BIRT,FCI,Jasper(reporting Tool), SQL Developer Shell Scripts. Java,JavaScript

Database: Oracle 10g

Confidential

Senior Software Engineer

Responsibilities:

  • Requirement Analysis through business model and functional model.
  • Developed a Metadata as per the data model for Project work.
  • Developed Informatica 8.6 mappings/Workflows using various transformations like Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc and having files as a source and targets along with database objects.
  • Improved Performance by selecting all Dimension LKP cache as persistent and reused those caches for Fact loads.
  • Effectively involved in test data preparation and code review.
  • Attending weekly client calls and Video conference for Project discussion.
  • Actively involved in Defect solving in SIT and UAT testing phase.

Environment: 2 Tier Architecture.

Tools: Used: Informatica Power Center 8.6.1, SQL Developer, and Shell Scripts.

Database: Oracle 10g

Confidential

Senior Software Engineer

Responsibilities:

  • Working as a developer for the entire modules.
  • Responsible for timely development and release of modules in phases.
  • Involved in Problem Solving and maintaining a constant interaction with the Onsite and Configuration team for speedy closure of development related issues.
  • Requirement Analysis through business model and functional model.
  • Developed a Metadata as per the data model for Project work.
  • Developed Informatica 8.6 mappings/Workflows using various transformations like Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc and having files as a source and targets along with database objects.
  • Create oracle functions and store procedures.
  • Developed test cases and unit testing, conducting peer reviews of all my mappings before moving it to production.
  • Effectively involved in test data preparation and code review.
  • Attending weekly client calls for Project discussion.
  • Actively involved in Defect solving in SIT and UAT testing phase

Environment: 2 Tier Architecture.

Tools: Used: Informatica Power Center 8.6.1, FCI, BIRT, Jasper(reporting tool)SQL Developer.

Database: Oracle 10g and DB2

Confidential

Senior Software Engineer

Confidential

Responsibilities:

  • Working as a developer for the entire two modules.
  • Responsible for creating the Triggers, Functions, Store procedure and packages.
  • Responsible for timely development and release of modules in phases.
  • Monitoring Patch releases to QC and Onsite team.
  • Involved in Problem Solving and maintaining a constant interaction with the Onsite and
  • Configuration team for speedy closure of development related issues.

Environment: 3 Tier Architecture.

Tools: Used: Informatica Power Center 8.6.1, PL/SQL, Oracle 9i Forms (D2k) and Toad.

Database: Oracle 9i

Hire Now