ETL Testing with GCP

About Client: Our Client is a global IT services company headquartered in Southborough, Massachusetts, USA. Founded in 1996, with a revenue of $1.8B, with 35,000+ associates worldwide, specializes in digital engineering, and IT services company helping clients modernize their technology infrastructure, adopt cloud and AI solutions, and accelerate innovation. It partners with major firms in banking, healthcare, telecom, and media. Our Client is known for combining deep industry expertise with agile development practices, enabling scalable and cost-effective digital transformation. The company operates in over 50 locations across more than 25 countries, has delivery centers in Asia, Europe, and North America and is backed by Baring Private Equity Asia. Job Title : ETL Testing with GCP Key Skills : ETL Testing ,SQL,GCP,Bigquery,Informatica,Python,Datawarehouse Experience : 7-9 Years Location : Hyderabad Education Qualification : Any Graduation Work Mode : Hybrid Employment Type : Contract to Hire Notice Period : Immediate - 10 Days. Job Description : 8+ years of experience in ETL/data testing Design, implement, and execute data validation test plans and test cases Understanding of data modelling and data governance principles Experience with test automation frameworks and scripting (e.g., Python, Shell)Conduct thorough ETL testing, including data extraction, transformation, and loading Validate data integrity across various sources and destinations (data lakes, warehouses, etc.)Perform data reconciliation and analysis to identify inconsistencies or data quality issues Develop and maintain automated data testing frameworks using SQL or scripting languages Strong experience with SQL and writing complex queries for data validation Knowledge of data warehouse concepts and testing tools Experience with ETL tools (e.g., Informatica, Talend, SSIS, etc.)Familiarity with cloud platforms (Azure, GCP) and modern data tools (e.g., Snowflake, Big Query). GCP is mandatory Experience in Agile development and working within cross-functional teams Exposure to BI tools (Power BI, Tableau, Looker)Familiarity with CI/CD pipelines and version control systems like GitISTQB or equivalent testing certifications 8+ years of experience in ETL/Data Testing. Strong experience in validating large-scale data migration and transformation projects. Key Responsibilities Design, develop, and execute comprehensive data validation test plans, test cases, and test scenarios. Perform end-to-end ETL testing, including data extraction, transformation, and loading validation. Validate data integrity, accuracy, completeness, and consistency across multiple data sources, data lakes, and data warehouses. Conduct data reconciliation and root cause analysis to identify data quality issues and inconsistencies. Develop, maintain, and enhance automated data testing frameworks using SQL, Python, or Shell scripting. Write complex SQL queries for data validation and reconciliation. Collaborate with developers, data engineers, business analysts, and product teams to understand data requirements and ensure quality throughout the development lifecycle. Participate in Agile ceremonies including sprint planning, daily stand-ups, reviews, and retrospectives. Support CI/CD practices by integrating automated data tests into deployment pipelines. Required Skills Data Testing Strong expertise in ETL Testing and Data Warehouse Testing. Experience in data validation, data reconciliation, and data quality testing. Good understanding of data modeling and data governance principles. Knowledge of data warehouse concepts and dimensional modeling. Technical Skills Advanced SQL with experience writing complex queries. Experience with Python and/or Shell scripting for test automation. Hands-on experience with ETL tools such as: Informatica Talend SSIS Or equivalent ETL platforms Experience with modern cloud-based data platforms including: Google Cloud Platform (GCP) Mandatory Azure (preferred) Hands-on experience with modern data technologies such as: Snowflake BigQuery Familiarity with Git and version control systems. Experience working with CI/CD pipelines. Reporting & Analytics Exposure to BI and reporting tools such as: Power BI Tableau Looker About Client: Our Client is a global IT services company headquartered in Southborough, Massachusetts, USA. Founded in 1996, with a revenue of $1.8B, with 35,000+ associates worldwide, specializes in digital engineering, and IT services company helping clients modernize their technology infrastructure, adopt cloud and AI solutions, and accelerate innovation. It partners with major firms in banking, healthcare, telecom, and media. Our Client is known for combining deep industry expertise with agile development practices, enabling scalable and cost-effective digital transformation. The company operates in over 50 locations across more than 25 countries, has delivery centers in Asia, Europe, and North America and