SQL Developer

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. Good 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.