Senior ETL Tester at Cognizant in El Dorado Hills, California

Job Description:

We are Cognizant Artificial Intelligence

Digital technologies, including analytics and AI, give companies a once-in-a-generation opportunity to perform orders of magnitude better than ever before. But clients need new business models built from analyzing customers and business operations at every angle to really understand them.

With the power to apply artificial intelligence and data science to business decisions via enterprise data management solutions, we help leading companies prototype, refine, validate and scale the most desirable products and delivery models to enterprise scale within weeks

*You must be legally authorized to work in the United States without the need for employer sponsorship, now or at any time in the future *

Job Title – Senior ETL Tester

Location – El Dorado Hills, California (Remote until COVID)

Roles/Responsibilities:

• Bachelor’s degree in Computer Science or equivalent education/training.


• Should have Strong SQL Skills (any RDBMS),Data Analysis,Data Testing skills in BI/DW Environment.


• Define ETL testing process and validate business rules and policies to data and transformations including all data pipelines on Hadoop Clusters, monitoring data activities in TD, Oracle, HDFS, Hive, etc.


• Cloud QA experience on AWS/Azure or GCP; Cloud Data validation and automation experience.


• Experience in Web Services – API testing.


• Strong knowledge in Java, python programming and shell scripting.


• Analyze data for discrepancies, identify issues with data processing and communicate using the issue tracking/bug reporting system. Ensure data standards/integrity are maintained in order to deliver the highest quality products.


• Create and manage integration and regression testing framework for testing environments to implement load and performance testing techniques.


• Develop and automate integration, functional, and system test scripts.


• Develop, maintain and validate data quality standards and metrics.


• Develop and review test plans and test scripts.


• Knowledge of data flows, data architecture, ETL and processing of unstructured data.


• A solid understanding of common software development practices and tools. 


• Experience with testing real-time data-processing and Analytics Application System.


• 3 + years of experience in creating scripts/processes to automate QA, Integration and production systems and experience with automated testing in a CI environment.


• 2+ years of hands-on experience in Cloud, Hadoop, TD, and Hive in supporting Hadoop applications and testing.


• Should have Strong Communication Skills to deal with Biz Users, Dev Team & multiple Teams


• Good verbal and written communication skills.

Required Qualifications:  

• Primary Skills: "SQL & ETL Testing knowledge is Mandatory", Oracle, Teradata, Hadoop(Hive,HDFS).


• Secondary Skills: Cloud QA, Java, Python, Shell Scripting, API Testing, AWS/Azure/GCP, Automation Development Experience.