Strong in writing complex queries.
· Exp in Query Optimization & Performance tuning (Redshift/
· Exp in S3 bucket or other tool, EC2, RedShift DB
· Good Knowledge on EMR, Data Pipeline.
· Strong Experience in SQL.
· Should have experience in UNIX scripting.
· Good to have knowledge of Hadoop ecosystem e.g.Spark, Python, Scala, Hbase, Hive(will be added advantages)
· Hands on experience with any RDBMS solution (Oracle, SQL Server, D2)
· Hand on experience with RDBMS based analytical data warehouses
· Experience with Financial Services transactional systems and analytical systems with P&C Insurance preferred.