Solutions Architect

MatchPoint Solutions is a fast-growing, young, energetic global IT-Engineering services company with clients across the US. We provide technology solutions to various clients like Uber, Robinhood, Netflix, Airbnb, Google, Sephora, and more! More recently, we have expanded to working internationally in Canada, China, Ireland, UK, Brazil, and India. Through our culture of innovation, we inspire, build, and deliver business results, from idea to outcome. We keep our clients on the cutting edge of the latest technologies and provide solutions by using industry-specific best practices and expertise.
We are excited to be continuously expanding our team. If you are interested in this position, please send over your updated resume. We look forward to hearing from you!

Job Title: Solution Architect

Location: Remote with some travel to California (California candidates preferred)

Work Hours: 9-5pm PST

Duration: 12 months

Start Date: Nov. 14, 2022

Requirements:

• Delivers a comprehensive solution architecture relating to modernizing your data platform services through cloud technology.
• Help to translates the companies' data vision and strategy into a viable architectural framework to meet your business needs.
• Responsible for defining the policies, procedures, models and technologies to be used in collecting, organizing, storing and accessing company information.
• Strong experience working with oracle

Projects:

Stack used:

• DW Oracle 19C
• ODI Oracle Data Integrator
• SSIS to push data into Oracle DW
• OSI PI

First Project - OBI Metadata Improvement:

• • Phase 1
    • Currently the tables have not details/definitions about the table, columns etc.
    • Oracle Database
    • Identify tool where to save the details/definitions.
    • Populate the details for all databases with relevant details.
  • Phase 2
    • Application Component Dependency Mapping
    • Identify which applications are accessing which data from which databases and the data flow.
    • Identify tool/system to capture this information
    • Populate this data in the identified system/tool.

Second Project - ED PI Data Quality Improvement:

• • This team is expected to help build Data Quality detection algorithms
  • Original they used SQL Server environment but is now all in Oracle.