ETL Tester-7
Looking for more job opportunities? Click here!
Job Type: Contract
Job Category: IT
Role: ETL TesterLocation: Charlotte, NC (Onsite)
Contract
Job Description
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, Payment’s knowledge preferred.
Concept: Data Warehousing, Data Transformation, ETL/ELT, Data Quality.
Required Skills
JUNIOR CHEMICAL TESTER
PERFORMANCE TESTERS
Recommended Jobs
Beef Shoppe/Seafood Clerk PT Asheboro NC
Beef Shoppe/Seafood Clerk PT Asheboro NC at Lowes Foods summary: CVWalletExtranet.Domain.Entities.JobShortDescription Overview: To provide excellent guest service through meat and seafood depa…
Nanny
We are looking for someone who is open-minded, adapt to a Vegan lifestyle, and team up with the parents who are working from home to take care of 4 years old toddler during the weekday afternoons, and…
Account Executive - Fire Solutions
A region leading Security and Fire Integration organization is expanding and looking to bring on a talented Fire Account Executive in the Charlotte metro area to add to their culture and success.…
Architect Positions
Carlton Edwards is seeking a talented Project Manager/Architect to join our dynamic team. In this role, you’ll oversee the planning, design, and execution of cutting-edge architectural projects, ensur…
Maintenance Mechanic
Are you a skilled mechanic eager to apply your expertise in a great team environment? At Jackson Paper Mfg, you'll work on diverse mechanical equipment, interpret technical drawings, and contribute d…
Class A Truck Driver Job
Class A Truck Driver Job Transport goods and materials safely and efficiently to various locations across the United States. Comply with all applicable traffic and safety regulations. Maintain accu…
Assistant Director of Career Services
: The Assistant Director works collaboratively within the Employer Relations Team of ECU Career Services to provide opportunities for engagement between employers and students. The Assistant Director…
Internal Medicine Physician - Tarboro, North Carolina
Internal Medicine Physician – Tarboro, North Carolina An established multispecialty medical clinic in historic Tarboro, North Carolina is seeking a Board Eligible or Board Certified Internal …
Nurse Practitioner Core
Job Responsibilities: Evaluate, make recommendations, co-manage and treat patients' medical needs for safe and high-quality treatment. Document all patient care within an electronic health reco…
Dental Hygiene Assistant
Riccobene Associates Family Dentistry is looking for a full time Dental/Hygiene Assistant for our Porters Neck location! Are you tired of going to work with no sense of fulfillment, happiness or…