fbpx

Solutions Designer

Location: Philippines

Role

Technical Consultant/Senior Technical Consultant

Job Description

Primary Responsibilities:

  • Provide design solutions, conduct source code reviews, unit test plan reviews. 
  • Responsible for delivery of all design artifacts required by compliance teams. 
  • Responsible for Database designs, data interface/transformation/loading designs. 
  • Provide inputs to the Conceptual Data Model, Logical/Physical Data Model to help ensure the conceptual and logical model design conforms with the data requirements and overall application design 
  • Consults with Data Engineer and DBA to ensure that the physical database design best optimizes multiple drivers – such as support and maintainability (physical database design and 
  • Provides direction to developers and provides support to the Data QA team 
  • Estimate the time and effort for various phases and tasks to be performed by the design and development team 

Qualifications

Primary Skills:

  • Data Object Modeling 
  • Data Governance (Metadata Management and Data Classification) 
  • Data Governance (Data Transformation and Lineage) 
  • Data Access and Privacy Layer Modeling 
  • ELT 
  • Normalization 
  • Data Architecture Patterns (Snowflake and Star Schema) 
  • Data Ops 
  • Functional Data Engineering Cloud Serverless Architecture 
  • Data Lake Implementation Patterns ANSI-SQL (MSSQL, Oracle SQL, MySQL) 
  • Informatica Power Center 
  • Python/Node JS/Java Any Scheduling Tools (CRON – Batch, Windows Task Scheduler, Autosys, ControlM) 
  • REST API 
  • FileFormating (CSV, TSV, Excel, Fixed/Variable-Width, JSON, Parquet, ORC) 

Number of Vacancies:

1

Apply Now

Realise your potential at Thakral One.