Skip to main content

Beta Help us improve the Digital Marketplace - send your feedback

Cognizant Worldwide Limited

Cognizant Data Integration and ETL Testing Services

Cognizant's Data Integration and ETL Testing Services provide a comprehensive solution with easy-to-use methods to test high-volume, data-centric information management applications on the cloud. A best practice layer based testing solution is tightly integrated with automation testing tools catering to new data integration setup and migration programs.

Features

  • Validation of data extraction process
  • Support in validating the ETL jobs developed for the project
  • Validation of source fields, field consistency, naming standards etc.
  • Validation of source reliability, completeness, and quality
  • Perform data aggregation checks
  • Support in validating system history and daily data loads
  • Validation of Transformation scripts aligned to functional specifications
  • Data load frequency validation, ETL scripts scheduling, load-dependency checks, etc
  • Validation of target properties including views, triggers, and stored procedures
  • Validation of DI and ETL processes for performance

Benefits

  • Ensure all data are successfully loaded from source to target
  • Confirm successful execution by analyzing the audit logs
  • Prove that all data loaded is correct and consistent
  • Ensure the quality of data is maintained
  • Aggregation rules and lookups are confirmed against the transformation logic
  • Ensure data retention and system updates are happening correctly
  • Ensure that data are loaded as per business rules.
  • Proves the data will be available on-time for the business
  • Helps to maintain data integrity in the target application
  • Ensure that data volumes are loaded to time and quality

Pricing

£415 to £1,500 a unit a day

  • Education pricing available

Service documents

Request an accessible format
If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at inquiryPSandHealth@cognizant.com. Tell them what format you need. It will help if you say what assistive technology you use.

Framework

G-Cloud 14

Service ID

1 8 9 2 9 5 6 6 1 6 6 0 6 7 8

Contact

Cognizant Worldwide Limited Frank Mcdade
Telephone: +44 (0) 7711 588 127
Email: inquiryPSandHealth@cognizant.com

Planning

Planning service
No

Training

Training service provided
No

Setup and migration

Setup or migration service available
No

Quality assurance and performance testing

Quality assurance and performance testing service
Yes
How the quality assurance and performance testing works
Our testing services enable rapid validation of your data integration and ETL setup and migration.
The service covers both Quality Assurance and Performance Testing. Where applicable testing automation is employed to ensure rapid and repeatable test outcomes. The service is technology agnostic and supports all major ETL and Integration tools on the market.
The services are normally provided on a T&M basis.

Security testing

Security services
Yes
Security services type
  • Security strategy
  • Security risk management
  • Security design
  • Cyber security consultancy
  • Security testing
  • Security incident management
  • Security audit services
Certified security testers
Yes
Security testing certifications
  • GBEST
  • CREST
  • Tigerscheme
  • Cyber Scheme
  • Other
Other security testing certifications
Certified Ethical Hacker (CEH)

Ongoing support

Ongoing support service
No

Service scope

Service constraints
None

User support

Email or online ticketing support
No
Phone support
No
Web chat support
No
Support levels
This service is normally project driven and therefore all support costs will be factored into the project estimate.

Resellers

Supplier type
Not a reseller

Staff security

Staff security clearance
Conforms to BS7858:2019
Government security clearance
Up to Developed Vetting (DV)

Standards and certifications

ISO/IEC 27001 certification
Yes
Who accredited the ISO/IEC 27001
DNV Business Assurance
ISO/IEC 27001 accreditation date
02/07/2021
What the ISO/IEC 27001 doesn’t cover
Certain locations of Cognizant are not in scope of the certification
ISO 28000:2007 certification
No
CSA STAR certification
No
PCI certification
No
Cyber essentials
No
Cyber essentials plus
Yes
Other security certifications
Yes
Any other security certifications
ISO 22301 – Business Continuity Management System

Social Value

Social Value

Social Value

Fighting climate change

Fighting climate change

OUR SOCIAL VALUE COMMITMENT
We support and deliver across all identified areas of Social Value. We have provided the below as an example for Fighting Climate Change.
Our Social Value typically has two components:
1-Reducing the greenhouse gas emissions of clients’ in house software development/support teams.
2-Training technical teams in ways of working that reduce GHG emissions.
Below is dependent on the size/scope/length of the engagement:
ACTIONS WE WILL UNDERTAKE
• We typically start with a one-day workshop to 1) Define what sustainability is in terms of software development/support. 2) Agree what can be measured, monitored and improved. 3) Produce a comprehensive Social Value Plan outlining our actions.
• We use Cognizant's Carbon Footprint Calculator to measure and report on the IT team’s baseline emissions, using energy as a proxy. This data drives action planning and progress tracking.
• If appropriate, our specialists conduct in-depth assessments of existing services/ways of working and identify areas where environmental impacts can be reduced. This process aligns with the Greenhouse Gas Protocol Product Standard and ISO/IEC 21030 standards for software measurement. We will assess ideas such as 1) cloud migration (eg optimised scalability). 2) Cloud native design (eg microservices and containers). 3) Green software design (eg code that minimises resource usage)
• If appropriate, we host workshops to discuss findings and agree changes in ways-of-working.
SUSTAINABILITY PRINCIPLES
We typically run sprints to test changes and measure improvements. We agree ways to integrate these techniques into business as usual.
EMBEDDING THE PRINCIPLES
We train client’s staff in the new ways of working by a blend of joint working, training sessions, and an on-line Sustainability Guide which will cover best practices for sustainable design, development, and operations. We periodically meet with the client to encourage continuous improvement through a blend of refresh training and challenge.

Pricing

Price
£415 to £1,500 a unit a day
Discount for educational organisations
Yes

Service documents

Request an accessible format
If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at inquiryPSandHealth@cognizant.com. Tell them what format you need. It will help if you say what assistive technology you use.