Senior Data Engineer with a focus on Data Testing required to lead efforts in testing data migration activities, ensuring data integrity and accuracy throughout the process.
The successful candidate will play a critical role in testing a large-scale data migration effort, ensuring data integrity and accuracy throughout the process.
Key Responsibilities:
- Data Testing: Lead efforts in testing data migration activities, including validating data mapping, monitoring data flows, ensuring proper execution of ETLs, applying cleaning rules, managing sync-back processes, and developing thorough test plans.
- ETL Validation: Guarantee the precision and dependability of ETL/ELT workflows utilizing tools like Informatica, SSIS etc
- Data Integrity: Ensure post-migration data integrity by identifying inconsistencies, analyzing discrepancies, and providing actionable solutions.
- Collaboration: Partner with cross-functional teams to streamline data integration processes, ensuring efficient and data-driven decision-making.
- Test Plan Development: Create, document, and implement detailed test plans to oversee the migration and transformation of data across systems.
Technical Skills:
- 5+ years of SQL experience.
- 5+ years working with ETL/ELT tools (Informatica, SSIS, etc.).
- Proficient with BI tools (SSRS, Tableau, Power BI, etc.).
- Preferred experience with R and Python.
- Familiarity with MPP databases and Snowflake is a plus.
- AWS experience is a plus.