ETL Tester

Good day,We have immediate opportunity for ETL TesterJob Role: ETL TesterJob Location: PuneExperience- 8 Years+Notice Period: Immediate to 30 days.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 industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end 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, mobile-first 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 14,700+ and has 55 offices in 20 countries within key global markets. For more information on the company, please visit our website or LinkedIn community.Diversity, Equity, and InclusionDiversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and an affirmative-action 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:We are seeking an experienced ETL Tester with a strong database engineering background to join our data team. The ideal candidate will be proficient in writing complex SQL queries, performing data profiling, and testing ETL processes, data migrations, and reporting systems. You will play a critical role in ensuring the integrity, accuracy, and performance of our data pipelines and dashboards.Key Responsibilities:- Data Profiling: Analyze source data to understand data structures, distributions, and anomalies to ensure data quality and readiness for processing. - ETL/Data Migration Testing: Validate the extraction, transformation, and loading processes to confirm data accuracy and completeness during migrations or regular ETL runs. - Test Strategy Development: Design comprehensive testing plans and strategies for ETL workflows, data migrations, and reporting tools. - Report Testing: Validate the accuracy, completeness, and performance of reports generated from the data warehouse, including front-end dashboards and backend reporting systems. - Frontend & Backend Testing: Perform end-to-end testing of the Banker Dashboard interface and backend systems, ensuring consistent data flow and user experience. - SQL & Database expertise: Write advanced SQL queries for data validation, reconciliation, and troubleshooting. - Issue Identification & Resolution: Detect data discrepancies, performance bottlenecks, and functional issues, and collaborate with developers and data engineers for resolution.Qualifications:- Bachelor’s degree in Computer Science, Information Technology, or related field. - Proven experience (3+ years) as an ETL Tester, Data QA Analyst, or similar role. - Strong proficiency in SQL (write complex, optimized queries, stored procedures, etc.) - Hands-on experience with data profiling, data validation, and data migration testing. - Familiarity with ETL tools and frameworks (Informatica, Talend, DataStage, etc.) is a plus. - Experience with testing dashboard frontends and backend services. - Knowledge of databases such as SQL Server, Oracle, MySQL, or PostgreSQL. - Strong analytical and problem-solving skills. - Excellent communication skills to document issues and collaborate with cross-functional teams.Preferred Attributes:- Experience with automating tests and scripts. - Knowledge of scripting languages like Python, Shell, or similar. - Familiarity with BI tools such as Tableau, Power BI, or similar. - Understanding of banking or financial data systems.If you find this opportunity interesting kindly share your below details (Mandatory)- Total Experience - Experience in ETL Testing – - Experience in Data profiling– - Experience in Test Strategy – - Current CTC – - Expected CTC– - Notice period– - Current Location-If you had gone through any interviews in Synechron before? If Yes whenRegards,Recruitment Team, Pune.