ETL Tester
Location: Remote
Duration : 6 months
Job Description
Minimum Position Qualifications -
6+ years of software product development and delivery experience.
5+ years of ETL testing/SQL experience.
3+ years of Informatica Power Center, IDQ, IICS/IDMC experience.
3+ years' experience overseeing the development of data test plans, test scenarios, test cases, execution of test case and documentation of test results
2+ years of experience in some of the Azure Cloud tools: ADF, Pyspark, databricks notebooks
2+ Experience with Python and libraries like Panads, Numpy & Matplotlib.
Ability to interpret and draw System & Architecture diagrams.
Experience in summarizing large number of metrics into meaningful graphs and reports.
Familiar with Latest Cloud Technologies.
Key Responsibilities:
Essential Job Functions:
Develop and support the complete life cycle of our Data Warehouse product which includes requirement analysis, Test Estimation, Test Planning, design test cases, traceability matrix, execution of test cases and support of Extract, Transform, Load (ETL/ELT) processes and environments.
Experience in Data Testing, Data Conversion, Data Migration, Data Transformations, Data Profiling, Data Analysis and Data Quality Validation
Experience in testing of ETL Mappings to extract data from multiple sources like Oracle, SQL Server, Flat files etc. into target tables using transformations like Expressions, Lookups, Source Qualifiers, Aggregators, Filters, and Joiners etc.
Hands on experience in design and implementation of E2E Data testing strategies and developing data testing automation frameworks.
Work on End-to-End product feature testing and Business Report Testing. Designing, testing, and troubleshooting data and reports.
Knowledge of any of database systems like SQL Server, Oracle or db2 etc and experience writing complex queries and creating stored procedures
Good understanding or knowledge in Azure Cloud, ADF.
Hands on experience & good exposure to Python, Pyspark, Databricks notebook.
Interact with project teams, development, operations, and infrastructure resources to recommend solutions to remediate data issues.
Experience in defect life cycle management - logging, replication, triaging, verification, closing, metrics reporting, etc.
Demonstrated ability to acquire high volumes of test data required to support Test execution.
Experience handling multiple programs simultaneously and work under offshore and Onsite model
Good understanding of Agile methodology.
Mentor and groom team members on product/application features/functionality and domain.
Working knowledge of test management tools like HP ALM/ Jira/ Qmetry
Excellent verbal and written communication skills.
Santosh Pal
IT Technical Recruiter
Phone : 201-578-5048
Email: Santosh@stellentit.com
Gtalk: Santosh@stellentit.com
...currently have an opening for a Turf Equipment Technician in our Berkeley, Missouri location.... ...candidate will be an outstanding mechanic with above average diagnostic, hydraulic... ...compressors, power tools etc. Safely operate a forklift. Maintain cleanliness and safety of...
...Clinical Office Coordinator Join the Team at Dependable Health Services Inc.! At Dependable Health Services Inc. , we know that our success starts and ends with our amazing employees. When you join us, you'll be working for a company renowned for its top-notch patient...
...Spokane Valley Dermatologist Job#16549803 Dermatology Physician Job Opening Spokane Valley, WA Join a leading dermatology practice located in the beautiful eastern part of Washington State, known for its commitment to exceptional patient care and a supportive work...
...offer more than just a jobwe provide stability, growth, and industry-leading benefits for our employees. As a large company serving... ...career while working with top-tier clients in the HVAC and refrigeration industry!Responsibilities: The Foreman serves as Technical...
...Interventional Radiologist West Reading, PA S eeking a collaborative and motivated Interventional Radiologist to join our team to replace a retiring physician. We are a cohesive group dedicated to high quality personalized patient care, continuous quality improvement...