ETL Tester

3 weeks ago

pune, India Mastek Full time
ETL Tester
As an ETL Tester, your primary responsibilities include manual testing for ETL testing, such as SQL, scripting languages, and tools like SSIS and Query surge. Able to test ETL processed efficiently. With 5 years of experience will have a strong foundation in data validation and be able to handle complex ETL processes. Here are some key roles and responsibilities:
Advanced Test Design and Execution:
Design and execute comprehensive test plans covering all aspects of the ETL process (extract, transform, load).
Create detailed test cases for functional, non-functional, and data quality testing.
Utilize SQL to write complex queries for data validation across source, staging, and target systems.
Perform performance testing to identify bottlenecks and ensure efficient data flow.
Data Quality Expertise:
Analyze data lineage to understand the flow of data throughout the ETL process.
Implement data profiling techniques to identify anomalies and inconsistencies in the data.
Design and execute test scripts to verify data accuracy, completeness, and validity based on business rules.
Work with data engineers to define and enforce data quality standards.
Automation and Tool Proficiency:
Develop and maintain automated test scripts using ETL testing tools or scripting languages (e.g., Python).
Integrate ETL testing into CI/CD pipelines for continuous validation.
Utilize data profiling tools to automate data quality checks.
Stay up-to-date on the latest ETL testing tools and technologies.
Collaboration and Communication:
Participate in requirements gathering sessions to understand business needs.
Effectively communicate test results and identify data quality issues to stakeholders (developers, data engineers, business analysts).
Work collaboratively with developers and data engineers to resolve data quality issues and improve ETL processes.
Document test plans, test cases, and defects clearly and concisely.
Must have:
• Strong understanding of DWH concepts and ETL testing methodology
• Design and execute comprehensive test plans covering all aspects of the ETL process and experience in testing Data Warehousing solutions using the MSBI stack (SSIS, SSAS, SSRS)
• Create detailed test cases for functional, non-functional, and data quality testing.
• Utilize SQL to write complex queries for data validation across source, staging, and target systems
• Good exposure migration approach for the cloud-based Data platform using Microsoft Azure.
• Work with data engineers to define and enforce data quality standards.
• Excellent documentation skills around producing and maintaining the Testing artifacts for BI projects.
• Hands on experience to carry out automation POCs by using Automation tool
• Effectively communicate test results and identify data quality issues to stakeholders (developers, data engineers, business analysts).
• Work collaboratively with developers and data engineers to resolve data quality issues and improve ETL processes.
• Document test plans, test cases, and defects clearly and concisely.
• Develop and maintain automated test scripts using ETL testing tools or scripting languages using Querysurge
Prefer to have:
• Integrate ETL testing into CI/CD pipelines for continuous validation.
• Utilize data profiling tools to automate data quality checks.
• Azure certification
• Participate in code reviews for ETL logic.
• Contribute to the development of ETL testing best practices within the organization.
• Explore and implement new data quality tools and methodologies
In summary, an ETL Tester developer plays a crucial role to support business intelligence and analytics initiatives within an organization.

  • ETL Tester

    1 week ago

    Pune, Maharashtra, India Pibythree Full time

    JobdescriptionETLTester (Informatica Powercenter andIICS)We are seekingdynamic and experienced ETL testers to join our dynamicteamInterestedcandidates can fill the form:RoleLocation: PuneIndiaRequirementsand skills1. 4years experience2.Design and develop test cases and test scenarios for ETL processesimplemented in Informatica PowerCenter andIICS.3....

  • Etl Testers

    3 weeks ago

    Pune, India Bultaminds Venture Full time

    Job Title ETL testers Work Experience 4years -7years **Skills**: ETL testing Location pune - Maharashtra, India **Skill Set: - ** - 4+ years of experience. - Experience in ETL testing, Strong in SQL queries - Hands on experience in Automated Test development; C# preferred - Agile concepts with JIRA knowledge

  • Etl Tester

    2 months ago

    Pune, Maharashtra, India Ashra Technologies Pvt Ltd Full time

    Greetings from Ashra Technologies we are hiring Job Role: ETL Tester Experience Required: 5+ Years Location: Pune, Mumbai Notice Period: Immeditae to 15 Days 5 + years of experience in ETL Testing/DWH Testing. - Strong understanding of data migration / transformation and its methodologies. - Extensive experience in Database/ETL data validations,...

  • Etl Testers

    1 week ago

    Pune, Maharashtra, India Bultaminds Venture Full time

    Job TitleETL testersWork Experience4years -7yearsSkills:ETL testingLocationpune - Maharashtra, India**Skill Set: - **- 4+ years of experience. Experience in ETL testing, Strong in SQL queries Hands on experience in Automated Test development; C# preferred Agile concepts with JIRA knowledge

  • ETL Tester

    1 month ago

    Pune, India Mastek Full time

    ETL TesterAs an ETL Tester, your primary responsibilities include manual testing for ETL testing, such as SQL, scripting languages, and tools like SSIS and Query surge. Able to test ETL processed efficiently. With 5 years of experience will have a strong foundation in data validation and be able to handle complex ETL processes. Here are some key roles and...

  • ETL Tester

    3 weeks ago

    Pune, India Mastek Full time

    ETL TesterAs an ETL Tester, your primary responsibilities include manual testing for ETL testing, such as SQL, scripting languages, and tools like SSIS and Query surge. Able to test ETL processed efficiently. With 5 years of experience will have a strong foundation in data validation and be able to handle complex ETL processes. Here are some key roles and...

  • ETL Tester

    3 weeks ago

    Pune, India Mastek Full time

    ETL TesterAs an ETL Tester, your primary responsibilities include manual testing for ETL testing, such as SQL, scripting languages, and tools like SSIS and Query surge. Able to test ETL processed efficiently. With 5 years of experience will have a strong foundation in data validation and be able to handle complex ETL processes. Here are some key roles and...

  • ETL Tester

    3 weeks ago

    Pune, India Mastek Full time

    ETL Tester As an ETL Tester, your primary responsibilities include manual testing for ETL testing, such as SQL, scripting languages, and tools like SSIS and Query surge. Able to test ETL processed efficiently. With 5 years of experience will have a strong foundation in data validation and be able to handle complex ETL processes. Here are some key roles and...

  • ETL Tester

    1 month ago

    Pune, India Mastek Full time

    ETL TesterAs an ETL Tester, your primary responsibilities include manual testing for ETL testing, such as SQL, scripting languages, and tools like SSIS and Query surge. Able to test ETL processed efficiently. With 5 years of experience will have a strong foundation in data validation and be able to handle complex ETL processes. Here are some key roles and...

  • ETL Tester

    1 week ago

    Pune, Maharashtra, India Mastek Full time

    ETL Tester As an ETL Tester, your primary responsibilities include manual testing for ETL testing, such as SQL, scripting languages, and tools like SSIS and Query surge. Able to test ETL processed efficiently. With 5 years of experience will have a strong foundation in data validation and be able to handle complex ETL processes. Here are some key roles and...

  • Etl Tester

    3 weeks ago

    Pune, India RAK SOFTECH PVT.LTD. Full time

    Urgent Requirement ETL Tester 4+ Years Experience Pune Bangalore Location Feel free to call Rupali - 7499870673 **Job Types**: Full-time, Regular / Permanent **Benefits**: - Cell phone reimbursement - Health insurance - Leave encashment - Provident Fund Schedule: - Day shift - Monday to Friday Ability to commute/relocate: - Pune, Maharashtra:...

  • Etl Tester

    1 week ago

    Pune, Maharashtra, India Aptra Technologies Pvt Ltd Full time

    Greetings of the day we are Hiring Job Role:Python with ETL Tester Experience:10+years Loactions:Pune/Chennai/Mumbai Below is the JD for your reference. - 10+ years of strong Data warehouse experience - Strong database (Oracle, MS SQL) skills in writing and optimizing SQL queries - 3+ years of experience in designing and developing cloud computing...

  • ETL Tester

    1 week ago

    Pune, India TMF Group Full time

    We never ask for payment as part of our selection process, and we always contact candidates via our corporate accounts and platforms. If you are approached for payment, this is likely to be fraudulent. Please check to see whether the role you are interested in is posted on  our career website. About TMF Group TMF Group helps its clients operate...

  • Etl Tester

    2 weeks ago

    Pune, India Citi Full time

    The IT Quality Intmd Analyst is a developing professional role. Deals with most problems independently and has some latitude to solve complex problems. Integrates in-depth specialty area knowledge with a solid understanding of industry standards and practices. Good understanding of how the team and area integrate with others in accomplishing the objectives...

  • Etl Tester

    3 weeks ago

    Pune, India Barclays Full time

    Job Title :ETL Tester Location: Pune About Barclays Barclays is a British universal bank. We are diversified by business, by different types of customers and clients, and by geography. Our businesses include consumer banking and payments operations around the world, as well as a top-tier, full service, global corporate and investment bank, all of which...

  • Etl Tester

    4 weeks ago

    Pune, India Synechron Full time

    Goodday, We have immediate opportunity for QA ETL Test Engineer. Job Role: QA ETL Test Engineer Job Location: Pune Hinjewadi Experience 5 to 8 Years. Notice Perod : Upto 15 days preferred. About Company: At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative...

  • ETL Tester

    1 week ago

    Pune, Maharashtra, India Synechron Full time

    Goodday, We have immediate opportunity for QA ETL Test Engineer. Job Role: QA ETL Test Engineer Job Location: Pune Hinjewadi Experience 5 to 8 Years. Notice Perod : Upto 15 days preferred. About Company: At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative...

  • ETL Tester

    1 week ago

    Pune, Maharashtra, India Synechron Full time

    Goodday,We have immediate opportunity for QA ETL Test Engineer.Job Role:QA ETL Test EngineerJob Location:Pune HinjewadiExperience5 to 8 YearsNotice Perod :Upto 15 days preferred.About Company:At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to...

  • Etl Tester

    1 week ago

    Pune, Maharashtra, India Skillety Technologies Full time

    1. Responsible for undertanding ETL requirements, Mapping documents and Transformation logicsResponsible for creating Test Strategy, Test scenarios,ScriptingStrong proficiency in SQL Queries, data validations and its variation among popular databasesWell versed in writing SQL queries - the ability to write joins and handling multiple tables.Strong knowledge...

  • ETL Tester

    2 months ago

    Pune, India Synechron Full time

    Goodday,We have immediate opportunity for QA ETL Test Engineer.Job Role: QA ETL Test EngineerJob Location: Pune HinjewadiExperience 5 to 8 Years.Notice Perod : Upto 15 days preferred.About Company:At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology...