1.About the Job - The candidate should require mandatory Senior Data Architect (Data Modeling & DB Optimization) Experience. 2.Job Title - Senior Data Architect (Data Modeling & DB Optimization) 3.Location - Noida, Mumbai, Pune, Bangalore, Hyderabad, Chennai 4.Educational Background - UG. B. Tech /B. E in any specialization PG. MCA in Computers 5.Key Responsibilities - Data Architecture Design: Lead the design and development of comprehensive data architectures, including relational, NoSQL, and cloud-based database solutions. Build logical and physical data models that can scale to handle large volumes of data and high transaction rates. Advanced Data Modeling: Design and implement complex data models using best practices in dimensional modeling (star, snowflake, galaxy schemas), entity-relationship diagrams (ERD), and data normalization/de-normalization for performance optimization. Database Performance Tuning: Apply advanced techniques such as indexing, partitioning, query optimization, caching, and materialized views to optimize database performance for both OLTP and OLAP systems. ETL and Data Integration: Design and implement scalable ETL pipelines to integrate data from heterogeneous sources, using tools like SQL Server Integration Services (SSIS), Apache Spark, and cloud-based data transformation services. Big Data Solutions: Architect and implement solutions using big data technologies (Hadoop, Spark, AWS Redshift, Azure Synapse) to handle vast amounts of unstructured or semi-structured data, ensuring data is processed efficiently and can be analyzed in real-time. Data Governance and Security: Ensure that data is governed in compliance with industry standards and regulations, with a focus on data quality, privacy, and security. Collaborate with Cross-Functional Teams: Work with data scientists, business analysts, and application developers to ensure that the data architecture is aligned with business goals, analytical needs, and application requirements. 6.Skills Required - Proven experience in data architecture, designing enterprise-level data systems and data lakes. Expertise in data modeling (both logical and physical models), with a strong understanding of relational and NoSQL databases (SQL Server, MySQL, MongoDB, Cassandra, etc.). Strong background in performance tuning, query optimization, and database design for large-scale systems. Experience with big data technologies and cloud-native data architectures. Hands-on experience with data integration tools (SSIS, Talend, Apache Kafka, etc.) and ETL pipelines. Familiarity with data governance frameworks, data lineage, and data privacy/security best practices.,
Employement Category:
Employement Type: Full timeIndustry: IT Services & ConsultingRole Category: Not SpecifiedFunctional Area: Not SpecifiedRole/Responsibilies: Senior Data Architect (Data Modeling & DB)