Position: Senior Database Developer (PL/SQL, ETL)

Overall/Total Experience: 5-8 years only

Location: Bengaluru, Mumbai, Pune, Noida, Hyderabad, Kolkata, Gurugram, Chennai

Working Days: 5 Days Working from Office

Notice Period Requirement: 15-30 Days (Maximum)

Client's Company Size: Mid-Sized

Key Responsibilities:

- Design and develop complex PL/SQL and SQL procedures, functions, and queries that ensure accurate, performant, and reliable data processing for enterprise reporting needs.

- Implement and optimize ETL workflows using Microsoft SSIS to move, transform, and validate large datasets from diverse operational systems into centralized warehouse structures.

- Configure and manage scheduling for batch jobs and data pipelines to guarantee timely data availability aligned with business-day operations and service level expectations.

- Perform detailed root cause analysis and remediation of data quality issues to ensure downstream analytics, dashboards, and operational decisions are based on trustworthy information.

- Conduct unit, integration, and regression testing of PL/SQL, SQL, and ETL components to verify functional accuracy, performance benchmarks, and alignment with enterprise standards.

- Provide production support for data warehouse jobs and SSIS packages by monitoring execution, troubleshooting failures, and implementing preventive improvements to reduce recurrence.

Candidate Requirements:

- Must have minimum 5+ years of strong hands-on experience in PL/SQL and SQL development, including complex stored procedures, functions, queries, joins, data manipulation, and query/performance optimization.

- Must have strong hands-on experience in ETL development using Microsoft SSIS, including building, maintaining, optimizing, and troubleshooting SSIS packages for large-volume data movement and transformation.

- Must have solid experience working with Data Warehousing concepts and architectures, including data models, fact/dimension structures, ETL data flows, and enterprise reporting/data warehouse environments.

- Must have experience managing batch jobs, scheduling, and data pipelines, ensuring timely and reliable execution of enterprise ETL workflows.

- Must have hands-on experience in production support for SSIS/ETL and data warehouse jobs.

- Must have experience with unit, integration, and regression testing of SQL, PL/SQL, and ETL components, along with strong documentation of technical designs, data mappings, data flows, and deployment processes.