Job Description
Role - ETL Tester
Location - Plano, TX
Fulltime/FTE
Salary Range: $100000 to $110000/Annum
Job Description
Location : Charlotte,NC ;Plano,TX;
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 Client 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.
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Job Tags
Full time
Similar Jobs
Prisma Health
...America) Location Blount Memorial Hospital Facility 8001 Blount Memorial Hospital, Inc. Department 80016201 Orthopedic Surgery Share your talent with us! Our vision is simple: to transform healthcare for the benefits of the communities we serve...
o3schools
...Nestl USA is delighted to offer the Finance & Accounting Internship Program for students passionate about accounting and finance.Our program is open to all students who have a strong interest in a career in Accounting & Finance.The internship program is designed to...
HealthChannels
...HealthChannels, LLC is looking for a Medical Scribe to support healthcare teams by documenting patient visits in real-time. You will work alongside doctors, record medical histories, and ensure accurate patient charts.This role offers both part-time and full-time shifts...
AB Staffing Solutions
...Description Job Description Now hiring a qualified RN / Registered Nurse with Psychiatric or related nursing experience for a contract... ...Springs, MT! Local and travel candidates welcome to apply! Psych RN Pay: ~$3,486 weekly gross working 48 hours. ~$2,614...
Ohio Department of Education
...High School Spanish Teacher Highland Local School District Highland Local School District - Marengo, Ohio Open in Google Maps Highland High School is seeking qualified applicants for a High School Spanish Teacher position. Candidates must hold or be eligible to obtain...