G
Software Engineer, Business Intelligence & Analytics
Goodhope•location_onSri Lanka
work_historyFull-Timehome_workOn-site
About the Role
Build and maintain ETL/ELT pipelines, design and optimize stored procedures, and work with functional team analysts to understand data requirements for various systems.
Responsibilities
- Build and maintain reliable ETL/ELT pipelines to ingestion data from various sources, preferably by using Informatica connecting to Oracle/MSQL/MYSQL database sources
- Design, construct, and optimize stored procedures using SQL to handle data verification for integrity
- Work with functional team analysts to understand the requirements for FACT/MASTER data for schema design
- Troubleshoot, debug, and optimize data systems for maximum performance and scalability
- Maintenance of data accuracy and consistency between data warehouse and various source system
Requirements
- 1-2 years experience in a similar role
- Bachelor's Degree in Computer Science/Software Engineering or a similar discipline
- Database knowledge in SQL is mandatory
- Experience in Informatica and OBIEE is an added advantage
- Knowledge in Data Warehousing
Skills
`Informatica` · `Oracle` · `MSQL` · `MYSQL` · `SQL` · `FACT/MASTER` · `OBIEE` · `Data Warehousing`
What we offer
- Attractive remuneration package including fringe benefits
- Commensurate with industry standards
How to apply
Email your CV to **careers-lk@goodhope.co** with the position title in the subject line.