Software Engineer 4

JobDescription

Underthe direction of the ETL Development sr. manager, serves as ETL Developer withdeep SSIS-based ETL expertise as well as ODI. Develops and delivers ETLaccording to standards for all in scope applications usage. Findsand utilizes new techniques to move data (i.e. web services, amazon glue) whenpossible. Ability to be hands on when needed.

Duties and Responsibilities:

  • Contribute to thedesign and development of an overall data exchange solution, including thereview of existing processes to confirm technical feasibility of ODIintegration
  • Assist withestimating, creation of road map and strategy, development, and implementationof new solutions
  • Build ODS andOLTP solutions for new and existing data exchanges
  • Ensure standardsand best practices for all current and new frameworks are followed
  • Recommendsolutions to address short term and long term gaps
  • Create technicaldocumentation and build instructions to onsite and/or offsite global teams
  • Assist with codereviews, deploying, and validating the technical solution when needed
  • Design anddevelop data transformation/ETL integrations that conform to consistentmethodologies, standards (including security), and industry best practices
  • Develop andmaintain SQL, PL/SQL code as needed for Oracle database
  • Maintain,monitor, and support ETL/ELT integrations using ODI

MinimumCore Competencies:

  • Must beproficient and have experience with SSIS with a detailed understanding of theSSIS ETL framework architecture
  • Recent experienceof SSIS ETL design experience
  • PETL proficiencya plus
  • Knowledge of ETLconcepts and with data flow diagrams or data flow designs
  • Demonstratedunderstanding and experience of Oracle Data Integrator (ODI) or other ETL toollike Microsoft SQL Server Integration Services
  • Working knowledgeand experience using ETL tools such as PL/SQL stored procedures, Informatica,DM Express, Biztalk, etc.
  • Expert leveldevelopment experience in SQL or PL/SQL
  • Experience withfull Software Development Lifecycle methodologies and data managementprinciples

Requirements:

  • Strong working knowledgeof SQL Server Integration Services
  • Adherence to ETLArchitecture Standards
  • 5 or more years'experience with the following:
  • Oracle Database 10g, 11g or 12c in a DataWarehousing environment
  • Oracle Data Integrator(ODI)
  • Hands-on Data Modeling
  • Working knowledge of ETL and ELT designconsiderations
  • Participate in and/or lead meetings and workshops
  • Effectively work with business and project team members across the globe whether face-to-face, web conference, telephone or email.
  • Create a positive work environment through teamwork & conflict resolution
  • Hands on ETL development experience
  • 4-year Bachelor'sdegree or equivalent in IT, Computer Science, Engineering or another relateddegree of study

Meet Some of Asurion's Employees

Bryant M.

Senior Manager, Software Engineering

Bryant manages the Software Development Group at Asurion that focuses on back-office technology. By doing so, he helps deliver new products and business capabilities.

Christy R.

Senior Manager, Technology Strategy & Business Operations

Christy serves as the internal consultant to the CIO. She handles special projects and strategic deep dives to assess internal operating success and future operational plans.


Back to top