41 Informatica Testing Jobs - Page 2

Perform ETL testing to verify data extraction, transformation, loading Validate data movement across systems, ensuring data consistency, quality Write complex SQL queries to validate data source, target Conduct data reconciliation, data profiling Required Candidate profile Collaborate with all Create and maintain test cases, test plans, and test reports Identify, log, and track defects and data issues Work with various DB systems (Oracle, SQL Server, PostgreSQL, etc.) Perks and benefits Perks and Benefits

The ETL Tester role involves working with relevant technologies, ensuring smooth operations, and contributing to business objectives. Responsibilities include analysis, development, implementation, and troubleshooting within the ETL Tester domain.

The ETL Tester role involves working with relevant technologies, ensuring smooth operations, and contributing to business objectives. Responsibilities include analysis, development, implementation, and troubleshooting within the ETL Tester domain.

The PL/SQL, BI Testing role involves working with relevant technologies, ensuring smooth operations, and contributing to business objectives. Responsibilities include analysis, development, implementation, and troubleshooting within the PL/SQL, BI Testing domain.

The PostgreSQL, Test Automation, BI Testing role involves working with relevant technologies, ensuring smooth operations, and contributing to business objectives. Responsibilities include analysis, development, implementation, and troubleshooting within the PostgreSQL, Test Automation, BI Testing domain.

The ETL Tester role involves working with relevant technologies, ensuring smooth operations, and contributing to business objectives. Responsibilities include analysis, development, implementation, and troubleshooting within the ETL Tester domain.

Role & responsibilities Lead and manage a team of QA testers for ETL, data warehouse, and BI report testing. Define and implement test strategies and test plans for DWH projects, covering data pipelines, data integrity, and reporting accuracy. Develop and execute comprehensive test cases and SQL queries to validate data accuracy, completeness, and transformation logic. Test ETL workflows for data extraction, transformation, and loading processes, ensuring alignment with business requirements. Perform data validation testing and reconciliation across data sources, staging, and data warehouses. Test and validate BI reports and dashboards built using tools like Tableau, Power BI, and ThoughtSpot, ensuring data correctness, visual accuracy, and performance. Collaborate with BI developers and stakeholders to validate KPIs, data visualizations, and user interface requirements. Perform performance testing for complex BI dashboards, ensuring scalability and optimal query performance. Oversee defect management and issue resolution using tools like Jira or Azure DevOps. Conduct root cause analysis for data issues and collaborate with engineering teams for resolution. Automate data validation processes using scripting tools such as Python or frameworks like dbt to optimize testing efficiency. Generate test reports and metrics, providing updates on testing progress, issues, and resolution status. Drive continuous improvements in QA processes, tools, and techniques to ensure testing scalability and efficiency. Ensure all testing adheres to organizational quality standards and best practices for DWH and BI projects. Preferred candidate profile Bachelors degree in Computer Science, Information Systems, or a related field. 5+ years of experience in software testing with a strong focus on Data Warehousing, ETL testing , and BI testing . Solid understanding of data warehouse concepts (star schema, snowflake schema, OLAP, and dimensional modeling). Proficiency in writing complex SQL queries for data validation, reconciliation, and transformation testing. Hands-on experience testing ETL tools such as Informatica, Talend, Apache Airflow, or dbt . Expertise in testing and validating reports and dashboards built on BI tools: Tableau Power BI ThoughtSpot Familiarity with cloud-based DWH platforms like Snowflake , Databricks , AWS Redshift , or Azure Synapse . Experience with defect management tools such as Jira , TestRail , or Azure DevOps . Strong analytical skills with the ability to troubleshoot data quality and performance issues. Experience with performance testing and optimization for BI dashboards and large-scale datasets. Excellent communication, leadership, and stakeholder management skills. Hands-on experience in automating data validation using scripting languages like Python or tools like dbt. Familiarity with Big Data tools like Apache Spark, Hive, or Kafka. ISTQB certification or similar QA certifications. Working knowledge of CI/CD pipelines and integration of automated data tests. Experience with data governance, security, and compliance practices. Perks and benefits Training in Databricks. Training and certification in Thoughtspot. Support on certifications. Hands-on AWS, Azure, and GCP. Support you on any cloud certification. Build leadership skills.

Greetings!! Immediate hiring for ETL testing!! Role : ETL Tester Exp: 5 - 7 Years Notice: Immediate Location : Chennai(Preferred) / bangalore/ Kochi Immediate joiners share cv to safoora.imthiyas@aspiresys.com / call on 9384788107 JD: Job Summary: We are seeking a highly skilled ETL Testing - Software Engineer with 5 to 6 years of experience to join our dynamic team. The ideal candidate will have proficient knowledge in SSIS, SSRS, SQL, MS SQL Server and knowledge of Azure Databricks. This role involves ensuring the quality and reliability of ETL processes and data integration solutions. Key Responsibilities: ETL Testing: Design, develop, and execute ETL test plans and test cases to ensure data accuracy, completeness, and integrity. SSRS Reporting: Validate the BI Reports using complex SQL Queries SQL Proficiency: Write complex SQL queries for data validation, testing, and troubleshooting. Azure Databricks: Apply basic knowledge of Azure Databricks for data processing and analytics. Data Quality Assurance: Perform data validation and verification to ensure data quality and consistency across various systems. Defect Management: Identify, document, and track defects using appropriate tools such as JIRA and methodologies. Collaboration: Work closely with developers, business analysts, and other stakeholders to understand requirements and ensure comprehensive testing coverage. Documentation: Create and maintain detailed documentation of test cases, test results, and testing processes. Required Skills and Qualifications: Proficient in SSIS /SSRS/SQL skills for writing and optimizing queries. Sound knowledge of Azure Databricks. Strong analytical and problem-solving skills to identify issues and ensure data accuracy. Attention to Detail: High attention to detail and commitment to delivering high-quality work. Communication: Excellent verbal and written communication skills. Team Player: Ability to work effectively in a team environment and collaborate with cross-functional teams. Experience: Previous experience in a similar role within the Insurance sector.

Project description We need Test / QA Analyst with ETL and Data Testing experience worked on Banking regulatory projects. Responsibilities Ensure successful delivery of Test Planning Coordination of testing activities Manage the project test resources Test design review Test execution management Risk and Issue management and escalation Test defect management Test reporting Provide test metrics for service delivery reporting Any additional responsibilities as identified / agreed with the Project Skills Must have 3 to 6 years of experience in ETL & Data Testing Experience in testing Regulatory projects in banking Proficiency in writing SQL queries for data validation and testing. Experience in writing Test Strategy & Test Plans Test execution management Test defect management Test reporting Provide test metrics for service delivery reporting Nice to have Exposure to Agile AZURE cloud experience

Project description We need experienced Test / QA Lead with ETL and Data Testing experience worked on Banking regulatory projects. Responsibilities Ensure successful delivery of Test Planning Coordination of testing activities Manage the project test resources Test design review Test execution management Risk and Issue management and escalation Test defect management Test reporting Provide test metrics for service delivery reporting Any additional responsibilities as identified / agreed with the Project Skills Must have 10 + years of experience in ETL & Data Testing Experience in testing Regulatory projects in banking Proficiency in writing SQL queries for data validation and testing. Experience in writing Test Strategy & Test Plans Test execution management Test defect management Test reporting Provide test metrics for service delivery reporting Nice to have Exposure to Agile AZURE cloud experience

Project description We need experienced Test / QA Lead with ETL and Data Testing experience worked on Banking regulatory projects. Responsibilities Ensure successful delivery of Test Planning Coordination of testing activities Manage the project test resources Test design review Test execution management Risk and Issue management and escalation Test defect management Test reporting Provide test metrics for service delivery reporting Any additional responsibilities as identified / agreed with the Project Skills Must have 10 + years of experience in ETL & Data Testing Experience in testing Regulatory projects in banking Proficiency in writing SQL queries for data validation and testing. Experience in writing Test Strategy & Test Plans Test execution management Test defect management Test reporting Provide test metrics for service delivery reporting Nice to have Exposure to Agile AZURE cloud experience

Project description We need Test / QA Analyst with ETL and Data Testing experience worked on Banking regulatory projects. Responsibilities Ensure successful delivery of Test Planning Coordination of testing activities Manage the project test resources Test design review Test execution management Risk and Issue management and escalation Test defect management Test reporting Provide test metrics for service delivery reporting Any additional responsibilities as identified / agreed with the Project Skills Must have 3 to 6 years of experience in ETL & Data Testing Experience in testing Regulatory projects in banking Proficiency in writing SQL queries for data validation and testing. Experience in writing Test Strategy & Test Plans Test execution management Test defect management Test reporting Provide test metrics for service delivery reporting Nice to have Exposure to Agile AZURE cloud experience

Roles and Responsibility Design, develop, and implement data pipelines using ETL tools such as PySpark. Collaborate with cross-functional teams to identify and prioritize project requirements. Develop and maintain large-scale data warehouses using Snowflake. Ensure data quality and integrity by implementing data validation and testing procedures. Optimize data processing workflows for improved performance and efficiency. Troubleshoot and resolve technical issues related to data engineering projects. Job Requirements Strong understanding of data modeling and database design principles. Experience with big data technologies such as Hadoop and Spark. Proficiency in programming languages such as Python and Java. Excellent problem-solving skills and attention to detail. Ability to work collaboratively in a team environment. Strong communication and interpersonal skills. Familiarity with cloud-based platforms such as AWS or Azure is an added advantage. Mandatory Skills: ETL Testing.Experience: 3-5 Years.

Position Description: We are looking for an experienced DataStage tester to join our team. The ideal candidate should be passionate about coding and testing scalable and high-performance applications Your future duties and responsibilities: Develop and execute ETL test cases to validate data extraction, transformation, and loading processes. - Write complex SQL queries to verify data integrity, consistency, and correctness across source and target systems. - Automate ETL testing workflows using Python, PyTest, or other testing frameworks. - Perform data reconciliation, schema validation, and data quality checks. - Identify and report data anomalies, performance bottlenecks, and defects. - Work closely with Data Engineers, Analysts, and Business Teams to understand data requirements. - Design and maintain test data sets for validation. - Implement CI/CD pipelines for automated ETL testing (Jenkins, GitLab CI, etc.). - Document test results, defects, and validation reports. Required qualifications to be successful in this role: ETL Testing: Strong experience in testing Informatica, Talend, SSIS, Databricks, or similar ETL tools. - SQL: Advanced SQL skills (joins, aggregations, subqueries, stored procedures). - Python: Proficiency in Python for test automation (Pandas, PySpark, PyTest). - Databases: Hands-on experience with RDBMS (Oracle, SQL Server, PostgreSQL) & NoSQL (MongoDB, Cassandra). - Big Data Testing (Good to Have): Hadoop, Hive, Spark, Kafka. - Testing Tools: Knowledge of Selenium, Airflow, Great Expectations, or similar frameworks. - Version Control: Git, GitHub/GitLab. - CI/CD: Jenkins, Azure DevOps, or similar. Soft Skills: - Strong analytical and problem-solving skills. - Ability to work in Agile/Scrum environments. - Good communication skills for cross-functional collaboration. Preferred Qualifications: - Experience with cloud platforms (AWS, Azure). - Knowledge of Data Warehousing concepts (Star Schema, Snowflake Schema). - Certification in ETL Testing, SQL, or Python is a plus. Skills: Data Warehousing MS SQL Server Python

Project description We need Test / QA Analyst with ETL and Data Testing experience worked on Banking regulatory projects. Responsibilities Ensure successful delivery of Test Planning Coordination of testing activities Manage the project test resources Test design review Test execution management Risk and Issue management and escalation Test defect management Test reporting Provide test metrics for service delivery reporting Any additional responsibilities as identified / agreed with the Project Skills Must have 3 to 6 years of experience in ETL & Data Testing Experience in testing Regulatory projects in banking Proficiency in writing SQL queries for data validation and testing. Experience in writing Test Strategy & Test Plans Test execution management Test defect management Test reporting Provide test metrics for service delivery reporting Nice to have Exposure to Agile AZURE cloud experience

Project description We need experienced Test / QA Lead with ETL and Data Testing experience worked on Banking regulatory projects. Responsibilities Ensure successful delivery of Test Planning Coordination of testing activities Manage the project test resources Test design review Test execution management Risk and Issue management and escalation Test defect management Test reporting Provide test metrics for service delivery reporting Any additional responsibilities as identified / agreed with the Project Skills Must have 10 + years of experience in ETL & Data Testing Experience in testing Regulatory projects in banking Proficiency in writing SQL queries for data validation and testing. Experience in writing Test Strategy & Test Plans Test execution management Test defect management Test reporting Provide test metrics for service delivery reporting Nice to have Exposure to Agile AZURE cloud experience