Pipeline || SQL Programmer

Job Title: SQL Programmer (Data Analyst) – FSS Location: Indore, Madhya Pradesh, IndiaWork Mode: Onsite (with rotational shifts)Experience: 3–5 years (minimum 3 years of hands-on SQL development)Employment Type: Full-time Shift Details: Rotational Shifts (5 shifts) covering business and support hours, including early morning, general, evening, and night rotations. Flexibility to swap or adjust shifts per process requirements and SLAs. About the Role: We’re looking for a SQL Programmer to support the Financial Shared Services (FSS) process. You will design, optimize, and maintain database objects, build robust queries and procedures, and collaborate with cross-functional teams to ensure the accuracy, timeliness, and reliability of financial data pipelines and reporting. This role is critical to ensuring high-quality data, compliant operations, and continuous performance improvements in a high-availability environment. Key Responsibilities: Database Development: Design and implement SQL queries, stored procedures, functions, views, triggers, and ETL routines to support FSS use cases (AP/AR, GL, reconciliations, settlements, aging, audit trails). Performance Tuning: Analyze execution plans, refactor queries, optimize indexes/partitions, and resolve bottlenecks to meet SLAs in rotational shift windows. Data Integrity & Governance: Implement validations, constraints, auditing frameworks, and error handling to ensure completeness and accuracy of financial data. ETL & Pipelines: Build and maintain batch/near real-time data ingestion and transformation jobs (SSIS/PL SQL scripts or equivalent), including scheduling, monitoring, and recovery steps. Snowflake Integration: Develop and optimize queries for Snowflake-based data warehouses; ensure efficient data loading and transformation for analytics. AS400 & SAP Data Handling: Work with AS400 and SAP systems to extract, transform, and validate financial data for downstream processes and reporting. Reporting & Analytics Support: Deliver data marts, views, and optimized datasets for BI tools (Power BI/SSRS/Tableau), ensuring semantic consistency. Incident & Production Support: Triage and resolve data/process incidents across shifts; document RCA; drive preventive actions and automation. Documentation & Standards: Maintain technical specs, data dictionaries, SOPs, service runbooks, and adhere to coding/review standards. Stakeholder Collaboration: Work closely with FSS operations, finance, QA, and platform teams to translate business rules into performant SQL solutions. Compliance & Security: Follow access controls, data privacy guidelines, and audit requirements relevant to FSS operations. Continuous Improvement: Propose and implement automations, reusable components, and best practices to reduce manual effort and improve reliability. Required Skills & Qualifications: Strong SQL expertise (advanced joins, window functions, CTEs, dynamic SQL, error handling). Hands-on with one or more: T-SQL (MS SQL Server), PL/SQL (Oracle), MySQL/PostgreSQL. Performance tuning experience (indexing, partitioning, statistics, query plan analysis). Experience building and supporting ETL jobs (., SSIS, SQL native scripts, schedulers). Familiarity with financial processes/data in FSS (vendor/customer ledgers, payments, reconciliations). Experience with Snowflake for data warehousing and analytics. Exposure to AS400 and SAP systems for financial data extraction and validation. Experience with production support and incident management in rotational shifts. Proficiency with version control (Git) and ticketing/ITSM tools (Jira/ServiceNow). Strong problem-solving, documentation, and communication skills. Bachelor’s degree in computer science/IT/Engineering or equivalent practical experience. Good to Have (Preferred): Exposure to data warehousing concepts (star/snowflake schema, slowly changing dimensions). Experience with BI tools (Power BI, SSRS, Tableau) and building optimized data sources. Knowledge of schedulers (SQL Agent/Control M/Autosys) and job orchestration. Basics of cloud databases (Azure SQL, AWS RDS/Redshift, GCP BigQuery) or Python for data tasks. Experience in audit/compliance frameworks relevant to finance shared services. Familiarity with RCA, observability tools (query store, performance monitors).