Add office photos
Engaged Employer
i
This company page is being actively managed by
Encora Team. If you also belong to the team, you
can get access from
here
Encora
Compare
All Filters
256 Encora Jobs
Data Migration Specialist
Encora
posted 15hr ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
Important Information
Location: India
Experience: 10+ years
Job Mode: Full-time
Job Summary
The SQL-to-Postgres Data Migration Specialist will play a key role in data modernization initiatives by leading the migration of legacy SQL Server databases, including T-SQL stored procedures and SSIS packages, to PostgreSQL. This role requires deep expertise in database administration, migration strategies, and tools to ensure minimal downtime, data integrity, and a seamless transition to a modern, scalable cloud-based architecture. The specialist will leverage tools such as Babelfish, generative AI, or custom frameworks to optimize the migration process and ensure compatibility across systems.
Responsibilities and Duties
- Database Migration & Compatibility:
- Lead the migration of complex SQL Server environments, including stored procedures and SSIS packages, to PostgreSQL.
- Use Babelfish for Aurora PostgreSQL or other tools to streamline compatibility with legacy T-SQL code.
- Analyze existing SQL Server structures to identify potential issues and develop robust solutions for smooth transitions.
- Data Transformation & Integration:
- Design and implement ETL processes to transform and migrate data accurately while maintaining its integrity.
- Collaborate with the data engineering team to integrate workflows using tools such as AWS Glue and Apache Airflow.
- Optimization & Performance Tuning:
- Optimize database performance during and post-migration, ensuring the new environment supports existing and future workloads.
- Perform tuning for PostgreSQL systems to meet performance benchmarks and scalability requirements.
- Collaboration & Stakeholder Engagement:
- Work closely with the Solution Architect, Data Architect, and QA Lead to align migration strategies with project objectives and quality standards.
- Partner with the client s in-house team to validate migrated components and ensure compatibility with application logic.
- Tool & Framework Utilization:
- Evaluate and implement tools such as Babelfish or generative AI frameworks to automate and ease T-SQL to PostgreSQL translation.
- Develop scripts and workflows for automating migration tasks and minimizing manual intervention.
- Documentation & Knowledge Transfer:
- Prepare detailed documentation for migrated components, including database structures, stored procedures, and ETL pipelines.
- Conduct training sessions for the client s technical team to ensure they are equipped to maintain and operate the new system
Qualifications and Skills
- 10+ years of experience in database administration, with significant expertise in SQL Server and PostgreSQL.
- Proven track record in large-scale database migration projects, including stored procedure and ETL package migration.
- Hands-on experience with Babelfish for Aurora PostgreSQL or similar tools to aid SQL Server compatibility.
- Strong understanding of ETL frameworks such as AWS Glue and Apache Airflow.
- Expertise in database performance tuning and optimization.
- Strong collaboration and communication skills to work effectively with technical teams and stakeholders.
- Attention to detail and a proactive approach to identifying and mitigating migration risks.
- Ability to work in a fast-paced environment and deliver results within tight deadlines
Additional Requirements
- Experience using generative AI tools or frameworks to support database migration and compatibility tasks.
- Familiarity with microservices architecture and API-driven database interaction.
- Knowledge of cloud-native platforms, particularly AWS Aurora and Snowflake.
- Strong analytical skills for troubleshooting and problem resolution during complex migrations.
About Encora
Encora is a global company that offers Software and Digital Engineering solutions. Our practices include Cloud Services, Product Engineering & Application Modernization, Data & Analytics, Digital Experience & Design Services, DevSecOps, Cybersecurity, Quality Engineering, AI & LLM Engineering, among others.
At Encora, we hire professionals based solely on their skills and do not discriminate based on age, disability, religion, gender, sexual orientation, socioeconomic status, or nationality.
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for Data Migration Specialist roles with real interview advice
People are getting interviews at Encora through
People are getting interviews through
(based on 50 Encora interviews)
Job Portal
Referral
Company Website
Walkin
54%
18%
2%
2%
24% candidates got the interview through other sources.
High
Confidence
?
High Confidence means the data is based on a large number of responses received from the candidates.
What people at Encora are saying
What Encora employees are saying about work life
based on 671 employees
Flexible timing
Monday to Friday
No travel
Day Shift
Encora Benefits
Submitted by Company
Job Training Health Insurance Soft Skill Training 
Cafeteria
Submitted by Employees
View more benefits 
Compare Encora with
TCS
Compare
Infosys
Compare
Wipro
Compare
HCLTech
Compare
Tech Mahindra
Compare
LTIMindtree
Compare
Mphasis
Compare
Hexaware Technologies
Compare
Persistent Systems
Compare
Xoriant
Compare
CitiusTech
Compare
HERE Technologies
Compare
BT Business
Compare
HTC Global Services
Compare
Tietoevry
Compare
Unisys
Compare
Slk Software Services
Compare
Altimetrik
Compare
Apexon
Compare
TEKsystems
Compare
Similar Jobs for you
Encora Chennai Office Locations
Chennai Office
2nd floor, Module 7, North Block, Phase 2, IG3 Infra Ltd. IT SEZ, Pallavaram, Thoraipakkam
Chennai
600097
600097
Chennai Office
No. 11, Doxa Business Center, Rattha Tek Tower, OMR Road Thoraipakkam
Chennai 600097, India
Chennai
Share an Interview