Software Developer
Id: AT0093
2023-07-20
· Review requirements and design documents with business analysts, developers, and project managers to confirm expected functionality with business needs.
· Develop Complex SQL Queries in Teradata, Oracle, etc.
· Develop Terraform Code to Build and Maintain Infrastructure in Azure.
· Develop Pipelines in git hub using Git Actions, to deploy the code into higher environments.
· Develop Pipelines to train and retrain the ML models, deploy them to higher environments.
· Design, engineer and develop information technology solutions using informatica, Synapse & ADF.
· Design, deploy data integration solutions in a test data ware housing involving complex data transformation, change and error handling using unit and integration testing, database testing.
· Implementation, evaluation and documentation of the developed test cases and test scenarios.
· Validation and development of data warehouse data, using complex SQL Queries in Teradata, oracle, etc. to perform data analysis and apply problem solving skills to explain why actual results do not match expected results.
· Validation of List reports, Drill Down reports, Drill through reports, cross tab reports in Tableau, Power Bl, SAP BO using SQL queries in Azure, Teradata, oracle, etc. and business requirements.
· Develop SQL Queries in Azure, Teradata, oracle, etc. to analyze data to prepare test cases that will accurately verify the data.
· Participate in project meetings/ design groups as a team member with other data analysts to design, engineer and develop test solutions.
· Design documents to build ETL maps to test the migration.
· Build manual and automated Scripts in Python.
· Build Complex, Sub Queries to compare the data between different source systems and the target systems using DB.
· Review the test results with the leads of the project and explaining all the conditions how the data has been populated in t he target tables or the extracts.
Qualification:
This position requires a minimum of a Bachelor’s degree in Computer Science, Computer Information Systems, Information Technology, or a combination of education and experience equating to a related degree.