ETL Tester-Data Migration Testing

Description:

Location : Charlotte,NC ;Plano,TX; Primary Skil: ETL testingSecondary: ETL Testing, Autosys, SQL, Shell Scripting, Exposure to IDMC/InformaticaExperience: Minimum 10 yearsRoles & 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 d...