VBA+SQL-4+ years

Location Mumbai
Job type: Permanent
Salary: ₹1,500,000.00
Contact name: Shubham Thakur

Contact email: shubham.thakur@crescendogroup.in
Job ref: 34987
Published: 18 days ago
Startdate: 02/08/2021

 

Your Employer: A MNC professional services firm
Strong in :
1. Understanding database relationships and writing complex SQL queries & working experience in VBA +SSis
2. Data analysis and profiling & working experience in data quality assessment report--Null Value Analysis, Compression Anaysis, Unique Value Analysis, Data Profiling Anomalies, Minimum Maximum column length, Zero/Spaces Counts or Similar
3. Communication (read & write in English), Collaboration & Presentation skills & working experience in team player or Similar

 

 

Requirements

  1. Deep Knowledge of SQL, VBA+ SSISOracle or similar and experience in understanding database relationships
  2. Working experience with Null Value Analysis, Compression Anaysis, Unique Value Analysis, Data Profiling Anomalies, Minimum Maximum column length, Zero/Spaces Counts or Similar
  3. working experience in either Azure DevOps, JIRA or Similar and Agile Process (Scrum cadences, Roles, deliverables)
  4. Proficiency in visualization tools (PowerBI or Tableau or Similar) and working experience in ERwin, ER/Studio, PowerDesigner or Similar
  5. Strong Communication , Collaboration & Presentation skills

 

Responsibilities

  1. Use Enterprise Data Modelling and Semantic Modelling
  2. Make Logical/Physical models on Big Data sets or modern data warehouse
  3. Reading Data Formats & working experience in JSON, XML or Similar
    4. Writing functional & technical documentation & basic understanding in data integration architecture documentation, data models, data dictionaries, data integration specifications, data testing plans or Similar