29 Aug
|
Laksh Consultants
|
India
29 Aug
Laksh Consultants
India
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 robust 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.
📌 Senior Database Developer - PL-SQL (India)
🏢 Laksh Consultants
📍 India