We provide IT Staff Augmentation Services!

Informatica Developer Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • Bachelor of Engineering with 5.7 years’ experience in the IT Industry on the Data Warehousing and Business Intelligence background, which includes Requirement Analysis, Design, Development, Testing, Infrastructure migration and Release Coordination for Data warehousing applications using Informatica Power center 9.1.
  • Presently associated with Infosys Limited and deputed at Jersey City, New Jersey as Technology Analyst.
  • Experience in all aspects of Software Development Life Cycle (SDLC).
  • Experience in interacting with Business users in analyzing the Business requirements and transforming them into documenting, designing, and rolling out the deliverables.
  • Strong Data Warehousing, ETL experience using Informatica Power Center 9.x/8.x.
  • Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
  • Hands on experience with mappings from varied transformations such as Lookups (connected and unconnected), Router, Aggregator, Sorter, Filter, Update Strategy, Normalizer, Sequence Generator, Joiner.
  • Worked on advanced Informatica concepts like pipeline partitioning, concurrent workflows.
  • Expertise in Oracle SQL, PL/SQL concepts and query tuning for better performance.
  • Expertise in implementation of SFTP, FTP services to retrieve Flat Files from the external sources
  • Experience on writing Unix Shell Scripting in Unix Environment.
  • Experience in scheduling of ETL jobs using Autosys.
  • Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.

TECHNICAL SKILLS:

RDBMS: Oracle 11g

DB Tool: SQL plus, Toad

Scripting: Unix/Linux Shell Scripting.

Scheduling Tool: Autosys

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

  • Extracted the source data from the MYSQL server and transformed the same into ORACLE database by populating first into STAGE area and then into TARGET Data warehouse.
  • Have converted the MYSQL functions into ORACLE functions.
  • Changed the sql queries from MYSQL to ORACLE format.
  • Used various transformations like Lookup, Filter, Expression, Sequence Generator and Router to migrate the same to ORACLE database using the Informatica Designer.
  • Extensively worked with Lookup transformation both Connected and Unconnected.
  • Developed mapping parameters and variables to support SQL override.
  • Used existing ETL standards to develop the Informatica objects.
  • Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance.
  • Created sessions, configured workflows to extract data from MYSQL to ORACLE server.
  • Scheduled jobs using Autosys Tool.
  • Created detailed Unit Test Document with all possible Test cases/Scripts.
  • Involved in Unit, Integration and Regression testing levels.
  • Migrated the code into QA and supported QA team.
  • Involved in the maintenance, bug fixes & request analysis of the existing reports.
  • Constantly interacted with on-site team and designers to discuss the requirements.

Confidential

Informatica Developer / Senior Informatica Developer

Responsibilities:

  • Lead a team of 7 members providing guidance on domain, development and process.
  • Closely worked with business analysts to identify the appropriate source systems for dataset required.
  • Created ETL Design specification document and walkthrough with the team.
  • Involved in all stages of Software development life cycle.
  • Responsible for conversion of Business requirements into ETL Informatica technical specifications.
  • Prepared Estimation based on the complexity and object details.
  • Responsible for providing various Broker data which was received from Associate Investment Monitoring data to CSDR repository.
  • Handled performance tuning of high volume data of 2bn on daily basis using Session Partitioning, Concurrent Workflows and Persistent Cache.
  • Schedule, Plan Resources and Task Tracking using the utilization tracker.
  • Extensively worked in the Oracle exchange partition concepts for the fact data loads.
  • Increased Code Reusability using Shortcuts, Mapplets, Reusable Transformations and Reusable Sessions to reduce redundancy in code. Expertise in design and implementation of slowly changing dimensions - (SCDs Type I & II).
  • Scheduled jobs using Autosys Tool.
  • Performed UTP preparation, Unit testing, Integration Testing and Regression testing.
  • Performed objects migration to higher environments and coordinated for SIT and UAT sign off.
  • Involved in monitoring the workflows and optimizing the load times using session partition, concurrent workflow concepts.
  • Prepared release documents and coordinated code packaging, migration and release process.

Confidential

Senior Informatica Developer

Responsibilities:

  • Lead a team of 12 members providing guidance on domain, development and process.
  • Closely worked with business analysts to identify the appropriate source systems for dataset required.
  • Modified ETL Design specification document and walkthrough with the team.
  • Involved in all stages of Software development life cycle.
  • Responsible for conversion of Business requirements into ETL Informatica technical specifications.
  • Prepared Estimation based on the complexity and object details.
  • Responsible for implementing the Legal Entity data into CSDR repository.
  • Scheduled jobs using Autosys Tool.
  • Schedule, Plan Resources and Task Tracking using the utilization tracker.
  • Performed UTP preparation, Unit testing, Integration Testing and Regression testing.
  • Performed objects migration to higher environments and coordinated for SIT and UAT sign off.
  • Involved in monitoring the workflows and optimizing the load times using session partition, concurrent workflow concepts.
  • Prepared release documents and coordinated code packaging, migration and release process.

Confidential

Database Developer

Responsibilities:

  • Lead a team of 2 members providing guidance on domain, development and process.
  • Have managed the ORCIT inventory by using the oracle in the backend.
  • Have created the risk assessment proposal and tested the same using UI.
  • Have performed various unit testing and Regression testing.
  • Various DDL & DML scripts have been developed to support the risk assessment process.
  • Performed objects migration to higher environments and coordinated for SIT and UAT sign off.

We'd love your feedback!