Job Description :
Description:
Data modeler Full time position
Note that with the more senior levels, some banking/finance experience is mandatory
Logical Data Modeling:
3-5 years’ Experience in Data Warehouse and Data Mart applications
2+ Years of Conceptual and Logical Data Modeling
Good to have Domain knowledge of Banking with Wholesale and Retail Products or HR and GL systems
Data Demand Analysis to determine existing data vs new data
Add new data elements to Data Model
Create and publish TRL (target record layout) for source data acquisition
Work with SIT, UAT, ETL and DQP teams to socialize the data model/TRL changes
Troubleshoot problems faced by SIT & UAT testing teams provide solutions
Physical data Modeling:
2+ Physical Data Modelling & Ensure fitness of Data model
Develop source to target mappings (TRL (target record layout) to physical data models)
Ensure and track model deployments across all the environments/swim lines
Troubleshoot problems faced by SIT & UAT testing teams provide solutions
PROD support on identified issues when required
Managing versioning repository
Act as effective communicator, work with different teams and Testing partners on issues
Very proficient with SQL to investigate and analyze the data Loading/transformation issues.