ETL Tester

  • Pune
  • Synechron
Goodday, We have immediate opportunity for QA ETL Test Engineer. Job Role: QA ETL Test Engineer Job Location: Pune Hinjewadi Experience 5 to 8 Years. Notice Perod : Upto 15 days preferred. About Company: At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industryleading digital solutions. Synechron’s progressive technologies and optimization strategies span endtoend Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobilefirst applications and more. Over the last 20+ years, our company has been honoured with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 13,950+, and has 52 offices in 20 countries within key global markets. For more information on the company, please visit our website or LinkedIn community. Diversity, Equity, and Inclusion Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and an affirmativeaction employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more. All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law. Job Description : ETL Testing Engineer Software Requirements: Knowledge of data engineering/orchestration concepts. Experience working with ETL and data pipelines. Familiarity with Cloud data warehouses such as Snowflake or Google BigQuery. Basic understanding of Apache Airflow or Google Cloud Composer. Experience with Data Quality Check tools like dbttest, Soda, Google Dataplex, or similar. Proficiency in Python for implementing and/or automating tests. Strong SQL skills for querying databases and validating data integrity. Overall Responsibilities: Develop and execute ETL testing strategies to ensure the accuracy, completeness, and timeliness of data. Collaborate with data engineers and analysts to understand data transformation processes and requirements. Create and maintain test cases, scripts, and scenarios for ETL processes. Conduct data quality checks to identify and resolve data anomalies and inconsistencies. Analyze test results and communicate findings to relevant stakeholders. Continuously improve testing processes and methodologies to enhance data quality and efficiency. Categorywise Technical Skills: Data Engineering/Orchestration: Understanding of data pipeline architectures and workflows. Familiarity with tools like Apache Airflow or Google Cloud Composer. ETL Testing: Proficiency in designing and executing test cases for ETL processes. Experience with Data Quality Check tools such as dbttest, Soda, Google Dataplex, or similar. Programming Languages: Python: Ability to implement and/or automate tests. SQL: Strong ability to query databases and validate data integrity. Experience: Minimum of 5 years of experience in ETL testing or related fields. DaytoDay Activities: Reviewing ETL requirements and specifications. Designing and executing test cases and scenarios. Analyzing test results and identifying data quality issues. Collaborating with crossfunctional teams to address data anomalies. Documenting test findings and communicating with stakeholders. Qualifications & Soft Skills: Bachelor's degree in Computer Science, Engineering, or related field. Strong analytical and problemsolving skills. Excellent communication and interpersonal skills. Ability to work independently and in a team environment. Attention to detail and commitment to quality. Proactive mindset with a willingness to learn and adapt to new technologies. Preferred Skills and Experience: Experience with Snowflake and/or Google BigQuery. Familiarity with Datorama and DSPs (Demand Side Platforms). Prior exposure to adtech and media agency work processes. If you find this opportunity interesting kindly share your updated profile on prasad.taware@synechron.com With below details (Mandatory) Total Experience Experience in ETL Testing Experience in Python – Experience in Snowflake or Google Big Query– Current CTC Expected CTC Notice period Current Location If you had gone through any interviews in Synechron before? If Yes when Regards, Prasad Taware Prasad.taware@synechron.com