{"id":"0307921b-5d60-4cbf-8f54-01ed6196b36f","company":{"id":"44d4a59b-bd4c-496a-ade3-0792cd5631f4","company_stack":[],"company_gallery":[],"company_stats":[],"company_about_section":null,"company_benefit_section":[],"company_testimonial_section":[],"company_culture_section":[],"onboarding_process":null,"ticker_logos":[],"gtn_companies":[],"role_category":[],"cta_color":"#333333","name":"Prudent Technologies and Consulting, Inc.","short_name":"CMP2089","slug":"prudent-technologies-and-consulting-inc","description":null,"short_description":null,"about_us":null,"video_link":null,"logo_url":"https://talent500-public-prod-cb.s3.ap-south-1.amazonaws.com/company_logos/New_logoWhite_f3828439e996457db7531ecf9769a3ab.png","job_logo":null,"job_logo_url":"https://talent500-public-prod-cb.s3.ap-south-1.amazonaws.com/company_job_logos/T500_nogoTz6_a4600b31ac8d42be8fc807e2392f2e0d.png","show_powered_by_talent500_logo":false,"website":null,"redirect_logo_url":"https://talent500.com//joblist/?search_term=Prudent Technologies and Consulting, Inc.","linkedIn":null,"facebook":null,"twitter":null,"instagram":null,"hero_type":"1","nav_bar_color":null,"nav_items_color":"#FFFFFF","gallery_heading":"Gallery","company_image_url":"","meta_title":null,"meta_description":null,"hero_h1":null,"hero_h2":null,"primary_color":"#FF9900","secondary_color":"#333333","cta_text":null,"jobs_subtitle":null,"mission":null,"stack_section_title":null,"stack_section_description":null,"powered_by_logo_url":"https://d36dj8u11ystvj.cloudfront.net/Talent500_PoweredBy+(1).png","cta_bg_color":"#FFFFFF","cta_text_color":"#FFA000","cta_border_color":"#FFFFFF","h1_font_size":null,"h2_font_size":null,"h3_font_size":null,"h4_font_size":null,"body_size_1":null,"body_size_2":null,"h1_font_w":null,"h2_font_w":null,"h3_font_w":null,"h4_font_w":null,"body_w_1":null,"body_w_2":null,"public_name":null,"use_public_name":false,"unique_id":"efabd7f8-ca8f-423e-90f2-a0c1ab4ba597","head_favicon_url":"","head_title":null,"privacy_policy_name":"Privacy Policy","privacy_policy_url":null,"mandate_privacy_policy":null,"ticker_title":null,"publish":false,"company_font_family":"5","use_company_font_on_jobs_page":true,"gallery_section_name":null,"about_section_name":null,"testimonial_section_name":null,"benefits_section_name":null,"culture_section_name":null,"jobs_section_name":null,"is_job_displayable":true,"is_onboarding_skip":false,"company_specific_workflow":0,"third_party_company":true,"is_vendor_third_party_company":true,"priority_order":0,"order_of_about_role":1,"order_of_about_company":2,"whatsapp_company_logo":null,"whatsapp_company_logo_url":"","whatsapp_job_bg_color":null,"whatsapp_job_text_color":null,"engagement_type":null,"font_family":5},"location":"Greater Hyderabad Area","primary_skills":["Data modeling","reverse engineering","MSSQL","ETL pipelines in Python","Postgres","Azure DataFactory",".NET-Integrated environments","architectural decisions","stored procedures","transformation logic","schema behavior","ERDs","target data model","transformation layer","Python-based ETL pipelines","Azure Data Factory","documentation and traceability"],"secondary_skills":[],"experience_range":"","job_qualifications":[],"screening_questions":[],"title":"Senior Data Architect","description":"<p>\n We are looking\n <strong>\n  DATA ARCHITECT\n </strong>\n for someone who can step into ambiguity, reverse engineer reality, and architect a clean, scalable foundation.\n</p>\n<p>\n <br/>\n</p>\n<ul>\n <li>\n  This is not a maintenance role.\n </li>\n <li>\n  This is a\n  <strong>\n   ground-up re-architecture of the data layer\n  </strong>\n  .\n </li>\n</ul>\n<p>\n <br/>\n</p>\n<p>\n CORE REQUIREMENTS\n</p>\n<p>\n <br/>\n</p>\n<ul>\n <li>\n  Strong experience in\n  <strong>\n   Data modeling for legacy systems\n  </strong>\n  (not just greenfield)\n </li>\n <li>\n  Proven ability to\n  <strong>\n   reverse engineer undocumented systems\n  </strong>\n </li>\n <li>\n  Deep hands-on experience with\n  <strong>\n   MSSQL\n  </strong>\n </li>\n <li>\n  Experience building\n  <strong>\n   ETL pipelines in Python\n  </strong>\n </li>\n <li>\n  Working knowledge of\n  <strong>\n   Postgres\n  </strong>\n </li>\n <li>\n  Experience with\n  <strong>\n   Azure DataFactory\n  </strong>\n </li>\n <li>\n  Familiarity with\n  <strong>\n   .NET-Integrated environments\n  </strong>\n </li>\n <li>\n  Ability to make and defend\n  <strong>\n   architectural decisions with confidence\n  </strong>\n </li>\n <li>\n  Reverse engineer existing\n  <strong>\n   stored procedures, transformation logic, and schema behavior\n  </strong>\n </li>\n <li>\n  Map what the system is actually doing vs. intended behavior\n </li>\n <li>\n  Build\n  <strong>\n   current-state ERDs\n  </strong>\n  (from scratch)\n </li>\n <li>\n  Design a\n  <strong>\n   clean, maintainable target data model\n  </strong>\n  (Postgres as target, migrating from MSSQL)\n </li>\n <li>\n  Deconstruct and rationalize the transformation layer:\n </li>\n <li>\n  Remove dead logic\n </li>\n <li>\n  Consolidate redundant transformations\n </li>\n <li>\n  Simplify pipelines\n </li>\n <li>\n  Retrofit missing capabilities into the redesigned schema\n </li>\n <li>\n  Develop\n  <strong>\n   Python-based ETL pipelines\n  </strong>\n </li>\n <li>\n  Orchestrate workflows using\n  <strong>\n   Azure Data Factory\n  </strong>\n </li>\n <li>\n  Ensure\n  <strong>\n   clear documentation and traceability\n  </strong>\n  across all components\n </li>\n</ul>\n<p>\n <br/>\n</p>\n<p>\n WHAT YOU DON’T NEED\n</p>\n<ul>\n <li>\n  Domain expertise in behavioral health\n </li>\n <li>\n  Scrum leadership or team management experience\n </li>\n <li>\n  Big data / distributed systems expertise\n </li>\n</ul>\n<p>\n <br/>\n</p>\n<p>\n WHO THIS IS FOR\n</p>\n<p>\n This role is for someone who has done this before:\n</p>\n<ul>\n <li>\n  Walked into a\n  <strong>\n   messy, undocumented system\n  </strong>\n </li>\n <li>\n  Figured out how it actually works\n </li>\n <li>\n  Rebuilt it into something\n  <strong>\n   clean, structured, and scalable\n  </strong>\n </li>\n</ul>\n<p>\n</p>","employment_type":null,"industry":"","job_template":false,"country":{"name":"India","country_code":"IN","region":"Asia"},"is_job_displayable":true,"job_url":"https://talent500.com/jobs/prudent-technologies-and-consulting-inc/senior-data-architect-greater-hyderabad-area-T500_CMP2089_15820_4403098556","created_at":"2026-04-29T05:40:01.822551+05:30","updated_at":"2026-05-12T23:50:01.471487+05:30","title_alias_1":null,"slug":"senior-data-architect-greater-hyderabad-area-T500_CMP2089_15820_4403098556","summary":null,"typical_workday":null,"what_you_offer":null,"what_you_need_to_succeed":null,"responsibilities":null,"type":null,"min_experience_years":0,"max_experience_years":0,"ctc_unit":"LPA","is_featured_job":false,"is_active":true,"job_code":"T500_CMP2089_15820_4403098556","external_id":null,"external_job_code":"15820_4403098556","is_anonymized":false,"mercurial_skills":null,"open_date":"2026-04-29T05:40:01.813039+05:30","published_at":"2026-10-05T05:30:00+05:30","anonymization_needed":null,"anonymized_description":null,"xml_feed_anonymization":null,"unregistered_user_anonymization":null,"registered_user_anonymization":null,"pre_application_email_anonymization":null,"mettl_account":null,"job_table_sub_head":null,"job_table_short_desc":null,"is_remote":false,"job_video":null,"job_video_title":null,"job_video_description":null,"job_image_url":null,"role_summary":null,"syndication_control":true,"syndication_status":"new","syndication_job_title_alias":null,"sourcing_requirements_updated_at":null,"t500_sourcing_control":true,"status":"open","job_redirection_url":"https://click.appcast.io/t/zznGn_RB7wc0zwLJgE5ucrnTNucRFeRNx81fX_Uv3_7UMT-tdqHTpt4GhrcM2gdWovmv2N92I4aW7_EWDYZ1mA==","is_external_job":true,"is_leadership_job":false,"leadership_confidentiality_level":null,"pricing_type":"cpc","recruiter":"1154daea-f24c-4f7f-aad6-494543ee6112","category":11,"job_sub_category":92,"role":null,"job_function":null,"job_sub_function":null,"naukri_industry":null,"naukri_functional_area":null,"naukri_role":null,"role_category":null,"linkedin_industry":null,"syndication_partners":[],"candidate_job_status":null,"candidate_job_id":null,"mettl_assessment_to_be_taken":false,"company_font_data":{"font-family":"Montserrat","url":"https://fonts.googleapis.com/css2?family=Montserrat:ital,wght@0,100;0,200;0,300;0,400;0,500;0,600;0,700;0,800;0,900;1,100;1,200;1,300;1,400;1,500;1,600;1,700;1,800;1,900&display=swap"}}