Manager ODI Developer

Job Description

Role Overview:At PwC, as a member of the data and analytics team, you will focus on utilizing data to drive insights and support clients in making informed business decisions. Your role will involve leveraging advanced analytics techniques to help clients optimize their operations and achieve strategic goals. In business intelligence, you will be responsible for using data and analytics to provide strategic insights and facilitate informed decision-making for clients. Your innovative solutions will play a crucial role in enhancing business performance and competitive advantage.Key Responsibilities:- Designing and implementing ELT architecture for building data warehouses, including source-to-staging and staging-to-target mapping design- Configuring Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Mappings, Scenarios, Load plans, and Metadata- Creating database connections, physical and logical schema using the Topology Manager- Developing packages, constructing data warehouses and data marts, and ensuring synchronization using ODI- Architecting data-related solutions, developing data warehouses, ELT/ETL jobs, and identifying bottlenecks in the process flow- Utilizing Dimensional Data modeling, Star Schema modeling, Snow-Flake modeling, Normalization, Fact and Dimensions Tables, Physical and Logical Data Modeling- Demonstrating strong Oracle SQL expertise, particularly using tools like SQL Developer- Having knowledge of Oracle cloud services and Database options- Understanding ERP modules is an added advantageQualifications Required:- Education: B.Tech / M.Tech / MBA / MCA- Mandatory Skill Sets: Oracle Data Integrator (ODI)- Preferred Skill Sets: Oracle Data Integrator (ODI), Oracle Analytics Cloud (OAC)- Years of Experience Required: 7 - 10Additional Company Details:At PwC, you will join a vibrant community that prioritizes trust and delivers distinctive outcomes for clients and communities. The purpose-led and values-driven work, coupled with technological advancements fostering innovation, will empower you to create a tangible impact in the real world. PwC acknowledges and promotes equal employment opportunities without discrimination based on various factors. The firm strives to provide an inclusive environment where every individual can contribute authentically and grow personally and professionally. PwC maintains zero tolerance for discrimination and harassment, aiming to foster a culture of diversity and respect. Role Overview:At PwC, as a member of the data and analytics team, you will focus on utilizing data to drive insights and support clients in making informed business decisions. Your role will involve leveraging advanced analytics techniques to help clients optimize their operations and achieve strategic goals. In business intelligence, you will be responsible for using data and analytics to provide strategic insights and facilitate informed decision-making for clients. Your innovative solutions will play a crucial role in enhancing business performance and competitive advantage.Key Responsibilities:- Designing and implementing ELT architecture for building data warehouses, including source-to-staging and staging-to-target mapping design- Configuring Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Mappings, Scenarios, Load plans, and Metadata- Creating database connections, physical and logical schema using the Topology Manager- Developing packages, constructing data warehouses and data marts, and ensuring synchronization using ODI- Architecting data-related solutions, developing data warehouses, ELT/ETL jobs, and identifying bottlenecks in the process flow- Utilizing Dimensional Data modeling, Star Schema modeling, Snow-Flake modeling, Normalization, Fact and Dimensions Tables, Physical and Logical Data Modeling- Demonstrating strong Oracle SQL expertise, particularly using tools like SQL Developer- Having knowledge of Oracle cloud services and Database options- Understanding ERP modules is an added advantageQualifications Required:- Education: B.Tech / M.Tech / MBA / MCA- Mandatory Skill Sets: Oracle Data Integrator (ODI)- Preferred Skill Sets: Oracle Data Integrator (ODI), Oracle Analytics Cloud (OAC)- Years of Experience Required: 7 - 10Additional Company Details:At PwC, you will join a vibrant community that prioritizes trust and delivers distinctive outcomes for clients and communities. The purpose-led and values-driven work, coupled with technological advancements fostering innovation, will empower you to create a tangible impact in the real world. PwC acknowledges and promotes equal employment opportunities without discrimination based on various factors. The firm strives to provide an inclusive environment where every individual can contribute authentically and grow personally and professionally. PwC maintains zero tolerance for discriminati

Keyskills :
Business Case DevelopmentCommunicationCompetitive AdvantageContinuous Process ImprovementCreativityData ArchitectureData CollectionData QualityData ScienceData VisualizationOracle Data Integrator ODIAccepting FeedbackActive ListeningAnalytica