ETL Tester

ETL Tester – Join Our Team .job-posting-container {font-family: Arial, sans-serif; line-height: 1.6; color: #333; margin: 0; padding: 20px; background-color: #ffffff; box-sizing: border-box;} .job-posting-container * {box-sizing: border-box;} .job-posting-content {background-color: #ffffff; padding: 30px; max-width: 800px; margin: 0 auto; box-shadow: 0 0 10px rgba(0,0,0,0.1); border-radius: 10px;} .job-posting-container h1, .job-posting-container h2 {color: #004080; margin: 15px 0;} .job-posting-container h1 {font-size: 22px;} .job-posting-container h2 {font-size: 20px; border-bottom: 1px solid #ccc; padding-bottom: 5px; margin-top: 30px;} .job-posting-container ul {margin-left: 20px;} .job-posting-container .section {margin-bottom: 25px;} .job-posting-container .highlight {background-color: #eef6ff; padding: 15px; border-left: 4px solid #004080; margin-bottom: 15px; border-radius: 5px;} .job-posting-container strong {color: #333;} .job-posting-container li {margin-bottom: 8px;} ETL Tester Location: Charlotte, North Carolina, USA | Employment Type: Full-Time | Pay Rate: $110/hour | Job Code: JB-JUM2IEM6 | Industry: IT | Tax Term: C2C Position Overview We are seeking an experienced ETL Tester with a minimum of 10 years of hands-on experience in data validation and quality assurance within enterprise environments. This role requires deep expertise in ETL processes, data warehouse validation, and complex SQL scripting to ensure data integrity across critical systems. Why Join Us? Work on challenging enterprise data projects with cutting-edge ETL technologies Collaborate with cross-functional teams in a dynamic IT environment Opportunity to leverage advanced tools including Informatica, IDMC, and Hadoop ecosystems Competitive compensation with professional growth opportunities Key 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 including count, data completeness, consistency, and truncation checks Identify, log, and track data defects using tools like JIRA, HP ALM, or Octane Automate test scripts and validate data volume, performance, and scalability requirements Validate HiveQL, HDFS file structures, and data processing within Hadoop clusters Qualifications Minimum 10 years of experience in ETL testing and data validation Expert-level knowledge of SQL for data analysis and complex query development Strong experience with Informatica PowerCenter and IDMC tools Understanding of data warehouse concepts including star and snowflake schemas Familiarity with Hadoop, Spark, Hive, and Kafka technologies Experience with Oracle, PL/SQL, and shell scripting Knowledge of metadata-dependent ETL processes and batch/job frameworks Strong analytical and troubleshooting skills with excellent communication abilities Preferred: Banking or payments domain knowledge Ready to Apply? If you meet the qualifications and are interested in this exciting opportunity, please reach out to discuss how your expertise aligns with this role. Contact: anji@dprsolutionsinc.com Phone: 5712236760 Take the next step in your career!