INManagerData ArchitectAppTechAdvisoryMumbai (Early joiners)

Job Description & Summary:A career withinTechnology Consultingservices will provide you with the opportunity to bring our clients a competitive advantage through defining their technologyobjectives assessing solution options and devising architectural solutions that help them achieve both strategic goals and meet operational requirements. We help build software and design data platforms manage large volumes of client data develop compliance procedures for data management and continuallyresearchingnew technologiesto drive innovation and sustainable change.

Responsibilities:

Set up technical standards and governance structure for the enterprise.

To provide technology architectureexpertiseand guidance across multiple business divisions & technology domains.

Assist business strategyand accordinglydrive technology strategy from an architecture perspective.

Setting up technical standards formulation of Enterprise Architecture (EA) Governance Framework.

Driving technology strategy from an architecture perspective across a portfolio of applications in the Bank for resource optimization and Risk mitigation.

Translating business requirements into specific systemapplicationor process designs including working with business personnel and executives toidentifyfunctional requirements.

Define/maintainTarget Architectures in Roadmaps.

Lead and/orassistefforts to scope and architect major change programs leading

strategicoptions analysis & proposing end-to-end solutions & highlighting tradeoffs.

Review ongoing designs of major programs toidentifystrategic opportunities and resolve design issues during delivery.

Identifykey technology enablers tooptimizeIT investment.

Develophighly complexsolutions thatexemplifiesquality optimizationregardingreliability availability scalability manageability flexibility usability/ reusability and high performance.

Deliver Architecture solutions in a Banking environmentatthe highest-level technicalexpertise.

Lead other IT Architects to provide effective consulting on complex projects including RFP technical evaluations for various businessdomain.

Lead multifunctional teams in successful application of methodologies and architecture modelling tools.

As anarchitectthe person wouldbe responsible forsuggestion and implementation ofnew technologies.

Collaborate with key stakeholders inITinfra domain IT-vendors and other architects to achieve enterprise business goals.

The Enterprise Data Architect willbe responsible formaturing and extending data management data engineering metadata management Data warehouse DataLakeand Data virtualization/fabric solutions across the organization. By combining a strong technical background with a solid understanding of market trends the IT Enterprise Data Architect willbe responsible forarchitecting designing and delivering projects and enhancements across the Enterprise Data Platform.

Evaluate current state architecture and recommend and implement changes with a focus on modernization of Data integration (ETL ELT API / ESB) and Data Virtualization solutions.

Combine business needs vendorroadmapsand technology trends to develop Enterprise Data Management platforms and product roadmapsand future state architecture diagrams for the bank based on their roadmap.

Mitigate issues related to data quality

Provide technical and architectural guidance to projects teams and service providers ensuring that new initiatives enable effective and scalable data storage dataengineeringand data analysis capabilities

Participatein architectural review boards evaluations of data and analytics solutions/COTS products and technologies

Research recommend and pilot tools and process changes to drive quality and efficiency across the solution development lifecycle

Act as a thought leader on industry trends emerging data management capabilities (such as enterprise Data Lake) and technologies (cloud platforms) and potential use for various existing and potential Customers.

Any othertasks asdeemednecessary by the Bank.

Mandatory skill sets:

Minimum 12years experienceinITfield after completion of under graduation out of which minimum 5 years should be in Data Architect role. Minimum 5 years in Banking / Financial Sector

Mandatory Certifications (Anyone):

DAMA Certified Data Management Professional (CDMP) Oracle Certified Master: Oracle Database 12c Administrator Microsoft Certified: Azure Database Administrator Associate MySQL Database Administrator Certification MongoDB Certified DBA Associate Cassandra Certified Developer/ Administrator Redis Certified Developer IBM Certified Database Administrator DB2.

• In depth knowledge of data reconciliation storage (capacity planning) lineage using

differenttools

Ability to design both the logical and physical aspects of databases.

Understanding how to normalize data to reduce redundancy and ensure data

integrity and when to de-normalize forperformance optimization.

Proficiencyin creating Entity-Relationship Diagrams (ERD) and other data models.

RDBMS (Relational DBMS):Expertisein relational databases such as:

o Oracle

o SQL Server

o MySQL

o PostgreSQL

NoSQL DBMS: Knowledge of NoSQL databases like:

o MongoDB

o Cassandra

o Couchbase

o Redis

Cloud Databases: Familiarity with cloud-native databases such as:

o Amazon RDS

o Google CloudFirestore

o Azure SQL Database

Having skills inmigration oflogical DWH from one stack to another.

A proventrack recordof setting up massively scalable always-on multiregional

o data systems.

Expertisein relational databases and NoSQL data storage technologies like Oracle

o Postgres SQL server Azure SQL MongoDB etc.

Proficiencyin query optimization and performance tuning.

Securing data and databases with encryption access control and audit logging.

Identifyingand resolving bottlenecks to improve database performance.

Implementing caching strategies for high-performance applications (e.g. Redis Memcached).

Familiarity with tools like Ansible or Terraform for database provisioning and management.

Understanding the principles of distributed database architecture consistency availability and partition tolerance (CAP theorem).

Ability to troubleshoot complex database issues andoptimizesystem performance.

Strong knowledge of DWHtechnologiesetc. Netezza including its architecture and optimization.

Expertisein data modellingdesignand data visualization skills.

Data management and migration skills.

Ability to train teams and prepare presentations. Deep understanding of cloud-native architecture and services on platforms such as AWS Azure or Google Cloud.

Deep understanding ofon-premiseprivate cloud deployment model

Preferred skill sets:

Knowledge and experience in IBM stack Teradata/SAP/Oracle stacketcwill bepreferred.

Knowledge of reporting tools like IBM Cognos Tableau Power BI etc.

Years of experience:

Minimum 12years experienceinITfield after completion of under graduation out of which minimum 5 years should be in Data Architect role. Minimum 5 years in Banking / Financial Sector

Education qualification:

BE/ BTech in (Computer Science/ Computer Science & Engineering/ Information Technology/ Software Engineering/ Electronics & Communications Engineering or equivalent degree in relevant discipline) or MCA or MTech/ MSc in (Computer Science/ Information Technology/ Electronics & Communications Engineering) from recognized University/ Institute.