Shared jobSenior Data Engineer - Snowflake, PLSQL
Bengaluru · Senior
Applicants who checked fit first are 3.1× more likely to hear back
Your score for this role already exists
ASAI compared this JD against 41 signals - skills, seniority, domain, stack overlap etc. Add a resume and it unlocks in about 30 seconds.
No credit card · 1 tap with Google
What we know about this role
MEDIUM
Relanto is reviewing applications at a steady pace. Expect a standard response time as they evaluate the current pool.
First 72 hours
Still inside it - posted 2h agoEarly applicants get seen before the pile builds.
Not a repost
The first time we've seen this listing - it hasn't been closed and reopened.
Skills required
20 listedYou almost certainly match several of these already. Unlock your skill map to see the matches, the gaps, and what to fix first.
Job description
Position Overview
Key Responsibilities
- Lead the end-to-end Oracle-to-Snowflake migration, including assessment, architecture, development, testing, cutover, and stabilization.
- Analyze Oracle schemas, tables, views, stored procedures, packages, functions, triggers, and dependencies and translate them into Snowflake.
- Design and implement scalable Snowflake data models, ELT pipelines, ingestion frameworks, and transformations.
- Convert Oracle SQL/PLSQL and database logic into optimized Snowflake SQL and modern cloud data patterns.
- Develop production-grade Apache Airflow DAGs for data ingestion, transformation, scheduling, dependencies, monitoring, and error handling.
- Design efficient Parquet-based data pipelines, including extraction, staging, loading, partitioning, compression, and schema evolution.
- Evaluate and implement Snowflake Hybrid Tables for appropriate transactional/operational workloads.
- Identify, document, and migrate business rules embedded in Oracle PL/SQL, ETL processes, database objects, and application logic.
- Determine appropriate implementation of business rules using
- Snowflake SQL, Python, dbt, Airflow, or a Business Rules Engine (BRE).
- Build automated data reconciliation, validation, and business-rule regression testing between Oracle and Snowflake.
- Perform Snowflake query, warehouse, pipeline, and data-load performance optimization.
- Collaborate with architects, DBAs, application teams, business analysts, QA, and data engineering teams.
- Support production cutover, troubleshooting, and post-migration stabilization.
Required Qualifications & Skills
- 6+ years of overall database/data engineering experience.
- 3+ years of hands-on Snowflake experience.
- Proven experience delivering enterprise-scale Oracle-to-Snowflake migrations in production.
- Strong Oracle SQL and PL/SQL expertise, including stored procedures, packages, functions, triggers, views, and complex database logic.
- Strong Snowflake SQL, architecture, data modeling, and ELT experience.
- Hands-on Apache Airflow experience developing and operating production DAGs.
- Strong experience with Parquet and cloud object storage such as AWS S3, Azure Data Lake, or GCP.
- Experience with Snowflake Streams, Tasks, Snowpipe/COPY INTO, stages, and performance optimization.
- Hands-on experience with Snowflake Hybrid Tables is strongly preferred.
- Experience with large-volume data migration, incremental loads, CDC, reconciliation, and migration testing.
- Strong problem-solving, communication, and cross-functional collaboration skills.
Nice-to-Have Skills
- SnowPro Advanced: Data Engineer certification.
- SnowPro Core certification.
- Experience with a Business Rules Engine (BRE) or decision/rules-management platform.
- Experience migrating and modernizing business rules from Oracle/PLSQL.
- Experience integrating BRE with Snowflake and Airflow.
- Python and DBT experience.
- Experience with Oracle GoldenGate, AWS DMS, Fivetran, Qlik Replicate, Informatica, or similar tools.
- Experience with CI/CD, Git, and cloud data platforms.
- Snowflake security and governance experience.
Free · no signup
Get tomorrow's jobs before you have to search
Daily job drops, skill trends and free resources - posted straight to the group. Leave any time.
No spam. Just jobs and resources.
Why people use ASAI
Someone shared one job with you. ASAI keeps finding the rest.
Scored, not searched. Every role ranked against your actual profile.
Alerts as often as hourly. Reach new roles while the pile is still small.
Skill gaps, spelled out. See exactly which requirements you don't meet yet.
Verified jobs, only. Say no to ghost jobs. Your time deserves respect.
More Data Engineer roles in Bengaluru
See allKeep browsing