SQL Developer

JOB DETAILS:

Work set-up: Hybrid

Shift Schedule: Day Shift

Location: Makati City, Philippines

JOB QUALIFICATIONS:

• 5 to 10+ years of work experience as a SQL Developer
• Expert level SQL with the ability to create and evaluate complex SQL statements, stored procedures, and index tables
• Strong programming skills in Python, Scala, or similar languages for scripting and data manipulation

JOB DESCRIPTION:

• Work with Data Engineers, ETL developers and Data Analytics team to build a robust data pipelines for our data platforms via stored procedures, views and SQL queries
• Execute on technical requirements and document new ones when needed
• Diagnosing and resolving defects of ODS and other data platform
• Document technical requirements, architecture diagrams, data dictionaries, and pipeline operational procedures.
• Proactively monitor data workflows, identify bottlenecks, and resolve operational issues.
• Extract and ingest data from diverse sources including production databases, and third-party systems.
• Implement data validation routines to enforce high data governance, integrity, and cleanliness standards.
• Apply best practices for development of stored procedures, views, indexes and SQL queries
• Understanding the technical architecture of ADaM ODS and other data platforms
• Protect the confidentiality and security of client data
• Understand business processes and requirements from the business and mapping documents
• Work both independently and as part of a team