LatAm - Sr. QA Data Migration Engineer

We currently have a career opportunity for a Senior QA Data Migration Engineer to join our high-performing team located in LatAm.

As a Senior Technical Consultant, you will drive the quality assurance strategy for complex data migration projects, moving legacy on-premise data to modern AWS cloud architectures. You will participate in all aspects of the data lifecycle, including estimation, test strategy design, automated script implementation, data validation, and documentation. As a member working in a collaborative agile environment, you will take direction from Data Architects and Leads to ensure zero data loss and high fidelity for our clients.

Perficient is always looking for the best and brightest talent and we need you! We are a quickly growing, global digital consulting leader transforming the world’s largest enterprises. You will work with the latest cloud technologies, expand your Data Engineering skills, and become a part of our global community of diverse and knowledgeable colleagues.

• Data Validation Strategy: Design, code, and execute automated test scripts to validate data integrity, completeness, and accuracy between source (Legacy/On-Prem) and target (AWS Cloud) systems.

• Pipeline Testing: Analyze and test ETL/ELT pipelines using AWS Glue, Lambda, or Step Functions to ensure data transformation logic meets business requirements.

• Automation Development: Develop robust automated testing frameworks using Python and SQL to perform row counts, column mapping, and checksum validations on large datasets.

• AWS Integration: Validate data ingestion and storage flows involving AWS services such as S3, Redshift, RDS, and DynamoDB.

• Migration Tools: utilize AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT) to monitor replication tasks and identify discrepancies.

• Defect Management: Lead root cause analysis for data discrepancies, parsing log files (CloudWatch), and working closely with Data Engineers to resolve ETL defects.

• CI/CD & AI: Integrate data testing scripts into CI/CD pipelines (GitLab/Azure DevOps). Utilize AI tools (Github Copilot, Anthropic Claude) to optimize SQL queries and generate test data scenarios.

• Collaboration: Ensure technical data governance processes are followed and effectively communicate data quality metrics to non-technical stakeholders.

• Technical Background: Passionate data advocate with 3-5+ years of experience in Data Quality, Data Engineering, or Backend QA.

• Core Languages: Strong proficiency in SQL (complex joins, stored procedures) and Python (Pandas, Boto3, PyTest) for scripting automated validations.

• AWS Expertise: Breadth of experience with AWS Data ecosystems, specifically S3, Glue, Redshift, Athena, and DMS (Database Migration Service).

• Testing Frameworks: Experience with data testing tools such as Great Expectations, dbt (data build tool) tests, or custom Python frameworks.

• Analytical Skills: Strong debugging and investigative skills. Ability to assimilate disparate information from database logs and error messages to find the root cause of data skew or corruption.

• Methodology: Experience with Agile/Scrum methodology and working with high-volume datasets.

• Education: Bachelor’s Degree in Computer Science, Math, Engineering, Data Science, or comparable major.

• Communication: Strong consulting skills with the ability to explain complex data issues to various organizations.

Perficient full-time employees receive complete and competitive benefits. We offer a collaborative work environment, competitive compensation, generous work/life opportunities and an outstanding benefits package that includes paid time off plus holidays. In addition, all colleagues are eligible for a number of rewards and recognition programs including billable bonus opportunities. Encouraging a healthy work/life balance and providing our colleagues great benefits are just part of what makes Perficient a great place to work. 

WHO WE ARE

Perficient is a leading global digital consultancy. We imagine, create, engineer, and run digital transformation solutions that help our clients exceed customers’ expectations, outpace competition, and grow their business. With unparalleled strategy, creative, and technology capabilities, our colleagues bring big thinking and innovative ideas, along with a practical approach to help our clients – the world’s largest enterprises and biggest brands succeed.

WHAT WE BELIEVE

At Perficient, we promise to challenge, champion, and celebrate our people. You will experience a unique and collaborative culture that values every voice. Join our team, and you’ll become part of something truly special.

We believe in developing a workforce that is as diverse and inclusive as the clients we work with. We’re committed to actively listening, learning, and acting to further advance our organization, our communities, and our future leaders… and we’re not done yet.

Perficient, Inc. proudly provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a protected veteran in accordance with applicable federal, state and local laws. Perficient, Inc. complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. Perficient, Inc. expressly prohibits any form of unlawful employee harassment based on race, color, religion, gender, sexual orientation, national origin, age, genetic information, disability, or covered veterans. Improper interference with the ability of Perficient, Inc. employees to perform their expected job duties is absolutely not tolerated.

Disability Accommodations:

Perficient is committed to providing a barrier-free employment process with reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or accommodation due to a disability, please contact us.

Disclaimer:  The above statements are not intended to be a complete statement of job content, rather to act as a guide to the essential functions performed by the employee assigned to this classification.  Management retains the discretion to add or change the duties of the position at any time. 

Perficient is the global AI-first consultancy. Our team of strategists, designers, technologists, and engineers partners with the world’s most innovative enterprises and admired brands to deliver real business results through the transformative power of AI. As part of our AI-First strategy, we empower every employee to build AI fluency and actively engage with AI tools to drive innovation and efficiency. We break boundaries, obsess over outcomes, and shape the future for our clients. Join a company where bold ideas and brilliant minds converge to redefine what’s possible - while building a career filled with growth, balance, and purpose.