Data Support Engineer

Location: Bangalore

Role Overview:

We are seeking a Data Support Engineer to join our APJ Data and Automation team. The ideal candidate will support database operations, develop data pipelines, and assist with SQL query development. Knowledge of PHP for supporting legacy code is preferred.

Key Responsibilities:

Database Development & Support:

• Write and optimize SQL queries, stored procedures, and views for data retrieval and transformation.
• Develop and maintain data pipelines to support business intelligence and analytics requirements.
• Support SQL Server and Amazon Redshift environments for data storage, transformation, and analytics.
• Ensure data integrity, security, and quality across all database solutions.

Operational Support:

• Monitor ETL logs and troubleshoot data pipeline issues to minimize downtime.
• Perform data validation and reconciliation to ensure data accuracy.
• Maintain Excel reports and updates as part of regular operational tasks.

Development & Automation:

• Utilize Python for automation, data processing, and workflow enhancements.
• Work with AWS services (e.g., S3, Redshift, Glue) to implement cloud-based data solutions.
• Assist in maintaining and optimizing legacy PHP code for database interactions (preferred).

Experience & Qualifications:

• Minimum 2 years of experience in database development, support, or data engineering roles.
• Strong SQL skills with experience in query optimization, stored procedures, and data provisioning.
• Hands-on experience with relational databases (SQL Server) and cloud data warehouses (Redshift).
• Python programming skills for automation and data transformation.
• AWS expertise in services like S3, Redshift, and Glue (preferred).
• Knowledge of Databricks and big data processing is a plus.
• Experience with data validation and reconciliation processes.
• Exposure to CI/CD, version control, and data governance best practices.
• Knowledge of PHP for database-related development and maintenance (preferred but not mandatory).