Senior PL/SQL Developer

Job Description

The Senior PL/SQL SAS Mart Developer (BFSI) will be a crucial member of the data warehousing team, responsible for the design, development, and maintenance of data marts specifically tailored for the Banking, Financial Services, and Insurance (BFSI) domain. This role requires a strong combination of deep PL/SQL development skills for data transformation and manipulation within an Oracle environment, coupled with expertise in SAS for data mart creation, reporting, and analytical purposes. The successful candidate will leverage their extensive experience in the BFSI sector to build efficient, robust, and compliant data marts that support critical business intelligence, reporting, and analytical needs. Responsibilities: Data Mart Design and Development: Design and develop dimensional and multi-dimensional data marts based on business requirements within the BFSI context, utilizing both PL/SQL for backend data processing and SAS for data mart structuring and access. PL/SQL Development for Data Marts: Utilize advanced PL/SQL skills to extract, transform, and load data from the central data warehouse or source systems into the designated data marts, ensuring data quality, performance, and adherence to BFSI data standards. This includes developing complex stored procedures, functions, packages, and triggers. SAS Data Mart Implementation: Leverage SAS tools (e. g. , SAS Data Integration Studio, SAS Enterprise Guide, SAS OLAP Cube Studio) to structure, populate, and manage data marts for efficient reporting and analysis. BFSI Data Expertise: Apply a strong understanding of BFSI data models, key performance indicators (KPIs), regulatory reporting requirements (e. g. , BASEL, RBI, Solvency II), and common analytical needs within the financial services and insurance industries to design relevant and effective data marts. Performance Optimization: Optimize PL/SQL code and SAS processes related to data mart development and access to ensure high performance and efficient query execution for reporting and analytical tools. Data Quality and Governance: Implement and enforce data quality checks within both PL/SQL and SAS processes to ensure the accuracy, consistency, and integrity of data within the data marts, adhering to the banks data governance policies and BFSI-specific data quality standards. Troubleshooting and Support: Investigate and resolve issues related to data mart performance, data accuracy, and accessibility, involving both PL/SQL and SAS components. Provide expert-level support for data mart users. Documentation: Create and maintain comprehensive technical documentation for data mart designs, PL/SQL code, SAS jobs, data mappings, and user guides, ensuring compliance with BFSI documentation standards. Collaboration: Work closely with business analysts, report developers, data scientists, and other stakeholders within the BFSI departments to understand their data mart requirements and deliver solutions that meet their analytical and reporting needs. Security and Compliance: Ensure that data marts and the processes used to build and access them comply with the banks security policies and relevant BFSI regulatory requirements regarding data access and privacy. Mentoring: Provide technical guidance and mentorship to junior developers on PL/SQL and SAS skills related to data mart development within the BFSI domain. Required Skills and Experience: Bachelors degree in Computer Science, Information Technology, Statistics, Economics, Finance, or a related field. Proven experience of 7-10 years in developing data warehousing and business intelligence solutions, with a significant focus on data mart development within the Banking, Financial Services, and Insurance (BFSI) sector. Extensive and demonstrable expertise in PL/SQL development, including advanced querying, stored procedures, functions, packages, and performance tuning within an Oracle environment. Strong proficiency in SAS programming and experience using SAS tools for data mart creation and management (e. g. , SAS Data Integration Studio, SAS Enterprise Guide, SAS OLAP Cube Studio, SAS Metadata Server). Deep understanding of BFSI data models, common KPIs, and regulatory reporting requirements (e. g. , BASEL, RBI guidelines, Solvency II, IFRS). Strong SQL skills and experience working with relational databases, particularly Oracle.