Salary Range: 130000 to 140000 (Currency: USD) (Pay period: per-year-salary)

Primary Skills

• ETL Fundamentals, HDFS, Hive, MapReduce, Modern Data Platform Fundamentals, Oozie, PLSQL, T-SQL, Stored Procedures, Python, Spark - Pyspark, Spark - Scala, SQL

Specialization

Job requirements

• Expertise in Oracle SQL and PL/SQL programming, developing complex code units.
• Expertise in creating the indexes on tables and partitioning the table for SQL tuning purpose.
• Experience in Shell Scripting is mandatory (30% shell scripting and 70% SQL)
• Expertise in writing procedures, functions, views, materialized views as required.
• Knowledge of aggregate functions; performance tuning Oracle Databases
• Convert the Business need into Technical complex queries.
• Use different strategies of database development to meet the client functional requirement.
• Knowledge on MicroStrategy or any BI reporting tool will be an Add on
• #LI-PA1 
• Equal Employment Opportunity Declaration Brillio is an equal opportunity employer to all, regardless of age, ancestry, colour, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding, and related medical conditions), and sexual orientation.