NuStar Technologies · 11 hours ago
ETL Tester
Charlotte, NC
Full-time
Onsite
Senior Level, Lead/Staff
$100K/yr - $120K/yr
10+ years expNuStar Technologies is seeking an ETL Tester to analyze data mapping documents and business requirements. The role involves designing comprehensive test plans, performing data reconciliation, and automating test scripts to ensure data quality and transformation accuracy.
AnalyticsConsultingEnterprise Resource Planning (ERP)IT ManagementStaffing Agency
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
Qualification
Required
Minimum 10 years of experience
Primary Skill: ETL testing
Secondary Skills: ETL Testing, Autosys, SQL, Shell Scripting, Exposure to IDMC/Informatica
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)
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
Concept: Data Warehousing, Data Transformation, ETL/ELT, Data Quality
Preferred
Familiarity with Hadoop or Spark
Domain: Banking knowledge, Payments knowledge preferred
Company
NuStar Technologies
NuStar Technologies provides staffing, recruiting, cloud enablement, ERP implementation, analytics, web solution, and managed services.
11-50 employees
H1B Sponsorship
NuStar Technologies has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (1)
2023 (3)
2022 (1)
2020 (3)
Funding
Current Stage
Early StageCompany data provided by crunchbase