NOIDA · FULLTIME
Data Architect
Kastech Software Solutions Group
Noida · onsite · Posted 22d ago
Sourced from
Undisclosed9–13 yrsfulltimeNoida
About a minute. You'll make an account on the way through.
agent · working
- Read this posting0.5s
- Found the form on Naukri · 6 questions to answer1.6s
- Decided the answers for all of them2.4s
- Tailor your résumé to this role
- Waiting for you
Section · 01
About this role
Core Responsibilities
Design and enforce an on-premises SQL-First Medallion Architecture (Bronze, Silver, Gold) on SQL Server 2025 Standard Edition.
Architect robust, metadata-driven ingestion patterns to extract data from a greenfield NetSuite ERP using SuiteAnalytics Connect and SuiteQL, specifically engineering solutions for hard-delete detection.
Develop custom T-SQL frameworks for data quality, matching, and survivorship in the Silver layer to offset the deprecation of Microsoft DQS and MDS.
Design Kimball-style dimensional models (Star/Snowflake schemas) optimized for downstream consumption by Power BI Service via an Enterprise On-Premises Data Gateway.
Evaluate and implement high-volume data ingestion tooling, determining the optimal balance between metadata-driven SSIS pipelines and hybrid SaaS agents (e. g. , Fivetran) within strict network security boundaries.
Technical Prerequisites
Expertise in Microsoft SQL Server internal architecture, specifically configuring Resource Governor, temporal tables, and columnstore indexes for analytical workloads on Standard Edition.
Proven experience migrating legacy ERP historical data and merging it with new cloud ERP operational data within an on-premises data warehouse.
Deep understanding of NetSuites data model, ODBC drivers, and SuiteAnalytics connection concurrency limits.
Mastery of Power BI semantic model design, DAX, Row-Level Security (RLS), and on-premises gateway capacity planning.
Strong background in establishing automated, idempotent ETL/ELT patterns that decouple extraction logic from business transformation.
Making a mid-flight leadership change is never easy, but protecting the architectural baseline now is the only way to safeguard the projects cutover. Core Responsibilities
Design and enforce an on-premises SQL-First Medallion Architecture (Bronze, Silver, Gold) on SQL Server 2025 Standard Edition.
Architect robust, metadata-driven ingestion patterns to extract data from a greenfield NetSuite ERP using SuiteAnalytics Connect and SuiteQL, specifically engineering solutions for hard-delete detection.
Develop custom T-SQL frameworks for data quality, matching, and survivorship in the Silver layer to offset the deprecation of Microsoft DQS and MDS.
Design Kimball-style dimensional models (Star/Snowflake schemas) optimized for downstream consumption by Power BI Service via an Enterprise On-Premises Data Gateway.
Evaluate and implement high-volume data ingestion tooling, determining the optimal balance between metadata-driven SSIS pipelines and hybrid SaaS agents (e. g. , Fivetran) within strict network security boundaries.
Technical Prerequisites
Expertise in Microsoft SQL Server internal architecture, specifically configuring Resource Governor, temporal tables, and columnstore indexes for analytical workloads on Standard Edition.
Proven experience migrating legacy ERP historical data and merging it with new cloud ERP operational data within an on-premises data warehouse.
Deep understanding of NetSuites data model, ODBC drivers, and SuiteAnalytics connection concurrency limits.
Mastery of Power BI semantic model design, DAX, Row-Level Security (RLS), and on-premises gateway capacity planning.
Strong background in establishing automated, idempotent ETL/ELT patterns that decouple extraction logic from business transformation.
Making a mid-flight leadership change is never easy, but protecting the architectural baseline now is the only way to safeguard the projects cutover.
Design and enforce an on-premises SQL-First Medallion Architecture (Bronze, Silver, Gold) on SQL Server 2025 Standard Edition.
Architect robust, metadata-driven ingestion patterns to extract data from a greenfield NetSuite ERP using SuiteAnalytics Connect and SuiteQL, specifically engineering solutions for hard-delete detection.
Develop custom T-SQL frameworks for data quality, matching, and survivorship in the Silver layer to offset the deprecation of Microsoft DQS and MDS.
Design Kimball-style dimensional models (Star/Snowflake schemas) optimized for downstream consumption by Power BI Service via an Enterprise On-Premises Data Gateway.
Evaluate and implement high-volume data ingestion tooling, determining the optimal balance between metadata-driven SSIS pipelines and hybrid SaaS agents (e. g. , Fivetran) within strict network security boundaries.
Technical Prerequisites
Expertise in Microsoft SQL Server internal architecture, specifically configuring Resource Governor, temporal tables, and columnstore indexes for analytical workloads on Standard Edition.
Proven experience migrating legacy ERP historical data and merging it with new cloud ERP operational data within an on-premises data warehouse.
Deep understanding of NetSuites data model, ODBC drivers, and SuiteAnalytics connection concurrency limits.
Mastery of Power BI semantic model design, DAX, Row-Level Security (RLS), and on-premises gateway capacity planning.
Strong background in establishing automated, idempotent ETL/ELT patterns that decouple extraction logic from business transformation.
Making a mid-flight leadership change is never easy, but protecting the architectural baseline now is the only way to safeguard the projects cutover. Core Responsibilities
Design and enforce an on-premises SQL-First Medallion Architecture (Bronze, Silver, Gold) on SQL Server 2025 Standard Edition.
Architect robust, metadata-driven ingestion patterns to extract data from a greenfield NetSuite ERP using SuiteAnalytics Connect and SuiteQL, specifically engineering solutions for hard-delete detection.
Develop custom T-SQL frameworks for data quality, matching, and survivorship in the Silver layer to offset the deprecation of Microsoft DQS and MDS.
Design Kimball-style dimensional models (Star/Snowflake schemas) optimized for downstream consumption by Power BI Service via an Enterprise On-Premises Data Gateway.
Evaluate and implement high-volume data ingestion tooling, determining the optimal balance between metadata-driven SSIS pipelines and hybrid SaaS agents (e. g. , Fivetran) within strict network security boundaries.
Technical Prerequisites
Expertise in Microsoft SQL Server internal architecture, specifically configuring Resource Governor, temporal tables, and columnstore indexes for analytical workloads on Standard Edition.
Proven experience migrating legacy ERP historical data and merging it with new cloud ERP operational data within an on-premises data warehouse.
Deep understanding of NetSuites data model, ODBC drivers, and SuiteAnalytics connection concurrency limits.
Mastery of Power BI semantic model design, DAX, Row-Level Security (RLS), and on-premises gateway capacity planning.
Strong background in establishing automated, idempotent ETL/ELT patterns that decouple extraction logic from business transformation.
Making a mid-flight leadership change is never easy, but protecting the architectural baseline now is the only way to safeguard the projects cutover.
Timing : 11:00 am to 8 pm
(Candidate has to be flexible, and may require 4 hours overlap of US hours with EST)
(Candidate has to be flexible, and may require 4 hours overlap of US hours with EST)
Hybrid/ Remote
(Pune, Bangalore, Mumbai, Hyderabad, Noida)
(Hybrid - Candidate has to work 2/3 days from office in a week)
(Pune, Bangalore, Mumbai, Hyderabad, Noida)
(Hybrid - Candidate has to work 2/3 days from office in a week)
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Sourced from naukri
Section · 02
Skills
data qualityCapacity PlanningSSISodbcDownstreammetadataNetwork SecurityERPBusiness Transformationanalytical
Section · Company
About Kastech Software Solutions Group
Kastech Software Solutions Group
IT Services & Consulting
168
employees
2007
19 years old
Hyderabad / Secunderabad, Telangana
India
₹8.2L PA avg
Avg at Kastech Software Solutions Group
About
Accelerate Your Digital Transformation and Gain the Ability to Operate from Edge to Cloud. Kastech Services Can Help You Stay Ahead of Trends and Focus on Business Innovation.
Industries
IT Services & ConsultingBPO
Employee ratings
10 reviews
3.5/ 5
Culture
3.2
Career growth
2.7
Work-life
3.1
Employees rate it well for
Company Culture36Work-Life Balance35
Find them on