Role: ETL Technical Lead Location: Raleigh, NC (ONSITE) Duration: 12 Months Technical Skills: (Primary): IICS and Experience in Migration SQL knowledge (query performance tuning, index maintenance, etc as well as an understanding of database structure 8- 10 year hand on exp in ETL Should be able to lead the team and handle client communication End to end solution design for the data replication / transformation between mainframe and AWS Aurora (Postgres) Experience in AWS Aurora (Postgress) Migration Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities Gather requirements and business process knowledge in order to transform the data in a way thats geared towards the needs of end users Maintain and improve already existing processes Ensure that the data architecture is scalable and maintainable Work with the business in designing and delivering correct, high-quality data. Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions. Prepare documentation for further reference. Technical Skills (Secondary Nice to have, NOT MANDATORY): Knowledge of data modeling principles Organizational skills: time management and planning Knowledge of at least one ETL tool (SSIS, Informatica, Talend, etc Soft Skills: As this is an onsite role, must have strong written and oral communication skills. Insurance Domain Knowledge Strong ability to work with client stakeholders. Requirement Review and Work Effort Estimation