3–7 years in data engineering, BI development
Experience working on DW or analytics projects
Exposure to enterprise data volumes
Experience working with BI teams
Familiarity with SLA-driven support models
Data Engineering
Strong SQL (complex joins, CTEs, window functions)
Data ingestion from structured and semi-structured sources
Data transformation logic and aggregation
ETL / ELT
Hands-on experience with ETL tools (SSIS, Informatica, ADF, dbt, etc.)
Scheduling, orchestration, and dependency management
Handling data validation and reconciliation checks
Databases
Oracle and/or MSSQL development
Understanding of indexes, constraints, and data types
Writing efficient and maintainable SQL code
Data Quality & Testing
Implementing validation rules
Supporting SIT/UAT data testing
Root cause analysis of data issues
Operational Support
Monitoring and troubleshooting ETL pipelines
Incident management and root cause analysis
Handling data load failures and reruns
Performance & Stability
Query optimisation and performance tuning
Managing growing data volume
Implementing fixes with minimal disruption
Enhancement & Maintenance
Onboarding new data sources
Minor model changes and enhancements
Maintaining documentation and runbooks