Job description
i. Boss 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.