JPC-221497 - Data Architect
Job Posted: May 14, 2024 | Total views: 2

Job Description:

• Job Description

   

  Work Hours: 1-10 pm IST as overlap with US team is required

   

  Duration: 12 months

   

  Rate: 30-32LPA

   

  Number of roles: 2

   

  Requirements:

   

   

  
  
  

  •  Deep experience with large data sets and managing deltas 

   

  • Experience across multiple big data platforms (Hadoop, Hortonworks, MapR, Cloudera, AWS, GCP, etc.)

   

  •  5+ years of experience

   

  • Develop database solutions to store and retrieve company information

   

  • Install and configure information systems to ensure functionality

   

  • Analyze structural requirements for new software and applications

   

  • Migrate data from legacy systems to new solutions

   

  • Design conceptual and logical data models and flowcharts

   

  • Improve system performance by conducting tests, troubleshooting and integrating new elements

   

  • Optimize new and current database systems

   

  • Define security and backup procedures

   

  • Provide operational support for Management Information Systems (MIS)

  
  
  

  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.

  
  
  
  
  
  

  • 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.

  
  
  
  
  
  
  

  
  
  
  
  
  

   

  
  
  
  
  

   

   

   

   

About Company :
Purview is a leading Digital Cloud & Data Engineering company headquartered in Edinburgh, United Kingdom having a presence in 14 countries India (Hyderabad, Bangalore, Chennai and Pune), Poland, Germany, Finland, Netherlands, Ireland, USA, UAE, Oman, Singapore, Hong Kong, Malaysia and Australia.

We have a strong presence in UK, Europe and APEC, providing services to Captive Clients (HSBC, NatWest, Northern Trust, IDFC First Bank, Nordia Bank etc) in fully managed solutions and co-managed capacity models. Also, we support various top IT tier 1 organisations (Capgemini, Deloitte, Wipro, Virtusa, L&T, CoForge, TechM and more) to deliver solutions and workforce/resources.

Company Info: