Big data Tester

krg technology inc; Detroit (MI); On-site; USD 80,000 - 100,000; Full time

Job summary

A data solutions company in Detroit seeks a Test Development Engineer to create and maintain test plans, collaborating closely with data analysts and developers. The ideal candidate has over four years of experience in BI/DW, is proficient in SQL, PL/SQL, and has hands-on experience with Hadoop and its tools. This role also emphasizes writing and troubleshooting SQL queries, and implementing scalable automation processes. Join a dynamic team focused on quality and data integrity in an agile environment.

Qualifications

• Four or more years of test development experience in Business Intelligence or Data Warehousing.
• Hands-on experience with Hadoop and tools such as Hive, Sqoop, Pig, Impala, and Spark.
• Demonstrated experience implementing automation frameworks using scripting languages like Shell, Java, and Python.

Responsibilities

• Create test plans, test data, data validation SQL scripts and analyze test results.
• Setup and maintain test environments.
• Collaborate with Data Analysts, ETL developers, and other stakeholders on requirements and design.

Skills

Data analysis

Data migration

Business intelligence solutions

SQL

PL/SQL

ETL processes

Automation frameworks

Hadoop

Agile methodologies

Scripting languages

Tools

Informatica

SQL Server

Tableau

Jenkins CI

Hive

Sqoop

Pig

Impala

Spark

Python

Job description

• Create test plans, test data , data validation SQL scripts and analyze test results
• setup and maintain test environments
• Design and test ETL processes in Oracle and Hadoop platforms
• Write and troubleshoot SQL queries and stored procedures
• Collaborate with Data Analysts, ETL developers, and other stakeholders on requirements and design
• Develop scalable and reusable processes and automation frameworks for analyzing data and delivering ongoing quality metrics (leveraging SQL, PL SQL, UNIX, PYTHON, HIVE and other tools)

Qualifications

• Four or more years of test development experience in BI/DW
• Expertise in Data analysis, Data migration, and Business intelligence solutions
• Hands-on experience with Hadoop and tools such as Hive, Sqoop, Pig, Impala and Spark is required
• Experience with Informatica is a plus
• Experience working on an Agile team using test driven development
• Strong understanding of Datawarehouse, Big Data and BI Analytics concepts
• Strong experience in SQL, PL/SQL Oracle, Informatica & Tableau
• Demonstrated experience implementing automation frameworks using scripting languages/tools like Shell, Java, Python
• Experience with Jenkins CI platform
• Deep knowledge and hands-on experience with iterative (Agile/Scrum) and waterfall development methodologies

Additional Information

All your information will be kept confidential according to EEO guidelines.