ETL Tester

Mandate : ETL Testing ,MS SQL ServerGood to have : Informatica ,Snowflake , AWS/Azure , Lead level experience

Budget : LPA(Depending on experience level)

Total Experience -6+ years

Relevant Experience -6+ years
Work 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 applications through the creation of discrete business services and their supporting components.

Job Description :
Designs and builds test framework to test the end-to-end solution on the validation of the product.
Requires knowledge of best practices in the areas of design, development, and testing.
Brings collaborative ideas on testing improvements shared among different test groups and organizations.
Requires knowledge of writing and running automated tests with direction from the Software Engineering 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 and
procedures, 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 implements them for thorough test coverage.
Creates integration test plans for smaller projects.
Develops and implements test plans and scripts for quality and performance without
impacting application integrity.
Develops and maintains negative test cases and scripts to ensure database integrity and
application functionality.
Maintains manual and automated test scripts and recommends modification as per
requirements.
Performs statistical tests on large datasets to determine data quality, integrity and
performance.
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 provides
recommendations for improvement in both standards and practices. Leads code reviews for peers 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 Systems or equivalent preferred and a minimum of four (4) + years of relevant technology job experience.
Understanding of financial terms and concepts is preferred. Knowledge of mortgage specific terminology, 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.

Job Type: Full-time

Pay: ₹1,200, ₹2,000,000.00 per year

Experience:

• ETL: 7 years (Required)
• MS SQL: 7 years (Required)
• Informatica: 6 years (Required)
• Snowflake: 6 years (Required)
• AWS: 6 years (Required)
• AZU: 6 years (Required)
• Confluence: 6 years (Required)
• TFS: 6 years (Required)
• Jira: 6 years (Required)

Location:

• Kochin, Kerala (Preferred)

Work Location: In person