Senior Database Developer (PL/SQL, ETL)

Relic Consultancy Services; Hyderabad; Hybrid; INR 1,500,000 - 2,300,000; Full time

Job summary

Relic Consultancy Services invites an experienced Senior Developer to design and optimize data solutions using PL/SQL, SQL, ETL, and Microsoft SSIS, supporting enterprise data warehousing in a hybrid work model. This role focuses on robust scheduling workflows and integrating multi-channel and supply chain data to boost operational insights for global stakeholders.

The ideal candidate will have 5+ years of hands-on PL/SQL/SQL, SSIS ETL development, data warehousing familiarity, and strong

Qualifications

• Mandatory 5+ years of strong hands-on PL/SQL and SQL development, including complex stored procedures, functions, queries, joins, data manipulation, and performance optimization.
• Mandatory strong hands-on ETL development using Microsoft SSIS, including building, maintaining, optimizing, and troubleshooting SSIS packages for large-volume data movement and transformation.
• Mandatory experience with Data Warehousing concepts and architectures, including data models, fact/dimension structures, ETL data flows, and enterprise reporting/data warehouse environments.
• Mandatory experience managing batch jobs, scheduling, and data pipelines for timely and reliable enterprise ETL workflows.
• Mandatory production support experience for SSIS/ETL and data warehouse jobs, monitoring, troubleshooting, root cause analysis, and preventive fixes.
• Mandatory experience with data quality, validation, and troubleshooting affecting downstream reports, dashboards, and analytics.
• Mandatory experience with unit, integration, and regression testing of SQL, PL/SQL, and ETL components, plus documenting designs, mappings, data flows, and deployments.
• Mandatory location requirement - willing to work in hybrid model from a city where Cognizant has an office.
• Mandatory notice period - immediate joiners or join within 2-4 weeks.

Responsibilities

• Design and develop complex PL/SQL and SQL procedures, functions, and queries for enterprise reporting needs.
• Implement and optimize ETL workflows using Microsoft SSIS to move, transform, and validate large datasets into centralized warehouse structures.
• Configure and manage scheduling for batch jobs and data pipelines to ensure timely data availability.
• Analyze data warehousing concepts and models to propose improvements for scalability and analytical value.
• Collaborate with cross-functional teams to translate data requirements into technical solutions for supply chain data.
• Perform root cause analysis and remediation of data quality issues to ensure trustworthy downstream analytics.
• Document technical designs, mappings, data flows, and deployment steps for maintenance and audits.
• Conduct unit, integration, and regression testing of SQL/PL/ETL components and ensure alignment with standards.
• Provide production support for data warehouse jobs and SSIS packages, monitoring and troubleshooting failures.
• Engage stakeholders in a hybrid work setting to gather requirements and refine deliverables.
• Contribute to continuous improvement of data engineering practices by proposing new patterns and automation.
• Align daily development activities with organizational goals for better customer experiences and optimized supply chains.
• Ensure compliance with quality guidelines and regulatory expectations through robust controls and traceability.

Skills

PL/SQL

SQL

SSIS

ETL

Data Warehouse

Tools

Microsoft SSIS

Job description

About Role

Key Skills:

Job Summary

We are seeking an experienced Senior Developer to design and optimize data solutions using PL/SQL, SQL, ETL, and Microsoft SSIS, supporting enterprise data warehousing initiatives in a hybrid work model. This role centers on building robust scheduling workflows and integrating multi-channel and supply chain data to improve operational insights and drive informed business decision-making for global stakeholders.

About Role

Key Skills: PL/SQL | SQL | SSIS | ETL | Data Warehouse

Job Summary

We are seeking an experienced Senior Developer to design and optimize data solutions using PL/SQL, SQL, ETL, and Microsoft SSIS, supporting enterprise data warehousing initiatives in a hybrid work model. This role centers on building robust scheduling workflows and integrating multi-channel and supply chain data to improve operational insights and drive informed business decision-making for global stakeholders.

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.
• Analyze existing data warehousing concepts and models to propose improvements that enhance scalability, maintainability, and analytical value across multiple business units.
• Collaborate with cross-functional teams to translate multi-channel and supply chain management data requirements into well-structured technical solutions supporting strategic initiatives.
• Perform detailed root cause analysis and remediation of data quality issues to ensure downstream analytics, dashboards, and operational decisions are based on trustworthy information.
• Document technical designs, mappings, data flows, and deployment steps in clear, reusable formats to support ongoing maintenance, future enhancements, and audit readiness.
• 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.
• Engage with stakeholders in a hybrid work setting to gather requirements, demonstrate solutions, and refine deliverables to consistently meet business expectations.
• Contribute to continuous improvement of data engineering practices by proposing new patterns, tools, and methods that increase automation, reliability, and transparency of data flows.
• Align daily development activities with organizational goals, ensuring data solutions enable better customer experiences, optimized supply chains, and informed decision-making across markets.
• Ensure compliance with internal quality guidelines and external regulatory expectations by implementing robust controls, validations, and traceability within data warehouse ecosystems.

Ideal Candidate

• Strong Senior Developer - PL/SQL, SQL & ETL (Microsoft SSIS) Profile
• Mandatory (Experience 1) - 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.
• Mandatory (Experience 2) - 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.
• Mandatory (Experience 3) - 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.
• Mandatory (Experience 4) - Must have experience managing batch jobs, scheduling, and data pipelines, ensuring timely and reliable execution of enterprise ETL workflows.
• Mandatory (Experience 5) - Must have hands-on experience in production support for SSIS/ETL and data warehouse jobs, including monitoring job execution, troubleshooting failures, performing root cause analysis, and implementing preventive fixes.
• Mandatory (Experience 6) - Must have experience with data quality, validation, and troubleshooting, including identifying and resolving data discrepancies/issues affecting downstream reports, dashboards, and analytics.
• Mandatory (Experience 7) - 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.
• Mandatory (Location) - Must be willing to work in a hybrid model from a city where Cognizant has an office.
• Mandatory (Notice Period) - Immediate joiners or candidates who can join within 2-4 weeks.

Skills: ssis,sql,pl/sql,etl,data warehouse