ETL Application Developer

Qualifications:

• Bachelor of Science and/or equivalent experience in Information Technology.
• 5+ years of ETL development and migration experience and all phases of testing.
• 3+ years of experience building ETL/ELT with a strong knowledge of Python.
• 3+ years of development experience in the Amazon Cloud Environment AWS (S3, Airflow, Data Lake, etc.).
• 2+ years of experience with Snowflake.
• Proficiency in developing, deploying, and debugging cloud-based data assets.
• Proficiency in SQL, understanding various databases (Oracle, MySQL, DynamoDB) and ability to:
  • output the results in several formats (JSON, data feeds, reports, etc.).
  • perform data manipulations, load, extract from several sources of data into another schema.
• Experience with traditional ETL tools such as Informatica, Talend and IBM preferred.
• AWS certification preferred.
• Understanding of the System Development Lifecycle (SDLC) and Change Control Management.
• Excellent organizational skills with the ability to work on multiple projects simultaneously.
• Excellent verbal and written communication skills.
• Ability to work within strict time constraints and adapt to changing direction and timelines.
• Ability to work independently with a proactive approach.
• Basic understanding of retail operations and experience with retail and supply chain data preferred.

Job Overview

The ETL Application Developer works with IT partners to build and maintain a data integration framework to enable the PCHI's data sharing needs between applications, business partners and our Enterprise data warehouse. The Developer will do so according to agreed upon specifications and in compliance with IT technology standards.

Responsibilities and Duties

• Develop application code based on specifications provided by project management and according to defined IT standards.
• Conduct program testing, for both internally and externally generated programs.
• Maintain system design and program documentation.
• Fulfill information requests from users and IT management.
• Comply with guidelines for development tools and methodologies.
• Ensure that application software meets the requirements for internal standards for security, compliance, and development best practices.
• Ensure required documentation is drafted and approved.
• Proactively incorporate continuous improvement into the standard company defined SDLC process.
• Assist with production support and partner with Project Managers and users to resolve production issues that arise.

Business Acumen: The developer should have a solid understanding of retail and supply chain operations and related data.

Interpersonal Skills: Strong verbal and written communication skills are essential.