ETL Tester

Jersey City, NJ, US • Posted 1 day ago • Updated 1 day ago
Full Time
No Travel Required
On-site
Depends on Experience
Company Branding Image
Fitment

Dice Job Match Score™

📊 Calculating match score...

Job Details

Skills

  • SQL
  • Autosys
  • ETL testing
  • Shell Scripting
  • IDMC/Informatica

Summary

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. 
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91143240
  • Position Id: 1771-30669-
  • Posted 1 day ago

Company Info

About K&K Global Talent Solutions

K&K Global Talents Solutions Inc: A New Era in the US Recruitment Industry With their partnership with a highly reputable German recruitment firm boasting over 30 years of experience, K&K Global Talents Solutions Inc. is an emerging player in the US recruitment industry. This collaboration allows them to merge the advantages of a new entrant with the vast knowledge and expertise of a well-established player. Clients and candidates are guaranteed to benefit from innovative recruitment approaches, cutting-edge strategies, and a wealth of knowledge and trust. K&K Global Talents represents the future of recruitment in both IT and Nursing industry, with a modern outlook and flexibility, combined with the methodologies that have sustained success for over 30 years, thanks to their esteemed German partner.

About_Company_OneAbout_Company_Two
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

It looks like there aren't any Similar Jobs for this job yet.

Search all similar jobs