ITC Infotech Bangalore Automation Engineer Posts | B.E/B.Tech/MCA | Apply Now

ITC Infotech is a specialized global full service IT consulting & outsourcing solutions provider.

In the latest job announcement, ITC Infotech announces job vacancies for Automation Engineer posts, with work location in Bangalore.

Under ITC Infotech Bangalore Automation Engineer 2023 Jobs, candidates having required skills in SQL, Java or Python can apply.

The selected candidate will be recruited with a permanent and full-time job.

An Interested and qualified candidate has to apply through online mode.

Job Designation: Automation Engineer.

Job Code: 38501.

Education Qualification: B.E/B.Tech/MCA.

Experience Level: 5 to 7 years.

Job Location: Bangalore. 

Apply Mode: Online.

Role:

• Create and execute scenarios to test various API. Preparing request block and analyzing the responses in JSON/XML formats. 
• Validate the flow of data from disparate sources ingested into multiple databases inside MySQL/Databricks, post which data is transformed by workflows built inside Azure Data Factory followed by Azure Databricks (ETL process). 
• Thoroughly test the ETL rules built for data transformation. 
• Test different source and target tables available in MySQL and Azure Databricks that are sourced, cleansed, transformed, joined, aggregated and final data sent in files or in Synapse tables 
• Develop test queries using SQL or Python or PySpark as per the user stories to validate the data inside various databases including Databricks. 
• Automate recurring QA processes through the use of SQL scripts or advanced languages such as Java or Python. Help design and build out an automation framework and automation suite that continually validates data.

Job Description:

• Excellent SQL skills and the ability to write complex queries.
• 2+ years working with Azure Data Factory
• 1+ year experience with Azure Databricks
• Experience in Python programming to deal with data or PySpark experience would be a plus.
• Good understanding of file formats including JSON, Parquet, Avro, and others
• Solid software engineering skills - participated in full lifecycle development on large projects.
• Create and execute scenarios to test various API. Preparing request block and analyzing the responses in JSON/XML formats.
• Validate the flow of data from disparate sources ingested into multiple databases inside MySQL/Databricks, post which data is transformed by workflows built inside Azure Data Factory followed by Azure Databricks (ETL process).
• Thoroughly test the ETL rules built for data transformation.
• Test different source and target tables available in MySQL and Azure Databricks that are sourced, cleansed, transformed, joined, aggregated and final data sent in files or in Synapse tables
• Develop test queries using SQL or Python or PySpark as per the user stories to validate the data inside various databases including Databricks.
• Automate recurring QA processes through the use of SQL scripts or advanced languages such as Java or Python.
• Help design and build out an automation framework and automation suite that continually validates data.
• Experience building basic workflows or data pipelines inside Azure Data Factory would be a plus. This would be a great add as certain repeated testing of data flows will need to be automated.
• Create and execute detailed manual test cases from information as related to functional requirements and technical specifications documentation to assure quality and accuracy.
• Log appropriate defects within Jira when product does not conform to specifications.
• Coordinate with development team members regarding defect validation and assist development team members with re-creating defects.
• Create appropriate test cases within TestRail Test Management tool.
• Update tasks information in Jira as appropriate to communicate progress with onshore test lead.

How to apply:

Interested and qualified job applicants have to apply through online mode, by initially registering with ITC Infotech career portal and login in to apply.

Apply online:

https://jobs.itcinfotech.com/#!/job-view/automation-engineer-bangalore-technical-infrastructure-cloud-azure-2023091810022613