IT- ETL Developer V - Must Reside in IA, IL or WI
Apply NowCompany: Scope Services
Location: Cedar Rapids, IA 52402
Description:
Job Location: Specifically looking for candidates in the Iowa and Wisconsin territory (surrounding states may be an option).
Start/End Dates: 8/16/2024 - 12/31/2024. Contract to Hire role, candidate who wants to be permanent post 3 months of the contract.
JOB SUMMARY:
We are currently looking for an ETL Developer that works directly with business users to develop data pipelines from source applications to corporate data platforms (Data Warehouse/Lake) and optimize analytic solutions. This position will utilize Informatica development tools to create integrations or modify current integrations for various projects that are handed off to the Data and Analytics Services group.
ACCOUNTABILITIES:
These accountabilities are not intended as a complete list of specific duties and responsibilities and does not limit or modify the right of any supervisor to assign, direct, and control the work of employees assigned to this job.
Primary Accountabilities
*Develops scalable, innovative solutions for extracting, transforming, and moving data.
*Performs data profiling and data analysis to assist in understanding the data.
*Optimizes data models through normalization, table analysis and review of queries.
*Presents outcomes of analytic models in a format easily understood by the business.
*Performs ETL/ELT functions for new or existing sources.
*Conducts requirements gathering with business stakeholders and users to plan a roadmap of project activities.
*Works with the business to assess the validity of the data and achieve minimum levels of quality.
*Gathers and compiles data using various data collection techniques in response to data requests.
*Creates code or GUI data mappings while following company data standards and approaches.
*Collaborates with others responsible for pipeline development. Supervision QUALIFICATIONS The requirements listed below are representative of the experience, knowledge, skills and/or abilities required to perform this job. Educational Requirements Education Level Field of Study Required/Preferred Bachelor's Degree Emphasis in CIS, Software Development, analytics, operations research, computer science or another applicable field.
Required Experience:
5 years of direct experience in a related field (coding, ETL Development/Engineering, analytics, or research)
Experience with Informatica ETL/ELT tools, specifically PowerCenter, BDM/DEI, IICS products
Experience working with Snowflake and Snowpark
Experience in developing data pipelines utilizing Python
Direct experience working with source APIs into a big data environment
Proficiency in SQL required.
Preferred Experience:
Data Modeling experience utilizing Erwin Data Modeling tool
Experience with Tidal Job Scheduling Software
Development experience with DBT
CI/CD Experience
Laptop will not be provided Only VM access provided
Start/End Dates: 8/16/2024 - 12/31/2024. Contract to Hire role, candidate who wants to be permanent post 3 months of the contract.
JOB SUMMARY:
We are currently looking for an ETL Developer that works directly with business users to develop data pipelines from source applications to corporate data platforms (Data Warehouse/Lake) and optimize analytic solutions. This position will utilize Informatica development tools to create integrations or modify current integrations for various projects that are handed off to the Data and Analytics Services group.
ACCOUNTABILITIES:
These accountabilities are not intended as a complete list of specific duties and responsibilities and does not limit or modify the right of any supervisor to assign, direct, and control the work of employees assigned to this job.
Primary Accountabilities
*Develops scalable, innovative solutions for extracting, transforming, and moving data.
*Performs data profiling and data analysis to assist in understanding the data.
*Optimizes data models through normalization, table analysis and review of queries.
*Presents outcomes of analytic models in a format easily understood by the business.
*Performs ETL/ELT functions for new or existing sources.
*Conducts requirements gathering with business stakeholders and users to plan a roadmap of project activities.
*Works with the business to assess the validity of the data and achieve minimum levels of quality.
*Gathers and compiles data using various data collection techniques in response to data requests.
*Creates code or GUI data mappings while following company data standards and approaches.
*Collaborates with others responsible for pipeline development. Supervision QUALIFICATIONS The requirements listed below are representative of the experience, knowledge, skills and/or abilities required to perform this job. Educational Requirements Education Level Field of Study Required/Preferred Bachelor's Degree Emphasis in CIS, Software Development, analytics, operations research, computer science or another applicable field.
Required Experience:
5 years of direct experience in a related field (coding, ETL Development/Engineering, analytics, or research)
Experience with Informatica ETL/ELT tools, specifically PowerCenter, BDM/DEI, IICS products
Experience working with Snowflake and Snowpark
Experience in developing data pipelines utilizing Python
Direct experience working with source APIs into a big data environment
Proficiency in SQL required.
Preferred Experience:
Data Modeling experience utilizing Erwin Data Modeling tool
Experience with Tidal Job Scheduling Software
Development experience with DBT
CI/CD Experience
Laptop will not be provided Only VM access provided