SQL & Bi Developer
- Vantive
- 7 to 12 Yrs
- Noida, Gurugram
- 4 years ago
- Email to a friend
- Report this job
Job Description
SQL/Database Developer
Summary/Objective Responsible for designing, implementing, and maintaining data warehouses, consulting on front-end database designs, building and analyzing reports. The SQL/Database Developer will also assist in post implementation support and enhancements. Requires expert work experience in SQL/Database Development, Report generation & Analysis.
Essential Duties and Responsibilities
Develop SQL code to meet the needs of the business in pre-processing & post-processing of data, reporting, and other call-center services related functions.
Work closely with cross-functional project implementation teams and others, serving as a technical developer and working to design, develop, test, and implement database solutions.
Design data warehouses, data marts, and metadata Develop the semantic layer, reports, and report definitions Perform testing and quality assurance on all development Produce ETL design guidelines to ensure a manageable ETL infrastructure for the system.
Monitor SQL job performances and report/cube refreshes to ensure results are delivered correctly and according to schedule
Document system problems and resolutions for future reference Write clear and concise system documentation
Participate in regular process and/or code reviews to ensure they meet enterprise security and coding & documentations standards.
Contribute to team projects to design a technical solution or application to assist with business cases Coordinate with team on work assignments and project scheduling.
Collaborate with team on the long-term technology roadmap, ensuring alignment with business goals and positioning the business to meet its growth objectives.
Plan activities and report on the progress of assigned projects or tasks.
Knowledge of Database Administration (DBA) would be an added advantage. Perform other related duties as assigned.
Knowledge, Skills and Abilities
Problem analysis & solution development with exceptional analytical ability
Excellent knowledge of SQL - Code design, development, and Testing for MS SQL Server
Report Generation, Analysis & Documentation
Designing ETL packages, databases and ensuring their stability, reliability, and performance
Proficiency with SQL and hands on experience in procedures, function, and performance tuning.
Knowledge of programming discipline, design methods, and documentation techniques Knowledge of best practices when dealing with relational database.
Capable of troubleshooting common database issues
Understanding of potential blocking, deadlocking and write code to avoid those situations
Understanding of security issues such as SQL injection while writing code Knowledge of programming discipline, design methods, and documentation techniques
Experience in ETL development Expert knowledge of SSIS and SSRS
Working experience of Database administration will be given preferences.
Bachelors degree or equivalent combination of training/certifications and experience.
Job Responsibilities/Availability
SQL/Database Developer will be required for having 7+ years of work experience in the same field with desirable knowledge of SQL/Database development. Person will be required to work in flexible/global time zone (preferably USA). Job responsibility will include his/her availability as per business requirements i.e. it is expected to manage time and responsibility effectively.
Employement Category:
Employement Type: Full timeIndustry: BPO / Call CenterRole Category: Application Programming / MaintenanceFunctional Area: Not ApplicableRole/Responsibilies: SQL & Bi DeveloperContact Details:
Company: Avantive SolutionsLocation(s): Noida, Gurugram
Similar positions
Vantive
Avantive Solutions is a purpose-driven, global technology and business services organization. We specialize in the delivery of innovative customer engagement, strategic sales, and digital marketing solutions.Founded in 1988, our spirited, intelligent, and engaged employees operate in North America...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in