ETL developer

Role: ETL Developer

6 months Contract to Hire Locations: Resources will be aligned to the following Lending Technology location strategy hubs including: Dallas, Fort Worth, Arlington - TX; Chandler, Mesa, Phoenix - AZ; ; Des Moines, West Des Moines - IA; Philadelphia, PA; Camden, NJ: Wilmington, Delaware. Merchant: Add Charlotte, NC Hybrid - 3 days onsite Description: • Acts as a developer in providing application design guidance and consultation, utilizing a thorough understanding of applicable technology, tools and existing designs. • Develops simple or highly complex code. • Design data-intensive back-end transactional and analytical data warehouse systems using ETL tools like SSIS. • Data discovery and profiling, assessing data quality, tracing lineage. • Create data models and diagrams • Developing custom applications using Microsoft SQL Server Integration Services (SSIS) to extract data from various sources, transform it, and load it into databases or other data stores • Testing and debugging packages to ensure they function properly before they are deployed • Writing scripts in languages such as SQL Server Integration Services (SSIS), Visual Basic .NET, C#, Java, or Perl to automate complex tasks • Verifies program logic by overseeing the preparation of test data, testing and debugging of programs. • Assures quality, security and compliance requirements are met for supported area. • Responsible for application support. • Create Technical design documents and understand the business. • Troubleshoot applications and work directly with various application/ business/support team partners

Required qualifications • 5+ years of previous development and support experience in one or multiple data warehousing projects • 5+ years of experience in SSIS or related ETL tooling. • 5+ years of SQL • Unix shell scripting knowledge • Knowledge of scripting in .NET or Visual Basic to automate complex tasks in SSIS