iBoss Tech Solution Private
Limited

Job
Description: SQL Developer

About Company:

Established
Software Development and Consulting service provider delivering
business -critical applications on web, mobile and cloud platforms.
Best -in -class delivery centers with proven experience of providing solutions
across SME's to Fortune 500 companies.

Department: - EAS / ECOM Team

Open positions – 1

Gender – Male

Current Location - Noida

Employment Type - Full Time

Working Hours - Rotational

Exp - Minimum – 2 Years

Qualification: - B -Tech / MCA

Notice Period -

Budget –

Communication
Skills

Good
/ Excellent

Interpersonal
Skills

Self -motivated -
Mid to High

Confident -
Mid to High

Leadership -
Mid to High

Problem
Solving, Logical, Analytical Skills

Problem
Solving – Mid to High
Logical Ability: Mid to High

Analytical
– Mid to High

Must
Have Skills

Excellent
knowledge of PL/SQL.

Excellent
knowledge of joins, stored procedures and Trigger / Indexes.

Excellent
knowledge of writing functions / Stored procedure.

Excellent
knowledge of Postgres / SQL Server.

Experience
in creating and maintaining SSIS and SSRS packages

Exposure
to AWS Glue for ETL development.

Understand
Complex architecture and database structure.

Good
to Have

Exposure
to Apache Airflow ETL development.

Positive to have Power BI.

Good to have SSAS

Duties and Responsibilities

· Candidates
require to work closely with US Client.

· Model,
develop, and implement transactional, ETL staging, and analysis/reporting
databases, data structures, and cubes to satisfy business and technical
requirements.

· Develop
enterprise level ETL processes that include process logging, data validation,
and data integrity checks.

· Automate
complex processes using SQL agent jobs, SQL Server Integration Services, etc.

· Ensure
accuracy and integrity of data through the development of constraints and
validation rules.

· Manage
and write complex SQL queries.

· Manage
SQL code in a source control system.

· Establish
and enforce SQL development coding standards and best practices.
Lead/participate in SQL code reviews.

· Stay
current with database/reporting/Microsoft SQL Server tools and technologies and
the direction of the general database industry.

· Additional
duties as assigned.