ETL QA Tester

TMF Group

  • Shanghai
  • Permanent
  • Full-time
  • 1 month ago
We never ask for payment as part of our selection process, and we always contact candidates via our corporate accounts and platforms. If you are approached for payment, this is likely to be fraudulent. Please check to see whether the role you are interested in is posted here, on our website.About TMF GroupTMF Group is a leading global provider of high-value business services to clients operating and investing globally. We focus on providing specialized and business-critical financial and administrative services that enable our clients to operate their corporate structures, finance vehicles and investment funds in different geographical locations.TMF India is a Great Place to Work, ISO & ISAE certified organization.About the RoleThe Corporate Services Paralegal will assist with the internal management of client files from a legal/corporate compliance perspective in coordination with the department Manager. In this capacity the Paralegal will draft resolutions, bylaws, POA's, and minutes as well as monitor completeness of client files by checking regularly on-going tasks and filing requirements. The Paralegal will also assist with incorporations and corporate filings on behalf of client companies. Overall, will assist Manager on the day to day with the execution of all necessary tasks to have client's maintain legal compliance.Key Responsibilities
  • ETL Testing: Conduct thorough testing of ETL processes, with a focus on Azure Data Factory and Alteryx, to ensure data integrity, accuracy, and compliance with business rules.
  • Quality Assurance in Transformations: Implement quality assurance practices to validate the XSLT transformations and XML outputs. Ensure the correctness and efficiency of the transformations.
  • Test Plan Development: Develop detailed test plans and cases for ETL processes, particularly focusing on XSLT transformations and the generation of XML outputs.
  • Automation of Test Procedures: Utilize and develop automated testing tools and scripts to enhance the efficiency and accuracy of the testing process.
  • Web Service Integration Testing: Focus on testing web service integrations, ensuring seamless connectivity and data exchange between various systems and services.
  • Performance Testing: Assess the performance of ETL processes, especially those involving complex XSLT transformations, to ensure they meet the desired efficiency and speed benchmarks.
  • Defect Identification and Resolution: Identify, document, and report any issues or discrepancies found in ETL processes or XSLT transformations. Work collaboratively with the team for timely resolutions.
  • Data Security and Compliance: Ensure all ETL processes, including XSLT transformations, adhere to data security standards and compliance requirements.
  • Collaboration and Communication: Work closely with cross-functional teams, including development, data engineering, and business units, to understand requirements and provide feedback.
  • Documentation and Reporting: Maintain clear and comprehensive documentation of ETL test processes, test plans, test cases, and findings for future reference and audits.
Key Requirements
  • Proficiency in ETL testing, particularly with Azure Data Factory and Alteryx.
  • Strong experience in writing and testing XSLT transformations for XML outputs.
  • Familiarity with automated testing tools like Jenkins, SOAPUI, or any similar industry standard.
  • Knowledge of SQL and experience with database management systems.
  • Understanding of performance testing methodologies.
  • Experience in data security and compliance in ETL processes.
Key knowledge and experience
  • Bachelor's degree in computer science, Information Technology, or a related field.
  • Proven experience in ETL Testing script writing and execution.
  • 3-4 years of experience in ETL development, preferably with HRIS systems.
  • Strong analytical and problem-solving skills.
  • Excellent communication and project management abilities.
  • Demonstrated experience with Azure Data Factory, Alteryx, and XSLT.
  • Excellent analytical, problem-solving, and documentation skills.
  • Effective communication and teamwork abilities.
  • Adaptability to a dynamic and fast-paced work environment.
Preferred Qualifications
  • Certifications in Azure, Alteryx, or relevant fields.
  • Experience in the financial or professional services industries.
  • Knowledge of additional ETL tools and technologies.
What's in it for you?Pathways for career development
  • Work with colleagues and clients around the world on interesting and challenging work.
  • We provide internal career opportunities, so you can take your career further within TMF.
  • Continuous development is supported through global learning opportunities from the TMF Business Academy.
Making an impact
  • You'll be helping us to make the world a simpler place to do business for our clients.
  • Through our corporate social responsibility program, you'll also be making a difference in the communities where we work.
A supportive environment
  • Strong feedback culture to help build an engaging workplace.
  • Our inclusive work environment allows you to work from our offices around the world, as well as from home, helping you find the right work-life balance to perform at your best.
Other Benefits
  • Marriage Gift policy
  • Paternity & Adoption leaves
  • Interest free loan policy
  • Salary advance policy
  • Covid support taskforce
  • Well being initiatives
Advertised: 24 Jan 2024 China Standard Time
Applications close: 19 Mar 2024 China Standard Time

TMF Group