Description
You will own ETL testing and data integration validation for financial data systems.
This role is on-site.
Responsibilities
- Validate ETL processes and data integration workflows using strong SQL (SQL Server and/or Oracle), including stored procedures and performance tuning.
- Test file-based data feeds (CSV, fixed-width, XML, JSON) and SFTP/MFT integrations.
- Perform data validation and troubleshooting using C# or Python for data processing tasks.
- Execute testing within Agile/Scrum environments, utilizing Visual Studio, TFS, and Azure DevOps for CI/CD workflows.
- Integrate AI capabilities using GitHub Copilot or Azure OpenAI to enhance testing efficiency.
Required Skills
- 5+ years of ETL or data integration experience (3-5 years acceptable for one offshore role).
- Strong SQL proficiency in SQL Server and/or Oracle, with expertise in stored procedures and performance tuning.
- Hands-on experience with file-based data formats (XML, JSON, CSV, fixed-width) and SFTP/MFT tools.
- Proficiency in C# or Python for data processing and automation.
- Experience with cloud-based data platforms and Azure DevOps.
- Familiarity with Agile/Scrum delivery and SAFe framework.
Preferred Skills
- Experience with investment management or fund administrator data.
- Exposure to GRID, reporting, or downstream analytics.