We provide IT Staff Augmentation Services!

Informatica Developer Resume

PROFESSIONAL SUMMARY:

  • 6+ years of experience in extensively working with Data Integration Projects using Informatica PowerCenter 9.5.1, 8.x and 7.x.
  • Expertise in all phases of Software Development Life Cycle (SDLC) projects with exceptional skills in analysis, ETL integration design, object oriented design, development and Implementation of Informatica data integrations and applications.
  • Creating Functional and Technical specification Documentation for ETL.
  • Strong Working experience in Design and develop data warehouse solutions for highly complex business operations.
  • Develop, test and deploy new data pipelines to support customer requirements.
  • Fix defects and implement enhancements in existing pipelines.
  • Strong in Data warehousing concepts, Dimensional, Star Schema and Snowflakes Schema methodologies.
  • Extensively worked on Unix environments and have fair knowledge on shell scripting, Cron Jobs, etc.,
  • Worked extensively with complex mappings using different transformations like Source Qualifier, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators etc.,
  • Experience working on Performance tuning on different mappings by finding different types of bottle necks viz., Source bottle necks, Target bottle necks, mapping bottle necks and System bottle necks.
  • Experienced in working with Oracle using SQL, PL/SQL, SQL Plus, and TOAD.
  • Effective in cross - functional and global environments to manage multiple tasks & assignments concurrently.
  • Expert in troubleshooting/debugging and improving performance at different stages like database, workflows, mapping
  • Experience in developing and enhancing applications using Microsoft .Net Framework 2.0/3.0/3.5 Microsoft Visual Studio 2005/08 .
  • Knowledge in design and development of Business Intelligence reports using BI tools like SSRS.
  • Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.x/8.x/7.x/6.x

RDBMS: Oracle, MS SQL Server, MySQL.

Oracle Core: SQL, PL/SQL, Performance Tuning.

UNIX: Shell Scripting.

Scheduling Tools: Autosys, Tidal, SQL, PL/SQL, Unix, C#, VB.

IT EXPERIENCE:

Informatica Developer

Confidential

Environment: Tools: Informatica PowerCenter, TOAD, SSRS.

Database: Oracle-11g.

Operating Systems: Windows XP and Windows 7.

Responsibilities:

  • Participate in functional and business requirements and prepared technical specifications along with team and stakeholders.
  • Design mappings in Informatica Power Center and test workflows/interfaces and deploy into production.
  • Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
  • Involved in the designing of Dimensional Model and good exposure to development, testing, debugging, implementation, documentation, end-user training and production support.
  • Developed mappings to extract data from SQL Server, Oracle, Flat files, and load into Data warehouse using the Mapping Designer.
  • Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures and field size validation.
  • Extensively used various Performance tuning Techniques to improve the session performance (Partitioning etc).
  • Design documentation, status reporting, tracking on project deliverables.
  • Partner with users, platform, and application & support teams on Severe Incidents, Support issues, process issues, bug fixes and delivery of enhancements.

Confidential

Informatica Developer

Environment: Tools: Informatica PowerCenter8.6, TOAD, Autosys Scheduler.

Database: Oracle-11g.

Operating Systems: Windows 7 Enterprise.

Responsibilities:

  • Worked on Business requirements, perform data collection, cleansing, transformation, and loading to populate facts and dimensions for data warehouse.
  • Responsible for the Business solutions, design, development and deployment of GSAM enhancements.
  • Preparing Technical Design documents and Project Plan documents for each Phase.
  • Attending meetings with clients to give development/CRs update daily/weekly.
  • Creating mappings as per the requirements for respective Source Systems.
  • Maintaining the quality of the products to achieve customer satisfaction.
  • Testing the mappings by Unit testing, Integration testing and UAT.
  • Provided Technical support and hands on mentoring in the use of Informatica.
  • Review the mappings and creating review reports.
  • Preparing the issue logs/clarification logs for the Design, Development of ETL objects to smooth functioning of the project.
  • Preparing the test cases and understanding documents to users for future reference.
  • Handling warranty support tasks for maintenance and enhancements.

Confidential

ETL developer

Environment: Tools: Informatica PowerCenter

Database: Oracle

Operating Systems: Windows XP.

Responsibilities:

  • Responsible for the design, development and deployment of Confidential Phase 1 and Phase 2.
  • Preparing Technical Design documents and Project Plan documents for each Phase.
  • Preparing PowerPoint presentations for Project weekly status.
  • Attending meetings with clients to give development/CRs update daily/weekly.
  • Creating mappings as per the requirements for respective Source Systems.
  • Preparing SQL Queries for testing the data.
  • Maintaining the quality of the products to achieve customer satisfaction.
  • Testing the mappings by Unit testing, Integration testing and UAT of ETL routines.
  • Review the mappings and creating review reports.
  • Preparing the test cases and understanding documents to users for future reference.
  • Handling production support tasks for maintenance and enhancements.

Confidential

Junior Developer

Environment: Tools: VB,C#,ASP.Net, SQL server

Database: MSSQL server

Operating Systems: Windows

Responsibilities:

  • Worked on web application which includes modules like employee registration,, Confidential, forum, searching, advanced searching, updating and deleting records, and other general web modules for web application.
  • Worked closely with other members of the development team through the full systems lifecycle including requirements capture, design, development, testing, and deployment.
  • Used simplified client and server side validation, better session management and powerful data access management using ASP.NET.
  • Design and development of multiple system integration points using .net web services (written in C#) in combination with AJAX style web development.
  • Done UI development using ASP.NET web server controls, JQuery, HTML/HTML5.

Hire Now