Job Description
Responsibilities:
Data Model Design and Development:
o Design and develop logical and physical data models for the Customer and Loan Master Data API solution, encompassing schemas for loan, borrower, property, application, and other related data entities.
Data Integrity and Consistency:
o Ensure data integrity, consistency, and accuracy across all systems by implementing appropriate constraints, validation rules, and data quality checks within the data models.
Data Mapping and Integration:
o Create detailed data mappings between source systems (e.g., DataTrac, BytePro, LoanServ, Salesforce CRM) and the master data repository. Collaboration and Communication:
o Collaborate closely with the development team to ensure the data model is effectively implemented and integrated into the API solution.
Documentation and Standards:
o Maintain comprehensive data model documentation, including data dictionaries, entity-relationship diagrams (ERDs), and data flow diagrams. Skills & Qualifications:
Experience:
o 5+ years of experience as a Data Modeler, Data Architect. Technical Skills:
o Expert knowledge of data modeling principles, techniques, and methodologies (e.g., relational, dimensional, star schema, snowflake schema).
o Proficiency with data modeling tools such as Erwin Data Modeler, SAP PowerDesigner, or similar tools.
o Strong SQL skills, including the ability to write complex queries, stored procedures, and triggers.
o Experience with database management systems (DBMS) such as Microsoft SQL Server, Oracle, MySQL, or PostgreSQL.
o Familiarity with NoSQL databases (e.g., MongoDB, Cassandra) is a plus.
o Knowledge of data warehousing concepts, ETL processes, and data integration techniques.
Work Location : India(Remote), Mumbai, Delhi / NCR, Bengaluru , Kolkata, Chennai, Hyderabad, Ahmedabad, Pune
Work Timings : 2:30PM-11:30PM
Job Classification
Industry: IT Services & Consulting
Functional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Data warehouse Architect / Consultant
Employement Type: Full time
Contact Details:
Company: Codvo
Location(s): Mumbai
Keyskills:
Erwin Data Modeler
NoSQL databases
Microsoft SQL Server
PostgreSQL
MySQL
ETL processes
Oracle
SAP PowerDesigner
SQL