Senior Data Mapping & Integration Analyst

Developer

• For each Use Case analyze the Mapping document of target table to determines operational objectives by studying business functions gathering information and evaluating output requirements.
  

• Track the target field mapping back to origin data element in the source system.
  

• Having strong knowledge in SQL to perform data analysis and data profiling on different Legacy system.
  

• Document the existing source to target data flow for each table which includes:
  

  • Business transformation rule applied.
    

  • Key-Cutting implemented to identify surrogate key that is defined as a unique identifier in a table.
    

  • Reference data used to enhance the context and validity of target data elements.
    

• For tables where mapping document is not available TSBI and ETL leads jointly must go over the code to extract the business rules applied and capture them into the requirement document.
  

• L2L3 Model Business team would be responsible for the creation of L2 Model supported by Project Business Analyst Solution Architect and TSBI.
  

• Collaborate with data scientists business analysts and IT teams to integrate advanced L2L3 models into the data pipeline.
  

• Mapping Design of New L2L3 Prepares technical Design and mapping (Data Movement Model) for the new L2 Model by working with Project Business Analysts and Solution Architect.
  

• Review the Key Cutting process to be implement on the L2 model and get approval from L2 Schema Owners.
  

• Only BORT System data would be populated into L2 schema other reference and tactical data would directly be consumed by L3 processes.
  

• L2 to L3 mapping would contain the Business transformation rules for each target table.
  

• Custom Surrogate Key process would be implemented on L3 tables which would contain different keys than L2 tables.
  

• Any system having one-off tables holding business data would be loaded into L3 schema for target table processing.
  

• Spearheaded the implementation of robust data governance policies and procedures ensuring compliance with industry regulations and standards resulting in a 20 reduction in data security incidents.
  

• Collaborate with cross-functional teams to design and implement data quality frameworks improving data accuracy and integrity and reducing errors.
  

• Determines operational objectives by studying business functions gathering information evaluating output requirements and formats.
  

• Designs analyzing requirements and designing modifications.
  

• Defines project requirements by identifying project milestones phases and elements forming project team.
  

• Monitors project progress by tracking activity resolving problems publishing progress reports recommending actions.
  

• Provides references for users by writing and maintaining mapping documentation.
  

• Maintains user confidence and protects operations by keeping information confidential.
  

• Prepares technical Design and mapping by collecting analyzing and data profiling.
  

• Maintains professional and technical knowledge by attending workshops.
  

• TSBI - Analyze of Legacy System: For each Use Case analyze the Mapping document of target table to determines operational objectives by studying business functions gathering information and evaluating output requirements.
  

• Track the target field mapping back to origin data element in the source system.
  

• Having strong knowledge in SQL to perform data analysis and data profiling on different Legacy system.
  

Exp Required: 8