More jobs:
Job Description & How to Apply Below
Key Responsibilities
Test Planning & Strategy
Develop comprehensive test plans, test cases, and test scripts for data warehouse and ETL processes.
Analyze business and technical requirements to determine test scope, priorities, and acceptance criteria.
Define data quality validation approaches covering data completeness, accuracy, transformation logic, and referential integrity.
ETL & Data Validation
Perform ETL testing, including source-to-target data mapping validation, transformation rule verification, and workflow dependency testing.
Validate data across various layers (staging → integration layer → warehouse → data marts).
Conduct regression testing, system integration testing, and user acceptance testing (UAT) support.
Verify data consistency across different systems, dashboards, and reporting tools.
SQL & Automation
Write complex SQL queries to perform data profiling, reconciliation, and validation of large datasets.
Optionally participate in test automation using tools like Python, PySpark, SQL automation frameworks, or CI/CD pipelines.
Collaborate with developers to design testable ETL components.
Defect Management
Document defects clearly with supporting evidence, logs, and SQL outputs.
Track and manage defects using tools such as Jira, Azure Dev Ops, or Rally.
Work closely with data engineers to troubleshoot issues and retest fixes.
Collaboration & Documentation
Work with data architects, engineers, BI developers, and business analysts to understand data models and requirements.
Review and validate source-to-target mapping (STM) documents, data models, and ETL specifications.
Maintain clear documentation of test results, data validation approaches, and QA guidelines.
Qualifications
Required
Skills & Qualifications
Strong SQL skills (complex joins, aggregations, window functions, data profiling).
Solid understanding of data warehousing concepts (facts, dimensions, SCDs, star/snowflake schemas).
Experience testing ETL pipelines (e.g., Informatica, SSIS, Data Stage, Azure Data Factory, Snowflake tasks, Databricks jobs).
Experience working with large datasets and BI/reporting tools (e.g., Power BI, Tableau, Looker, Micro Strategy).
Familiarity with data modeling concepts and metadata.
Excellent analytical, problem-solving, and communication skills.
Experience with QA methodologies, test management tools, and defect tracking systems.
Preferred Qualifications
Experience with cloud data platforms (Azure, AWS, GCP).
Experience with big data technologies (Spark, Hive, Databricks).
Knowledge of Python or similar scripting languages for test automation.
Familiarity with CI/CD pipelines and Dev Ops processes.
Prior experience in finance, healthcare, or other data‑intensive industries.
Soft Skills
Attention to detail and strong commitment to data accuracy.
Ability to work independently and in cross-functional teams.
Strong documentation habits and communication skills.
Growth mindset and continuous improvement mentality.
About Us
At Zensar, we're 'experience-led everything' . We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures . Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus .
Part of the $4.8 billion RPG Group, we're a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.
We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.
Note that applications are not being accepted from your jurisdiction for this job currently via this jobsite. Candidate preferences are the decision of the Employer or Recruiting Agent, and are controlled by them alone.
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
Search for further Jobs Here:
×