**Job Title: SQL Programmer (Data Analyst) – FSS** **Location:** Indore, Madhya Pradesh, India **Work 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 (e.g., 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). Equal Opportunity Employer: Minority/Female/Disability/Veteran