ETL Developer

  • location: Wilmington, DE
  • type: Contract
  • salary: $50 - $55 per hour

job description

ETL Developer

We have an excellent opportunity for an ETL Developer who is responsible for the working implementation of features, through software development, design and testing as part of the delivery teams, performed in accordance with the Agile Methodology

Responsibilities:

  • Take ownership of applications assigned for development and support activity as agreed with team or tech lead for complete and successful delivery
  • Ensure all SLA's are met for assigned tasks.
  • Provide functional expertise within his/her skills to assist delivery team members, foster collaboration.
  • Work closely and maintain ongoing communications with project lead, project sponsor, business analyst and technical leads.
  • Provide issue response and root cause analysis on incident and problem tickets as assigned by team lead tech lead or project lead.
  • Escalate issues on a timely basis to team lead, tech lead, PO and scrum master.
  • Communicate incoming work requests to team lead/PO/scrum master when requested to work on unplanned items.
  • Report over or under allocation to the team lead, forecast work remaining, identify and communicate variance to plan. If colleague is a contractor he/she should request approval prior working overtime.
  • Perform on-call support and pager duties as assigned by team lead.
  • Report progress, delays and risks on assigned activities to Team.
  • Maintain cordial relationship with the Team members /PO/scrum master/BSA
  • Provide technical mentoring to team members
  • Provide feedback on lessons learned and retrospective meetings.
  • Raise awareness when existing code, systems or processes do not meet current quality expectations and standards.
  • Participate in all agile ceremonies
Requirements:

  • PL/SQL /ETL and Hadoop with Agile Methodology Work experience
Software Design, Programming and Unit Testing

  • Strong database (Oracle, Hadoop) skills including database design, development (packages, functions, procedures)
  • Strong data warehousing and OLTP system knowledge from database/ETL development perspective.
  • Database code performance tuning skills required.
  • Provide functional expertise within his/her skills to assist delivery team members, and foster collaboration with in BTG.
  • Strong understanding of Agile Methodologies and Ceremonies
  • Thorough understanding of Hadoop systems - be prepared for developing the processes in Hadoop
Development

  • Develop code, configuration files, build scripts, schemas or other artifacts associated by the features, user stories, as assigned by tech lead/PO.
  • Develop and maintain code and all related artifacts in source control; perform code merges and resolve conflicts as defined by development process update documentation and automated tests.
  • Develop unit tests for new code created; modify existing unit tests for altered functionality.
  • Develop system integration test to verify the code running in its functional environment.
  • Work with the PO, tech lead and team lead to schedule features into Releases.
  • Create implementation plans and Change Management Requests as assigned by team lead or tech lead.
  • Verify build and deployment completeness of the features owned in the QA environment
  • Responsible for doing performance testing of individual components and the application as a whole.
  • Estimate Production run times in terms of execution time per volume of data.
  • Attach Explain Plan for SQL statements wherever possible in the Solution review document.
  • Thorough understanding of Hadoop systems - be prepared for developing the processes in Hadoop
Design

  • Analyze the feature requirements as presented by the business analyst and the delivery team, in context of the overall project feature set and existing implementation. Translate requirements to technical concepts.
  • Help business analyst to refine and enhance initial requirements.
  • Contribute to logical/physical data models, class diagrams, activity diagrams, sequence diagrams and UI prototypes.
  • Responsible for organizing code review and obtaining sign-up on the code he/she delivered.
  • Provide follow-ups and resolution to the issues raised on design and code reviews.
  • Perform peer reviews on code and design as requested.
  • Perform additional design tasks as assigned by team or tech lead.
  • Responsible for Component/Application Design for flawless functionality and optimal performance.
Testing

  • Test all code, content, build and unit test changes in the lowest environments first, if such environments exist.
  • Develop Unit, Functional and System Integration (SIT) test plans.
  • Execute and document Unit, Functional and SIT tests.
  • Assist QA and production testing and deployment; assume ownership of the feature until passes successful Production Verification Test.

get jobs in your inbox.

sign up
{{returnMsg}}