Responsibilities
- Designing, developing, implementing, and maintaining a data warehouse to collate and integrate current/historical data from various sources/systems within an organization
- Implementing procedures for maintenance, monitoring, backup, and recovery for the data warehouse and related systems
- Expertise in Dimensional Modelling (using Star / Snowflake schema) and drafting High Level and Low Level DWH Design
- Conducting research into new data warehouse applications and determining viability for adoption
- Gathering and analysing data requirements and data flows to other systems
- Developing physical data models to define the database structure
- Optimizing database & ETL performance through efficient Performance Tuning techniques
- Expertise in ODI development (in BIAPPS Environment) & performance tuning of SQL programs.
- Developing data architecture and logical and physical data models
- Developing strategies for data acquisition, archive recovery, and database implementation
- Experience of automating various ETL jobs, failure notification etc
- Managing data migrations/conversions and troubleshooting data processing issues
- Expertise in Data warehousing concepts like SCDs, Dimensional Modelling, Archive strategy, Aggregation, Hierarchy etc and Database concepts like Partitioning, Materialized views etc
- Preparing data verification and testing methods for data/applications loaded into the warehouse to ensure compatibility across different sources
Tech Stack
ODI, SQL, PL/SQL, Java, SSIS, Informatica, Synapse, Oracle BI Tool stack, BIAPPS, Dimensional Modelling, Star schema, Snowflake schema, SCDs, Partitioning, Materialized views
Additional Information
- Ready to work in 24*7 environments
