EPM Database developer

• Testing ETL processes to ensure data accuracy, completeness and integrity throughout the extraction, transformation and loading processes.
• Scripting knowledge to automate the processes.
• Expert in tools like SQL, Python/Java, ETL testing frameworks, Tableau or Google looker.
• Develop and automate test scripts for ETL workflows, data pipelines to ensure database testing coverage.
• Identifying quality issues, collaborate with ETL developers, data engineers to understand data requirements.

What we'll offer you

• As part of our flexible scheme, here are just some of the benefits that youll enjoy
• Best in class leave policy
• Gender neutral parental leaves
• 100% reimbursement under childcare assistance benefit (gender neutral)
• Sponsorship for Industry relevant certifications and education
• Employee Assistance Program for you and your family members
• Comprehensive Hospitalization Insurance for you and your dependents
• Accident and Term life Insurance
• Complementary Health screening for 35 yrs. and above

Your key responsibilities

• Design databases that are functional, dependable, and stable - Partner with development teams to design data management and governance protocols, manage the information lifecycle, design infrastructure, and data integration controls
• Understanding business strategy and cascades business intelligence needs to the database level Execute tests and update databases in accordance with requests.
• Develop and maintain complex models and logical database designs.
• Create and Maintaining the ETL system to ensure data accuracy and integrity throughout the ETL process including data validation, cleansing, deduplication, and error handling to ensure reliable and usable data.
• Monitor its performance, updating ETL scripts and workflows as business requirements change, and ensuring the system scales with data growth.
• Perform performance tuning for optimizing ETL processes for speed and efficiency, addressing bottlenecks, and ensuring the ETL system can handle the volume, velocity, and variety of data.
• Create technical and training guides.
• Support users' data management.
• Verify that all database programs adhere to the organization's and performance standards.
• Conduct research and make recommendations for fresh database services, products, and methods.

Your skills and experience

• Proven work experience (10+ years) as a Database developer. Proficient with relational databases (e.g. Oracle, SQL Server, MySQL, PostgreSQL)
• In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
• Experience in designing and implementing database structures and automating data flows and DBA tasks
• Experience with data modeling and schema design.
• Demonstrated experience in tuning database and its objects
• Understanding of database design practices, including database normalization concepts
• Familiarity with working withJavaScript, HTML, Net Framework, and Oracle.
• Excellent analytical and organisational skills.
• Understanding the needs of front-end users and having a problem-solving mindset.
• Excellent verbal and written communication skills.
• Degree in Computer Science or relevant field

How we'll support you

• Training and development to help you excel in your career
• Coaching and support from experts in your team
• A culture of continuous learning to aid progression
• A range of flexible benefits that you can tailor to suit your needs