Level 3 Data Architect
Posted on :
26-06-2024
Employer Active
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Contact Details:
1.Debanjan Koley
Email:
Cell: (732)
2.Poonam Khandelwal
Email:
Cell: (732)/ Ext.408
3.Pio Dhivagar
Email:
Cell: (732)/ Ext.420
4.Sandeep Bisane
Email:
Cell: (732)
Location: Albany NY (Onsite)
Duration: 30 Months
Years of Experience: 12 Yrs.
Required Hours/Week: 40
Key Responsibilities:
Responsibilities will include:
Mandatory Qualifications:
Desirable Qualifications:
- Ten (10) or more years of handson professional experience building landing tables staging tables and base objects to develop a comprehensive master data model such as the party data model client/customer data model or provider/vendor data model in Informatica MDM Hub to support MDM solutions. This includes but not limited to designing developing and implementing entity relational diagrams conceptual logical and physical relational data models.
- Ten (10) or more years of handson professional experience creating data profiling rules data cleansing rules data match rules (exact match fuzzy match) merge options automerge rules manual merge rules unmerge rules validation rules and trust rules in Informatica MDM and Informatica Data Quality products.
- Seven (7) or more years of handson professional experience in Informatica MDM Hub load process landing process staging process consolidate process exception handling process and publishing process.
- Seven (7) or more years of handson professional experience in designing developing and maintaining integrations between Informatica MDM solutions and other systems using APIs web services message queues Java Message Service (JMS) ESB Kafka and ETL tools.
- Seven (7) or more years of handson professional experience using tools such as Informatica PowerCenter or Informatica Data Quality to export transform and load data from source databases (e.g. Oracle) and flat files into the Informatica MDM landing tables.
- Seven (7) or more years of handson professional experience integrating Informatica MDM solutions with medium to large scale high volume OLTP and OLAP systems such as Case Management systems Enrollment and Eligibility systems Financial Management systems Child Support systems Court Hearings systems or similar systems.
- Five (5) years or more of handson experience using data modeling software (e.g. Erwin Data Modeler) and developing complex SQL queries Oracle PL/SQL packages stored procedures functions views complex joins indexes triggers external tables roles grants permissions DDL and DML.
- Seven (7) or more years of handson professional experience in data analysis metadata cataloging creating and maintaining documentation including technical specifications data mappings data dictionary data lineage data flow diagrams and highlevel and lowlevel design.
- Domain knowledge and experience in health and human services especially in Integrated Eligibility System programs such as PA TA SNAP HEAP TANF etc.
- Knowledge and experience in applying data management concepts such as data architecture data quality metadata management Data Warehousing and Business Intelligence data integrity data integration and interoperability data governance data security data storage and operations.
Employment Type
Full Time
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
