ETL Tester
Charlotte NC
Fulltime
Face to face is must
Must Have Technical/Functional Skills
Primary Skill: 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.
...you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a ServiceNow Developer to join our team in Bangalore, Karntaka (IN-KA), India (IN). Design, build, and maintain ServiceNow catalog items, including...
...About Us TheraPeds Partners is a therapist-owned and operated organization. We partner with schools to provide American Sign Language Interpreter (ASL) services to PreK12 students nationwide. As a team of special education providers, we understand the education...
...5. Appointment levels will be dependent upon the pilots FAA ratings, their proficiency, and their job responsibilities within the Aviation Unit. Pilots hired by the Division will be required to enter into a binding agreement whereby they become financially responsible...
...About us: Do you love storytelling and want to make a lasting impact on students' lives? Vanguard College Prep is seeking full-time Essay Specialists to help high schoolers craft authentic, powerful application essays. Our specialists don't just edit words they shape...
The SCHOOL NURSE provides nursing services to the student population in various environments. The school Nurse works cooperatively with... ...healthcare, we want you to join us! We are currently looking for LPN's-Licensed Practical Nurses for School Nursing both full time and...