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