DearbornRecruiter Since 2001
the smart solution for Dearborn jobs

MDM Developer

Company: FastTek Global
Location: Dearborn
Posted on: January 13, 2022

Job Description:

Job description Software Engineer Senior #711723, W2 Contract for 24 months with likely extension, remote to start but prefer those open to living/working in the metropolitan Detroit area (This is NOT a C2C opportunity) Job Description: Candidate is responsible for Informatica MDM HUB development support and should have detailed technical knowledge of Informatica MDM product, Powercenter and IDQ tools. Drives technical solutions and issue resolutions based on business need. Produce and develop detailed MDM design specifications, develop custom mapping functions and customizations to the database tier of Informatica MDM Hub. Analyze and defines detailed MDM processes, tasks, data flows, and dependencies. Develop extensions and customizations to the services (SIF) tier of Informatica MDM Hub. Conducts MDM unit tests and code reviews. Participates in MDM design reviews, including database code design reviews. Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter and IDQ. Support requirement analysis, system analysis, design, development, testing, implementation, technical issue / conflict resolution; demonstrate problem solving skill. Participates in system and integration test, identifies and resolves solution defects. Provides ongoing support, monitoring, and maintenance of deployed products. Actively works with less experienced platform engineers providing technical guidance and oversight. Skills Required: Experience in Mater Data Management (MDM) Multi Domain Edition HUB Console Configurations, Informatica Data Director (IDD) Application creations, Informatica Powercenter and IDQ tools Extensive experience in Master Data Management (MDM) HUB Console Configurations such as Staging Process Configurations, Landing Process Configurations, Match and Merge Process, Cleansing Functions, User Exits. Experience in Mater Data Management (MDM) Multi Domain Edition HUB Console Configurations, Informatica Data Director (IDD) Application creations. Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM (Siperian). Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation. Experience in creation and maintenance of entity objects, hierarchies, entity types, relationship objects Relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation. Hands on experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages. Skills Preferred: Designed, Installed, Configured core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, Data Modeling. Worked with Sif API to interact with real time applications. Strong SQL, PL/SQL, T-SQL programming skills in Oracle 12c/11g/10g, Experience in debugging, error handling and performance tuning of sources, targets, mappings and sessions with the help of error logs generated by Informatica server. Experience in Agile, Waterfall and UML Methodologies. Good Exposure to development, testing, debugging, implementation, documentation and production support. Extensive experience in implementation of Data Cleanup procedures, Transformations, Scripts and Execution of Test Plans for loading the data into the targets. Experience in production support to resolve critical issues and mingle with teams to ensure successful resolution of the reported incident. Strong analytical, logical and problem solving skills and ability to quickly adapt to new technologies by self-learning. Experience Required: Over six years of experience in Informatica Master Data Management, Informatica Data Director (IDD) Application , Informatica Powercenter and IDQ tools Education Required: Bachelor's degree in Computer Science or equivalent Job Requirements:Perform the detailed design of ETL to DataMart (informatica)Analyze data in the data warehouse, data mart or operational systemsPerform statistical analysis of business dataLoad the data into the enterprise data warehouseSupport the lifecycle of physical data models and data maps for data warehouse systemPerform analysis on the dataSupport the development and design of the internal data integration frameworkCreate data mappings from source systems to the target systems, data warehouses and data martsLead the development /integration of the following: data loading for data marts and enterprise data-warehouseObtaining table designs and analyzing data structures in preparation for data exchanges, and completing data testing for data exchangesPerform data analysis and data profiling against source systemsPerform detailed data analysis to understand the source system dataDrive the design of solutions for the businessDevelop data solutions to help the product and business teams make data driven decisionsTransform Load) and interface/integration of data into the data warehouse and data marts)Participate in data modeling and data design with BI Tech LeadSupport new and existing data using InformaticaDevelop and maintain data management standards and conventions, data dictionaries, data element naming standards and data dictionary metadata standardsLead development on creating data-dictionaries of key tables and libraries within the data-warehouseIntegrating disparate sources of data

Keywords: FastTek Global, Dearborn , MDM Developer, IT / Software / Systems , Dearborn, Michigan

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Michigan jobs by following @recnetMI on Twitter!

Dearborn RSS job feeds