HIRING FOR THE Technical Manager

Job Description

* Role Responsibilities Strategy
• Responsible for the design and development analytical data model, reports and dashboards
• Provide design specifications to both onsite & offshore teams
• Develop functional specifications and document the requirements clearly
• Develop data mapping documents and technical design specifications for the project deliverables.
• Analyse the business requirements and come up with the end-to-end design including technical implementation.
• Install , upgrade, administration , and trouble shooting of ETL tools such as Informatica, Oracle and Hadoop
• Implement performance tuning techniques for ETL and data Migration
• Develop ETL procedures to ensure conformity, compliance with standards and translate business rules and functionality requirements into ETL procedures
• Assess and review the report performance, come up with performance optimization techniques using VLDB settings and explain plan.
• Develop scripts to automate the production deployments
• Conduct product demonstrations and user training sessions to business users
• Work with testing teams to improve the quality of the testing in adopting the automated testing tools and management of the application environments
Business
• Collaborate and partner with product owner, business users and senior business stakeholders to understand the data and reporting requirements of the business and clearly document it for further analysis
• Work closely with architects and infrastructure teams and review the solutions
• Interact with support teams periodically and get input on the various business users needs
• Provide all the required input and assistance to the business users in performing the data validation and ensure that the data and reporting delivered with accurate numbers.
Processes
• Process oriented and experienced in onsite-offshore project delivery, using agile methodology and best practices
• Well versed with agile based project delivery methodology.
• Should have successfully implemented or delivered projects using best practices on technology delivery and project release automation in banking and financing industry
• Deployment automation for Oracle Databse and Hadoop , Informatica workflow WorkFlow, Integration, BI layer including MicroStrategy and PBI components to the feasible extent
• Actively participate in discussions with business users and seek endorsements and approvals wherever necessary w.r.t technology project delivery.
People and Talent
• Minimum 9 years of experience in the business intelligence and data warehouse domain.
• Create project estimations, solution and design documentation, operational guidelines and production handover documentation
• Should have excellent technical, analytical, interpersonal and delivery capabilities in the areas of complex reporting for banking domain, especially in the area of Client Analytics and CRM.
• Full Life-cycle Business Intelligence (BI) and Data Warehousing project experience, starting with requirements analysis, proof-of-concepts, design, development, testing, deployment and administration
• Shall be a good team player with excellent written and verbal communications.
• Process oriented and experienced in onsite-offshore project delivery, using agile methodology and best practices
• Should be able play an Individual Contributor role
Risk Management
• Assess and evaluate the risks that are related to the project delivery and update the stakeholders with appropriate remediation and mitigation approach.
• Review the technical solutions and deliverables with architects and key technology stakeholders and ensure that the deliverables are adhering to the risk governance rules
Governance
• Work with Technology Governance and support teams and establish standards for simplifying the existing Microstrategy reports and Informatica batch programs
• Take end to end ownership of managing and administering the Informatica & Hadoop , MSTR and Power BI.
Regulatory & Business Conduct
• Display exemplary conduct and live by the Group s Values and Code of Conduct.
• Take personal responsibility for embedding the highest standards of ethics, including regulatory and business conduct, across Standard Chartered Bank. This includes understanding and ensuring compliance with, in letter and spirit, all applicable laws, regulations, guidelines and the Group Code of Conduct.
• Lead the [country / business unit / function/[team] to achieve the outcomes set out in the Bank s Conduct Principles: [Fair Outcomes for Clients; Effective Financial Markets; Financial Crime Compliance; The Right Environment.] *
• Effectively and collaboratively identify, escalate, mitigate and resolve risk, conduct and compliance matters.
• Exercise authorities delegated by the Board of Directors and act in accordance with Articles of Association (or equivalent)
Key Stakeholders
• Business and Operations (Product Owners)
• Sales Enablement Client Coverage Reporting
• Technology Services Teams
• Production Support Teams
Our Ideal Candidate
• Certified Microstrategy Administrator
• Certified Designer and Analyst in MicroStrategy platform.
ROLE SPECIFIC TECHNICAL COMPETENCIES
• BI and analytical dashboards , reporting design and development using PBI tools and MicroStrategy Business Intelligence product suite (MicroStrategy Intelligence Server, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Architect, MicroStrategy Object Manager, MicroStrategy Command Manager, MicroStrategy Integrity Manager, MicroStrategy Office, Visual Insight, Mobile Development) Expert
• Administration of iServer, System manager, Command Manager, Integrity Manager and Object Manager
• Design and development of MicroStrategy dashboards for mobile devices
• Design and Modelling the Microstrategy project and PBI Models Expert
• Design of dimensional modelling like star and snowflake schema
• Setting up connections to Hadoop big data (data lake) cluster through Kerberos authentication mechanisms Expert
• Design, development of ETL procedures using Informatica PowerCenter
• Performance tuning of star schemas to optimize load and query performance of SQL queries.
• Hive, HiveQL, HDFS, Scala, Spark, Sqoop, HBase, YARN, Presto , Dremio
• Experience in Oracle 11g, 19c. Strong knowledge and understanding of SQL and ability to write SQL, PL/SQL
• Expert
• Banking and Finance specific to financial market, Collateral, Trade Life Cycle , Operational CRM, Analytical CRM and client related reporting Advanced
• Unix / Linux Shell scripts, Control M
• Unix /Linux - Automation and Integration Core
• Power BI and Tableau Core
• Design and implementation of Azure Data Solution and Microsoft Azure Cloud Core
,

Keyskills :
javaagileproject managementdeliverytrade life cyclebig dataetl toolsoracle 11glife cycledata mappinghuman skillstesting tools