ETL Tester

Hello


Greetings!!!


This is Sakshi from Jconnect INC . Below is the requirement with my client. Please let me know if you are available for this role.

Title: ETL Tester


Location: Charlotte,NC ;Plano,TX;


Duration: Full Time

JOB DESCRIPTION :


Primary Skil: 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.


If you are interested, please send me your updated resume ASAP with below details:


Full Name:


Current Location/Zip:


Contact Number:


E-Mail Id:


Alternate Email Id:


Visa/Work Permit Status:


Current Rate/Salary:


Expected Base Salary:


Notice Period/Availability to Start:


Skype ID:


Willingness to relocate to job location:


Any Relocation Concern (family/house/weather):


Current/Previous Employer Name:


Preferred Interview timings (Specify Time zone):


Any other job opportunity in process & at which stage:


Overall Experience Summary:


LinkedIn URL:


Looking forward for your response..

Thanks and Regards,

Sakshi Tripathi


Jconnect Infotech Inc.


168 Barclay Center Ste. 347,


Cherry Hill, NJ 08034


Email: View email address on click.appcast.io


LinkedIn ID:

The contents of this email message and any attachments are intended solely for the addressee(s) and may contain confidential and/or privileged information and may be legally protected from disclosure. If you are not the intended recipient of this message or their agent, or if this message has been addressed to you in error, please immediately alert the sender by reply email and then delete this message and any attachments. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited.