17 Nov
|
Anaptyss
|
Gurugram
Job Information
- Industry: Banking Financial Services
- Work Experience: 10+ Years
- Job Type: Full Time
- City: Gurugram
- State/Province: Haryana
- Country: India
Job Summary
We are seeking an experienced Senior Solution Architect - Data Warehousing Database Management to lead the architecture, design, and implementation of enterprise-grade data solutions.
The role will drive scalable, secure, and high-performing data warehouse and database architectures across on-premises, cloud, and hybrid environments.
Work closely with business stakeholders, data engineering teams, analytics teams, and infrastructure teams to translate business requirements into robust technical solutions aligned with enterprise architecture and organizational objectives.
Provide technical leadership across data modernization, integration, migration, governance, performance optimization, and enterprise data management initiatives.
Responsibilities
- Design end-to-end data warehousing and database management solutions, including data models, database architectures, and ETL/ELT frameworks.
- Evaluate and recommend up-to-date data platforms and technologies such as Snowflake, Azure Synapse, AWS Redshift, Google BigQuery, Databricks, Oracle, and SQL Server.
- Lead data integration and migration initiatives from legacy platforms to modern cloud data environments, ensuring data quality, consistency, and lineage.
- Establish architectural standards and best practices for database design, data modeling, metadata management, security, and performance optimization.
- Oversee database performance, scalability, high availability, disaster recovery, and enterprise data security architecture.
- Collaborate with business, governance, compliance, and technology stakeholders to define data strategies, architecture roadmaps, and implementation plans.
- Lead architectural reviews, mentor technical teams, and ensure effective documentation, knowledge sharing, and continuous improvement.
Qualifications
Educational Qualifications
- Bachelor s or Master s degree in Computer Science, Information Systems,
or a related discipline (preferred).
- Relevant cloud platform certifications, such as Azure Data Engineer Associate, AWS Solutions Architect, or Google Professional Data Engineer (preferred).
Experience
- 10-15 years of professional experience in data architecture, data warehousing, and database management, including 5+ years in an architect-level role.
- Proven experience designing and implementing enterprise data solutions using platforms such as Snowflake, Azure Synapse, AWS Redshift, Google BigQuery, Oracle, and SQL Server.
- Strong expertise in conceptual, logical, and physical data modeling, database architecture, and performance tuning.
- Hands-on experience with ETL/ELT frameworks, data integration tools, and scripting languages, including SQL, Python, and Shell.
- Experience designing cloud data ecosystems, hybrid architectures, and data lake and data warehouse integrations.
- Experience architecting data migration and modernization initiatives, including legacy-to-cloud platform migrations and reporting technology transitions such as Qlik to Power BI and Teradata to Snowflake.
- Practical exposure to data ingestion, transformation, and integration tools such as Informatica, Alteryx, Azure Data Factory, and dbt.
- Experience optimizing database performance through indexing, partitioning, query tuning, and scalable database design.
- Strong understanding of data governance, metadata management, data lineage, data quality frameworks, and enterprise data management practices.
- Experience designing secure data environments with encryption, access controls, and compliance considerations, including GDPR and HIPAA.
- Experience collaborating with infrastructure teams on high availability,
disaster recovery, and scalability planning.
- Exposure to business intelligence and reporting platforms such as Power BI, Tableau, or Qlik.
- Experience with CI/CD pipelines, modern DevOps practices, machine learning data pipelines, and analytics modernization programs is preferred.
- Demonstrated experience leading architectural reviews, mentoring technical teams, managing stakeholders, and contributing to data strategy and roadmap planning.
Skills
- Data Architecture Warehousing: Enterprise data architecture, data warehousing, database management, cloud and hybrid architectures, data lake integration, and end-to-end solution design.
- Data Platforms Databases: Snowflake, Azure Synapse, AWS Redshift, Google BigQuery, Databricks, Oracle, and SQL Server.
- Data Modeling Database Management: Conceptual, logical, and physical data modeling, database design, indexing, partitioning, query tuning, and performance optimization.
- Data Integration Engineering: ETL/ELT frameworks, data ingestion, data transformation, Informatica, Alteryx, Azure Data Factory, dbt, SQL, Python, and Shell scripting.
- Data Migration Modernization: Legacy platform migration, cloud migration, data integration strategy, analytics modernization, and reporting platform transitions.
- Data Governance Security: Enterprise data governance, metadata management, data lineage, data quality, encryption, access control, GDPR, and HIPAA compliance considerations.
- Performance Infrastructure: Database optimization, scalability planning, high availability, disaster recovery, and secure data environments.
- BI Reporting: Power BI, Tableau, and Qlik.
- DevOps Emerging Technologies: CI/CD pipelines, modern DevOps practices, machine learning data pipelines, and cloud platform capabilities.
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.
📌 Sr Solutions Architect (Gurugram)
🏢 Anaptyss
📍 Gurugram