P1 C3 STS 1 Design build data cleansing and imputation map to a standard data model transform to satisfy business rules and statistical computations and validate data content Develop modify and maintain Python and Unix Scripts and complex SQL Performance tuning of the existing code and avoid bottlenecks and improve performance Build an end-to-end data flow from sources to entirely curated and enhanced data sets Develop automated Python jobs for ingesting data from various source systems Provide technical expertise in areas of architecture design and implementation Work with team members to create useful reports and dashboards that provide insight improve automate processes or otherwise add value to the team Write SQL queries for data validation Design develop and maintain ETL processess to extract transform and load Data from various sources into the data warehours Colloborate with data architects analysts and other stake holders to understand data requirement and ensure quality Optimize and tune ETL processes for performance and scalaiblity Develop and maintain documentation for ETL processes data flows and data mappings Monitor and trouble shoot ETL processes to ensure data accuracy and availability Implement data validation and error handling mechanisms Work with large data sets and ensure data integrity and consistency skills Python ETL Tools like Informatica Talend SSIS or similar SQL Mysql Expertise in Oracle SQL Server and Teradata DeV Ops GIT Lab Exp in AWS glue or Azure data factory About Virtusa Teamwork quality of life professional and personal development values that Virtusa is proud to embody When you join us you join a team of 27 000 people globally that cares about your growth one that seeks to provide you with exciting projects opportunities and work with state of the art technologies throughout your career with us Great minds great potential it all comes together at Virtusa We value collaboration and the team environment of our company and seek to provide great minds with a dynamic place to nurture recent ideas and foster excellence Virtusa was founded on principles of equal opportunity for all and so does not discriminate on the basis of race religion color sex gender identity sexual orientation age non-disqualifying physical or mental disability national origin veteran status or any other basis covered by appropriate law All employment is decided on the basis of qualifications merit and business need