We provide IT Staff Augmentation Services!

Informatica Data Quality Analyst/architect Resume

SUMMARY:

  • Overall 12 years of Total Experience in the IT Industry
  • Verified transformed feeds from ETL modules for the correctness/expected results and then loading them onto Recon systems for the testing team to test upon.
  • Experience of 10 years with ETL (Extract/Transform/Load) tool Informatica Power Center.
  • Expertise in analyzing the data from source system and adding all the required checks before the data is fetched in ETL or before loading in the target system.
  • Interact with business users for understanding the business requirement and then create the BRD, Design Doc, Test case etc.
  • Proficient in ETL, Database designs, Reporting Services and strong Excel skills for Data Analysis.
  • Migration of all the ETL jobs from Informatica 7 to Informatica 8 and Informatica 9 to Informatica 10.
  • Very good proficiency in Informatica Data Quality 9.5.1
  • Worked on the Golden Gate replication from hetrogenous data sources.
  • Have excellent knowledge on Anticipating the data issue due to user errors and have the checks in place so that the incorrect data is not loaded in the reporting tool.
  • Worked on Configuration of Informatica 10 on Windows server.
  • Worked on Generic ETL Framework Solutions - Synex for Exchange Traded Derivatives (ETD) Solutions using Informatica 8.6.1 for Data Integration and complex built rules.
  • Have knowledge on Oracle PL SQL, MS SQL Server and I-SQL programming languages.
  • Loading of ETL Files in TLM, Mapping of TLM KB to the ETL Files, TLM Engines Configurations and support management for backing out/reloading TLM files.
  • Worked on upgrading all the Informatica jobs from older version to new version.
  • Experience in all Phases of Software Development Life Cycle (SDLC) (from requirements gathering to post live support).
  • Performed admin tasks for managing user previlages and roles.
  • Good problem solving skills, analytical skills and creative skills
  • Code reviewing, documenting software code from a developer’s perspective, writing user manuals and Conscious towards coding standards, debugging skill, testing, Code Review, documentation and also interaction with onsite client.
  • Impact analysis of the system for new developments.
  • Analyzed requirements, provided estimation, and prepared High Level Designs.
  • Has very strong experience in the requirements gathering, functional gap analysis, configuration, writing training guides, training and production support.
  • Team player with good interpersonal, communication and fast learning skills. Highly adaptive to any type of work environment and technology.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter, Informatica IDQ and Datastage

Databases: Oracle9i/10g/11g, DB2, Sybase

Reconciliation Tool: TLM 2.6/2.7/Premium

Repository System: SVN, Star Team

Operating System: UNIX, Windows Advanced Server 2000/NT/XP.

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Data Quality Analyst/Architect

Technology: DB2, Oracle 11g, PL/SQL, Autosys, Data Stage 8.5, Informatica 9x/10x, Informatica IDQ 9x

Responsibilities:

  • Requirement Analysis for the new projects.
  • Migration of ETL jobs from Datastage to Informatica 9 and Informatica 10.
  • Oracle Procedure development and enhancements
  • Analysis of the data that could be added in the source system and adding all the required checks for checking the correctness of data
  • Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
  • Used IDQ to complete initial data profiling and removing duplicate data.
  • Golden Gate replication from sybase to Exadata
  • Deployment of the Informtica and the database objects in UAT for the enhancements
  • Ensuring all the validations are done at the source system before the data is loaded in database.
  • Client Co-ordination

Confidential

ETL and Database Lead Consultant

Technology: Informatica Power Center 8.6.1, Unix Shell Scripting, DB2, Oracle 11g, Autosys

Responsibilities:

  • Requirement Analysis for the new projects.
  • ETL Development and enhancements
  • Preparing design document and Technical Specification documents
  • Responsible for managing the user previlages and roles on Informatica.
  • Update or create new database views as per the downstream requirement.
  • Support for UAT
  • Client Co-ordination

Confidential

Database and ETL Lead Consultant

Technology: Informatica Power Center 8.6.1, Informatica Data Transformation B2B, Unix Shell Scripting, Sybase, Oracle 11g, Autosys, TLM Premium 3.1

Responsibilities:

  • Requirement Analysis, Data Model and Data Flow Creations,
  • Leading and Monitoring the development team to divide the function points and bring tasks into closure,
  • ETL Development, TLM Premium Monitoring
  • Preparing design document and Technical Specification documents
  • Preparing Unit Test Case.
  • Have been a part of correction team at the time of System Test to deliver bug-free modules
  • Support for UAT
  • Client Co-ordination

Confidential

ETL and Database Consultant

Technology: Informatica PowerCenter 8.6.1, Unix Shell Scripting, DB2, TLM 2.6

Responsibilities:

  • Requirement Analysis, Leading and Monitoring the development team to coordinate the users with the requirements
  • ETL Development, Reporting Development.
  • Responsible for enhancement and bug fixing.
  • Responsible for memory optimization and performance tuning.
  • Preparing Unit Test cases.
  • Handling Change Requests for IMPACT recs
  • Client Co-ordination.
  • UAT support

ETL Consultant

Confidential

Technology: Informatica, PL/SQL, MS/SQL, Ingress

Responsibilities:

  • Responsible for migrating all ETL jobs from Informatica 7 to Informatica 8.
  • Responsible for Requirement Analysis and Coding in Informatica
  • Responsible for enhancement and bug fixing.
  • Responsible for Unit Testing.
  • Real Time Support, Fix bugs, Deployment of Informatica apps
  • Client Co-ordination

Database Consultant

Confidential

Technology: Java, Servlets, JSP, Fatwire Content Server, IBM WSAD, Star Team

Responsibilities:

  • Responsible for Requirement Analysis
  • Responsible for enhancement and bug fixing.
  • Responsible for Unit Testing.
  • Real Time Support, Fix bugs
  • Build and deployment of the application
  • Client Co-ordination

Database Consultant

Confidential

Technology: Oracle, PL/SQL Developer, Fatwire Content Server, Hotdocs 2005

Responsibilities:

  • Responsible for Requirement Analysis
  • Responsible for enhancement and bug fixing.
  • Responsible for Unit Testing.
  • Development of Database modules like Table, Procedure creation,
  • PDF generation, Lias with 3rd Party
  • Client Co-ordination

Hire Now