Job Description
Genesis10 is seeking a Lead ETL Tester for a contract to hire position with a leading client in Columbus, OH. Our target pay rate is between $50.00 - $65.00 per hour on our W2. NBo C2C. This position is hybrid.
Responsibilities:
Actively participate in the review of project requirements, data mappings and technical design specifications.
Create test strategies and test plans for Data Warehouse projects, mapping back to the project requirements to ensure proper test coverage.
Execute test cases using manual and/or automated test processes.
Execute database queries to support test execution in Azure DevOps.
Perform ETL validation according to data mapping, execute data profiling, reconciliation of data, meta data validation, initial and delta validation for different SCD types.
Analyze data, troubleshoot data issues, and create action plans to address data quality issues.
Coordinate test execution with other application teams and UAT partners.
Create and communicate test status with project team members and stakeholders.
Identify, document, and communicate testing defects.
Collaborate with project team on defect analysis and triage.
Support continuous improvement by identifying and solving opportunities to define or enhance QA process.
Perform Functional, Regression, Negative and migration testing for the Data warehouse projects.
Requirements:
Bachelor's degree or military experience in related field (preferably computer science).
Minimum 2 years of experience with Snowflake and AWS Cloud
Minimum 5 years of ETL testing experience in data warehouse environment.
Minimum 5 years of experience analyzing data, troubleshooting data issues, and creating action plans to address data quality issues.
Minimum 5 years of experience writing SQL queries.
Understanding of enterprise data warehousing best practices and standards.
Experience leading QA Analysts on a project team.
Excellent verbal and written communications skills.
Highly motivated with strong organizational, analytical, and problem-solving skills.
Ability to effectively prioritize and execute tasks.
Preferred Qualifications
Experience in financial services (banking) industry.
Experience testing on Snowflake and AWS S3/EC2/EMR.
Genesis10 - Contract & Perm/Direct Hire
Ranked a Top Staffing Firm in the U.S. by Staffing Industry Analysts for six consecutive years, Genesis10 puts thousands of consultants and employees to work across the United States every year in contract, contract-for-hire, and permanent placement roles. With more than 300 active clients, Genesis10 provides access to many of the Fortune 100 firms and a variety of mid-market organizations across the full spectrum of industry verticals.
For contract roles, Genesis10 offers the benefits listed below. If this is a perm-placement opportunity, our recruiter can talk you through the unique benefits offered for that particular client.
Benefits of Working with Genesis10:
* Access to hundreds of clients, most who have been working with Genesis10 for 5-20+ years.
* The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for years.
* Access to an experienced, caring recruiting team (more than 7 years of experience, on average.)
* Behavioral Health Platform
* Medical, Dental, Vision
* Health Savings Account
* Voluntary Hospital Indemnity (Critical Illness & Accident)
* Voluntary Term Life Insurance
* 401K
* Sick Pay (for applicable states/municipalities)
* Commuter Benefits (Dallas, NYC, SF)
For multiple years running, Genesis10 has been recognized as a Top Staffing Firm in the U.S., as a Best Company for Work-Life Balance, as a Best Company for Career Growth, for Diversity, and for Leadership, amongst others. To learn more and to view all our available career opportunities, please visit us at our website.
Genesis10 is an Equal Opportunity Employer. Candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Genesis10 is an Equal Opportunity Employer/Minorities/Female/Disabled/Veteran
