AmbitionBox
Jobs
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Engaged Employer
i
This company page is being actively managed by
OptiSol Business Solutions Team. If you also belong to the team, you
can get access from
here
OptiSol Business Solutions
Compare
All Filters
15 OptiSol Business Solutions Jobs
Data Analyst
OptiSol Business Solutions
posted 1mon ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
Data Analyst for Data Migration & System Consolidation - OptiSol
Experience : 5 to 10 years
Salary : Best in Industry
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.
Mandatory Skills: SQL Server| ETL- SSIS | Data Migration | Client Handling | Team Handling | Excellent Communication skills
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 descriptionPrepare for Data Analyst roles with real interview advice
What people at OptiSol Business Solutions are saying
Data Analyst salary at OptiSol Business Solutions
reported by
1
employee
₹3.1
L/yr - ₹4
L/yr
41%
less
than the average Data Analyst Salary in India
View more details
What OptiSol Business Solutions employees are saying about work life
based on 123 employees
Flexible timing
Monday to Friday
No travel
Day Shift
OptiSol Business Solutions Benefits
Submitted by Company
Sponsorship for Learning and Development Job Training Rewards & Recognition Health Insurance Work From Home 
Submitted by Employees
View more benefits 
Compare OptiSol Business Solutions with
TCS
Compare
Infosys
Compare
Wipro
Compare
HCLTech
Compare
Tech Mahindra
Compare
LTIMindtree
Compare
Mphasis
Compare
Hexaware Technologies
Compare
Persistent Systems
Compare
PC Solutions
Compare
RNF Technologies
Compare
Hidden Brains InfoTech
Compare
Tekskills
Compare
Affine
Compare
Greemus Software Technologies Private Limited
Compare
360 Degree Cloud Technologies
Compare
Avantha Technologies
Compare
Amantya Technologies
Compare
Sumeru Software Solutions
Compare
Infojini
Compare
Similar Jobs for you
OptiSol Business Solutions Chennai Office Location
Chennai Office
OptiSol Business Solutions, 4th-floor block, Baid Hi-Tech Park, No 38, SH 49, Thiruvanmiyur
Chennai
600041
600041
Optisol Business Solutions - Team Lead - Artificial Intelligence/Computer Vision (3-7 yrs)
3-7 Yrs
Recently Viewed
INTERVIEWS
Guidehouse
No Interviews
REVIEWS
Blackrock
No Reviews
LIST OF COMPANIES
Guidehouse
Locations
JOBS
Tata AIA Life Insurance
No Jobs
INTERVIEWS
Guidehouse
No Interviews
SALARIES
ANZ Operations & Technology
INTERVIEWS
Guidehouse
No Interviews
JOBS
VXI Global Solutions
No Jobs
JOBS
Photon Interactive
No Jobs
JOBS
Aeries Technology
No Jobs
Share an Interview
How was your last interview experience?
Feedback
