Senior Data Engineer

Position Title: Data Engineer (AWS DMS / Python / Oracle PL/SQL)

Job Summary:

We are seeking an experienced Data Engineer with strong expertise in AWS Database Migration Service (DMS), Python, and Oracle PL/SQL. The ideal candidate will be responsible for designing, developing, and supporting large-scale data migration, transformation, and integration solutions across cloud.

Key Responsibilities

AWS DMS (Primary Skill)

Design, configure, and manage AWS DMS replication tasks for full-load and CDC.

Troubleshoot migration issues including latency, table mapping, LOB handling, and replication instance tuning.

Fine-tune DMS task parameters and validate data consistency post migration.

Automate monitoring and alerting DMS using CloudWatch, SNS, or Lambda.

Python

Develop Python scripts for:

o Data validation and reconciliation

o Migration automation workflows

o API integrations and utility tools

Build ETL/ELT orchestration using Python frameworks or AWS services (Lambda, Glue, Step Functions).

Write modular, scalable, production-ready code following best practices.

Oracle PL/SQL

Develop and optimize complex PL/SQL procedures, functions, triggers, and packages.

Analyze and optimize SQL queries for performance tuning.

Work closely with DBAs on schema design, indexing, and performance optimization.

Understanding of Oracle partitioning, materialized views, and transaction management.

General Responsibilities

Prepare technical documentation including design specs, runbooks, and migration plans.

Participate in code reviews and ensure adherence to engineering standards.

Ensure data security, quality, and compliance throughout the migration lifecycle.

Required Skills & Qualifications

Strong hands-on experience with AWS DMS .

Proficiency in Python for data engineering & automation.

Advanced skills in Oracle SQL/PLSQL development.

Experience with AWS services such as:

o EC2, S3, IAM, RDS, CloudWatch, Lambda.

Good understanding of ETL/ELT concepts and data modeling.

Familiarity with Agile/Scrum practices.

Preferred Skills

Knowledge of Redshift / Aurora / PostgreSQL.

Exposure to DevOps tools (Git, Jenkins, CI/CD).

Experience with performance tuning during large-scale migrations.

Familiarity with Unix shell scripting.

o Mandatory skills

o Practice: Next Generation

o Primary Skill: AWS DMS, Python & Oracle PL/SQL

o Experience: 4-6+ Years of Relevance Experience

o Primary Location: Hyderabad (1), Bangalore (2), Hyderabad (2), Noida (3)