BSA Data Mapping exp

Job Description

• Need only Banking Domain exp professionals
• Need to have Mainframe Exp
• System Data Analysis & Mapping
  • Lead end-to-end data mapping initiatives for system integrations, migrations, and ETL processes
  • Analyze source and target data structures to identify relationships, dependencies, and transformation requirements
  • Create comprehensive data mapping documentation including field-level specifications, transformation rules, and business logic
  • Develop data lineage diagrams and data flow documentation to ensure traceability
  • Conduct data profiling and quality assessment to identify anomalies, gaps, and inconsistencies
  • Define data validation rules and acceptance criteria for data migration and integration projects
  • Collaborate with data engineers and developers to ensure accurate implementation of mapping specifications
• SQL Development & Analysis
  • Write complex SQL queries to extract, transform, and validate data across multiple databases
  • Develop stored procedures, views, and scripts to support data analysis and reporting needs
  • Perform data reconciliation and validation using SQL to ensure data integrity post-migration
  • Optimize SQL queries for performance and efficiency
  • Conduct root cause analysis using SQL to troubleshoot data issues and discrepancies
  • Create ad-hoc reports and data extracts to support business intelligence and decision-making
  • Support database design reviews and provide input on data model optimization
• Business Analysis
  • Elicit, document, and validate business requirements through interviews, workshops, and process analysis
  • Translate business requirements into functional specifications and technical user stories
  • Create detailed process flow diagrams, use cases, and business requirement documents (BRDs)
  • Facilitate requirements review sessions with stakeholders and technical teams
  • Conduct gap analysis between current state and future state data architectures
  • Support UAT planning, test case development, and defect triage
  • Serve as liaison between business stakeholders and technical development teams
• Stakeholder Collaboration
  • Partner with cross-functional teams including IT, data engineering, business operations, and vendors
  • Present findings, recommendations, and project updates to stakeholders at all levels
  • Manage stakeholder expectations and ensure alignment on project scope and deliverables
  • Facilitate workshops and collaborative sessions to gather requirements and resolve issues
  • Provide training and documentation to end-users on new systems and data processes
• Technical Skills
  • Advanced SQL proficiency including:
    • Subqueries, CTEs (Common Table Expressions), and window functions
    • Aggregate functions, grouping, and pivoting data
    • Query optimization and performance tuning
    • Stored procedures, triggers, and views
  • Data mapping expertise including:
    • Data quality and validation rules
  • Database knowledge:
    • Relational database concepts and normalization
    • Experience with SQL Server, Oracle, Postgre
      
      SQL, or MySQL
    • Understanding of data warehousing and dimensional modeling
    • Familiarity with No
      
      SQL databases is a plus
• Business Analysis Skills
  • 5-7 years of experience as a Business Analyst or Business Systems Analyst
  • Strong requirements elicitation and documentation skills
  • Experience with Agile/Scrum methodologies and tools (Jira, Confluence)
  • Proven ability to create process flows, data flow diagrams, and technical specifications
  • Experience with UAT coordination, test case development, and defect management
  • Knowledge of SDLC (Software Development Life Cycle) best practices

$95,000-$100,000 a year

BACHELOR OF COMPUTER SCIENCE