ODI Developer

Role Overview: As a Data Warehouse Developer/Analyst at ACL Digital, your main responsibility will be designing, developing, implementing, and maintaining a data warehouse to collate and integrate current/historical data from various sources/systems within the organization. You will also be in charge of designing, implementation, development, and maintenance of the Enterprise Data Warehouse. Your expertise in Datawarehouse Maintenance, ETL Development & Support, performance tuning, and dimensional modeling and design will be crucial for this role. Key Responsibilities: - Design, develop, implement, and maintain a data warehouse to collate and integrate current/historical data from various sources/systems within the organization - Implement procedures for maintenance, monitoring, backup, and recovery for the data warehouse and related systems - Demonstrate expertise in Dimensional Modelling (using Star/Snowflake schema) and drafting High Level and Low Level DWH Design - Conduct research into new data warehouse applications and determine their viability for adoption - Gather and analyze data requirements and data flows to other systems - Develop physical data models to define the database structure - Optimize database & ETL performance through efficient Performance Tuning techniques - Show expertise in ODI development (in BIAPPS Environment) & performance tuning of SQL programs - Develop data architecture and logical and physical data models - Create strategies for data acquisition, archive recovery, and database implementation - Automate various ETL jobs, failure notification, etc. - Manage data migrations/conversions and troubleshoot data processing issues - Demonstrate expertise in Data warehousing concepts like SCDs, Dimensional Modelling, Archive strategy, Aggregation, Hierarchy, etc., and Database concepts like Partitioning, Materialized views, etc. - Prepare data verification and testing methods for data/applications loaded into the warehouse to ensure compatibility across different sources Qualification Required: - B.Tech/MCA If you are interested in this Data Warehouse Developer/Analyst role at ACL Digital, please click on Apply to know more. Role Overview: As a Data Warehouse Developer/Analyst at ACL Digital, your main responsibility will be designing, developing, implementing, and maintaining a data warehouse to collate and integrate current/historical data from various sources/systems within the organization. You will also be in charge of designing, implementation, development, and maintenance of the Enterprise Data Warehouse. Your expertise in Datawarehouse Maintenance, ETL Development & Support, performance tuning, and dimensional modeling and design will be crucial for this role. Key Responsibilities: - Design, develop, implement, and maintain a data warehouse to collate and integrate current/historical data from various sources/systems within the organization - Implement procedures for maintenance, monitoring, backup, and recovery for the data warehouse and related systems - Demonstrate expertise in Dimensional Modelling (using Star/Snowflake schema) and drafting High Level and Low Level DWH Design - Conduct research into new data warehouse applications and determine their viability for adoption - Gather and analyze data requirements and data flows to other systems - Develop physical data models to define the database structure - Optimize database & ETL performance through efficient Performance Tuning techniques - Show expertise in ODI development (in BIAPPS Environment) & performance tuning of SQL programs - Develop data architecture and logical and physical data models - Create strategies for data acquisition, archive recovery, and database implementation - Automate various ETL jobs, failure notification, etc. - Manage data migrations/conversions and troubleshoot data processing issues - Demonstrate expertise in Data warehousing concepts like SCDs, Dimensional Modelling, Archive strategy, Aggregation, Hierarchy, etc., and Database concepts like Partitioning, Materialized views, etc. - Prepare data verification and testing methods for data/applications loaded into the warehouse to ensure compatibility across different sources Qualification Required: - B.Tech/MCA If you are interested in this Data Warehouse Developer/Analyst role at ACL Digital, please click on Apply to know more.