ETL Test Analyst
Chennai, Tamil Nadu, India
Unison Consulting Pte Ltd
- Create test case documents/plan for testing the Data pipelines.
- Check the mapping for the fields that support data staging and in data marts & data type constraints of the fields present in snowflake Verify non-null fields are populated.
- Verify Business requirements and confirm if the correct logic Is implemented in the transformation layer of ETL process.
- Verify stored procedure calculations and data mappings.
- Verify data transformations are correct based on the business rules.
- Verify successful execution of data loading workflows
- Should have hands on experience in ETL/DWH Testing.
- Strong in ETL, Dababase/DWH Testing.
- Experience in writing ETL scripts and execution
- Experience in any of the test management tool (JIRA etc)
Requirements
1. Strong working knowledge on Informatica, Datastage, PySpark, Spark, Hadoop, SQL
2. Extensive exposure to Back-end/ETL Testing with high-level of SQL skills
3. Exp in delivering ETL solutions by liaising with business users, architects and understanding the business requirements
4. Should have prior experience working informatica / other ETL tools
5. Should be able to take source to target DDR and be able to write Test Cases independently
Good-to-Have
1. Recent experience with Finance/Banking domain
2. Excellent communication skills
Please note that Candidates are expected to work from office at Chennai or Bengaluru Location.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Banking Data pipelines ETL Finance Hadoop Informatica Jira Pipelines PySpark Snowflake Spark SQL Testing
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Engineer II jobs
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open Marketing Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open MLOps Engineer jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Business Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Sr Data Engineer jobs
- Open Product Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Research Scientist jobs
- Open Big Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Azure Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Manager, Data Engineering jobs
- Open Junior Data Engineer jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open PyTorch-related jobs
- Open NLP-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open Consulting-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Generative AI-related jobs
- Open Snowflake-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs