Talent.com
This job offer is not available in your country.
Senior Test Analyst - ETL / Data Warehousing Projects

Senior Test Analyst - ETL / Data Warehousing Projects

Varite IndiaBangalore
30+ days ago
Job description

Senior Test Analyst

We are seeking an experienced Senior Test Analyst to lead testing efforts for complex ETL and data warehouse projects in the banking and financial services domain.

The candidate will be responsible for validating data accuracy, integrity, and performance across multiple data layers and ensuring compliance with banking regulations.

Key Responsibilities :

  • Analyze ETL design documents, source-to-target mappings, and business rules to develop comprehensive test coverage.
  • Develop and execute detailed test strategies, test cases, and scripts to validate end-to-end data flows across staging, bronze, silver, and gold data layers.
  • Perform rigorous data validation and reconciliation between source systems and target databases using Teradata SQL, Hive, or Impala.
  • Validate Informatica PowerCenter workflows, sessions, and mappings for logic correctness, data accuracy, and performance efficiency.
  • Conduct integration, regression, and UAT testing in collaboration with business teams and development partners.
  • Utilize synthetic and masked data for functional and performance testing in line with banking security and compliance policies.
  • Track and report defects, manage resolution processes, and provide daily and sprint-level status updates.
  • Ensure traceability of test scenarios to business requirements, emphasizing regulatory compliance and financial data accuracy.

Qualifications :

  • Experience : 9 to 11 years in ETL / data warehouse testing, preferably within banking or financial services.
  • Expertise in Informatica PowerCenter and Teradata for handling large data volumes and complex transformations.
  • Hands-on experience with Big Data technologies such as Cloudera / Hadoop, Hive, HDFS, and Impala.
  • Strong skills in writing complex SQL queries for data validation and reconciliation.
  • Solid understanding of data quality principles, metadata management, and data lineage validation.
  • Familiarity with Agile methodologies and experience using tools like JIRA for sprint-based testing.
  • Experience in test data creation, data masking, and use of synthetic data aligned with regulatory compliance requirements.
  • Preferred Skills :

  • Strong knowledge of banking data systems, including customer, transaction, risk, and regulatory reporting domains.
  • Experience with Cognos or Power BI for validating report outputs against data models.
  • Excellent analytical skills and attention to detail.
  • Ability to work effectively with distributed, cross-functional teams.
  • Exposure to test automation or scripting frameworks for large-scale data validation is a plus
  • ref : hirist.tech)

    Create a job alert for this search

    Senior Test Analyst • Bangalore

    Related jobs
    • Promoted
    Talend Developer - ETL / Data Warehousing

    Talend Developer - ETL / Data Warehousing

    Scoop Technologies Pvt LtdBangalore
    Job Title : Talend Developer Experience Level : 7 to 10 Years Location : Bangalore / Chennai / Kerala<...Show moreLast updated: 30+ days ago
    • Promoted
    Azure Databricks Architect - ETL / Data Warehousing

    Azure Databricks Architect - ETL / Data Warehousing

    Aiprus Software Private LimitedBangalore
    Job Title : Azure Databricks Architect Experience : 10 to 15 Years Location : Bangalore, India ...Show moreLast updated: 10 days ago
    • Promoted
    Data Engineer / Analyst - ETL

    Data Engineer / Analyst - ETL

    Impetus Career Consultants Private LimitedBangalore
    Key Responsibilities : - Design and develop robust data models specifically tailored for ingestion into process intelligence pla...Show moreLast updated: 8 days ago
    • Promoted
    Data Engineer - ETL / Data Warehousing

    Data Engineer - ETL / Data Warehousing

    TalentojBangalore
    Responsibilities : Architect and Implement Data Infrastructure : Design, build, and maintain robust and scalable data pipelines and a data warehouse...Show moreLast updated: 23 days ago
    • Promoted
    DBiz.ai - Senior AWS Data Engineer - ETL / Data Warehousing

    DBiz.ai - Senior AWS Data Engineer - ETL / Data Warehousing

    DBIZ AI SOLUTIONS PRIVATE LIMITEDBangalore
    Job Description : Experienced Senior Data Engineer (8+ Yrs) with deep expertise in AWS cloud Data services, particularly AWS Glue, to design, build, ...Show moreLast updated: 30+ days ago
    • Promoted
    Data Analyst - ETL / Python

    Data Analyst - ETL / Python

    RecroBangalore
    Job Description : We are seeking a detail-oriented and analytical Data Analyst to join our team.The ideal candidate will be responsible for collectin...Show moreLast updated: 30+ days ago
    • Promoted
    Reveal HealthTech - Senior Data Engineer - ETL / Data Warehousing

    Reveal HealthTech - Senior Data Engineer - ETL / Data Warehousing

    Reveal HealthTechBangalore
    Reveal HealthTech is a dedicated healthcare-focused technology services company helping our clients with a range of AI and product engineering services. Reveal's mission is to unleash the full ...Show moreLast updated: 30+ days ago
    • Promoted
    Ascendion - ETL Talend Lead - Python / Data Warehousing

    Ascendion - ETL Talend Lead - Python / Data Warehousing

    AscendionBangalore
    Job Title : ETL Talend Lead.Location : Bangalore, Hyderabad, Chennai, Pune.Job Type : Full-Time.Shift Timings : 2 : 00 - 11 : 00 PM.Years Of Experience : ...Show moreLast updated: 19 days ago
    • Promoted
    Data Conversion / ETL Test Lead

    Data Conversion / ETL Test Lead

    BlitzenXBangalore
    Job Summary : We are seeking a skilled Data Conversion Test Lead / ETL Test Lead to lead testing efforts for large-scale data migration and ETL projects.The ideal ca...Show moreLast updated: 26 days ago
    • Promoted
    Genzeon - Data Architect / Modeler - ETL / Data Warehousing

    Genzeon - Data Architect / Modeler - ETL / Data Warehousing

    Genzeon Technology Solutions Pvt. Ltd.Bangalore
    Role : Data : 10 - 20 : Hybrid : Pune, Description : We are seeking a highly experienced Senior Data Architect to lead dat...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Data Analyst - Python / ETL

    Senior Data Analyst - Python / ETL

    Trailblaze CareerPaths Global Private LimitedBangalore
    We are seeking a highly skilled and motivated Senior Data Analyst / Python Developer with 5 to 7 years of experience to join our dynamic team in Bangalore. The ideal candidate will have a strong exp...Show moreLast updated: 26 days ago
    • Promoted
    Informatica Developer - ETL / Data Warehousing

    Informatica Developer - ETL / Data Warehousing

    Risk Resources IndiaBangalore
    Key Skills Informatica BDM, AWS Must have Skills 1.BDM Developer / Technical Lead 2.Good hands-on experience in AWS...Show moreLast updated: 30+ days ago
    • Promoted
    Data Engineer II - ETL / Data Warehousing

    Data Engineer II - ETL / Data Warehousing

    Talent ProBangalore
    Role & Responsibilities : Hopscotch is looking for a passionate Data Engineer to join our team.You will work closely with other teams like data analytics, marketi...Show moreLast updated: 18 days ago
    • Promoted
    DevoTrend - Talend Developer - ETL / Data Warehousing

    DevoTrend - Talend Developer - ETL / Data Warehousing

    DEVOTREND IT PRIVATE LIMITEDBangalore
    Company Description : DevoTrend IT is a global technology solutions provider delivering end-to-end digital transformation solutions ranging from ideation to deployme...Show moreLast updated: 16 days ago
    • Promoted
    ETL Test Analyst with Databricks (Bangalore, Bhubaneswar)

    ETL Test Analyst with Databricks (Bangalore, Bhubaneswar)

    Tata Consultancy ServicesBengaluru, Karnataka, India
    Role : ETL Test Analyst with Databricks.JOB LOCATION : Bangalore, Bhubaneswar.ETL Testing, Strong SQL, Data bricks.Good experience in developing SQL queries for testing complex ETL transformations....Show moreLast updated: 19 days ago
    • Promoted
    GIST Impact - Lead Data Engineer - ETL / Data Warehousing

    GIST Impact - Lead Data Engineer - ETL / Data Warehousing

    GIST ImpactBangalore
    About : GIST Impact is a leading impact data, analytics and product solutions provider that has been measuring, quantifying and valuing corporate impacts for more th...Show moreLast updated: 11 days ago
    Senior Data Modeler - Data warehousing

    Senior Data Modeler - Data warehousing

    Bosch GroupBangalore, Karnataka, India
    Data / Dimensional modelling in data warehousing.Oracle SQL PL / SQL views procedures functions.Experience extracting data (Oracle SQL / Excel) and creating data model as per customer requirement.Be pr...Show moreLast updated: 30+ days ago
    • Promoted
    Data Modeler - ETL / Data Warehousing

    Data Modeler - ETL / Data Warehousing

    Anlage Infotech (I) Pvt. Ltd.Bangalore
    Job Description : Lead Data Modeler About the Role : We are seeking a highly experienced and skilled Lead Data Modeler with 9+...Show moreLast updated: 30+ days ago