BI / Database Developer

Requirements :
Experience with Database Development using Packages/Stored Procedures/Triggers in SQL and PLSQL
Experience in Dimensional Modelling, Star and Snowflake Schemas design and maintaining dimensions using Slowly Changing Dimensions(SCD)
Experience in SQL performance tuning and optimization techniques Ability to work on on ad-hoc requests and should be able to work on simultaneous projects or tasks
Effective and positive communication and teamwork skills.

Job Description:
The candidate should be result-oriented, self-starter and self-motivated who can manage multiple time-sensitive assignments.
Should have expert data modelling skills including conceptual, logical and physical model design.
The candidate should be able to participate in the development of Business Intelligence solutions to meet the needs of the Commercial Organizations (Finance, CRM, Sales, Sales Operations, Marketing)
Evaluate business requirements, conduct a POC and proactively call out data anomalies within the source system.
Perform end to end data validation for a solution ensuring quality data delivery.
Develop/performance tune complex SQL (PL/SQL and/or T-SQL) queries and stored procedures.
Should be well versed with project tracking tools like Jira and Github.
Able to batch processes using any scripting language like pearl, Unix or python.
Candidate should be able to create strategic design and mapping of business requirements to system/technical requirements.
Candidate should be able to communicate, translate, and simplify business requirements to ensure buy-in from all stakeholders.