ETL Tester Job at JConnect Infotech, Plano, TX

  • JConnect Infotech
  • Plano, TX

Job Description

ETL Tester

Primary Skill: ETL testing

Secondary: ETL Testing, Autosys, SQL, Shell Scripting, Exposure to IDMC/Informatica

Experience: Minimum 10 years

Roles & Responsibilities:

  • Analyze data mapping documents and business requirements to design comprehensive test plans and cases.
  • Perform source-to-target data reconciliation, check data loading, and ensure transformation rules are applied correctly.
  • Write complex SQL scripts for validation (count, data completeness, data consistency, data truncation).
  • Identify, log, and track data defects using tools like JIRA or HP ALM or Octane.
  • Automate test scripts and validate data volume, performance, and scalability.
  • Expert-level knowledge of SQL for data analysis.
  • Experience with tools such as Informatica and IDMC.
  • Understanding of data warehouse concepts and architectures (e.g., star/snowflake schema).
  • Familiarity with Hadoop or Spark is often preferred.
  • Validate HiveQL, HDFS file structures, and data processing within the Hadoop cluster.
  • Strong analytical and troubleshooting skills.
  • Excellent communication for collaborating with developers and stakeholders.
  • Knowledge in Metadata dependent ETL process and batch/job framework

Tools & Skills: IDMC, Informatica Power center, Hive, Kafka Knowledge SQL, Oracle, PL/SQL

Domain: Banking knowledge, Payments knowledge preferred. Concept: Data Warehousing, Data Transformation, ETL/ELT, Data Quality.

Job Tags

Similar Jobs

Employbridge Career

Bilingual Staffing Agency Recruiter in Fairfield, OH Job at Employbridge Career

 ...of various positions and held accountable to meeting specific staffing goals (time to fill, diversity hiring, recruiting compliance, etc...  ...media channels Owns and writes effective content for online job postings to attract both active and passive candidates via... 

Virtual Vocations Inc

SAP SD Consultant Job at Virtual Vocations Inc

 ...Seeking a skilled SAP SD Consultant, the contract position offers a fully remote opportunity for an individual with extensive experience in end-to-end Order-to-Cash (O2C) implementations and a strong background in SAP SD/S/4HANA Sales & Distribution.Key responsibilities... 

GrabJobs

Remote Customer Success Manager Job at GrabJobs

 ...About the role:Customer Success Managers (CSM) own the post-sales experience at PetDesk, driving adoption and retention and maximizing the return on a customers technology investment. CSMs are responsible for ensuring the overall success of 400+ accounts. They are adept... 

St. Luke's College of Health Sciences

Driver, Community Activities - Wellspring Clubhouse Job at St. Luke's College of Health Sciences

 ...regardless of a patient's ability to pay for health care. Hours: Part-time, 16 hours/week Responsible for providing transportation of...  ...exterior of the vehicle to ensure cleanliness. Adheres to driving rules and regulations. Reports vehicle problems to the... 

Apex Systems

Revenue Specialist Job at Apex Systems

 ...Quick Service Restaurant (QSR) or retail industry. Everforth Apex is a world-class IT services company that serves thousands of clients...  ...an Everforth Apex team member can provide. Everforth Apex Systems is an equal opportunity employer. We do not discriminate or...