Analyse reporting requirements to determine development methods, development templates, and to determine job scheduling.
Work in an environment tasked to build a data warehouse using complex transformations that come from different systems.
Develop ETL jobs primarily in Data Stage, that satisfy identified business process and data models.
Troubleshoot and help improve existing ETL jobs.
Follow set standards and best practices in ETL development. Refactor existing jobs that do not follow set standards.
Provide guidance in some Data Stage administration tasks such as scheduling jobs, troubleshooting job errors, identifying issues in unusually long running jobs, etc.
Work with other development units in improving best practices in ETL development
Monitor loads and troubleshoot any issues that may arise.
Maintain technical support documentation.
Requirements
Must possess a good understanding of business requirements and IT strategies. Ability to work independently, but must a team player
Full life-cycle experience on large/complex enterprise software development projects.
Hands on experience in ETL Design, Development & Build.
Experience in project life cycle activities on DW/BI (Data warehouse and Business Intelligence) development and maintenance projects.
Experience in developing best practices, unit testing and developer code reviews.
Understanding of Unix/Linux system, files systems, shell scripting.
Understanding of databases/ data marts/data warehouses and complex SQL. Experience with databases - Oracle (11gR2/12c) or Microsoft SQL Server, MySQL.
Strong written and verbal communication skills including the ability to express ideas concisely and clearly to both technical and non-technical audiences.
Good problem solving and analytical skills used to resolve technical problems.