Database Architect RegTech-as-a-Service Product
Posted Updated
Description
Database Architect RegTech-as-a-Service Product
Company: Infosys Limited
Job Location: Maharashtra, India
Employment Type: Full-time
Experience Required: 7+ years
Job Description:
As Database Architect you will own the logical and physical database architecture for the RegTech as a Service product
You will design the canonical data model operational and analytical stores metadata repositories audit and lineage structures and data access patterns required across product modules
You will work closely with product leadership regulatory SMEs solution architects data engineers backend developers AI ML engineers security DevOps and QA teams to deliver a database foundation that is performant reliable secure explainable and configurable across reports regulations and client deployments
Key Responsibilities:
Define the end to end database architecture technology choices and design standards for operational analytical metadata audit evidence and AI ready data stores
Design a reusable report agnostic canonical data model covering regulatory entities customers accounts transactions balances MDRMs schedules controls exceptions approvals and lineage
Create logical and physical data models schemas keys relationships indexing partitioning retention and archival strategies for high volume regulatory and financial crime workloads
Architect multi tenant data isolation role based access encryption masking audit logging and jurisdiction aware data residency controls aligned with Secure by Design and Privacy by Design principles
Define ingestion change data capture API and batch data access patterns for integrating core banking general ledger reporting platforms CRM payment sanctions and external regulatory data sources
Establish database performance engineering practices including query optimization capacity planning workload management observability backup recovery high availability and disaster recovery
Design metadata driven configuration for report mappings validation rules thresholds regulatory changes schedule dependencies and source to report lineage
Lead database design reviews migration planning data quality controls proof of concepts and production readiness assessments while mentoring engineers and maintaining architecture documentation
Technical Requirements:
Minimum 7 years of experience in database architecture data architecture data engineering or enterprise scale data platform delivery including at least 6 years in an architect or technical leadership role
Strong hands on expertise in relational database design and advanced SQL preferably PostgreSQL Microsoft SQL Server Oracle or equivalent enterprise RDBMS platforms
Proven experience designing canonical models normalized and dimensional schemas metadata driven solutions audit stores temporal data and high volume transactional systems
Strong knowledge of indexing partitioning query optimization concurrency data lifecycle management backup and recovery high availability and disaster recovery
Experience designing secure cloud database solutions on Azure AWS or GCP including identity encryption secrets network isolation monitoring and cost controls
Strong understanding of data governance lineage data quality privacy access control PII handling and regulatory grade auditability
Ability to convert business and regulatory requirements into practical database designs and collaborate effectively with architecture engineering security and functional teams
Additional Responsibilities:
Experience in banking regulatory reporting AML KYC transaction monitoring risk compliance finance or other data intensive regulated platforms
Exposure to Azure SQL Azure Database for PostgreSQL Cosmos DB Databricks Snowflake BigQuery cloud data lakes or lakehouse architectures
Working knowledge of NoSQL graph and vector technologies such as Cosmos DB MongoDB Neo4j pgvector Pinecone Weaviate or Milvus with judgment on when each is appropriate
Experience with Python PySpark dbt Airflow Kafka schema registries data catalogues CDC tools and automated database deployment using CI CD and infrastructure as code
Familiarity with MDRM driven regulatory data XBRL XML outputs source to report reconciliation controls evidence AI RAG retrieval patterns and human review workflows
Preferred Skills: Technology->AI-Generative AI->Generative AI - Basic->open-source models (meta llama 2),Technology->Virtualization->Database Virtualization .
Skills
- AI
- Airflow
- API
- AWS
- Azure
- BigQuery
- CI/CD
- Cloud
- Cosmos Db
- CRM
- Data Engineering
- Data Governance
- Data Lake
- Data Quality
- Databricks
- dbt
- DevOps
- GCP
- General Ledger
- Generative AI
- Infrastructure as Code
- Kafka
- Lakehouse
- Machine Learning
- Milvus
- MongoDB
- Neo4j
- NoSQL
- Observability
- Oracle
- pgvector
- Pinecone
- PostgreSQL
- PySpark
- Python
- RDBMS
- Snowflake
- SQL
- SQL Server
- Virtualization
- Weaviate
- XML
Sign in to read and join the discussion.