Lead Informatica Mdm Developer/lead Idq Developer Resume
TexaS
SUMMARY:
- 7+ years of experience in the field of Information Technology with an extensive experience in Master Data Management and as an ETL Developer with prime focus on analysis, design, development, customization and maintenance of various data warehouse applications in an effective way to deliver leading edge software solutions.
- Strong expertise in installing and configuring the core Informatica MDM components (Informatica MDM Hub Server, Hub Cleanse, Resource Kit and Cleanse Adaptors like Address Doctor)
- Extensive experience in MDM solution and data migration solutions involving Data Quality, Data Governance, Data Stewardship, Data Mapping, ETL Development, Data Modeling, Metadata Management, Data Migration, Match/Merge, BPM and Reporting Solutions
- Extensively used Informatica PowerCenter 10.x/9.x/8, Informatica Data Quality (IDQ) 10.x/9.x as ETL tool for extracting, transforming, loading, and cleansing data from various source data inputs to various targets, in batch and real time.
- Used various Informatica PowerCenter and Data quality transformations such as - source qualifier, aggregator, update strategy, expression, joiner, lookup, router, sorter, filter, web services consumer transformation, XML Parser, labeler, parser, address validator, match, comparison, consolidation, standardizer, merge to perform various data loading and cleansing activities.
- Experienced in understanding the client’s business process & requirement gathering and act as a liaison between business and development/QA teams and have experience in working in Offshore/Onsite model
- Knowledge on Data Profiling, Data Modeling (Relational, dimensional, Star and Snowflake Schema), &Data Analysis.
- Installing, Upgrading, Designing, Configuring core Informatica MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD and ActiveVOS.
- Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records
- Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
- Knowledge on implementing hierarchies, relationships types, packages, and profiles for hierarchy management in MDM Hub implementation.
- Solid understanding of Informatica MDM design principles and good practical knowledge of performing MDM design processes through Informatica MDM.
- Expertise in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
- Expertise in integrating SIF API Calls for variety of operations like Merge, Unmerge, Execute Batch Unmerge, Execute Batch Delete, with Informatica Power center and develop workflows to automate the process.
- Designed & developed multiple cleansing and standardization scenarios using Cleanse Functions
- Expert in importing ORS data source in the application server environment for Informatica MDM Hub.
- Well versed with importing and exporting the ORS repositories from different environments.
- Expert in configuring Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, Profiles using Hierarchy tool.
- Highly proficient in creating transformations and mappings, processing tasks, scheduling sessions, importing/exporting repositories, managing users, groups, associated privileges, and folders.
- Responsible for creating user groups, privileges and roles to the users using Security Access Manager (SAM)
- Configured Informatica Data Director (IDD) for data governance to be used by the business users, IT Managers and Data Stewards and also implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching the data.
- Informatica Certified MDM specialist responsible for MDM professionals under the MDM practice of the organization. Pursuing Cloud Customer 360 under organization initiative to add to portfolio and assist w/ future resource development.
- Collaborate and work with Informatica Partner to identify features of the product that can be improved and enhanced for better product marketability.
- Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
- Excellent communication and interpersonal skills and an attitude to learn the new innovative technologies.
- Ability to quickly analyze and come-up with an efficient industry standard solution for a given problem
- Experience in delivering EDM and EIM projects in Agile Mode.
- Worked on Data Profiling using Informatica Data Quality to examine different patterns of source data. Proficient in developing Informatica IDQ transformations like Parser, Classifier, Standardizer and Decision.
- Experience in Slowly Changing Dimensions (Type 1, Type 2 and Type 3)
- Designed complex mappings using Source Qualifier, Filter, Normalizer, Aggregator, Router, Update Strategy, Union, Lookup, Joiner, Sorter and Stored Procedure Transformations
- Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts and SSRS Reports with PPS.
- Hands on experience in Performance Tuning of sources, targets, transformations and sessions using Informatica best practises like session partitioning, query optimization in database, incremental aggregation etc.
- Experience in writing PL/SQL stored procedures, functions, packages and triggers using PL/SQL developer
- Expertise in performance tuning of SQL statements and PL/SQL modules using Explain Plan, SQL Trace for optimizing the cost and evaluating the performance
- Experience in UNIX Shell Scripting on UNIX & Linux platform
- Highly Proficient in Informatica Designer Components like Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor
- Hands on experience on scheduling tools like CONTROL-M, Tidal, Informatica scheduler and UNIX Cron tab
TECHNICAL SKILLS:
Databases: Oracle 9i/10g/11g, Microsoft SQL Server, NETEZZA, TERADATA
Integration Tools: Informatica Intelligent Cloud Services (IICS/CAI)
Data Analysis/ETL: Informatica Power Center 9.x/10.x, SSIS, SAP Business Objects
EIM Tools: Informatica Multi domain Edition 10.3/10.2,10x,9.7.1, B2B Data Exchange 10.2.3 IDD, Provisioning Tool
Application Server: Jboss 6.4 and Web logic
Data Quality: Informatica Data Quality ( IDQ) 10.x
Programming Languages: C++, SQL, PL/SQL, UNIX Shell Scripting, Python, HTML
Operating Systems: Windows, UNIX, Linux
Application Software: MS Office (Word, Excel, PowerPoint)
Database Development Tools: Toad, SQL*Loader, SQL*Plus, SQL Developer
Scripting Languages: UNIX Shell Scripting
Autosys, Control: M, Tidal
Big data: Hadoop, Hive
PROFESSIONAL EXPERIENCE:
Confidential, Texas
Lead Informatica MDM Developer/Lead IDQ Developer
Responsibilities
- Involved in gathering business requirements for the provider, patient and location domains used by the management.
- Define measurable metrics and the minimal required attributes for each domain or subject area to support a robust and successful deployment of an MDM platform
- Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
- Interview and partner with key users to identify data requirements and design the data model.
- Evaluate current data model and implement best practices in Data Modelling, data integration & data quality
- Review requirements and implement Master Data Management program - with close collaboration with business analysts
- Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
- Used the SIF integration to publish the data in Real Time from different sources.
- Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
- Using the SIF call we Insert, Unmerge, Delete the records in Base Objects based on the requirements
- Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
- Used SIF to invoke the MDM Hub operations from external applications in real time
- Designed Mappings using B2B Data Transformation Studio.
- Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
- Creation of B2B DX Partners, profiles, workflows, endpoints for onboarding clients.
- Worked on Split process, Merge process of multi- client files using Informatica B2B Data transformation and Informatica B2B Data Exchange.
- Performed Documentation for all kinds of reports and DTS and SSIS packages.
- Worked on creating Patient, provider, Location, payer and Guarantor Domains and creating Data models for patient, Provider. Etc. Domains.
- Upgrading to Informatica MDM 10.1 to 10.2 and 10.3 installed system and configured Address doctor 5.
- Designed and implemented master domain to maintain the data.
- Configured the provider and s master subject are in IDD and created BE for users to see better view IDD application.
- Worked on Provisioning tool to extend the IDD application and configuration, creating start page, related record page and BE view pages. configured AVOS for the approval process for the business to maintain trusted data in MDM.
- Working as Data Governance for business to creating master specialty, board, License boards, CPT code and ICD 10 Code.
- Closely working with Data Governance team building the data Governance policy and produces.
- Implemented the Source to target mapping and crosswalk to translate source data to MDM standard data.
- Implemented standard size cleanse process load the data into MDM landing tables throw Informatica Data Quality.
- Worked on data cleansing and standardization using the cleanse functions in Informatica MDM
- Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
- Used Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD
- Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records
- Configured match rule set property by enabling search by rules in MDM according to Business Rules.
- Created automation process load the data In MDM using tidal scheduling tool.
- Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server
- Implemented reject summary report to analyze rejected records in MDM process.
- Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
- Implemented Bar chart, pie charts show in IDD application for the user can see quick summary report to see number of active provides and percentage valid address.
Work Environment : Informatica MDM 10.3 HF1/10.x (EBF), Informatica 10.1/9x, Jboss, Windows, Active VOS, SQL Server 2012/2016, IDD, Provisioning Tool, Tidal
Confidential, MD
Sr Informatica MDM Developer/Sr IDQ Developer
Responsibilities
- Involved as the lead and primary go to person for any technical enquiries about the Master Data Hub initiative.
- Designed and developed automated processes/workflows in Informatica PC to call variety of SIF calls to Unmerge and Merge based on identified issues
- Handle Production issues and Adhoc User Requests
- Identifying existing source systems within the organization and analyzing data to identify Business Rules to apply
- Working closely with Application Analysts, Data Integration team, Database Administrators team, Infrastructure team and Business Consultants.
- Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
- Implementing XREF match in Informatica MDM to perform Match and Merge on Patient Data.
- Responsible for configuring MDM Hub as well mentoring junior resources and validating their work before delivery to ensure quality.
- Responsible for designing ETL Processes using Informatica Power Center and IDQ Developer to implement data scrubbing before data pushed into Informatica MDM engine.
- Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports .
- Using IDD configure patient, address, patient role, and Patient E address subject area in IDD.
- Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
- Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
- Upgrading to Informatica MDM 10 to10.1 and Address doctor 5 configuration.
- Implemented the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems
- Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
- Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages, and query groups
- Configured Address Doctor, which can cleanse whole world address Data and enhanced by making some modifications during installation.
- Worked Address doctor to cleanse the address for patient, provider domains.
- Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
- Used Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD
- Worked with HIPAA Transactions and EDI Transaction Sets (834, 835, 837, 824, 820, 270, 276, 271, 278)
- Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records
- Configured match rule set property by enabling search by rules in MDM according to Business Rules.
- Responsible for creating, monitoring, modifying, & communicating the project plan with other team members.
- Performed match/merge and ran match rules to check the effectiveness of MDM process on data Created Unit Test Case document.
Work Environment : Informatica MDM 10.1/10.0, Informatica 10.1/9x and WebLogic, Windows, ActiveVOS, SQL Server 2012/2016, IDD, Tidal.
Confidential
Sr Informatica MDM/ETL Developer
Responsibilities:
- Involved in Requirement gathering from business users and translated them into technical specifications.
- Be the subject matter expert in Data Modelling - logical and physical and provide oversight in integration of various data sources into the Enterprise Data Warehouse.
- Configured and installed Informatica MDM Hub server, cleanse Server, resource kit in Development, QA, Pre- Prod and Prod Environments.
- Involved in gathering business requirements for the data-warehouse as well as business-intelligence reports used by the management.
- Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
- Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems.
- Involved implementing trust values and created validation rules for trust columns.
- Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
- Configured Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation
- Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
- Used Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.
- Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
- Configured match rule set property by enabling search by rules in MDM according to Business Rules.
- Involved in creating, monitoring, modifying, & communicating the project plan with other team members.
- Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
- Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL tool.
- Created and Scheduled sessions & Worklets using workflow Manager to load the data into the Target Database
- Extract data from Flat files and Oracle Database using Informatica.
- Scheduled and monitored the daily Informatica incremental loads through the Autosys Scheduler.
- Involved in performance tuning by setting Cache, limiting the number of initialization blocks, limiting select table types, pushing the calculation to the database.
Work Environment : Informatica MDM 10.1, Informatica 10.1/9x, Tableau 9.3.1. UNIX, Windows, ActiveVOS, Oracle 11g, PL/SQL, IDD, UNIX Shell Scripting, Putty, PL/SQL Developer, Tidal.
Confidential
Sr ETL Developer
Responsibilities:
- Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translated business rules and functionality requirements into ETL procedures. Extensively worked towards optimizing the Queries to enhance the performance
- Used Informatica Workflow Manager to create, Schedule, execute and Monitor Sessions, Worklets and Workflows
- Extensively used Source, Target and Transformation shortcuts.
- Extensively used Worklets and Mapplets which were reused across different releases.
- Involved in designing the procedures for getting the data from all systems to Data Warehousing system
- Involved in fixing invalid Mappings, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data
- Involved in developing the mappings for moving data from Flat Files to Staging (STG) and then to Data Warehouse (DWH) and then to Data Mart
- Created test cases and completed unit, integration and system tests for mappings developed. It involved documenting the test cases and the output for the given input
- Created Connected and Unconnected lookup transformations to look up the data from the source and target tables
- Improved the performance of the mappings by moving the filter transformations early into the transformation pipeline, performing the filtering at Source Qualifier for relational databases
- Designed and developed complex Aggregator, Joiner, Router, Lookup and Update Strategy transformation rules (business rules)
- Created ETL scripts for data conversion, migration and transformation of legacy data
- Created scripts, which were part of the mapping's session properties
- Used sessions to move files from one directory to another and also to compare files
Environment: Oracle 10g/9i, MSSQL, PL/SQL, SQL*Plus, SQL* Loader, Windows 2000, Informatica 8.6
Confidential
ETL Developer
Responsibilities:
- Interacted with the Business Partners to understand the overall business purpose of the project, gathered and analyzed the requirements
- Designed Complex Informatica mappings with transformations such as Aggregator, Expression, Joiner, Filter, Source Qualifier, Union Transformation, connected/unconnected Lookups, Update Strategy, Normalizer and Router Transformation to transform and load the data from and to and relational tables
- Developed and used re-usable transformations and mapplets extensively to simplify development and maintenance
- Daily coordination with offshore team on reviewing the work, resolving issues, providing directions on design and collecting the status
- Resolved the Issues raised by offshore team by contacting business team (if needed)
- Performed ETL Tuning by identifying and eliminating the bottlenecks at Source, Target and transformation levels
- Performed data quality analysis to validate the input data based on the cleansing rules
- Worked on database connections, SQL joins loops, aliases, views, aggregate conditions for processing business logic in the database. Tuned SQL queries for better performance
- Performed unit testing on the Informatica code using the Informatica Debugger and by manually checking through SQL Queries
- Involved in migration of ETL objects in all phases (DEV, QA and PROD) of project.
- Reviewed the Business/ Functional/ System Requirement Specs, High Level Design Documents, and Detailed Design Documents.
- Worked with Business Analysts and Business Users team to understand the requirements and translate the requirement into technical specifications.
Work Environment : Oracle 10g/9i, TOAD, PL/SQL, SQL* LOADER, UNIX, Business Objects, Informatica 8.1.