Oracle Autonomous Datawarehouse- Senior

Job Description

EY-Consulting Oracle Autonomous Datawarehouse Senior ConsultantThe opportunityWe re looking for Senior Consultant with expertise in OracleAutonomous Datawarehouse & ETL to join the EA group of our consulting Team . This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering.We are seeking experienced and motivated Cloud Data Engineer with a strong track record of business analytics and data warehousing to join our team providing deep technical expertise in Data warehousing, Analytics, Business Intelligence, Essbase across all industry sectors. Our Cloud Engineers work closely with external clients, presales, other architects and internal teams to design, build and enable solutions on different cloud & BI StacksThis role demands a highly technical, extremely hands-on cloud data engineer who will work closely with our EY Partners and external clients to develop new business as well as drive other initiatives on Autonomous Data warehouse Like Oracle, Snowflake, ETL & Machine Learning. The ideal candidate must have a good understanding of the value of data and analytics and proven experience in delivering solutions to different lines of business and technical leadership. From top to bottom approach, the Cloud data Engineer will engage with a customer to discover business problems and goals, and develop solutions using different cloud services.Your key responsibilities

• Lead Oracle Autonomous Data warehouse offerings: Oracle, Snowflake, SQL, Plsql, ETL, Rest API, CLI & Python
• Identify the different data ingestion and extraction mechanism for different Autonomous Data Warehouse from cloud storage (Like Oracle Object Storage) , on premise storage and applications.
• Responsible for designing, developing and maintaining the data architecture, data models and standards for various Data Integration & Data Warehousing projects in Oracle ADWC, Snowflake, combined with other technologies
• Take ownership of technical solutions from design and architecture perspective, ensure the right direction and propose resolution to potential data pipeline-related problems.
• Model new features and subject areas and integrate them with existing structures to provide a consistent solution as well as develop and maintain documentation of the data architecture, data flows and data models.
• Deliver high quality client solutions that meet and exceed client and EY expectations and are delivered on-time and on-budget.
• Manage client solution delivery, including defining project approach, leading and motivating project teams, monitoring and managing project risks, managing client and EY key stakeholders, and successfully delivering client solutions.
• Identifying new business opportunities, including building strong client relations, understanding client needs and EY solution offerings, communicating client opportunities to EY leadership, and helping develop client opportunities.

Skills and attributes for success

• Primary focus on developing customer solutions using Integration tools and database: Oracle Data Integrator, Informatica,
• Must have hands on experience moving data to cloud databases like Oracle Autonomous Data warehouse, Oracle DBCS etc.
• Must have hands on experience extracting data from Oracle Fusion Applications, Salesforce and placing into Cloud Databases and Cloud storage devices.
• Hands-on experience with Autonomous Database utilities, such as SQL Developer Web, SQL*Loader, Data Pump, Zeppelin Notebook, SnowSQL, SnowPipe, Big Data/Machine Learning model techniques using Python and Sql
• Proficiency in data modelling, very good understanding of data management concepts, Dimensional modelling and their specific applications.
• Very good knowledge of RDBMS topics, ability to write complex SQL, PL/SQL
• Experience in requirement gathering, solution blueprint, performing fit gap analysis, Business process design.
• Experience to translate business analyst requirements into analytics metadata.
• Must have extensive hands on/end to end implementation experience using ODI/Informatica or any integration tool.
• Must have experience in designing complex integration scenarios.
• Experience in answering business scenarios and requirements through Data-marts, Aggregate tables and queries.
• Experience in scripting language like Python, R, Ruby etc

To qualify for the role, you must have

• Minimum of 2 years of experience in Autonomous Data warehouse
• Minimum of 4 years of consulting experience in DW, ETL and SQL.
• Overall 6-10 years of industry experiences with sound knowledge of Data warehousing & Data Modelling

Ideally, you ll also have

• Engaging with business partners and IT to understand requirements from various parts of an organization to drive the design, programming execution, and UAT for future state capabilities within the platform.
• Working in a fast-paced and dynamic environment while managing multiple projects and strict deadlines
• Good understanding of outsourcing and off shoring, building win/win strategies and contracts with suppliers
• Knowledge of Data Visualization tools like OBIEE, Power BI
• Knowledge of Cloud data base like Snowflake, Redshift etc
• Experience with MuleSoft or similar software, especially in conjunction with Anaplan
• Experience with Tableau or similar software, especially in conjunction with Anaplan
• Experience with Oracle Applications Oracle E-business Suite or Oracle ERP, Oracle HCM (the Oracle cloud SaaS offering)
• Integration development to/from other systems

What we look for

• Consulting experience, including assessments and implementations
• Documenting requirements and processes (e.g., process flows)
• Working collaboratively in a team environment
• Excellent oral and written communication skills
• Strong analytical and problem-solving skills
• B.E. / Master s degree required.

What working at EY offersAt EY, we re dedicated to helping our clients, from start ups to Fortune 500 companies and the work we do with them is as varied as they are.You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:

• Support, coaching and feedback from some of the most engaging colleagues around
• Opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that s right for you

About EYAs a global leader in assurance, tax, transaction and advisory services, we re using the finance products, expertise and systems we ve developed to build a better working world. That starts with a culture that believes in giving you the training, opportunities and creative freedom to make things better. Whenever you join, however long you stay, the exceptional EY experience lasts a lifetime. And with a commitment to hiring and developing the most passionate people, we ll make our ambition to be the best employer by 2020 a reality.,

Keyskills :
oracle erpfortune 500data warehousingdata managementdata modelsoracle data integratordata pumpbusiness processgap analysisdata integrationoracle fusiondata integratororacle ebusiness suite