Domain Consultant - L3

Job Description

Role Purpose

The role incumbent is focused on implementation of roadmaps for business process analysis, data analysis, diagnosis of gaps, business requirements & functional definitions, best practices application, meeting facilitation, and contributes to project planning. Consultants are expected to contribute to solution building for the client & practice. The role holder can handle higher scale and complexity compared to a Consultant profile and is more proactive in client interactions.
 

͏

Do

• Assumes responsibilities as the main client contact leading engagement w/ 10-20% support from Consulting & Client Partners. 
• Develops, assesses, and validates a client’s business strategy, including industry and competitive positioning and strategic direction
• Develops solutions and services to suit client’s business strategy
• Estimates scope and liability for delivery of the end product/solution
• Seeks opportunities to develop revenue in existing and new areas
• Leads an engagement and oversees others’ contributions at a customer end, such that customer expectations are met or exceeded. 
• Drives Proposal creation and presales activities for the engagement; new accounts
• Contributes towards the development of practice policies, procedures, frameworks etc. 
• Guides less experienced team members in delivering solutions.
• Leads efforts  towards building go-to-market/ off the shelf / point solutions and process smethodologies for reuse
• Creates reusable IP from managed projects

B͏usiness System Analyst

Skills required:  Data warehousing, data analysis, ETL, SQL, spark SQL, data mapping, Azure, Databricks

 

Pyspark and data bricks

• Experience in AML/ Banking/ Capital Market
• Experience with Agile methodology – Plan, develop, test and deploy
• Experience with SQL server management tools and writing queries, with large SQL data marts, relational database experience.
• Profile data and prepare source to target mappings, map source data to the target tables for the multi hop architecture.
• Closely working with data modelers, data engineers and architect and product owners to identify any discrepancies and get it resolved.
• Strong knowledge of data extraction, design, load, and reporting solutions, strong ability to read SQL server SSIS packages, SQL stored procedures/functions and back trace views
• Work in the team of data designer/ developer to translate user and/or systems requirements into functional technical specifications.
• Work with business stakeholders and other SMEs to assess current capabilities, understand high-level business requirements and apply technical background/understanding in the development of System Requirements Specification (SRS) documents.
• Collaborate closely with Application Owners, Application Managers, and Solution Designers as the business/functional counterpart in solution identification and maintenance.
• Support testing teams in translating requirements and use cases into test conditions and expected results for product, performance, user acceptance, and operational acceptance testing; participate in the testing of developed systems/solutions.
• Act as a technical resource for business partners to ensure deliverables meet business and end-user requirements.
• Identifying the source data/source tables as per project specific use case and get that ingested into source raw zone.
• Raise Data access control requests and make source data available in analytical zone for data profiling and data analysis.
• Understanding the existing codes and data bricks workflows and leverage that for our use case.

 

͏

͏