Senior Data Architect

Job Description: -

Experience - 15 + Years

Location - Chennai, India

Who are we looking for?

As a Senior Data Architect in the BFSI domain, you will be responsible for designing and governing data architecture across core banking, Wealth Management and financial platforms. You’ll lead initiatives that span legacy systems (mainframes) to modern cloud-native and NoSQL solutions, ensuring regulatory compliance, data lineage, and high availability for mission-critical applications.

Key Responsibilities:

• Architect scalable data solutions for core banking, Wealth Management, risk management, fraud detection, and regulatory reporting.
• Design data models for transactional systems, data warehouses, and real-time analytics platforms.
• Lead data migration from legacy systems (e.g., DB2, VSAM) to cloud platforms like Snowflake, Azure Synapse, or Google Big Query. Lead Data migration from Oracle to Postgres, SQL Server to Postgres
• Collaborate with compliance teams to ensure data governance, auditability, and regulatory alignment (e.g., Basel III, IFRS, GDPR).
• Build and optimize ETL/ELT pipelines for high-volume financial data using tools like Informatica, Talend, Apache NiFi, or Azure Data Factory.
• Integrate data across core banking systems, Wealth Management Systems, CRM, insurance platforms, and digital channels.
• Define metadata standards, lineage tracking, and master data management frameworks.
• Mentor data engineers and analysts; contribute to architectural reviews and BFSI-specific best practices.

Domain Expertise:

• Deep understanding of BFSI data domains: customer, account, transaction, trading, portfolios, positions, credit, risk, claims, policy, and underwriting.
• Experience with financial data modeling, including ledger structures, risk hierarchies, and regulatory taxonomies.

Data Modeling & Architecture:

• Proficiency in Erwin, Power Designer, or Toad Data Modeler.
• Experience with 3NF, dimensional modeling, data vault, and canonical models.

Cloud & DevOps:

• Hands-on with GCP data services AWS, Azure
• Familiarity with Terraform, Git, CI/CD, Docker, Kubernetes

Governance & Security:

• Tools: Collibra, Alation, Apache Atlas
• Practices: Data lineage, masking, encryption, RBAC, audit trails

Programming & Scripting:

• SQL, Python, Shell scripting, Scala (optional)

Key Responsibilities:

• Architect scalable data solutions for core banking/wealth management, risk management, fraud detection, and regulatory reporting.
• Design data models for transactional systems, data warehouses, and real-time analytics platforms.
• Lead data migration from legacy systems (e.g., DB2, VSAM) to cloud platforms like Snowflake, Azure Synapse, or Google Big Query. Lead Data Migration between multiple databases like Oracle to Postgres.
• Collaborate with compliance teams to ensure data governance, auditability, and regulatory alignment (e.g., Basel III, IFRS, GDPR).
• Build and optimize ETL/ELT pipelines for high-volume financial data using tools like Informatica, Talend, Apache NiFi, or Azure Data Factory.
• Integrate data across core banking systems, CRM, insurance platforms, and digital channels.
• Define metadata standards, lineage tracking, and master data management frameworks.
• Mentor data engineers and analysts; contribute to architectural reviews and BFSI-specific best practices.

Preferred Qualifications:

• Bachelor’s/master’s in computer science, Information Systems, or Finance
• Certifications: GCP Certification, AWS Data Analytics, Azure Data Engineer, CDMP (DAMA), TOGAF
• Experience with financial regulations and reporting standards (e.g., BCBS 239, FATCA)

About Mphasis

Mphasis applies next-generation technology to help enterprises transform businesses globally. Customer centricity is foundational to Mphasis and is reflected in the Mphasis’ Front2Back™ Transformation approach. Front2Back™ uses the exponential power of cloud and cognitive to provide hyper-personalized (C=X2C2TM=1) digital experience to clients and their end customers. Mphasis’ Service Transformation approach helps ‘shrink the core’ through the application of digital technologies across legacy environments within an enterprise, enabling businesses to stay ahead in a changing world. Mphasis’ core reference architectures and tools, speed and innovation with domain expertise and specialization are key to building strong relationships with marquee clients.