Demo

Informatica workflow Tester

Infinite Computer Solutions
Berkeley Heights, NJ Full Time
POSTED ON 4/1/2025
AVAILABLE BEFORE 5/1/2025

Skill : Informatica ETL Tester

Location : Berkeley Heights, NJ(Onsite)

No of position : 5

We are seeking a highly skilled and detail-oriented Senior ETL Tester with expertise in Informatica IDMC testing, SQL, Snowflake (or similar RDBMS), and Control-M job scheduling. The ideal candidate will be responsible for validating ETL processes, ensuring data integrity, and supporting end-to-end testing of data pipelines in a dynamic and fast-paced environment.

Key Responsibilities :

  • Develop, execute, and maintain test plans, test cases, and test scripts for ETL processes using Informatica (IDMC).
  • Validate data transformations, mappings, and workflows against business requirements and technical specifications.
  • Write, execute, and debug SQL queries to verify data accuracy and integrity across various databases, including Snowflake or other RDBMS.
  • Perform data validation testing to ensure accuracy, completeness, and compliance with requirements.
  • Schedule, monitor, and execute ETL jobs using Control-M, ensuring job dependencies and timing requirements are met.
  • Collaborate with data engineers, developers, and analysts to identify and resolve ETL and data quality issues.
  • Perform root cause analysis on data discrepancies and provide recommendations for improvements.
  • Document testing processes, results, and defects while ensuring proper traceability and audit readiness.

Required Qualifications :

  • Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent experience).
  • 8 years of experience in ETL testing with strong expertise in Informatica (IDMC).
  • Proficiency in writing and executing complex SQL queries for data validation.
  • Hands-on experience with Snowflake or other relational database management systems (RDBMS).
  • Experience in job scheduling and monitoring using Control-M or similar tools.
  • Strong understanding of data warehouse and ETL concepts, including data transformations, workflows, and mappings.
  • Familiarity with Agile development methodologies and testing processes.
  • Excellent analytical, problem-solving, and communication skills.
  • Experience with cloud-based data platforms and modern data architectures.
  • Knowledge of scripting languages like Python or Shell for data and test automation.
  • Certification in Informatica or Snowflake is a plus.
  • Experience with test automation tools and frameworks for data testing.
  • If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Informatica workflow Tester?

    Sign up to receive alerts about other jobs on the Informatica workflow Tester career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $88,790 - $110,816
    Income Estimation: 
    $107,385 - $134,565
    Income Estimation: 
    $91,609 - $116,575
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $68,745 - $88,154
    Income Estimation: 
    $87,428 - $116,878
    Income Estimation: 
    $91,609 - $116,575
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $151,182 - $194,086
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Infinite Computer Solutions

    Infinite Computer Solutions
    Hired Organization Address Addison, TX Full Time
    Model Development : Collaborate with data scientists to develop, train, and validate machine learning models.Implement a...
    Infinite Computer Solutions
    Hired Organization Address Alpharetta, GA Full Time
    Key Responsibilities: Splunk Architecture & Implementation: Design and implement scalable, distributed Splunk environmen...
    Infinite Computer Solutions
    Hired Organization Address Orlando, FL Full Time
    Job Details Java Tester Start Date.07 Apr 2025 End Date.31 Dec 2025 Location: ORLANDO,FL Required skills : Strong backgr...
    Infinite Computer Solutions
    Hired Organization Address Tampa, FL Full Time
    Job Details Infrastructure Specialist (AWS Platform) Start Date.10 Apr 2025 End Date.31 Dec 2026 Location: TAMPA FL Skil...

    Not the job you're looking for? Here are some other Informatica workflow Tester jobs in the Berkeley Heights, NJ area that may be a better fit.

    Informatica Architect

    krg technology inc, Berkeley Heights, NJ

    ETL Informatica Developer

    M2mcs, Woodbridge, NJ

    AI Assistant is available now!

    Feel free to start your new journey!