Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Engaged Employer

OptiSol Business Solutions

Compare

4.0

based on 123 Reviews

Video summary

16 OptiSol Business Solutions Jobs

Data Analyst

Opti sol solutions

4.0

based on 123 Reviews

5-10 years

Chennai

1 vacancy

Data Analyst

OptiSol Business Solutions

posted 2mon ago

Job Role Insights

Flexible timing

Key skills for the job

Virtual Assistant Data Analysis SQL Oracle Data Structures and Algorithms SAP Data Migration

+ 3 more

Job Description

Data Analyst for Data Migration & System Consolidation - OptiSol

Experience : 5 to 10 years
Salary : Best in Industry

Overview:

We are seeking a highly skilled Data Analyst to support enterprise-level data migration efforts and the consolidation of data systems from acquired companies into the existing database infrastructure. The ideal candidate will possess strong analytical skills, a deep understanding of data structures, and expertise in SQL Server, SSIS, ETL processes, and data integration. Power BI knowledge is preferred but not mandatory. This role involves working closely with cross-functional teams, including IT, business units, and project managers, to ensure seamless and accurate data consolidation.

Responsibilities:

Data Migration:

Analyze and profile source and target data to identify gaps, inconsistencies, and transformation requirements.
Design and execute data mapping, cleansing, transformation, and validation strategies.
Implement and monitor ETL processes for data migration using SSIS and other industry-standard tools.

System Consolidation:

Conduct in-depth analysis of data systems from acquired companies.
Identify redundancies, overlaps, and opportunities for optimization during system integration.
Work with technical teams to migrate, deduplicate, and integrate data into the enterprise database, primarily SQL Server.

Data Analysis and Quality Assurance:

Develop and execute data validation strategies to ensure migration accuracy and completeness.
Establish and monitor data quality KPIs during and after migration.
Create reports to communicate findings, progress, and recommendations to stakeholders, leveraging tools like Power BI where applicable.

Stakeholder Collaboration:

Partner with business units to understand data requirements and priorities.
Collaborate with database administrators, developers, and project managers to meet project objectives.
Provide post-migration support, including troubleshooting and issue resolution.

Documentation and Best Practices:

Document data structures, migration workflows, and integration processes.
Maintain and promote best practices for data migration and system consolidation.

Requirements:

Strong knowledge of SQL Server is a must.
Working knowledge of Oracle databases is a plus.
Proficiency in SSIS is mandatory for ETL processes.
Familiarity with Power BI is preferred but not required.
Experience with data analysis, profiling, and quality assurance.
Strong collaboration skills to work with cross-functional teams and stakeholders.

If this excites you, Please fill the Form to start the application process and we will be in touch

Yes, Full time No, I am not working elsewhere What is your notice period / When can you join? * Please Mention Here Accepted file types: pdf, Max. file size: 4 MB.

This field is for validation purposes and should be left unchanged.

Employment Type: Full Time, Permanent

Read full job description

Prepare for Data Analyst roles with real interview advice