ETL Developer

As a Full-time ETL Specialist based in Pune, your key functions and responsibilities will include: - Serving as a technical Subject Matter Expert (SME) to provide detailed explanations of ETL specifications and addressing queries related to ETL technology. - Ensuring alignment of file transformation and integration solutions with the local Alteryx team. - Implementing data validation rules to verify accuracy and completeness before importing data. - Reviewing and rectifying any encountered errors during the data transformation process. - Developing and optimizing data pipelines using tools such as Alteryx, Azure Data Factory, or both. - Leading or supporting data transformation projects to ensure they align with key business objectives. - Conducting Unit Testing, data quality assurance, and debugging of source code implementations. - Peer reviewing existing source code to maintain quality standards. - Providing professional support in delivering TMF's Transformation Service to potential local and regional clients and offering guidance on the best fit to meet specific client requirements. - Maintaining a common codebase, delivering new features, and functionality. - Supporting the development and delivery of TMF Integration Service for clients utilizing other HCM solutions. - Periodically reviewing solution optimization, documenting process improvements, and collaborating with other IT and Platform Services to roadmap improvements. - Ensuring that transformation solutions are updated to handle ongoing country deviations and global functionality enhancements. - Collaborating with TMF IT development and local offices to build client integration files transformation for processing by TMF Local Offices. - Supporting complex client technology transformation projects, including leading business requirement gathering and blueprinting phases. - Ensuring completeness, currency, and appropriate sharing of documentation and internal communications related to the evolution of HRP Integrations. - Tracking, escalating, and supporting the resolution of transformation solution or API integration issues. - Sharing knowledge and contributing to internal discussion forums to enhance TMF's HRP global offerings and the related on-boarding process. In terms of technical skills, you should possess: - 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. - Strong SQL skills with the ability to write complex queries. - Familiarity with XML hierarchical structure, XPath, XSLT, and XML schema validation. - Experience with APIs outputting data in XML format, including SOAP and REST API data integrations. - Capability to transform XML data into other formats like JSON, CSV, or database. - Familiarity with Python, C, data warehousing, modeling, and ETL process design. - Experience with Azure services like Azure SQL Database, Blob Storage, and Data Lake. - Knowledge of Azure Data Factory's Mapping Data Flow for visual data transformation and Azure-based or Alteryx ETL workflow, pipeline orchestration, and monitoring. To qualify for this role, you should have: - A 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. Preferred qualifications include: - Certifications in AZURE Data Factory, Alteryx, or relevant areas. - Experience in HR, financial, or professional services industries. - Knowledge of additional ETL tools and technologies. This opportunity is based in Pune and offers a stimulating environment for individuals seeking to expand their expertise in ETL development and data transformation. Applications for this position will be accepted until 31 August 2024 (India Standard Time).,