Testing - ETL - Senior

div style=font-family:Arial;font-size:1.0empAt EY, we’re all in to shape your future with confidence. /ppWe’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go. /ppJoin EY and help to build a better working world. /p/divdiv style=font-family:Arial;font-size:1.0em /divpspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongEY_ Consulting _Data Analytics Testing_Senior/strong/span/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongThe opportunity/strong/span/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptAs a Data Analytics Test Lead, you will be responsible for testing Business Intelligence amp; Data warehousing Solutions both in on premise and cloud platform and should ensure Quality of deliverables. You will work closely with Test Manager for the Projects under Test. Testing proficiency in ETL, data-warehousing, and Business Intelligence area are required for this position./span/pp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptAdded advantage to have experience in testing Big Data/unstructured data using Hadoop/Spark framework, cloud platform knowledge either in AWS/Azure, knowledge in predictive analytics, Machine Learning and Artificial intelligence./span/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/pp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongSkills and attributes for success/strong/span/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptDevelop Test Strategy for Testing BI amp; DWH Projects for various aspects like ETL testing amp; Reports testing (Front end and Backend Testing), Integration Testing and UAT as needed. Provide inputs for Test Planning aligned with Test Strategy./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptPerform Test Case design, identify opportunity for Test Automation. Develop Test Cases both Manual and Automation Scripts as required./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptEnsure Test readiness (Test Environment, Test Data, Tools Licenses etc)/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptCoordinate testing efforts with cross-functional teams, including ETL developers, data engineers, business analysts, and project managers, to ensure testing aligns with project timelines and objectives/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptEstablish and enforce data quality standards, data profiling, and data cleansing procedures to maintain high-quality data./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptDelivery of Testing needs for BI amp; DWH Projects./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptPerform unstructured data / big data testing both in on-premise and cloud platform./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptThorough understanding of Requirements and provide feedback on the requirements./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptPerform Test execution and report the progress. Report defects and liaise with development amp; other relevant team for defect resolution./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptPrepare Test Report and provide inputs to Test Manager/ Lead for Test Sign off/ Closure/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptProvide support in Project meetings/ calls with Client for status reporting./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptProvide inputs on Test Metrics to Test Manager/ Lead. Support in Analysis of Metric trends and implementing improvement actions as necessary./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptHandling changes and conducting Regression Testing/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptGenerate Test Summary Reports/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptCo-coordinating Test team members and Development team in order to resolve the issues/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptInteracting with client-side people to solve issues and update status/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptAble to lead team across geographies/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptActively take part in providing Analytics and Advanced Analytics Testing trainings in the company/span/li/ulp /pp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongTo qualify for the role, you must have/strong/span/pp /pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptBE/BTech/MCA/M.Sc/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptOverall 5-8 years of experience in Testing Data warehousing / Business Intelligence solutions, minimum 3 years of experience in Testing BI amp; DWH technologies and Analytics applications./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptStrong in Data warehouse testing - ETL and BI and having exposure to the reporting tools such as Cognos/PowerBI/Tableau/Qlik etc/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExposure to one or more ETL tools such as Informatica, SSIS, SAP Data services, AWS Glue, Azure Data factory/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptStrong SQL skills with experience in writing complex data validation SQL’s on databases like Oracle/ SQL Server/ Teradata / Snowflake/Postgres/Redshift/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptProficiency in data services of any leading cloud providers like AWS, Azure, GCP and thorough knowledge on data platforms like Databricks, Azure synapse/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptValidate data integrity and consistency across various stages of ETL pipelines./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in master data management (MDM) is added advantage/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptWorking experience with python data processing is desirable./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptWork with cross-functional teams to ensure that ETL solutions meet business needs and quality standards./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in Bigdata testing with Hadoop/Spark framework and exposure to predictive analytics testing is desirable/span/li/ulpspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/pp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongIdeally, you’ll also have/strong/span/pp /pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience in Performance amp; Load Testing for backend systems is preferred. Exposure to Performance Tuning (Tuning concepts - indexes, segments, partitions, query tuning) of database systems would be an added advantage./span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience/ exposure to Test Automation and scripting experience in perl amp; shell is desirable/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptExperience with Test Management and Defect Management tools preferably HP ALM/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptAble to contribute as an individual contributor and when required Lead a small Team/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptAble to create Test Strategy amp; Test Plan for Testing BI amp; DWH applications/ solutions that are moderate to complex / high risk Systems/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptDesign Test Cases, Test Data and perform Test Execution amp; Reporting. Should be able to perform Test Management for small Projects as and when required/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptParticipate in Defect Triaging and track the defects for resolution/ conclusion/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptGood communication skills (both written amp; verbal)/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptGood understanding of SDLC, test process in particular/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptGood analytical amp; problem solving or troubleshooting skills/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptGood understanding of Project Life Cycle and Test Life Cycle. Exposure to CMMi and Process improvement Frameworks is a plus. Should have excellent communication skills amp; should be able to articulate concisely amp; clearly/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptShould be ready to do an individual contributor as well as Team Leader role/span/li/ulpspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/pp /ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrongWhat working at EY offers/strong/span/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptstrong /strong/span/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptAt EY, we’re dedicated to helping our clients, from start–ups to Fortune 500 companies — and the work we do with them is as varied as they are./span/ppspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptYou get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:/span/pp /pulli style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptSupport, coaching and feedback from some of the most engaging colleagues around/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptOpportunities to develop new skills and progress your career/span/lili style=font-family:arial, helvetica, sans-serif;font-size:10.0ptspan style=font-family:arial, helvetica, sans-serif;font-size:10.0ptThe freedom and flexibility to handle your role in a way that’s right for you/span/li/ulp /pdiv style=font-family:Arial;font-size:1.0empbEY | Building a better working world /b/ppEY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets./ppEnabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow./ppEY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories./p/div