ETL TESTER

Review system requirements and design documents, then create, execute and document detailed, accurate test cases.
Analyze, develop, debug, execute, maintain, and document test cases.
Help define test data and environment requirements.
Log defects, help resolve them.
Provide support to your technology peers and the business. join forces to identify solutions.
Play an active role in developing test strategies and plans, traceability matrices and test closure reports, for small to moderately complex projects.
Offer day-to-day test environment support, trouble shoot, triage issues, coordinate resolution with all tech partners.
Promptly identify and raise awareness of issues. quickly resolve them.
Find ways to improve processes and delivery outcomes.
Promote and develop awareness of testing methodologies and standards.
Support automation and test data management strategies.
May support and maintain virtualized services, components and environments by using Service Virtualization tools to enable functional and non-functional testing.
May develop, debug, execute and maintain performance testing scripts using various performance testing tools.
Respect TD's technology delivery practices, standards and project management disciplines.
Continuously enhance knowledge and expertise, keep current.
Coach colleagues and act as a reference for the requirements management life cycle.
Identify testing risks within projects and provide testing solutions/processes to mitigate the risks
Technical testing certificate such as ASQ CSQE or ISTQB.
Knowledge of testing methodology, best practices and processes (including but not limited to automation, performance and data management methodologies).
Talent in testing risks within projects and recommending ways to mitigate them.
Adherence to prescribed testing processes, and identify, assess and address risks
Advanced knowledge of SQL
Experience in working with complex data sources like SQL and no SQL databases, XML files, fixed length files, multi-segmented clustered and un-clustered files etc.
Experience in Hadoop ecosystem including strong understanding of HQL, HDFS data storage, data partitioning and data ingestion/extraction via scoop/oozie
Have hands on ETL testing and test automation experience using in-house automation framework or industry ETL testing tools
Experience with one of programming/scripting language – Java, Python, Jquery, javascript, Angular, VBA etc
Hands-on experience with Unix/Shell/Bash scripting
Knowledge of Cucumber, Bitbucket – Good to have
Have working knowledge of Jira and Confluence
Working experience with Tableau - Good to have
Hands on expertise in a variety of test automation frameworks/tools (e.g., Robot Framework / Selenium) and coding using any languages (e.g., Python, Bash, Java)
Experience in DevOps operations (with tools like Jenkins) and test integration, processes and tools (Client ALM, JIRA, etc.), source configuration tools (GIT, Bitbucket.)
Expertise on core Python and object oriented programing
• Good command over using libraries Pandas, NumPy etc. and experience handling different file formats
• Experience on developing/maintaining cloud automation framework using Pyspark