Data Architect ( Big Data)

Role : Data Architect ( Big Data) Criteria while submitting profile : Client is looking for test result of (IKM CodeChek/TechChek) along with resume and assessment.Location: anywhere in USWorking Time zone: Pacific Time Zone JDData Architect (Big Data)Expertise in SQL, Python, ERD, GCP(All services, especially BigQuery, GCS, Cloud Function, Composer), DBT with active hands-on experience in the last 3~5 yearsPossess the knowledge of Modern Data Technology released in the last 2~3 yearsDesign and optimize conceptual and logical database modelsAnalyze system requirements, implementing data strategies, and ensuring the efficiency and securityImprove system performance by conducting tests, troubleshooting, and integrating new elementsIn-depth understanding of database structure principlesExpertise in implementing and maintaining data pipelinesDeep knowledge of data mining and segmentation techniques10+ years in data modeling with 3+ years in Big data (100TB+)Familiarity with data visualization toolsPub-sub setup/configuration steps. Use case where pub-sub is used.EventGCP ServiceDBT: which versionIncremental strategy – pros & consGCP adapterPerformance boost, optimization used when data is in 100TB+Macro, use case, goal of macroRegexUtility packagesConfigure freshnessClustering Key : how data is stored when you do clusteringUUIDIAC tool usedCommands written in TerraformOpen data catalogueFunctionsLLMCoding test will be in SQL, Python programming. Client will share Coder Pad tool link to candidate during interview.