Cognizant Technology Solutions logo

ETL Testing Lead/Data Analysis Specialist

Cognizant Technology Solutions·$115,000 – $120,000

Primary stack

PostmanAWS CloudWatchAWSAirflowAPI TestingETLSQL

Nice to have's

Cloud-based data lakesData governanceTest automation frameworksHealthcare data standardsBig data technologiesLarge-scale enterprise data transformation programs

Job description

About the Position

ETL Testing Lead/Data Analysis Specialist

Cognizant is seeking an experienced ETL Testing Lead / Data Analysis Specialist to join our Quality Engineering and Assurance team. This role is responsible for leading data validation initiatives, ensuring data quality, and supporting enterprise data transformation programs within complex cloud and data warehouse environments.

The ideal candidate will possess strong expertise in ETL testing, data quality engineering, and data analysis, with hands-on experience validating large-scale data pipelines and cloud-based data platforms. This individual will collaborate closely with business stakeholders, developers, architects, and quality engineering teams to ensure high-quality, reliable, and accurate data solutions.

Healthcare industry experience is required for this role.


Responsibilities

ETL Testing & Data Validation

  • Lead end-to-end ETL testing activities across enterprise data integration programs.
  • Validate source-to-target data mappings and transformation logic across complex data platforms.
  • Design, develop, and execute ETL test strategies, test cases, test scripts, and validation processes.
  • Verify data movement, transformation accuracy, completeness, and consistency across systems.
  • Conduct regression, integration, system, and user acceptance testing for data initiatives.
  • Identify, document, track, and resolve data-related defects and production issues.

Data Analysis & Quality Engineering

  • Analyze large and complex datasets to identify trends, anomalies, patterns, and business insights.
  • Perform data profiling, data reconciliation, and root cause analysis to support quality initiatives.
  • Validate business rules and data transformation requirements to ensure accurate processing.
  • Drive data quality improvements and support enterprise data governance initiatives.
  • Execute data cleansing and validation activities to improve data integrity and accuracy.
  • Collaborate with stakeholders to define and implement data quality standards and metrics.

SQL Development & Query Analysis

  • Develop, optimize, and maintain complex SQL queries for testing and analysis activities.
  • Create data validation scripts and automated validation processes where appropriate.
  • Support ongoing analysis of data quality issues and performance optimization opportunities.
  • Conduct source-to-target reconciliations across multiple databases and cloud environments.

Cloud & Data Platform Testing

  • Validate data pipelines and workflows across cloud-based architectures.
  • Support testing activities involving AWS services and enterprise data platforms.
  • Verify data integrations between cloud systems, APIs, and downstream applications.
  • Monitor and assess data movement processes to ensure operational stability.

Stakeholder Collaboration

  • Work closely with business analysts, data engineers, developers, architects, and product owners.
  • Participate in requirements reviews and contribute to test strategy development.
  • Provide testing status updates, risk assessments, and quality metrics to project stakeholders.
  • Support defect triage sessions and help drive issue resolution efforts.

Continuous Improvement

  • Recommend improvements to ETL testing processes, automation approaches, and quality assurance practices.
  • Identify opportunities to increase testing efficiency and improve data quality outcomes.
  • Mentor junior team members on data validation, ETL testing, and quality engineering best practices.
  • Contribute to the development of reusable testing frameworks and accelerators.

Requirements

  • Bachelor's degree in Computer Science, Information Systems, Engineering, Data Analytics, or a related field, or equivalent work experience.
  • 10+ years of experience in:
    • ETL Testing
    • Data Testing
    • Data Quality Validation
    • Data Analysis
  • Strong hands-on experience with:
    • SQL
    • ICEDQ
    • AWS S3
    • BMC
    • Informatica CDI-PC
    • Informatica Intelligent Cloud Services (IICS)
    • PySpark
    • API Testing
    • Postman
    • SAS
    • AWS Athena
    • Apache Airflow
    • AWS CloudWatch
  • Strong experience performing source-to-target data validation and reconciliation.
  • Expertise in data quality engineering and data management best practices.
  • Strong analytical, troubleshooting, and problem-solving capabilities.
  • Excellent verbal and written communication skills.
  • Experience working in Agile delivery environments.
  • Healthcare industry experience.

Nice to Have

  • Experience with cloud-based data lakes and modern data warehouse architectures.
  • Knowledge of data governance and master data management concepts.
  • Experience with test automation frameworks for data validation.
  • Familiarity with healthcare data standards and regulatory requirements.
  • Exposure to big data technologies and distributed data processing frameworks.
  • Experience working in large-scale enterprise data transformation programs.

We Offer

  • Annual Salary: Between $115,000 and $120,000 USD, depending on experience, qualifications, geographic location, skills, and other factors permitted by law.
  • Additional Compensation:
    • Annual performance-based bonus
    • Merit-based compensation increases
    • Employee referral bonuses, where applicable

Benefits:

  • Medical, Dental, and Vision Insurance
  • Health Savings Account (HSA) and Flexible Spending Accounts (FSA)
  • Life Insurance and AD&D Coverage
  • Short-Term and Long-Term Disability Insurance
  • Paid Time Off (PTO) and Company Holidays
  • 401(k) Plan with Company Contributions (subject to eligibility)
  • Employee Stock Purchase Plan (where available)
  • Employee Assistance Program (EAP)
  • Parental Leave and Family Care Benefits
  • Tuition Reimbursement and Professional Development Programs
  • Access to Learning, Certification, and Career Development Opportunities

Benefits are subject to eligibility requirements and plan terms.


About the Company

Cognizant (NASDAQ: CTSH) is one of the world's leading professional services companies, helping clients modernize technology, reimagine processes, and transform experiences. We engineer modern businesses to improve everyday life. Our associates around the globe help clients build stronger, more agile, and innovative organizations.

At Cognizant, we help clients unlock the value of data through advanced analytics, cloud transformation, data modernization, and quality engineering solutions. We are committed to delivering innovative, scalable, and data-driven solutions that empower organizations to make better business decisions and improve outcomes.


Equal Opportunity Employer

Cognizant is an equal opportunity employer. We are committed to fostering an inclusive workplace where all associates feel valued, respected, and empowered to contribute their unique perspectives. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, national origin, disability, protected veteran status, or any other characteristic protected by applicable law.

Applications will be accepted until the position is filled.


About Cognizant

Cognizant (NASDAQ: CTSH) é uma construtora de IA e fornecedora de serviços de tecnologia, criando a ponte entre o investimento em IA e o valor para as empresas por meio do desenvolvimento de soluções de IA completas para nossos clientes. Nossa profunda experiência em setores, processos e engenharia nos permite incorporar o contexto único de cada organização em sistemas tecnológicos que potencializam a capacidade humana, geram resultados tangíveis e mantêm empresas globais à frente em um mundo em rápida transformação. Saiba mais em cognizant.ai ou @cognizant.

A Cognizant é uma empregadora que investe em equidade. Sua candidatura não será pautada em raça, cor, gênero, sexualidade, credo, origem, deficiência, gravidez ou qualquer outra característica protegida pelas leis brasileiras.

Informações adicionais de emprego

Os candidatos podem ser obrigados a comparecer a entrevistas presenciais ou por videoconferência. Além disso, os candidatos podem ser obrigados a apresentar seu documento de identificação emitido pelo estado ou governo atual durante cada entrevista.

Embora nosso sistema permita a candidatura em todos os idiomas, o(s) idioma(s) e o(s) nível(is) de proficiência exigidos para o trabalho variam. No entanto, é necessário um nível básico de inglês para fins de comunicação em toda a empresa.

A Cognizant é uma empregadora que investe em equidade. Sua candidatura não será pautada em raça, cor, gênero, sexualidade, credo, origem, deficiência, gravidez ou qualquer outra característica protegida pelas leis brasileiras.

Se você tem uma deficiência que requer adaptações razoáveis para procurar uma vaga de emprego ou enviar uma candidatura, envie um e-mail para [email protected] com sua solicitação e informações de contato.


Benefícios que ajudam a crescer e brilhar

Nosso programa de benefícios é construído pensando em você: para que você aproveite uma vida balanceada, saudável e plena.

Bem-estar financeiro

Nós revisamos regularmente os dados de mercado para garantir que a remuneração reflita o valor que você entrega. Seus benefícios vão além do salário e podem incluir planos de aposentadoria, educação financeira e outros recursos.

Saúde física e mental

Queremos que você priorize o seu bem-estar, oferecendo benefícios como férias remuneradas, trabalho flexível quando possível, planos de saúde, apoio psicológico, nosso programa de apoio à saúde mental (Mental Health Allyship) e muito mais.

Sua carreira, do seu jeito

Com mais de 350.000 oportunidades na Cognizant, você terá a possibilidade de explorar novas tecnologias, setores e localizações - e desenvolver as competências necessárias para evoluir na sua carreira.

Impacto no mundo real

Pense nas maiores marcas que você utiliza no seu dia a dia. É muito provável que elas contem com a nossa ajuda para fortalecer seus negócios. Aqui, você irá transformar ideias ousadas em soluções que melhoram a vida das pessoas em todo o mundo.


Seu caminho até a Cognizant

Veja o que você pode esperar do nosso processo seletivo. Lembre-se de que ele pode variar de acordo com a vaga e a localização. Explore nossas perguntas frequentes para saber mais.

Etapa 1: Candidate-se à oportunidade certa

Encontre uma vaga em aberto que esteja alinhada às suas habilidades e objetivos de carreira e mostre por que você é a pessoa certa para essa oportunidade. Não encontrou a vaga ideal? Considere se juntar à nossa Talent Community.

Etapa 2: Conecte-se com o recrutador

Se um de nossos recrutadores identificar compatibilidade com o seu perfil, ele irá agendar uma breve conversa inicial para conhecer melhor você e entender como suas experiências e habilidades se conectam com a vaga.

Etapa 3: Demonstre suas habilidades

Se houver interesse mútuo em seguir com o processo, você participará de entrevistas com nosso time de contratação. Algumas vagas também podem exigir testes técnicos e/ou entrevistas com clientes.

Etapa 4: Momento da decisão

Nosso time avaliará o potencial de cada candidato para ter sucesso na vaga. Essa etapa pode levar algum tempo, pois buscamos o melhor alinhamento tanto para você quanto para a empresa - mas você pode contar conosco para mantê-lo atualizado ao longo do processo.


Você ainda não encontrou a melhor oportunidade?

Receba as últimas atualizações sobre oportunidades, eventos e novidades da Cognizant no Brasil – tudo selecionado para você!

Mantenha-me atualizado

We care about your privacy

Thank you, your preferences have been updated.

By clicking "Accept All", you agree to the storing of cookies on your device to give you the most optimal experience using our website. We may also use cookies to enhance performance, analyse site usage and to personalise your experience.

Gerenciar preferências

© Cognizant Technology Solutions. This job description was sourced from the employer's public career page. TheJob is not the employer — we index the posting and route candidates to the source. All content rights and hiring decisions belong to the employer.

Cognizant (Nasdaq-100: CTSH) is one of the world’s leading professional services companies, transforming clients’ business, operating and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build and run more innovative and efficient businesses. Headquartered in the US, Cognizant is ranked 185 on the Fortune 500 and is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital atwww.cognizant.comor follow us @Cognizant.

More at Cognizant Technology Solutions

All 1104 roles

Popular searches