Description
ETL is developed in InformaticaPowercenter.We have multiple teams working in Agile on the same data warehouse. These teams support strategic pillars like B2C and B2B. The teams closely coordinate to keep the data warehouse consistent.
Main tasks:
- Translate business features into working software
- Design Data Model
- Develop InformaticaPowercenter Mappings
- Create and optimize Teradata database structures (tables / indexes / etc)
- Create, optimize and maintain Oracle scripting.
- Performance tuning in Powercenter and Teradata
- Work according to development standards
- Proactively improve development standards
- Proactively take actions to maximize business continuity (process cleaning, workarounds)
- Perform incident root cause analysis activities
- Advise Service operations in terms of operational stability, monitoring and other topics;
- Provide 3rd line support for production issues (solve incidents)
- Configure Informatica stack
Knowledge, Skills and Experience:
- InformaticaPowercenter (10)
- Teradata
- Oracle
- SQL
- Scripting on Linux
- Strong experience in BI
- Dimensional data modeling
- 3rd NF data modeling
- Experience in Telecommunications
- Communicate with business
- Experience with Agile