About Role

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

Roles & Responsibilities

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

Senior Database Developer (PL/SQL, ETL)