The ETL Developer will be an integral member of the technology team and will assist with developing scalable technical ETL solutions across the organization. The individual is responsible for supporting the deployment, testing, operations, and maintenance of new and existing developments in the technical environment. The ETL Developer will be required to contribute to the technical design, development tasks, estimates, and execution to completion. The ETL Developer must also ensure that developed code meets the technical and functional specifications through unit testing and validation. In addition, the ETL Developer will identify, cleanse and transform data to enable timely and data-driven decision making.
ESSENTIAL FUNCTIONS
Technical Design- Able to identify, analyze, specify, design, and translate functional design to technical design. Create and document technical designs for medium to high complexity solutions that may include integration with external systems.
Create and document technical designs for medium to high complexity solutions that may include integrations with external systems
Design systems that span multiple technologies/platforms
Apply design standards across all applications
Design solutions to meet performance requirements and scalability expectations
Application Development - Able to write, test, debug, and maintain applications for end-user adoption, productivity improvement and efficiency.
Research, analyze, and produce high quality source code for medium to high complexity solutions
Create, modify, and enhance medium to high complexity programs
Assist with technical design
Troubleshoot and resolve technical issues
Participate in peer code reviews
Collaborate with cross functional teams to identify and solve software defects
Anticipate risks and implement contingency plans to resolve issues impacting applications
Design operational support systems like monitoring, reporting, fail over, error handling etc.
Proactively enhances systems for stability, efficiency, scalability and robustness
Perform file level verification tasks via UNIX Shell scripts and command-line utilities.
Provide support to all ETL applications and perform root cause analysis on all processes to resolve all production issues.
Unit Testing and Validation - Ensures developed code meets the technical and functional specifications.
Develop and document effective unit test cases to test solution and validate results are as expected
Modify code if unit test fails
Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for same.
Ensure the application operates according to functional and technical specifications
Troubleshooting and resolve software bugs, data, and system configuration issues
Develops reusable unit test case suite
Provide Accurate Project Effort Estimates - Ability to quantify and meet individual and project phase level efforts.
Manage ambiguity, meet and create accurate project effort estimates for their assigned tasks
Understand, consider and communicate interdependenciesfor project estimates
Adhere to the company project methodology throughout project lifecycle
Adherence to Standards - Ability to create solutions that adhere to and incorporate standards.
Apply and use information and technology standards in solution design.
Obtain key inputs from Enterprise Architecture to ensure compliance and exception management
Identify commonalities and suggest a consistent approach across projects
REQUIRED & PREFERRED QUALIFICATIONS