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 effective 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).

📌 Walk-in || Indore Process Analyst FSS- SQL Developer
🏢 WM Universal Solutions
📍 Indore