Detailed Job Description
Design, implement, and support data warehouse infrastructure using Oracle and AWS (Redshift) technologies.
Create ETLs to take data from various operational systems and create a unified dimensional or star schema data model for analytics and reporting
Use business intelligence and visualization software (e.g., OBIEE, Micro Strategy, etc.) to empower non-technical, internal customers to drive their own analytics and reporting
Develop a deep understanding of our vast data sources and know exactly how, when, and which data to use to solve particular business problems.
Monitor and maintain database security and database software
Support the development of performance dashboards that encompass key metrics to be reviewed with senior leadership and sales management
Work with Product Managers, Business Analysts, and a growing global team to help in analyzing data and derive new insights that drive Amazons consumer marketing global success.
Manage numerous requests concurrently and strategically, prioritizing when necessary
Bachelor’s degree in Computer Science Engineering or related technical field
3+ years of relevant experience with ETL, data modeling, and business intelligence architectures
3+ years’ experience in relational database concepts with a solid knowledge of star schema, Oracle, SQL, PL/SQL, SQL Tuning, OLAP, Big Data technologies
Experience building self-service reporting solutions using business intelligence software (e.g., OBIEE, Tableau Server, Micro Strategy etc.).
Experience with Big Data solutions: Hadoop, Pig/Hive or other frameworks
Exceptional troubleshooting and problem-solving abilities.
Excellent written and verbal communications skills.
Demonstrated ability to work effectively across various internal organizations.
AWS Experience
Experience working with Apache Spark

Other Skills
Excellent written and verbal communications skills.,

Excellent written and verbal communications skills, Oracle, SQL, PL/SQL, SQL Tuning, OLAP, ,

Interview Information
Job Location : Bangalore
Interview Location : Bangalore