Published date Posted on Indeed on Aug 19, 2022 (39 d ago)

Test Engineer

Job Duties:

  • Ensure business requirements and system requirements are complete through partnering with Project managers and resource managers and translating them into unit tests, test cases, and other technical artifacts.
  • Establish goals and Milestones as per the desired results to be generated by the project.
  • Work with End Clients for Report Requirements and trained them for using the Reports.
  • Write Complex Queries, Stored Procedures, Views, triggers and User Defined Function in SQL Server 2008/2012.
  • Extract data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
  • Create numerous simple to complex queries involving self joins, correlated subqueries, functions, cursors, dynamic T-SQL.
  • Develop all the required Stored Procedures, user defined functions, triggers, views using T-SQL as per business logic which were used to support .net application for customers.
  • Perform ETL process extract, transform and load data from SQL Server Transactional Sources, Excel sheets, Flat files to tables using SSIS and Data Flow Transformations.
  • Plan, coordinate, develop and support ETL processes including architecting table structure, building ETL process, documentation, and long-term preparedness.
  • Design and create SSIS packages for data migration from OLTP systems to Data Warehouse.
  • Create jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
  • Perform database performance tuning of the database systems, jobs, indexes, queries and configurations.
  • Work with the development teams on projects and systems in database modeling and design, creating/tuning/optimizing indexes, stored procedures, DTS/SSIS packages and SQL jobs, as well as assisting in troubleshooting, performance tuning and general problem solving of SQL development.
  • Participate in on-call support and managing SQL Server monitors and alerts.
  • Implement T-SQL on a daily basis in creating customs view for data and business analysis.
  • Tune and optimized queries by altering database design, analyzing different query options, and indexing strategies. Optimize existing T-SQL code.
  • Analyze Execution Plans to troubleshoot potential performance issues.
  • Utilize Dynamic T-SQL within functions, stored procedures, views, and tables.
  • Documentation of steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production.
  • Troubleshoot and diagnose critical production issues and testing the workflow elements.

Job Types: Full-time, Contract

Pay: $37,761.00 - $50,000.00 per year

Schedule:

  • 8 hour shift
  • Monday to Friday

Experience:

  • SQL: 1 year (Preferred)
  • Selenium: 1 year (Preferred)
  • Test automation: 1 year (Preferred)

Work Location: Remote

Speak with the employer
+91 9000057033


Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

As an Engineering Product Manager III at CH Robinson, you will use your passion for technology and experience translating internal and external customer requirements into solutions for our Execution Capability team. As a part of the Execution team,.

Job Description:Provide ERP subject matter expertise and implementation support.Participate in work sessions with functional teams.Supports O&M functionality and researches and resolves incidents in priority orderConducts troubleshooting for technical.

ABOUT THIS JOB:Data and Analytics Engineering - Platform team is critical to making our organization's data strategy successful. You will play a key role in architecting and engineering modern, adaptive, data-driven, and secure platforms and processes.

American Electric Power American Electric Power |
7 d ago

Job Description:Information TechnologyThis is for AEP (American Electric Power) Commercial Operations. The ideal candidate will have will have experience in all phases of software development: gathering user requirements, making architecture decisions,.

INTO University Partnerships North America INTO University Partnerships... |
21 d ago

Company BackgroundINTO University Partnerships collaborates with leading universities to provide international students with a personalized and highly supportive learning environment in which to acclimate to life on a US university campus and prepare.