19 Nov
|
truelancer staffing
|
Chennai
19 Nov
truelancer staffing
Chennai
Senior Database Migration Engineer – Sybase/Oracle to Snowflake
Experience: 8+ Years
Location: Bangalore / Hyderabad / Chennai / Pune
Work Model: Onsite
Job Summary
We are looking for an experienced Senior Database Migration Engineer with 8+ years of IT experience and strong hands-on expertise in migrating databases from Sybase to Snowflake OR Oracle to Snowflake.
Key Responsibilities
- Design and execute end-to-end database migration from Sybase to Snowflake or Oracle to Snowflake.
- Analyze existing database structures, schemas, stored procedures, functions, views, and queries.
- Develop and optimize complex SQL queries for data extraction, transformation, and loading (ETL/ELT).
- Perform data mapping, data cleansing, transformation, and validation during migration.
- Identify and resolve database compatibility issues between source databases and Snowflake.
- Optimize Snowflake queries, warehouse utilization, and overall database performance.
- Ensure data integrity, consistency, and accuracy throughout the migration process.
- Troubleshoot migration-related issues and implement appropriate solutions.
- Collaborate with business, data engineering, and technical teams to ensure successful migration delivery.
- Prepare technical documentation and migration reports.
- - Required Skills & Experience
- 8+ years of overall experience in database development, administration,
or data engineering.
- Strong hands-on experience in either of the following migration technologies:
- Sybase to Snowflake Migration, OR Oracle to Snowflake Migration.
- Strong expertise in Snowflake architecture and database concepts.
- Advanced SQL skills, including complex queries, joins, subqueries, and query optimization.
- Experience with database schema conversion, stored procedures, functions, and views.
- Strong understanding of ETL/ELT processes and data migration methodologies.
- Experience in data validation, reconciliation, and performance tuning.
- Good understanding of database objects, data types, and source-to-target mapping.
- Strong analytical, troubleshooting, and problem-solving skills.
Preferred Skills
- Experience with Snowflake features such as Virtual Warehouses, Snowpipe, Streams, Tasks, and Time Travel.
- Knowledge of data migration tools and automation frameworks.
- Experience working in large-scale enterprise database migration projects.
- Familiarity with cloud-based data platforms and data warehousing concepts.
Candidate Expectations
- Must have hands-on experience in at least one of the specified migration paths.
- Should have independently handled database migration activities.
- Solid communication and stakeholder coordination skills.
📌 Senior Database Migration Engineer (Chennai)
🏢 truelancer staffing
📍 Chennai