We provide IT Staff Augmentation Services!

Sr Informatica Consultant Resume

Chemung, NY

SUMMARY:

  • 12 years of IT experience in the field of Data warehousing in tools like Informatica, IDQ, MDM,BODS,Teradata, Oracle.
  • Technical proficiency in the Data Warehousing teamed with Data Analysis, Data Modeling, Business Requirements Analysis, Application Design, Development & testing, Data profiling, data standardization & Quality Control and full life cycle Implementation of Data Warehouse.
  • Involved in Requirement gathering, Data Analysis, Application Design, Data Modeling, Application Development, Implementations and Data Quality in different Data warehouse Projects.
  • Experience in designing error and exception handling procedures to identify, record and report errors.
  • Extensive Experience in developing and performance tuning of informatica mappings
  • Worked extensively in onsite (client location and having exposure of direct involvement with client).
  • Created source to target mapping documents for input into ETL specifications by Identifying, analyzing data sources
  • Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
  • Created transformations such as Joiners, Lookups, Filters, Aggregator, Sequence Generators, according to the business rules
  • Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure and Router transformations for populating target table in efficient manner .
  • Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting
  • Experience in testing the data using debugging mapping method. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
  • Experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
  • Created unit test cases to test data loads and check whether the components adhere to the technical design
  • Used SQL tools to run SQL queries to view and validate the data loaded into the warehouse and troubleshoot data issues.
  • Effective working relationships with client team to understand support requirements, and effectively manage client expectations

TECHNICAL SKILLS:

Informatica MDM Multi: Domain, IDD, SIF

ETL Tools: Informatica 10.X/9.X/8.x (Power Center/Power Mart),IDQ BODS,Teradata SQL Assistant, TOAD, Putty.

Data Modeling: Physical Modelling, Logical Modelling, Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes

Databases: Teradata, Oracle 12g/11g/10g/9i, MS SQL Server, MS Access

Languages: SQL, PL/SQL, Data Structures, Unix Shell

ScriptTools: SQL plus, PL/SQL Developer, SQL* Loader

Operating Systems: Windows NT/2000/2003/XP/Vista/7, Unix, Linux

DAC, BMCCTRL: M, Autosys

Supporting Tools: Service Now, TSRM

PROFESSIONAL EXPERIENCE:

Confidential, Chemung, NY

Sr Informatica Consultant

Environment: Informatica 10.1.0/9.6, Oracle 12g, Tableau, EBS,SQL Developer

Responsibilities:

  • Develop the mappings using needed Transformations in Informatica tool according to technical specifications
  • Implemented Informatica error handling, dynamic parameter file generations and coding best practices
  • Responsible for technical Design Document and Details mapping document
  • Analyzing and understanding functional requirements.
  • Used Informatica reusability at various levels of development.
  • Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
  • Designed and developed Informatica mappings for data sharing between interfaces utilizing SCD type 2 and CDC methodologies
  • Develop informatica mappings and workflows for new change requests.
  • Responsible for creating Source to Target data mapping.
  • Developing Informatica ETL jobs to extract data from EBS and to load into the SQL Server.
  • Extensively used Informatica Power Center and created mappings using transformations like SourceQualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
  • Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
  • Created scripts for Batch test and set the required options for overnight, automated execution of test scripts
  • Conceptualized and developed initial and incremental data loads in Informatica using Update strategy transformation, variables
  • Resolving issues raised by customer
  • Handling Issues during development and analyzing phase and Fixing Bugs if any
  • Preparing Test Results
  • Unit testing
  • Defect Fixing

Confidential

Sr Informatica Consultant/Developer

Environment: Informatica 9.1,IDQ,Oracle 11g, DAC

Responsibilities:

  • Responsible for technical Design Document and Details mapping document
  • Develop the mappings using needed Transformations in Informatica tool according to technical specifications
  • Responsible for creating Source to Target data mapping.
  • Interacting with the onsite people and resolving the offshore issues.
  • Developing Informatica ETL jobs to extract data from Source and to load into the Oracle.
  • Implemented Informatica error handling, dynamic parameter file generations and coding best practices
  • Analyzing and understanding functional requirements.
  • Used Informatica reusability at various levels of development.
  • Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
  • Designed and developed Informatica mappings for data sharing between interfaces utilizing SCD type 2 methodologies
  • Develop informatica mappings and workflows for new change requests.
  • Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
  • Extensively used Informatica Power Center and created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
  • Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volumeof data
  • Developed sessions using different types of partitions like round robin, hash key portioning for better performance.
  • Handling Issues during development and analyzing phase and Fixing Bugs if any

Confidential

Sr Informatica Consultant/Developer.

Environment: BODS, TERADATA

Responsibilities:

  • Extract, transform and Load data from different sources into Oracle database using SAP BODS XI4.0 as ETL tool.
  • Experience in BTEQ scripts
  • Have designed history logics and written good SQLs in Teradata.
  • Have involved in solving complications in the production level issues.
  • Have involved SIT and UAT defects closing.
  • Worked extensively in Perl, shell scripting and click stream analysis
  • Handled off shore for related work in respect of unit test case preparation and documentation like implementation, warranty & support.
  • Have helped in re-building of Jobs based on requirement.

Confidential, Miami, FL

Informatica Consultant

Environment: Informatica 9.1, Oracle

Responsibilities:

  • Develop the mappings using needed Transformations in Informatica tool according to technical specifications
  • Responsible for technical Design Document and Details mapping document
  • Interacting with the onsite people and resolving the offshore issues.
  • Developing Informatica ETL jobs to extract data from Source and to load intothe Oracle.
  • Implemented Informatica error handling, dynamic parameter file generations and coding best practices
  • Responsible for creating Source to Target data mapping.
  • Used Informatica reusability at various levels of development.
  • Attended weekly status meetings and provide detailed status report to the client.
  • Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
  • Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
  • Preparing Test Results, Unit testing, Defect Fixing

Confidential, Amarillo,TX

Informatica Consultant

Environment: Informatica, Oracle

Responsibilities:

  • Developing Informatica ETL jobs to extract data from Source and to load into the Oracle.
  • Develop the mappings using needed Transformations in Informatica tool according to technical specifications
  • Analyzing and understanding functional requirements.
  • Responsible for technical Design Document and Details mapping document
  • Extensively used Informatica Power Center and created mappings using transformations like SourceQualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
  • Involved in retesting the defects
  • Used Informatica reusability at various levels of development.
  • Fixed the invalid mapping's and troubleshoot the technical problems of the database.
  • Attended weekly status meetings and provide detailed status report to the client..
  • Develop informatica mappings and workflows for new change requests.
  • Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
  • Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
  • Preparing Test Results, Unit testing, Defect Fixing

Hire Now