Enterprise Solutions Architect

Mphasis; Chennai District; On-site; INR 2,000,000 - 3,000,000; Full time

Job summary

A leading technology firm is looking for a Senior Data Architect to design and govern data architecture across core banking and financial platforms in Chennai, India. The candidate will lead initiatives in modern cloud solutions, ensuring data integrity and compliance while mentoring other data professionals. Strong experience in BFSI data domains and data modeling is essential.

Qualifications

• Deep understanding of BFSI data domains.
• Experience with financial data modeling.
• Proficiency in data modeling tools like Erwin and PowerDesigners.

Responsibilities

• Architect scalable data solutions for core banking.
• Lead data migration from legacy systems to cloud.
• Build and optimize ETL/ELT pipelines for high-volume data.

Skills

Data modeling

SQL

Data governance

ETL processes

Cloud platforms

Tools

Erwin

Informatica

Talend

Snowflake

Apache NiFi

Job description

Job Description

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.

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.
• Proficiency in Erwin, PowerDesigners, or Toad Data Modeler.
• Experience with 3NF, dimensional modeling, data vault, and canonical models.

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.

Knowledge & Skills:

Databases & Platforms: Category Technologies

Mainframe - IBM DB2, IMS, VSAM

Relational - Oracle, SQL Server, PostgreSQL

ETL & Streaming:

• Informatica, Talend, Apache NiFi, Azure Data Factory, IICS, Airflow and DBT
• Hands-on with GCP data services AWS, Azure
• Familiarity with Terraform, Git, CI/CD, Docker, Kubernetes

Governance & Security:

• Practices: Data lineage, masking, encryption, RBAC, audit trails

Programming & Scripting:

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