Analyze and evaluate existing software and database management systems including several databases like Oracle and MS SQL Server to identify IT needs and assess system performance; develop Spark applications and create pipelines in Azure Data Factory for efficient data handling and batch processing techniques to ingest data into data lakes; focus on migrating data from on-premises systems to cloud applications, enhancing system capabilities and data accessibility; develop user interfaces, layout, and front-end programming using HTML for web applications that align with business requirements; create, modify, and test codes, scripts, and forms that facilitate running various types of applications; develop packages, procedures, and functions using PL/SQL as part of product enhancement efforts; document all aspects of an application or system project for future reference, maintenance, and upgrades. May need to work in other locations as required.