SQL Developer

P.S International HR Consultants

understand database design principles including normalization and aggregation for online and data warehouse schemas to support the needs of application developers.

· design, plan, and develop programs to optimally extract, transform, and load data between data sources.

· diagnose and resolve database performance issues.

· maintain developed source code in the repository for all databases and keep all build programs up to date.

· be responsible for overall development success (inclusive of peer/code reviews, adherence to corporate standards, build process guidelines, maintainability, unit tests) of the project.

· ensure appropriate and adequate unit test cases are created and enacted.

· ensure appropriate and detailed documentation for developed modules.

must to have

· min 3 - 5 years of sql development experience on mysql.

· strong knowledge of sql joins and mysql programming techniques.(view, functions, procedures etc).

· strong knowledge of database design patterns.

· strong knowledge of writing queries used for front-end reporting applications (reporting app, websites, business logics)

· review and interpret ongoing business report requirements, research data and build appropriate reporting deliverables.

· good knowledge of reporting stack like tableau, power bi, ssrs, qlikview.

· hands-on optimizing large sql statements for better reporting.

· hands-on tools to troubleshoot and profile queries to optimize.

good to have

· knowledge of code versioning tool.(ex bitbucket,github)

· sql developer certification on any of relational databases ( like mssql, oracle)

• Experience

  3 - 7 Years

• No. of Openings

  1

• Education

  B.C.A, B.E, B.Sc

• Role

  SQL Developer

• Industry Type

  IT-Hardware & Networking / IT-Software / Software Services

• Gender

  [ Male / Female ]

• Job Country

  India

• Type of Job

  Full Time

• Work Location Type

  Work from Office