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

StudyPoint

Tutor - Sat/Act - Part-Time, In-Person Job at StudyPoint

 ...We are StudyPoint, a national leader in one-on-one tutoring. We operate in 19 markets nationwide as well as online, and we have worked...  ...Prime tutoring hours generally fall outside of school hours and on weekends. Your availability should include 6 or more hours per week and... 

DaVita

Patient Care Technician Job at DaVita

 ...Patient Care Technician DaVita is hiring a Patient Care Technician (PCT) to support patients with end-stage renal disease in an outpatient dialysis clinic. As a PCT, you'll provide direct, hands-on care under RN supervision, helping patients through life-sustaining... 

Central Peninsula Hospital

Clinical Informaticist Job at Central Peninsula Hospital

 ...Alaska and CPH seamless and stress-free.POSITION SUMMARYThe Clinical Informaticist provides mid-level support for system issues, focusing...  ...technology projects, helping to align clinical needs with informatics solutions while following established guidelines and best... 

gpac

Survey Party Chief Job at gpac

 ...established, growing engineering firm in your area is seeking 3+ Survey Party Chief to join their team. They have a work hard/play hard...  ...Microstation is a plus. What you will be doing: Supervise Land Surveying Projects Conduct on-site investigations... 

All Star Healthcare Solutions

Physician (MD/DO) - Radiology - General/Other in New York Job at All Star Healthcare Solutions

 ...wish Perform 2-4 daily fluoroscopic GI procedures.Mainly speech pathology. Employed position Work Schedule: Monday - Friday 8 am to 5 pm EST Remote: 1 weekend per month (1 day off is provided in the week following the weekend worked) Workload of 55-65 RVUs...