ETL Developer

Allied Universal - Carmel, IN

Full-time - Entry Level

Carmel, IN

11-50 employees

Administrative and Support Services

About the position

The ETL Developer position at Allied Universal is focused on designing, developing, unit testing, documenting, and providing ongoing support for ETL and MS SQL products and code. The role requires a deep understanding of ETL processes, database interactions, and file formats, positioning the developer as a subject matter expert for the team.

Responsibilities

• 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.
• Troubleshoot and correct existing ETL solutions.
• Understand and implement best practices and process standards.
• Assist in creating automations that will help the team be efficient and move faster.
• 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.
• Log and document task progress for development projects and support issues.

Requirements

• Bachelor's Degree required, or equivalent education/work experience.
• Three to Four years of relevant work experience.
• Preferred certifications in Informatica IDMC/IICS, AWS, Snowflake, Agile Software Development.

Nice-to-haves

• Strong communication skills.
• Knowledge of data management platforms such as Informatica IDMC/IICS, AWS, Snowflake.
• Knowledge of SQL/Database platforms like Microsoft SQL Server, Snowflake.
• Knowledge of server platforms including Microsoft Windows and Unix/Linux.
• Familiarity with file formats and communication types such as APIs, JSON, XML, CSV, and unstructured data.

Benefits

• 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.
• Career growth opportunities within the company.