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.
...Proposal Writer Mobile Healthcare To Apply Now - email your resume to ****@*****.*** Who: Mobile healthcare company seeking a detail-oriented and experienced proposal writer. What: You will create compelling proposals for local governments...
...JOB TITLE ( 1478 ): Physician Assistant / Gastroenterology - Bronx, NY Open to new grads (for Part-time applicants, must have experience in the specialty) Impact Recruiting Solutions is currently seeking a Physician Assistant to fill an opening with a multi-specialty...
...Role: Snowflake Engineer Location: Plano, TX 75024 (Onsite) Duration: Contract Job Description: Proficient knowledge in Snowflake basics. Basic knowledge in Python. Must be able to debug python scripts. Solid understanding in end to...
...The Global Operations Supply Chain Director is responsible for leading and optimizing Ormcos end-to-end global supply chain across multiple manufacturing sites. This role integrates strategic leadership, global materials management, production planning, logistics, regulatory...
...**Job Summary:**Humano is looking for a Warehouse Inventory Control Associate to join our team. The role involves operating an Order Picker (OP) to complete daily cycle count lists. This individual will receive a count list each day and escalate any issues to the Inventory...