Business System Analyst
Apply NowCompany: Futran Tech Solutions Pvt. Ltd.
Location: Dallas, TX 75217
Description:
Location - MOUNT LAUREL / Hybrid
Only Recruit / full time profiles needed
Salary : 120K - 130K / Annum
JC - 35723
JD for Business System Analyst
Experience in AML/ Banking/ Capital Market (Any banking domain)
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.
Only Recruit / full time profiles needed
Salary : 120K - 130K / Annum
JC - 35723
JD for Business System Analyst
- Skills required: Data warehousing, data analysis, ETL, SQL, spark SQL, data mapping
- Pyspark and data bricks
Experience in AML/ Banking/ Capital Market (Any banking domain)
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.