Senior Informatica Mdm Developer Resume
Columbus, OH
SUMMARY
- Senior Informatica MDM Developer with 8+years of IT experience and has portrayed skills in analysis, designing custom solutions, implementationand development of Data warehouses using Informatica and trouble - shooting and testing using ETL testing tools.
- Experience in integrating external application with Informatica MDM hub using message queries as a significant advantage.
- Experience working on Informatica MDM in design, develop, test and review & optimize Informatica MDM (Siperian) and IDD Applications.
- Strong proficiency in maintaining data warehousing applications using Informatica Power Centre.
- Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
- Expertise on DataWarehousing Concepts like Dimension Tables, Fact tables, slowly changing dimensions, Datamarts and dimensional modeling schemas.
- Developed complex mappings in Informatica using different transformations Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, Expression, Union, Stored Procedure transformation etc.
- Extensively worked with data warehousing, ETL methodologies, technologies, using Informatica Power Center.
- Excellent hands-on Data Exchange, MDM, IDQ, Data Transformation, SQL development.
- Good knowledge in Data warehousing concepts involving dimensional Star Schema, Snowflakes Schema and Galaxy Schema methodologies.
- Involved in OLAP data modeling for star and snowflake schemas.
- Experience in writing Indexes, PL/SQL procedures, Functions, Packages, Database Triggers.
- Experience in error handling, performance tuning and problem fixing in Informatica MDM.
- Experience on ETL testing tools and worked on QTP and QC.
- Expertise in writing the data clean up scripts using SQL queries and UNIX scripts.
- Proficient in data warehousing techniques for Data cleansing, Slowly Changing Dimension phenomenon's (SCD's), Change Data Capture (CDC), Customer Data Integration (CDI).
- Developed several test plans to find bugs and report errors.
- Experience in the SIF framework and Application Program Interface (API) development.
- Experience in resolving Defects, resolving requirement and observed design consistencies.
- Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by layering Business Requirements and developing Test Scenarios to support quality deliverables.
- Competent to deliver results on multiple tasks by promptly managing time and priority constraints. Ability to address any ongoing or changing Business needs.
- Strong potential in managing multiple projects without effecting quality and delivering on discussed timelines.
- Experience with On-Site/Off-Shore Model of project delivery.
TECHNICAL SKILLS
ETL Tools: Informatica Power center 8.6, 9.1, 9.5, 9.7, Informatica MDM, IDD, IDQ, SIF, ActiveVos
Reporting Tools: Tableau
Scripting Languages: UNIX Shell scripting, VBA Scripting
Databases: Oracle 8i/9i/10g/11g, Teradata, SQL server
Database Tools: TOAD
Loaders: SQL loader, Fastload, TPT, Multiload
Methodologies: Star schema, Snowflake schema
Testing tools: QTP, HP Quality center
Scheduling tools: Autosys, Tidal
Operating systems: UNIX, Windows
Languages: SQL, PL/SQL
PROFESSIONAL EXPERIENCE
Sr. MDM/ActiveVos Developer
Confidential, Houston, TX
Responsibilities:
- Associated with the business team to gain knowledge on the functional aspects.
- Conducted weekly sessions with the functional team to finalize the client requirements and the Datastewards team to understand the roles in their hierarchy.
- Configured source systems collaboratively and performed Batch group with Stage and Load jobs.
- Implemented Land Process for loading the customer Data Set into Informatica MDM from various sourcesystems.
- Design and develop MDM data model and defining logical relationships between the objects.
- Configure IDD and Hierarchy Manager. Configured Trust scores.
- Reviewed and designed the MDM/ActiveVOS setup and performed development and deployment.
- Configured integration between the Activevos 9.2.4.1 and MDM 10.0.1 for creating the custom workflow process and designingthe orchestration project.
- Designed Interfaces in connecting to External systems Salesforce/SAP using JMS messaging
- Performed a proof of concept in customizing the default MDM Task Workflow process.
- Developed BPEL files, deployed the .BPR files onto the ActiveVos server.
- Worked on the Activevos Console to monitor and report the processes, tasks and servers.
- Worked on Xpath, Xquery, and SOAPUi and WSDL files.
- Created workflows using Events, Gateways, Controlflows and generated forms by creating .avcconfig files.
- Generated .PDD files and exported them to the server and deployed the .BPR files into the server.
- Configured Human tasks in the workflow to assign roles to the Datastewards and configured Email/Messaging/Identity services
- Created forms in the Activevos designer and deployed them on the ActiveVos central to trigger workflows through form input.
- Involved in creating IDD tasks and assigning roles to the tasks in ActiveVos to trigger the workflows.
- Configured JMS on Activevos server to publish data to external applications/source systems.
- Installed ActiveVos sever on Windows with JBOSS.
- Configured and setup URN mappings on the Activevos Console.
- Implemented workflows based on Onestep, Twostep Approval processes and customized workflows to suffice business requirements.
- Collaborated with the offshore team and supervised on their build phase activity.
Environment: Informatica MDM 10.0.1, IDD, ActiveVos 9.2.4.1, Flat files,Java, SQL, UNIX Scripting, Putty, Visio, Tidal, Autosys.
Senior Informatica MDM Developer
Confidential, Atlanta, GA
Responsibilities:
- Interacted in business meetings to analyze the business requirements and developed a design plan.
- Coordinated with business analysts to analyze the business requirements and designed and reviewed the implementation plan.
- Worked in an Agile Software Development life cycle to successfully accommodate change in requirements.
- Worked with ETL tool Informatica Power center for performing custom cleansing when the data is loaded to the landing tables in the MDM.
- Performed a proof of concept in ETL to categorize junk records before data is pushed to landing, mocking the same functionality of post landing user exits.
- Normalized data schema across four different source systems and successfully delivered projects within budget.
- Configured source systems collaboratively and performed Batch group with Stage and Load jobs.
- Implemented Land Process for loading the customer Data Set into InformaticaMDM from various source systems.
- Design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages
- Configured custom landing tables and performed proof of concept integrating hub state indicator as required by the business requirements.
- Worked in a proactive manner with testers to identify and close defects before UAT.
- Peformed rule based Profiling on the client business data in understanding the depth of accuracy and duplicates which are needed for MDM implementation.
- Created draft technical design documents based on the functional design documents.
- Resolve functional as well as technical queries by taking help of functional SME or client users.
- Interacted with business users in configuring Match setup and tool proposition for Data quality Address doctor.
- Involved in designing MDM data model and created base objects, mappings, defined trust setting for sources, customized user exists, customized IDD applications.
- Reviewed and designed the MDM/ActiveVOS setup and performed development and Unit testing and deployment.
- Performed and implemented proof ofconcepts when needed to client for solution propositions.
- Worked through all the phases of SDLC including maintenance.
- Worked on the CA hub Master Data management to align four different source systems performing fine tuning to the match/merge rules.
- Initiated API calls using SOAP UI/tools to perform cleansing for Base Objects, HREF, HXREF.
- Integrated with the ETL team and developed a new approach for Initial Data loads.
- Implemented Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes.
- Altered Trust scores and set up Validation rules as per the business requirements.
- Created Batch deployment groupsand ran audit trail for Incremental loads.
Environment: Informatica MDM, IDD, IDQ9.7,Informatica 9.7, 9.6.0 & 9.5.1, (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Flat files, SQL, UNIX Scripting, Putty, Visio, Tidal, Autosys.
Senior Informatica MDM Developer
Confidential, Columbus, OH
Responsibilities:
- Teamed with business analysts to deduce the business requirements to produce effective technology solutions.
- Worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
- Conducting requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.
- Involved in implementing the Land Process of loading the customer Data Set into InformaticaMDM from various source systems.
- Collaborated with the data modelers to perform mappings and organize the data using the Erwin tool for data modeling.
- Worked on data cleansing using the cleanse functions in Informatica MDM.
- Used Informatica ETL Power Center 9.6 for migrating data from various OLTP databases to the data mart.
- Worked with different sources like Oracle, flat files, XML files, DB2, MS SQL Server
- Extracted data from Sales department to flat files and load the data to the target database
- Developed complex mappings using Informatica to load Dimension & Fact tables as per STAR schema techniques.
- Extracted data from sources like fixed width and Delimited Flat files transformed the data according the business requirement and then loaded into Target Data mart.
- Data Quality and Data integration in real-time using SIF API's.
- Defined Trust and validation rules before loading the data into the base tables
- Involved in SIF integration to develop xml code for external applications to perform search match API calls against MDM Hub Data.
- Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes.
- Performed in creating tasks in the workflow manager and exported IDQ mappings and executed them using the scheduling tools.
- Created IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data from flat file.
- Worked on Tidal and Autosysscheduling tools depending on client’spreference to schedule tasks
- Involved in preparing required Tech Specification Documents from the Business requirements following Organization standard.
- Publishing Data using Message Queues to notify external applications on data change in MDM Hub Base Objects.
- Constructed reusable objects like Mapplets and worklet transformations combined withuser-defined functions to use across multiple mappings.
- Executed jobs using ETL frameworkby setting up scripts and configuration files.
- Created deployment groups forproduction migration (mappings, workflows, parameter files and UNIX scripts) and supportedpostproduction support during warranty.
- Practiced soft proofing on JDF enabled products to communicate between each other by exchanging JDF files through hot folders.
- Worked on UNIX platform in creating a shell script to perform functions for updating the parmfiles, sending mails and FTP files.
- Used scheduling tools to create new jobs and job dependencies are setup with different Autosys cycles.
- Experienced in writing SQL queries for retrieving information from the database based on the requirement.
- Experienced in partition creations and dimension additions.
- Involved in the UAT testing of the Items Data Mart price files tool automation project.
- Performed testing on connections, scripts, workflows, mappings and other scheduled activities.
- Responsible for handling Supply Chain Management Data Warehouse and related database and online solutions.
- Worked with the offshore team and supervised on their development activity.
- Reviewed code and confirmed it was compatible to standard programming practice.
- Conducted Knowledge transfer sessions about the project to the team and managed the project by providing reviews on it.
Environment: Informatica MDM, SIF, IDQ9.7, Informatica 9.6.0 & 9.5.1, (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Erwin, Flat files, SQL, UNIX Scripting, Putty, Visio, Tidal, Autosys.