Click here to join our community of experts to get information on job search, salaries and more.

AMISEQ

Bi- Sql/plsql Developer

Company: AMISEQ

Location: San Jose, CA

Posted on: October 09

Job Description:

  • The candidate should be result-oriented, self-starter and self-motivated who can manage multiple time-sensitive assignments.
  • Should have expert data modeling 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.
  • Experience with source systems like salesforce (SOQL), NetSuite or any other CRM is a plus.
  • 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.
  • Requirements
  • 7-10 years of experience with Database Development using Packages/Stored Procedures/Triggers in SQL and PLSQL
  • 7-10 years of experience in Dimensional Modeling, Star and Snowflake Schemas design and maintaining dimensions using Slowly Changing Dimensions(SCD)
  • 7+ years of 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 Team working skills.