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.Sc, B.Tech/B.E

Role : SQL Developer

Industry Type : IT-Hardware & Networking / IT-Software / Software Services

Gender : [ Male / Female ]

Job Country : India