An employer is looking for an ETL Developer to sit remotely. You will primarily be tasked with designing, developing and maintaining robust ETL pipelines/ routines to load the data warehouse from multiple source systems. This team owns multiple enterprise systems related to the clients fleet management applications. With multiple new projects kicking off, you will deliver these data solutions to enable to business. You will implement data integration solutions using tools ADF, Informatica Cloud/ PowerCenter and QLIK Replication. Other primary tasks will include:
Ensure data quality, accuracy, and consistency across all integration processes
Write complex SQL queries, stored procedures, and functions for data extraction, transformation, and loading
Optimize SQL performance for large-scale data processing
Develop and maintain database objects supporting data warehouse operations
Map source system data elements to target data warehouse models
Monitor ETL job performance and resolve failures during business hours and after-hours support
Design and implement dimensional models and data mart structures
We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to
Human Resources Request Form. The EEOC "Know Your Rights" Poster is available
here.
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:
https://insightglobal.com/workforce-privacy-policy/ .
7-10 years experience in ETL/ data development and integration
5+ years experience with ADF- designing/ implementing data pipelines
Experience with Informatica PowerCenter/ IICS (Data integration, workflow design, traditional ETL development)
Experience with Qlik for replication, data synchronization
Expert SQL skills- query optimization, performance tuning
3+ years experience of hands-on experience with enterprise data warehouse projects (Star Schema)
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.