Responsibilities
- Minimum 8-10 years of industry experience in Data Architecture and Data Modeling using ER Studio or Erwin.
- Must have full lifecycle project experience as a Data Architect in designing and developing Enterprise Data models.
- Must have multiple full lifecycle project experience as a Data modeler in modeling for Operational Data Stores, Data Warehouses and Data Marts.
- Strong understanding of DW concepts
- Hand on experience in implementing Dimensional and 3NF data models.
- Understanding of DW appliances, Hadoop, SQL and PL/SQL concepts, standards and best practices
- Database development, physical database design and data modeling experience
- Capture new requirements or changed requirements for modeling for new data marts, ODS, data warehouse.
- Logical and Physical modeling and design for 3NF/dimensional model for ODS/Data Warehouse,
- Develop/Modify data models as per requirements
- Strong experience of data modeling in the Insurance industry, preferably life business, is a must.
- DDL for database creation on appliances and manage database creation activities from inception to completion including interdependencies with other teams
- Conversant with designing data structures for Hadoop staging and DW and Data marts hosted in DW appliances
- Take an active role in the cross-functional design and coordinate with ETL and reporting teams
- Work closely and foster strong relationships with ETL architecture team, database administration and data consumers (e.g., reporting and interfaces teams) to design warehouse/BI data structures
- Manage the build phase and quality‑assure the code to ensure that it meets requirements and adheres to standards; resolve difficult design and build issues; troubleshoot bugs
- Plan and execute Quality Assurance testing with the QA team and resolve QA defects
- Plan and manage QA and Production releases and ensure they are deployed smoothly
Generic Managerial Skills
- Ability to prioritize and work on multiple tasks simultaneously
- Strong communication and organizational skills
- Ability to multi‑task, prioritize and execute on assigned deliverables
- Ability to quickly learn new systems and business processes
Education
- Bachelor’s Degree
Qualifications
please share your profile to mdanish(at)1stitsolutions.com
Additional Information
Job Status: Full Time / Permanent
Share the Profiles to mdanish(at)1stitsolution.com
Contact:
Keep the subject line with Job Title and Location
#J-18808-Ljbffr