Apply on
Original
Simplified
The purpose of the ETL Developer position is to design, develop, unit test, document, and perform ongoing support for the ETL and MS SQL products and code. Additionally, the developer needs to understand ETL to and from common database and file formats. This person is expected to be a subject matter expert that other team members can use as a reference for ETL, SQL, data design, and programming.
Job Duties & Responsibilities
Data Integration Development (75%)
Develop and unit-test mappings and taskflows as ETL code to integrate data from and into various systems/databases and data stores / file formats.
Develop and unit-test SQL code as needed for use in mappings or as scripts for taskflows.
Develop and unit-test Unix/Linux/Windows scripts as needed for use in taskflows.
Create migration worksheets and related documentation for deployment of ETL objects/code to higher environments.
Assist in and monitor the migration process and validate ETL objects/code once migration has completed.
Assist in QA efforts as required to ensure data integrity and quality.
Perform peer reviews of ETL objects/code for completeness of work and adherence to standards.
Provide support for daily Production jobs executing ETL processes to ensure data is loaded within SLA for business systems and reporting.
Troubleshooting and correcting existing ETL solutions.
Understand and implement best practices and process standards.
Assist in creating automations that will help the team be more efficient and move faster.
Discovery, Design, and Documentation (15%)
Attend discovery sessions to obtain an understanding with IT and business SMEs to gather appropriate project / Production support requirements.
Assist in creation of business requirements documents from discovery sessions.
Assist in creation of technical design documents from business requirements.
Design or assist in designing end-to-end low to medium complexity level data flows, implementing technical design and business requirements for the task.
Create and maintain documentation for ETL mappings and taskflows, referencing technical design and business requirements.
Create migration worksheets and related documentation for deployment of ETL objects/code to higher environments.
Log and document task progress for development projects and support issues (Jira is used as tracking tool).
Enhance Skillsets (10%)
Qualifications
Bachelor's Degree required, or equivalent education / work experience
Preferred certifications in
Agile Software Development
Three to Four years of relevant work experience
#LI-ID1
#LI_HYBRID
The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, skills, efforts or working conditions associated with a job.
We offer our employees a robust compensation package! Our comprehensive benefits include: medical, dental and vision insurance coverage; 100% company-paid life and disability coverage, 401k options with company match, three weeks PTO by the end of the first year and much more. Allied proudly promotes from within as part of a strong commitment to providing career growth opportunities for employees of all levels. Our diverse business portfolio allows employees broad career options with the advantage of staying with the same organization.
All qualified candidates will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.
To view our privacy statement click here
To view our terms and conditions click here
Job Duties & Responsibilities
Data Integration Development (75%)
Develop and unit-test mappings and taskflows as ETL code to integrate data from and into various systems/databases and data stores / file formats.
Develop and unit-test SQL code as needed for use in mappings or as scripts for taskflows.
Develop and unit-test Unix/Linux/Windows scripts as needed for use in taskflows.
Create migration worksheets and related documentation for deployment of ETL objects/code to higher environments.
Assist in and monitor the migration process and validate ETL objects/code once migration has completed.
Assist in QA efforts as required to ensure data integrity and quality.
Perform peer reviews of ETL objects/code for completeness of work and adherence to standards.
Provide support for daily Production jobs executing ETL processes to ensure data is loaded within SLA for business systems and reporting.
Troubleshooting and correcting existing ETL solutions.
Understand and implement best practices and process standards.
Assist in creating automations that will help the team be more efficient and move faster.
Discovery, Design, and Documentation (15%)
Attend discovery sessions to obtain an understanding with IT and business SMEs to gather appropriate project / Production support requirements.
Assist in creation of business requirements documents from discovery sessions.
Assist in creation of technical design documents from business requirements.
Design or assist in designing end-to-end low to medium complexity level data flows, implementing technical design and business requirements for the task.
Create and maintain documentation for ETL mappings and taskflows, referencing technical design and business requirements.
Create migration worksheets and related documentation for deployment of ETL objects/code to higher environments.
Log and document task progress for development projects and support issues (Jira is used as tracking tool).
Enhance Skillsets (10%)
- Possess and demonstrate strong communication skills.
- Enhance skills and knowledge around these data management platforms
- Informatica IDMC / IICS
- AWS
- Snowflake
- Enhance skills and knowledge around these SQL / Database platforms
- Microsoft SQL Server
- Snowflake
- Enhance skills and knowledge around these server platforms
- Microsoft Windows
- Unix/Linux
- Enhance skills and knowledge around these file formats and communication types
- APIs
- JSON
- XML
- CSV (or other delimited)
- Unstructured
Qualifications
Bachelor's Degree required, or equivalent education / work experience
Preferred certifications in
- Informatica IDMC / IICS
- AWS
- Snowflake
Agile Software Development
Three to Four years of relevant work experience
#LI-ID1
#LI_HYBRID
The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, skills, efforts or working conditions associated with a job.
We offer our employees a robust compensation package! Our comprehensive benefits include: medical, dental and vision insurance coverage; 100% company-paid life and disability coverage, 401k options with company match, three weeks PTO by the end of the first year and much more. Allied proudly promotes from within as part of a strong commitment to providing career growth opportunities for employees of all levels. Our diverse business portfolio allows employees broad career options with the advantage of staying with the same organization.
All qualified candidates will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.
To view our privacy statement click here
To view our terms and conditions click here
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job Similar Jobs
