ETL TESTER

Mandate

: ETL Testing ,MS SQL Server

Good to have

: Informatica ,Snowflake , AWS/Azure , Lead level experience

Budget

: 12 - 20 LPA

(Depending on experience level)

Total Experience -6+ years

Relevant Experience -6+ yearsWork Location -Cochin/TVM

Prefer

only KERALITES

, willing to work from office on hybrid mode.

Expected date of onboarding- Immediate – 30days

Job Purpose

Responsible for delivering innovative, compelling, coherent software solutions for our consumer,internal operations and value chain constituents across a wide variety of enterprise applicationsthrough the creation of discrete business services and their supporting components.▪ Designs and builds test framework to test the end-to-end solution on the validation of theproduct.▪ Requires knowledge of best practices in the areas of design, development, and testing.▪ Brings collaborative ideas on testing improvements shared among different test groups andorganizations.▪ Requires knowledge of writing and running automated tests with direction from the SoftwareEngineering Manager and/or Lead SDET.▪ Follows best coding practices and methods identified by the team.▪ Ensures the performance of all duties in accordance with the company’s policies andprocedures, all U.S. state and federal laws and regulations, wherein the company operates.

Duties And Responsibilities

▪ Reviews and translates requirements into functional and technical test cases and implementsthem for thorough test coverage.▪ Creates integration test plans for smaller projects.▪ Develops and implements test plans and scripts for quality and performance withoutimpacting application integrity.▪ Develops and maintains negative test cases and scripts to ensure database integrity andapplication functionality.▪ Maintains manual and automated test scripts and recommends modification as perrequirements.▪ Performs statistical tests on large datasets to determine data quality, integrity andperformance.▪ Evaluates system performance and design, as well as its effect on data integrity.▪ Collaborates with database developers to improve data collection and storage processes.▪ Runs data queries to identify coding issues and data exceptions, as well as cleaning data.▪ Gathers data from primary or secondary data sources to identify and interpret trends.▪ Ability to maintain multiple QA environments for multiple applications.▪ Adheres to coding and testing standards. Follows established best practices and providesrecommendations for improvement in both standards and practices. Leads code reviews forpeers and makes necessary adjustments. Contributes to coding standards.▪ Performs other duties and projects as assigned.▪ B.S. in Computer Science, B.S. Software Engineering or B.A. in Computer Information Systemsor equivalent preferred and a minimum of four (4) + years of relevant technology jobexperience.▪ Understanding of financial terms and concepts is preferred. Knowledge of mortgage specificterminology, concepts and systems is preferred.▪ Advance competence with Microsoft SQL Server

▪ Experience With Azure And Snowflake Preferred.

▪ Experience with TFS, JIRA, and Confluence preferred.▪ Minimum three (3) + years of experience working collaboratively in a team environment.▪ Experienced with several methods for analyzing data, log files, performance, etc.▪ To adhere to the Information Security Management policies and procedures.