Read about us on www.copious-software.com
Role & Responsibilities -
Interact with business and system analysts to solutionise problems.
Collaborate with analysts to understand source structures, evaluate requirements and finally deliver a solid solution.
Conduct data analysis on various source systems as part of the ETL development process.
Utilise the toolstack of the environment which is primarily Microsoft (SSIS, T-SQL) to deliver solutions.
Must be able to read and maintain code not written by yourself.
Have experience following a formal SDLC as part of solution delivery.
Optimise ETL processes as well as SQL queries by analyzing query execution plans.
Maintain code repositories for version control of developed solutions.
Create and maintain metadata repositories.
Implement database structures according to specifications and guide on improvements (indexes/partitioning etc) where necessary.
Perform ETL support on a standby basis to ensure that the ETL batch completes within SLA.
Technical skills required -
Ability to design and implement complete ETL processes using SSIS and T-SQL.
Strong ETL experience in loading slowly changing dimensions as well as transactional and snapshot fact tables.
Proven experience with working with large datasets in the region of billions of records.
Experience on working with delta datasets and versioned history on target tables.
Solid experience in understanding ERD’s and source-to-target mappings as well as producing source-to-target mappings of solutions.
Strong SQL query writing ability (across database environments eg Oracle, Postgres etc) with a firm understanding of analytical functions.
Good understanding of ODS, data warehouse, data mart, cube, and database technologies.
Other skills required -
Awards & Certifications -
We define the role level as below -
Employment type -