We provide IT Staff Augmentation Services!

Informatica Idq Lead Resume

Charlotte -, NC

SUMMARY

  • Having around 12 years of IT experience in Data Warehousing Development and migration projects in which, 6+yrs of experience in ETL (Informatica - powerCenter, Informatica developer, Abinitio) development, and around 6yrs exp in Informatica(PowerCenter/MDM) Administration.
  • Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse. Extensively used Abinitio and Informatica client tools - Source Analyzer, Warehouse designer, mapping designer.
  • Designing, Installing Configuring core Informatica MDM Hub components: Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD
  • Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
  • MDM Hub configurations - Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager.
  • Customized/configured IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data.
  • Worked extensively on BDD Config file to get the changes reflected on IDD.
  • Designing developing multiple cleansing and standardization scenarios.
  • Implementing Hierarchy Manager Module in addition to Match/Merge/Unmerge to depict various hierarchies
  • Performing Data Standardization of addresses using Address Doctor and Informatica Data Quality.
  • Profiling Data Sources using IDQ developer analyst .
  • Informatica PowerCenter tools such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
  • Working on transformations like Source Qualifier, Expression, Aggregator, Router, Filter, Update Strategy, Lookup, Sorter, Normalize, Union, Stored Procedure, and Sequence Generator, Slowly Changing Dimensions.
  • Scheduling and Creating Workflows, sessions involved in the Performance Tuning of Mappings Sessions.
  • SQL, UNIX, Shell Scripting, Data Relationships, Data extraction Validation.
  • Debugging, troubleshooting, monitoring and performance tuning in SQL queries.
  • Having Experience in Informatica Infrastructure administration.
  • Familiar IaaS in salesforce, AWS-EC2 & S3, RDS, Cloud watch, Elastic IP’s and managing security groups on AWS.
  • Having knowledge with AWS Cloud computing and launching Instances
  • Having production support experience on Informatica PowerCenter, IDQ & MDM -Admin with UNIX/TERADATA environment
  • Access management for conman and composer programme, involving the pwd management
  • Hands-on experience in Informatica Power Center 9.5.1 Administration
  • Strong experience on Deployment of Informatica objects from one environment to another.
  • Regularly Coordinating with the onsite, offshore team and the client to understand requirements, analyze scripts provided by them and develop specifications.
  • Having good knowledge on Tivoli 8.6.0.1
  • Having exposure to Tivoli workload scheduler, Tivoli workload Console, Tivoli Workload Admin and experience on setting up Unix Jobs/ETL Jobs in Tivoli
  • Prepared the work estimates, and managing the resources
  • Prepared Business required documents, LLD for offshore team
  • Prepared test plan documents, test cases, Test scripts for Development & Migration project and tested accordingly
  • Experience in design and development of various frameworks and conducting POCs.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte - NC

Informatica IDQ Lead

Environment: Informatica PowerCenter9.6.1, Informatica Metadata Manager & Developer 9.6.1, Informatica MDM10x & MS Sql Server2012 & Unix

Responsibilities:

  • Developed reports as per business use case and documented.
  • Design and developing IDQ mappings in informatica developer
  • Installed & configured MDM servers in all environment from Lab/Dev/SIT/UAT/BCP & PROD.
  • Imported metadata from different sources such as Relational Databases, XML Sources and Impromptu Catalogs into Frame Work Manager
  • Configure, execute, and monitor the loading and linking of metadata
  • Load Business Glossary and link glossary terms with technical metadata objects
  • Installed & configured MDM10.1 servers and configured MDM Landing, staging & BO objects.
  • Design and developing reusable mapplets for each rule.
  • Integrated IDQ mappings with power center
  • Developing the dash boards using informatica developer 9.6.1 & generated scorecards with profiling results on source data

Confidential, Chicago, IL

IDQ Analyst

Environment: Informatica Powercenter 9.1 & Developer 9.6.1, Oracle

Responsibilities:

  • Designed the project execution frame work and provided the best solution in development.
  • Analyzed in detail, existing data quality framework for eCDP and created detail documentation on process sequence with good data examples and integration points.
  • Design and developing reusable mapplets for each rule.
  • Integrated IDQ mappings with power center
  • Developing the dash boards using informatica developer 9.6.1 & generated scorecards with profiling results on source data.
  • Participated with the Informatica professional services’ team to complete the development and testing of close to 500 rules as part of the DQM and met deadlines
  • Integrating IDQ rules with IPC, Created composite mapplet and mappings

Confidential

Environment: Informatica 9.5.1(powercenter & Developer), Oracle, Teradata, TWS

Responsibilities:

  • Coordinating with clients, interfacing teams, database Administrators to get a detailed understanding of existing functionality and system requirements
  • Working as Onshore Lead and managing offshore team for coordinating issues and helping resolves issues to the client
  • Prepared the work estimates, and managing the resources Confidential onshore
  • Prepared Business required documents, Prepared test plan documents, test cases, Test scripts for Development & Migration project and tested accordingly
  • Design, implementation and management of security access roles and privileges for all types of metadata consumers.
  • Design and development of Metadata Repository backup/recovery strategy.
  • Development of processes and guidelines for Metadata management - change management, metadata access and sharing. This will include processes and capabilities for versioning all forms of metadata.
  • Configuration of Landing, Staging and Loading processes, Trust and Validation rules, Match and Merge process
  • Created Unix scripts to Execute Batch jobs and Batch Groups
  • Created Unix scripts which will kick off the informatica workflows and scheduled them through TWS.
  • Creation of Hierarchies, relationship type, packages and Profiles
  • Analyze profiling results and make recommendations for improvements.
  • Build profiling, cleansing and validation plans
  • Sole developer building a process in IDQ for cleansing and migrating global customer data.
  • Worked along with Tier 1/Tier2 support teams and managed multiple applications and worked on SLA related issues about 45-50 servers(Unix/Linux)
  • Script review and porting to target environment.
  • Support Data Migration activities, Provide post production support and consultancy.

Confidential, Irwing, TX

Environment: Informatica 9.1, Informatica MDM & Teradata

Responsibilities:

  • Analyzing the requirement given by client and Responsible for design and development of Data Warehouse project leveraging Informatica Power Center ETL tool
  • Extensively worked in the performance tuning of SQL, ETL and other processes to optimize session performance.
  • Worked extensively on transformations like Lookups, Aggregator, Update Strategy, Sequence generator, Joiner transformations Created Test plan documents and test scripts and tested SIT/UAT Environment.
  • Demonstrated experience with design and implementation of Informatica (IDQ v9.1), Data Quality applications for the business and technology users across the entire full development life-cycle.
  • Knowledge of IDQ 9.1 standards, guidelines and best practices.
  • Knowledge of Data Profiling guidelines and best practice
  • Carrying out User Acceptance Testing of the codes.
  • Played key role in Development environment
  • Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
  • Worked with Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power center.
  • Providing daily status updates to the Onsite coordinator.

Confidential

Environment: Sql Server 2008, Informatica 8.5

Responsibilities:

  • Designed and developed Process Code update mapping by using Informatica
  • Designed and developed Domain Check mappings
  • Created One shot file documents as per the new feed
  • Created test plan documents and test scripts for one shot files and tested accordingly
  • Regularly coordinating with Onsite and Offshore team

Confidential

Environment: Informatica 8.5 & Teradata, TWS

Responsibilities:

  • Analysis of Functional Specification
  • Designed and development of ETL mappings using Informatica.
  • Testing and Test plan preparation
  • Implement Indexing Technique on the Framework
  • Tuning the mappings for better Performance (Implement session partition, Persistent Cache etc)
  • Deployment of informatica objects from one environment to Another Best Practices Documentation
  • Managing the Serena to follow up the issues, and promoting the new code from one environment to another environment.

Confidential

Environment: Ab intio2.14, co ops1.14, Unix

Contribution:

Responsibilities:

  • Designed Data Element Mapping Document for Collections Phase-I.
  • Prepared Data Validation Test Case Documents for Phase-I and Phase-II.
  • Created Data Validation Test Scripts for Phase-I and Phase-II Validated files.
  • As per business rule written many complex sql scripts for all Phases (DEV, SIT And UAT).
  • Coordinated with Onsite and Offshore ETL Team Confidential the time of SIT and UAT.
  • Validated the Data and generated the reports for user

Confidential

Environment: DataStage7.5, DTS on SQL Server 2000

Contribution

Responsibilities:

  • Designed and developed Simple, Medium DTS Packages, and Complex Data Stage Jobs based on user requirements to lead data from subscribeV4 Data to SubscribeV6 structure.
  • Prepared Test Plans for Unit Testing and tested packages with Unit test plan
  • Strategies and prepared test result documents.
  • Involved in SQL query optimization.
  • Created Sql Scripts for Drop and Creating Indexes Dynamically.
  • Created Sql Scripts for Disable and Enable Triggers Dynamically.
  • Prepared Test Plans for Unit Testing for Pre and Post Validation Stream and tested Validation Scripts with Unit test plan.
  • Prepared the Database change request document
  • Strategies and prepared test result documents.
  • Direct interaction with clients for change requests and modifications.
  • Given knowledge Transfer on Data Stage for new team members.
  • Written BCP commands for V4 to V6 Package.

Confidential USA

Environment: Informatica 7.1 & DB2, Oracle

Contribution:

Responsibilities:

  • Designed and developed Informatica Mappings and Sessions based on user requirements and business rules to lead data from source and RDBMS tables to target tables.
  • Ensuring project completion within specified time and in compliance with quality norms and delivering it to the Onsite team.
  • Involved in detail design and development of mappings using Informatica.
  • Extensively involved in Data Extraction, Transformation and Loading (ETL Process) from source to target systems using Informatica.
  • Worked on connected as well as unconnected Lookup transformation to look up values in a table
  • Used most of the Transformations such as Source Qualifier, Expression, Joiner, Router, Update Strategy, Filter, and Unconnected Lookups.

Hire Now