ETL DEVELOPER

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 on  our career website.
About TMF Group TMF Group is a leading provider of administrative services, helping clients invest and operate safely around the world.
As we’re a global company with + colleagues based in over 125 offices across 87 jurisdictions, we actively seek out people with the talent and potential to flourish at TMF Group, whatever their background, and offer job opportunities to the broadest spectrum of people.
Once on board we nurture and promote talented individuals, making sure that senior positions are open to all.
TMF India is a Great Place to Work, ISO & ISAE certified organization.
Key Responsibilities.
Act as a technical SME to explain the ETL specifications, clarifying questions related to ETL technology.
Mapping of the finalized data elements to the corresponding data field of the payroll engine.
Align the file transformation and integration solution with the local Alteryx team.
Develop ETL solutions to integrate the HRP PLATFORM into the local payroll system.
Implement data validation rules to check for accuracy and completeness before import.
Test import/ API integration to ensure data is correctly processed by the payroll engine.
Review and rectify any errors encountered.
Develop and optimize data pipelines using tools like Alteryx or Azure Data Factory or both.
Collaborate with cross-functional teams, technical business analyst and Payroll Business Analyst to gather and translate business requirements into code.
Lead or support data transformation projects, ensuring alignment with key business objectives.
Conduct Unit Testing and data quality assurance and debugging of implemented source code.
Peer Review of existing source code Provide professional support and input into delivering TMF's Transformation Service offering to prospective local and regional clients and guidance into the best fit to meet a client's specific requirements in collaboration with Business and Technical Stake Holders.
Maintain a common codebase and deliver new features and functionality.
Support the development and delivery of TMF Integration Service for clients utilizing other HCM solutions.
Undertake periodic reviews of solution optimization, document process improvements and work with other IT and Platform Services to roadmap the improvements.
Ensure transformation solutions are maintained to manage ongoing country deviations/global functionality enhancements.
Work with local offices and TMF IT development to build transformation of client integration files for processing by TMF Local Offices Supports complex client technology transformation projects including leading the business requirement gathering and ownership of blueprinting phase.
Support technical SME on all transforming data to payroll platform solutions.
Ensure documentation and internal communications relating to the evolution of the HRP Integrations are complete, current, and appropriately shared.  This could include high-level training/webinars.
Track, escalate and support the resolution of transformation solution or API integration.
Share Knowledge & contribute to internal discussion forums with initiatives aimed at improving and promoting both the way TMF structures its HRP global offerings and the related global on-boarding process.
Key Requirements.
Proficiency in Azure Data Factory or Alteryx for data integration and transformation.
Experience in designing and implementing data integration solutions using Azure Data Factory or Alteryx or both.
Strong SQL skills ability to write complex queries.
Familiarity with the hierarchical structure of XML, including elements, attributes, and nesting.
Skills in XPath to navigate through elements and attributes in XML documents.
Understanding of XSLT for transforming XML documents into other formats.
Ability to validate XML documents against a defined schema (XSD) for data consistency and structure.
Experience with APIs that output data in XML format, including parsing and handling the data.
Hands on experience with SOAP and REST API data integrations and API Tools.
Capability to transform XML data into other formats like JSON, CSV, or into a database.
Familiarity with Python, or C# for scripting in Azure environments.
Understanding of data warehousing, modelling, and ETL process design.
Ability to optimize ETL workflows and ensure data quality and security.
Experience with Azure services like Azure SQL Database, Blob Storage, and Data Lake.
Familiarity with Azure Data Factory's Mapping Data Flow for visual data transformation.
Knowledge of Azure-based or Alteryx ETL workflow, pipeline orchestration and monitoring.
Key knowledge and experience.
Bachelor’s degree in computer science, Engineering, or a related field.
3-4 years of experience in ETL development, preferably with HRIS systems.
Strong analytical and problem-solving skills.
Excellent communication and project management abilities.
Certifications in AZURE Data Factory, or Alteryx, or relevant areas.
Experience in the HR or 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.
01 Oct India Standard Time Applications close.
30 Nov India Standard Time