MDM Developer

Back MDM Developer Other Area(s) Albany W-2 hourly Aug 25, 2026 Our goal is to solve problems and deliver results for our clients. At Cloud and Things, you can be a part of transforming the public sector’s IT environment. Our team is on the forefront of helping to solve the government's most complex IT challenges. If you are seeking a role that offers the opportunity to work on rewarding projects, consider a career with Cloud and Things. *This is an exempt position. Salary commensurate with experience* Job Title: Senior MDM Developer Location: 40 North Pearl, Albany, NY (Hybrid) Duration: 31 Months (with potential for extension) Start Date: estimated - 10/8 W2 Hourly Rate: $65-85/hour Application Deadline: 9/4 Overview We are seeking a MDM Developer who will support our NYS client. The role will analyze requirements and design, develop, implement, and support end-to-end Master Data Management (MDM) solutions, including data models, data quality rules, and match and survivorship rules. The developer will also manage ETL solutions and troubleshoot data integration and performance issues across medium- to large-scale OLTP and OLAP environments. Duties Analyze requirements, design, and develop end-to-end Master Data Management (MDM) solutions. Design and build data models, data quality rules, and match and survivorship rules. Perform analysis, design, development, and implementation, including data analysis, data access, data structures, data transformation, data reporting solutions, and user documentation. Manage and administer ETL solutions for medium- to large-scale OLTP and OLAP projects. Monitor daily ETL jobs and processes that identify load and performance issues, determine the resolution, and revise incorrect operational processes. Communicate and coordinate with members of the development team to work across multiple projects. Explore, actively support, and work on new technology initiatives that may be of interest to the organization. Actively participate in troubleshooting any technical issues that the program may have. Other duties as assigned. Mandatory Qualifications 7+ years of experience working on complex projects with two (2) or more years in a leadership role as a Developer. 7+ years of hands‑on experience in implementing and maintaining data integration processes using the Informatica suite of products such as Master Data Management (MDM), Informatica PowerCenter and/or Informatica Data Quality, or similar products. 2+ years of experience of domain knowledge and experience in an Integrated Eligibility System within Health and Human Services programs such as PA, TA, SNAP, HEAP, Fair Hearings, Child Support, etc. 7+ years of experience of using ETL tools like Informatica PowerCenter to migrate data from various sources and targets including databases, flat files, XML files, and UNIX shell scripts. 7+ years of experience with Data Quality processes, approaches, measurement techniques, and business cases for data profiling, data cleansing, standardization, match and merge functionality using tools such as Informatica Data Quality. 7+ years of experience developing complex SQL and PL/SQL objects with Oracle 11g or higher such as stored procedures, triggers, packages, materialized views, and using Oracle supplied utilities including SQL Loader, external tables, and Oracle built-in packages to migrate data. 7+ years of experience writing complex UNIX scripts to validate and FTP files, and for scheduling and automating ETL processes. 7+ years of experience implementing ETL solutions for medium- to large-scale OLTP and OLAP projects. 7+ years of experience writing technical specifications including ETL source-to-target mapping documents, ETL design documents, and implementation documents. Ready to make a difference? We’re eager to connect with qualified candidates committed to delivering results and fostering excellence within client projects. AI-Assisted Resume Evaluation Notice Cloud and Things complies with all applicable federal, state, and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other category protected by applicable federal, state, or local laws. Notice to Candidates Cloud and Things utilizes artificial intelligence (AI) tools to assist our recruiting team in evaluating candidate applications for streamlining; consistency, efficiency, and thoroughness. All hiring decisions are ultimately made by our human recruiting professionals. How AI Is Used Analyzing resumes against job requirements Supporting our recruiters in candidate data evaluation Ensuring consistent review standards across all applications Important: AI serves as a support tool only. As noted above, all candidate selection and hiring decisions are made by experienced human recruiters. Your unedited resume will be processed by our AI tools as part of this evaluation. Your Data and Privacy Cloud and Things Data Handling: Your information is processed securely and used exclusively for recruitment purposes Cloud and Things may store your resume in our Applicant Tracking System (ATS) indefinitely for future job matching opportunities You may opt out of long-term ATS storage by emailing your name and your request to opt out of storing your resume in the ATS to: View email address on click.appcast.io All personal information is handled confidentially in accordance with our privacy policy AI Tool Data Processing AI processing data is retained for a maximum of 90 days, after which it is deleted All data sent to AI tools is encrypted in transit and at rest AI tools comply with applicable privacy laws including GDPR and CCPA Personal data is anonymized or minimized wherever possible during AI processing Your Participation By submitting your application, you acknowledge this notice and consent to AI-assisted evaluation as part of our recruitment process. You may opt out only by choosing not to submit your resume for consideration. #J-18808-Ljbffr