Looking for Sr. WhereScape ELT Developer
Kumar Varada
Title: Sr. WhereScape ELT Developer
Location: Los Angeles, CA
Duration: 6 months plus
Must have:
Need minimum 10 years of overall IT experience.
Need 4-5 years of recent Banking industry experience.
Need 4-5 years of recent Data warehouse experience.
Job Summary:
The Senior WhereScape ELT Developer will be involved in designing & developing extract/transform/load routines, performing intensive data analysis, loading 3NF and dimensional data models, preparing design documents and participating in all phases of testing. Hands-on experience in designing and implementing data warehouses and data marts for large financial institutions. Experience leading a development team to implement high-quality solutions using ETL and ELT tools and related database technology such as DB2, Oracle.
Essential Functions:
• Responsible for design, development, implementation, and maintenance of Data Warehouse and downstream applications, system architectural direction and recommendations using Informatica ETL and WhereScape ELT technologies.
• Prepare detailed specs from which programs will be written.
• Develop complex workflows and mappings using Informatica ETL and shell scripts to satisfy the business requirements.
• Test ETL and reports of others for quality assurance, and migrating releases into testing and production environments.
• Support the UB Data Warehouse batch cycle and any required changes to the schedule.
• Assist the team by helping them in the data analysis requests, internal controls, performance tuning, etc.
• Contribute to peer code reviews for all ETL changes
• Debug and troubleshoot issues.
• Research and evaluate solutions and recommends the most efficient and cost effective solutions for the system design.
• May provide assistance or training to lower level staff
• Provides conceptual guidance to other senior and high-level technical experts.
Deliverables:
- Data warehouse design documents
- Shell scripts
- Data warehouse architecture diagrams
- ETL process documentation & implementation plan