The Python Developer will be responsible for the following tasks:
a. Requirement Analysis:
Review and understand the existing Excel-based calculations.
Identify the key functionalities and logic implemented in the Excel sheets.
Collaborate with stakeholders to gather additional requirements and clarify any ambiguities.
b. Code Conversion:
Convert the Excel-based calculations to Python code, ensuring accuracy and consistency.
Optimize the Python code for performance and scalability.
Implement error handling and validation to ensure robustness.
c. Documentation:
Document the existing Excel-based calculations, including formulas, macros, and data flows.
Create comprehensive documentation for the Python code, including code comments, user guides, and technical specifications.
Maintain an organized repository of all project documentation.
d. Testing and Validation:
Develop and execute test cases to validate the accuracy and performance of the Python code.
Compare the results of the Python code with the original Excel calculations to ensure consistency.
Address any discrepancies and refine the code as needed.
e. Optimization and Best Practices:
Identify and implement the most efficient methods for migrating calculations from Excel to Python.
Follow best practices for coding, documentation, and version control.
Provide recommendations for further improvements and optimizations.
"Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."