REMOTE- ETL Developer (ADF/ Informatica)

Lensa is a career site that helps job seekers find great jobs in the US. We are not a staffing firm or agency. Lensa does not hire directly for these jobs, but promotes jobs on LinkedIn on behalf of its direct clients, recruitment ad agencies, and marketing partners. Lensa partners with DirectEmployers to promote this job for Insight Global. Clicking "Apply Now" or "Read more" on Lensa redirects you to the job board/employer site. Any information collected there is subject to their terms and privacy notice.

Job Description

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 diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, 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 HR@insightglobal.com.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/.

Skills And Requirements

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) Microstrategy

PowerBI

Modernization experience null

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.

If you have questions about this posting, please contact support@lensa.com