ETL Tester Job Description
ETL tester
provides efficient utilization of UNIX shell scripting with advanced Informatica concepts for key design solutions.
ETL Tester Duties & Responsibilities
To write an effective ETL tester job description, begin by listing detailed duties, responsibilities and expectations. We have included ETL tester job description templates that you can modify and use.
Sample responsibilities for this position include:
Knowledge of dimensional modeling and data warehouse concepts, such as star schemas, snowflakes, dimensions, facts
Ensure all sign offs on deliverables (overall test strategy, test plan, test cases, ) and that testing meets governance requirements
Responsible for ensuring quality of their work the work of the entire development team
Strong experience in of the following technologies preferred –Web API (MS ASP.Net), MVC, WCF, HTML5, CSS, JavaScript, JSON, SOAP, REST, JQuery, Java , .Net Framework, C#, Ab Initio
Create SIT test cases/test data and perform Test execution
Review Data Models, Data Mappings, Architectural Documentation to create/execute effective SIT Test Plans and SIT test cases
Validates data by running queries in the database and verify that the results match the expectations
Analyzes and troubleshoots erroneous results, determines the root cause of defects, logs the defects in HP Quality Center/ALM and enables defect management, including working with the development team on the resolution of Software related defects
Works closely with software development team (Business Analysts, Developers & other testers) to ensure timely and effective testing effort
Writing queries to extract data for test case data comparison
ETL Tester Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for ETL Tester
List any licenses or certifications required by the position: CSTE, ISTQB
Education for ETL Tester
Typically a job would require a certain level of education.
Employers hiring for the ETL tester job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Education, Engineering, Information Systems, Information Technology, Technical, Business, Computer Sciences, Business/Administration, Software Engineering
Skills for ETL Tester
Desired skills for ETL tester include:
Defect management process
ETL tools like Informatica
Risk Framework and mitigation
Talend
Enterprise Testing standards
Unix/Linux & Shell scripting
Both
Dimensional modeling and data warehouse concepts
Dimensions
Facts
Desired experience for ETL tester includes:
Review Data Models, Data Mappings, Architectural Documentation to create/execute effective SIT Test Plans and SIT test case
Validates data by running queries in the database and verify the results match the expectations
Analyzes and troubleshoots erroneous results, determines the root causes, logs the defects in HP Quality Center/ALM and enables defect management, including working with the development team on the resolution of Software related defects
Solid understanding of databases and systems and the ability to communicate effectively across groups
Self Starter, with strong confidence level
Flexible in thought and creative in approach to testing
ETL Tester Examples
1
ETL Tester Job Description
Job Description Example
Our company is looking for an ETL tester. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for ETL tester
- Review and understand BRDs/SRDs
- Ability to transform complex Business logic into SQL or PL/SQL queries
- Ability to run, read from, debug batch processes
- Works closely with the Software development team (Business Analysts, Developers & other testers) to ensure timely and effective testing effort
- Creating requirements traceability matrix (RTM)
- Perform Vibration testing, Shock test, Vibration Random test on sealed Relays
- Perform Internal Moisture, Screening Run-In (Miss Test), and Burn-In on sealed relays
- Perform all Environmental Testing as required
- Will be responsible to ensure quality of process and measurements are acceptable in accordance with the specifications
- Computer entries, such as time labor and job assignments for inventory control
Qualifications for ETL tester
- Reconciliation and Data Validation using SQL
- 5 years as Data warehouse developer or tester ( Must have)
- 3+ years QA/Testing Lifecycle
- 3+ years DB related testing
- 2+ years HP Quality Center/ ALM
- Natezza and Financial domain knowledge is an asset
2
ETL Tester Job Description
Job Description Example
Our growing company is looking for an ETL tester. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for ETL tester
- Experience with advanced SQL queries and scripting language (ex
- 1+ years of proven test experience in the range of Big Data architectures and frameworks including Hadoop ecosystem, Java, MapReduce, Pig, Hive, Hue, Oozie, Hbase, Ranger, Attunity
- 1 year of any application development experience (Preferably Java, ETL,Mainframe, LINUX/UNIX etc)
- Must be a self-starter with the ability to work on complex projects and analyses business requirements independently
- Must be able to identify and document testing issues and quality risks, participate in defect remediation
- Willingness to follow Agile Testing practices and guidelines, including Defect Management using HP ALM tool
- Actively participate in all test management activities like assessment, test strategies and test plans
- Experience testing ETL products especially Informatica 9.x or Oracle Data Integrator (ODI) and PL/SQL
- Experience with Data replication tools such as Oracle Golden Gate (OGG) or Informatica Data Replication (IDR)
- Publish meaningful metrics for effectiveness & coverage
Qualifications for ETL tester
- Hadoop experience is a bonus
- Risk or Capital Market related experience is an asset
- 2-5 years as Data warehouse tester ( Must have)
- Natezza and Financial domain knowledge is a MUST
- Bachelor Degree in Computer Science and/or Business
- Hands on Informatica experience
3
ETL Tester Job Description
Job Description Example
Our company is looking for an ETL tester. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for ETL tester
- Creating test plans and test cases for assigned modules
- Experience on ETL testing
- Knowledge on ETL tool and process
- Knowledge on basic Database objects and relational data model
- Experience on SQL query and script
- Testing experience with different file types
- ETL test validations and checks / Quality checks
- Test automation experience is huge plus
- Data profiling is plus
- Understanding of ETL requirements (source-to-target mappings)
Qualifications for ETL tester
- Testing experience with SQL Server & Microsoft Business Intelligence stack (SSIS, SSAS, SSRS)
- Testing experience with reporting and BI tools (Tableau a plus)
- The Quality Assurance QA works with the Project Lead, Solution Architect, Business Analyst and Quality Assurance Testing Team in the software testing life cycle and defect management
- Participate in data conversion Testing and data maintenance, authoring SQL queries to fetch the data between various databases, execute them and analyze the data
- Reviews application requirements and project documentation and asks follow-up questions as needed in order to gain a full understanding of requirements
- Define scope, execution plans, and coordinate test activities
4
ETL Tester Job Description
Job Description Example
Our company is looking for an ETL tester. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for ETL tester
- Writing basic SQLs to check record counts, data truncation, invalid datatypes, NULLs and data integrity
- Basic test cases for a ETL process (for a ETL process that loads data from files to SQL database and vise versa)
- How ETL testing is different from functional testing
- Involved in the design of product and project requirements / user stories
- Experience working in a Agile development environment
- Identify test approaches, coverage, requirement gaps and risks and risk remediation
- Ensures quality measures are included in the initial project design
- Writes detailed test strategies and plans, making full use of different test estimation techniques in
- Design appropriate test case repository
- Build and teach scrum team to populate test case repository
Qualifications for ETL tester
- Experience working on an Agile Scrum Team would be a great plus
- Develops documents and maintains functional and non-functional test cases and other test artifacts such as test data, data validation and test environments
- Conducts System & Integration Testing and develops test plans/test cases for modules to test all required functionalities and possible failure causes
- Own all aspects of a program from a QA perspective including but not limited to manual testing, functional testing, database testing, and regression testing
- Creates test scripts that translates the client’s business requirements into specific systems, applications or process designs for very large complex IT solutions
- Analyze and review the test results and documents for consistency & accuracy
5
ETL Tester Job Description
Job Description Example
Our growing company is looking to fill the role of ETL tester. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for ETL tester
- Participate in requirements meetings with business as input into test planning
- Prepare testing strategies, test plans, and test cases
- Design test cases based on business rules and data mapping documents
- Create Test Scripts (Requires strong background in SQL scripting)
- Execute the required ETL, Cubes and Reports validations
- Cube Testing – Browse the Cube using BIDS or SQL Server Management Studio and compare the output against the Mart using SQL Query
- Perform aggregate and comparative data analysis to ensure data flows and integrations are valid
- Log defects for failed test cases
- Work directly with project managers, SME’s, developers, to work towards successful project completion
- Experience in onshore/offshore team model
Qualifications for ETL tester
- Ensures QA standards are maintained and followed across the projects and phases
- Participate in Deployment Planning sessions and ensure all deployment checklist activities are covered
- Ensures the client's QA processes are followed throughout the test cycle
- Able to interpret situations and recognize where change and flexibility is required
- Provides feedback to project team and other internal customers on the production readiness of software
- Responsible for creating high level, mid-level and low level planning documents for team