Senior ETL Tester with Data Engineer Job at Cloud Analytics Technologies LLC, Jersey City, NJ

TVZzOC9CMG94Q01MSXV5OXNKUUhya2FrT2c9PQ==
  • Cloud Analytics Technologies LLC
  • Jersey City, NJ

Job Description

Job Details

JOB TITLE:  AZURE DATA ENGINEER

LOCATION:  JERSEY CITY, NJ (HYBRID)

DURATION: 24+ MONTHS CONTRACT

We are seeking a meticulous ETL QA Tester with 6+ years of experience, strong SQL skills and experience in ETL testing to ensure data integrity, accuracy, and completeness throughout our data transformation processes. This role demands flexibility in working hours to facilitate effective communication with developers and project teams across various time zones.

Key Responsibilities:
* Design, develop, and execute ETL test cases to validate data extraction, transformation, and loading processes.
* Write and execute complex SQL queries to perform data validation and back-end testing.
* Identify, report, and track defects systematically.
* Participate in project meetings and be available for discussions in US EST working hours as needed
* Clarify requirements when necessary and ensure comprehensive coverage of all requirements in the testing process.

Required Skills & Qualifications:
* Must-have: Strong SQL skills with hands-on experience in writing and optimizing complex queries
* Familiarity with data warehouses and data lake is a must.
* Experience in ETL Testing: Understanding of data extraction, transformation, and loading (ETL) processes.
* Knowledge of Agile Methodologies and Defect Tracking Tools: Familiarity with Agile development processes and proficiency in using defect tracking tools like JIRA.
* Data Validation & Reconciliation: Ability to compare large datasets between sources and targets.
* Experience with SQL DBMS Tools: Knowledge of database management systems such as Oracle, Denodo, Azure Databricks, SQL Server.
* Strong analytical and problem-solving skills with attention to detail.
* Excellent communication skills with the ability to work in a collaborative and fast-paced environment.

Good to Have:
* Knowledge of Python is an advantage.
* Knowledge of Azure Databricks is a plus.
* Familiarity with cloud platforms (AWS, Azure, Google Cloud Platform) and their data services is a plus.

Job Tags

Contract work,

Similar Jobs

Genesis Orthopedics & Sports Medicine

Orthopedic Spine Surgeon Job at Genesis Orthopedics & Sports Medicine

 ...Genesis Orthopedics & Sports Medicine is seeking a Board-Certified/Board-Eligible Orthopedic Spine Surgeon to join our rapidly growing private practice in the Chicagoland area. Our mission is to deliver high-value orthopedic care to patients across all socioeconomic... 

OM MANUFACTURING LLC

Farm/Orchard Supervisor Job at OM MANUFACTURING LLC

 ...management, soil health, irrigation, pest control, and harvest activities. The ideal candidate will bring a strong background in horticulture, agronomy, or sustainable crop production and will be committed to optimizing yield, quality, and long-term soil productivity.... 

IOC Company

Crane Operator (Certified) Job at IOC Company

 ...Description: A crane operator isa construction worker responsible for safely operating a crane to lift, move, and position heavy materials...  ...), TB ,75, LBCR, LBCW, Lattice Boom Crawler # Knowledge of road construction equipment and repair. # Knowledge of equipment... 

University of the Pacific

Assistant Athletic Director for Development Job at University of the Pacific

 ...Assistant Athletic Director for Development Job #: F00784 Location Syracuse, NY Pay Range: $110,000 - $117,000 Hours: Standard University business hours. 8:30am - 5:00pm (academic year)8:00am - 4:30pm (summer) Hours may vary based on operational... 

Augsburg University

Public Safety Officer Job at Augsburg University

 ...from underrepresented or marginalized backgrounds are encouraged to apply. Job Description Summary of Position The Public Safety Officer is responsible for fostering and maintaining a safe learning and working environment for the Augsburg University...