- Develop and tune ETL mappings and sessions
- Code and document scripts and stored procedures for data warehousing processes
- Performance and tuning of ETL tool for parallel loads and cache optimization
- Document ETL processing systems.
- Manage Informatica Metadata repository and Folders shared by multiple teams.
|
- 2 years experience with the design, development, and implementation of data warehouses
- 1 year experience developing with Informatica ETL tool (v7.x)
- 5 years relational database experience (Oracle)
- Solid understanding of data warehousing concepts
- Strong understanding of OLTP and dimensional modeling
- Experience optimizing large data loads
- Strong UNIX-Solaris scripting experience to support data warehousing tasks
- Strong SQL programming and stored procedure development skills
- Proven teamwork, and communication skills
|
