Job Description :
Perform data modeling and data analysis Data Model design for landing layer staging layer consolidated layer and end layer
Analyze data at landing and staging layers Design the data model and convert to physical tables
Define the application inbound and outbound data feed process frequency and data structure to ODS
Analyze and define the data structure map the data fields including derived fields from various source system identify the data extraction transformation and loading processes
Design and implement effective database solutions and models to store and retrieve data
Examine and identify database structural necessities by evaluating client operations applications and programming
Assess database implementation procedures to ensure they comply with internal and external regulations
Prepare accurate database design and architecture reports for management and executive teams