Candidate must have 7+ years of relevant experience in PL/SQL and T-SQL coding. Experience in coding PL/SQL Procedures, Triggers and complex SQL queries. Analyze, Design and T-SQL. Create Database Views/materialized views, Indexes, Partitions.
Strong knowledge DW concepts. Ability to communicate with Business users, understand and Analyze requirements and Use Cases. Experience working in Agile Teams. Proven problem solving, communication, interpersonal and analytical skills. Ability to work both independently as well as within a team.
Core/Must have skills
Good knowledge in Data Warehouse concepts and different schema types like Star and Snowflake
Strong experience in writing complex queries, performance tuning, query optimization and debugging.
Must be proficient in writing PL/SQL procedures, triggers and packages and T-SQL.
Strong experience in writing complex queries, performance tuning, query optimization and debugging.
Experience in Agile model.
Excellent verbal and written communication skills.
State Street's Speak Up Line