Skills and Knowledge
•Strong DB Skills
•Proficient in writing complex SQLs by incorporating Joins, Aggregations, Common Table expressions, Analytical functions etc.
•Proficient in database performance tuning including indexing, partitioning, analyzing SQL plans etc.
•Experience with SQL database programming, SQL performance tuning, relational model analysis, queries, stored procedures, views, functions and triggers
•Demonstrate strong and hands-on experience and background in database principles and concepts
•Solid understanding of data modeling, data warehousing principles, best practices
•Hands-on experience in writing and understanding stored procedures / packages / Functions
•Atleast 5 years of hands-on experience with at least one of the databases including Postgres, Oracle, DB2, Sybase etc.
•Experience with ETL tools preferably Informatica
•Knowledge in developing UNIX scripts
•Strong experience with Agile/SCRUM methodology
•Strong technical experience in Design (Mapping specifications, HLD, LLD), Development (Coding, Unit testing) using .