Design Draftsman

Position: Data Architect

Location: New Jersey

Mode of Work: Full time

Salary: Industry Standard.

Positions: 1

Need immediate joiners.

Skills/Experience/Qualifications

15+ years of professional experience in the field of Data Architecture, Design and Development of Data Management and Data Governance projects

Experience should include hands-on experience of implementing Customer Data Hub or Customer Information Management system or Customer Data Mart which

includes Modelling Customer Data Model in 3NF / Dimensional Model, defining and developing integration patterns like Batch and real time, defining & developing the physical storage layer, defining & developing the consumption pattern

Experience with Data Modelling is a MUST, experience of defining standards and data architecture best practices is a must

Experience with Data Management/Architecture Practices like Data Integration, Data Governance, Data Quality, Metadata management, Data Security, Data Encryption etc. is a must

Must have hands on experience with developing large Data Mart or Datawarehouse or Data hub involving data modelling, data ingestion, data processing and extract generation to the downstream systems

Must have experience with any ETL tool like Informatica or Data stage or other for data processing requirements.

Experience with any Identity resolution products for Name and Address standardization like Informatica IDQ / Address Doctor /IBM Quality stage is required.

Experience with any Data Quality product like Informatica IDQ, Quality stage or trillium will be an added advantage

Must have strong experience with writing SQL s for pulling and analyzing source / data platforms

Experience with Data Science models, model validation, model tuning and model management will be a added advantage.

Proactively communicate and collaborate with business stakeholders to understand the business requirement and translate them into design and develop the respective module based on the requirements.

Must have experience working in a Agile implementation set up with Product Backlogs, User Stories, Scrum and sprint planning etc.

Strong verbal and written communication and English language skills

Strong consulting skills, consulting experience strongly desired.

Requirements

Job Responsibility

Developing Data Architecture and Design documents for Data Lake, Datawarehouse & Data Marts corresponding to Customer Information Management Systems

Configuring Solution and Coding any customization required for the Data platform including Data Lake, Datawarehouse and Data Marts

Working with the clients to understand the requirements. Develop required codebase for the functional needs

Develop Source to Target mapping document for all the attributes that are required to be captured for Data Lake, Datawarehouse and Data Marts

Configure and develop code required for Upstream and downstream system communication in a Batch and real time mode

Provide clarifications for any questions that Business / SME team or any other stakeholder has on Data implementations.

Participate in system and acceptance testing along with the stake holders

Benefits