Wherever you're based and whatever your role at TMFGroup, one thing's for certain : you'll be part of a truly diverse,global business and benefit from the many advantages that brings.
ETL QA Tester Job no : 570190 Work type : Full time Location : Bogota,Colombia Categories : Information Technology Office Location : Colombia About TMF Group TMF Group is a leading global provider ofhigh-value business services to clients operating and investingglobally.
We focus on providing specialized and business-criticalfinancial and administrative services that enable our clients tooperate their corporate structures, finance vehicles and investmentfunds in different geographical locations.
Key Responsibilities : -ETL Testing :
Conduct thorough testing of ETL processes, with afocus on Azure Data Factory and Alteryx, to ensure data integrity,accuracy, and compliance with business rules.
Quality Assurancein Transformations : Implement quality assurance practices tovalidate the XSLT transformations and XML outputs.
Ensure thecorrectness and efficiency of the transformations. - Test PlanDevelopment : Develop detailed test plans and cases for ETLprocesses, particularly focusing on XSLT transformations and thegeneration of XML outputs.
- Automation of Test Procedures : Utilizeand develop automated testing tools and scripts to enhance theefficiency and accuracy of the testing process.
- Web ServiceIntegration Testing : Focus on testing web service integrations,ensuring seamless connectivity and data exchange between varioussystems and services.
- Performance Testing : Assess the performanceof ETL processes, especially those involving complex XSLTtransformations, to ensure they meet the desired efficiency andspeed benchmarks.
- Defect Identification and Resolution : Identify,document,
and report any issues or discrepancies found in ETLprocesses or XSLT transformations.
Work collaboratively with theteam for timely resolutions. - Data Security and Compliance : Ensureall ETL processes, including XSLT transformations, adhere to datasecurity standards and compliance requirements.
- Collaboration andCommunication : Work closely with cross-functional teams, includingdevelopment, data engineering, and business units, to understandrequirements and provide feedback.
- Documentation and Reporting : Maintain clear and comprehensive documentation of ETL testprocesses, test plans, test cases, and findings for futurereference and audits.
Key Requirements : - Proficiency in ETLtesting, particularly with Azure Data Factory and Alteryx. - Strongexperience in writing and testing XSLT transformations for XMLoutputs.
- Familiarity with automated testing tools like Jenkins,SOAPUI, or any similar industry standard. - Knowledge of SQL andexperience with database management systems.
- Understanding ofperformance testing methodologies. - Experience in data securityand compliance in ETL processes. Key Knowledge and Experience : -Bachelor's degree in computer science, Information Technology, or arelated field.
- Proven experience in ETL Testing script writingand execution. - 3-4 years of experience in ETL development,preferably with HRIS systems.
- Strong analytical andproblem-solving skills. - Excellent communication and projectmanagement abilities. - Demonstrated experience with Azure DataFactory, Alteryx, and XSLT.
- Excellent analytical,problem-solving, and documentation skills. - Effectivecommunication and teamwork abilities.
- Adaptability to a dynamicand fast-paced work environment.
Preferred Qualifications : -Certifications in Azure, Alteryx, or relevant fields. - Experiencein the financial or professional services industries.
- Knowledgeof additional ETL tools and technologies. Advertised : 06 Nov 2024SA Pacific Standard Time Applications close : 05 Dec 2024 SA PacificStandard Time #J-18808-Ljbffr