This job opening is for TSETMC Business Intelligence and Data Mining department. This department provides trusted and integrated information for Iran capital market institutions. For this position, the anticipated candidate is going to be responsible for the role of a data warehouse developer. The candidate will be responsible for:o Develop, implement, and maintain data models and database designs for data warehouseso Extract, transform & load into dimension model structures of EDW & data martso Performance improvement & tuning of mappings, SQL & PL/SQL scriptso Technical reviews, Data validation & end to end testing of ETL Objects, Source data analysis and data profiling.o Understand business requirements and convert them into detail technical specificationso Design and Develop ETL programs primarily using Oracle ETL tools, PL/SQL, Unix Shell Scripts
o Relevant data warehouse development and data warehouse architecture experience
o Experience in working with Enterprise Data Warehouse Frameworks, and direct experience with BI or DW projects
o Understanding of methodologies and techniques for designing data integration, conversion, aggregation, standardization and validation in Enterprise Data Warehouse solutions
o Strong data analysis and data profiling skills, as well as knowledge of principles, techniques, and best practices of enterprise data modelling and dimensional data modelling
o Experience in Relational Databases (preferably with Oracle) including database design and SQL coding skills.
o Experience in ETL tools (preferably with OWB/ODI) with an ability to develop ETL design specifications and troubleshoot ETL issues
o Hands on experience with database Performance tuning, and strong database languages like SQL, PL/SQL, Unix Shell Scripting
o Good Experience in tuning of ETL mappings and Database scripts and procedures
o Strong organizational, collaboration and relationship-building skills
o Ability to multi-task and function efficiently in a fast-paced environment
o Ability to function as a self-starter
o Financial services industry domain knowledge
o Experience in analytics and large data processing and data volume optimizations