ETL Engineer

• Perform technical detail design, coding, testing of applications. Serves as subject matter expert for both customer and internal discussions related to maintaining and enhancing existing software systems. Develop and/or analyze interface design documentation. Comply with hardware and software systems standards and procedures. Deliver large systems for tens of thousands of users. Comply with code quality, migration and dev/ops standards and policies
• Performs software analysis, including requirements and uses case development and design. Implements and documents source code to design specifications. Performs software testing including developing and running automated unit tests, drafting, and executing structured automated test cases. Compile, assess, and report data results from software testing and analysis.
• Develops software solutions for enterprise environments and other technologies. Analyzes and implements functional and non - functional (e.g. performance, availability) requirements and designs, implements, and tests software. Performs operations & maintenance (O&M) of existing systems. Identifies areas for improvement and streamlining. Demonstrated experience with front-end and back-end programing and integration frameworks and tools. Assist in the estimation of development of application features
• Provides direct technical support for high level, high visibility and critical trouble calls for supported applications. Works with cross functional teams to develop highly reliable software that runs at scale. Provides recommendations to infuse new technology. Extend open-source libraries and systems as necessary to meet the needs of the team. Play a crucial role in product scoping and roadmap / architecture discussions. Continually evaluate emerging technologies to identify opportunities, trends, and best practices. Mentoring of junior software engineers

Experience: 5 years experience with software development, basic coding and compilation, software architecture/design, user requirements definition and software specification development., Knowledge, Skills and Abilities (KSAs)

• Knowledge of database technologies (e.g. cloud, SQL, Oracle PL/SQL, Snowpark, Snowflake, PostgreSQL), Advanced
• Implementing ETL pipelines within and outside of a data warehouse using Python and Snowflakes Snow SQL. Advanced
• Development of scripts using Unix, Python, etc. for loading, extracting, and transforming data: Advanced
• Assist with production issues in Data Warehouses like reloading data, transformations, and translations: Advanced
• Ability to communicate technical requirements to all levels of expertise., Advanced
• Proficient in establishing and maintaining good working relationships., Advanced
• Knowledge and understanding of software development life cycle (SDLC)., Advanced
• Proficient with integrating complex and/or existing systems., Advanced
• Knowledge of programming languages (e.g. Python, Java)., Advanced
• Excellent communication skills both written and verbal., Advanced
• Knowledge of cloud technologies (AWS), Proficient
• Fundamental knowledge of software engineers best practices, agile methodologies, CI/CD pipelines, Advanced
• Knowledge of test-first practices including Test-Driven Development (TDD) for unit tests and Behavior-Driven Development (BDD) for automated acceptance tests, Advanced
• Knowledge of Code quality and promotion practices, Advanced