ETL DEVELOPER

Level:  Sr

Location:  Wilmington Delaware

JOB REQUIREMENT:

As a team member, candidate will be working in an agile team following scrum practices. Team owns many business critical BATCH applications primarily developed with technologies such as Oracle, DATASTAGE, Unix Scripts and frameworks build in-house using combinations of them. The day to day activity has working on stories for multiple projects at the same time and skills to problem solving for each one of them. Team works in Dev-Ops mode. Each Team owns problems and incidents associated with the applications they own. Investigating incidents and finding root causes and resolution is also a priority. Candidate will work with highly motivated and talented team but self-motivation is the key to success. Team follows agile scrum processes in their day to day activities. This team is moving towards use of new generation technologies, e.g., Hadoop using SPARK, KAFKA, HDFS, HIVE, HUE. Team is exploring options and is trained in some of those ecosystem tools. Team is also engaged in ETL automation of the testing using Java and Selenium.

RESPONSIBILITY:

  • Develop, test and implement systems, ETL processes and database technologies that provide optimal performance, availability and reliability for large data warehouses
  • Work in new emerging technologies like Hadoop and BigData
  • Explore options in moving data from legacy warehouse to Hadoop using Spark, HDFS, Hive and other ecosystem tools
  • Evaluate, analyze, design, develop, document, test and implement various solutions and system enhancements
  • Adapt ETL processes to accommodate changes in source systems and to respond to changes in business requirements
  • Work closely with IT technical staff to ensure changes are implemented according to business and IT technical specifications, policies and operational procedures
  • Assist in the planning, documentation and presentation to management the recommended solutions for complex server based projects
  • Curious and excited by new ideas
  • Skills in Problem Management for identifying issues inside the application codes
  • Energized by a fast-paced environment
  • Willing to learn other technologies on self-driven fast pace, e.g., Java, Selenium and Hadoop Eco System tools
  • Able to understand and translate business needs into leading-edge technology
  • Comfortable working as part of a connected team and remain self-motivated
  • Community-focused, dependable and committed
  • Exceptionally detail-oriented
  • Present technical ideas for improving applications
  • Work multiple projects concurrently and shift priorities as required to meet business requirements and deadlines

SKILL SET:

  • Min 10+ years of IT experience working with Oracle databases
  • Must have strong experience with Data Warehouse design
  • Strong technical knowledge about designing and developing applications
  • Strong knowledge on performance tuning of database code
  • Must have experience as technical lead designing applications from ground up
  • Must be proficient in writing stored procedures, functions, packages, triggers
  • Must be proficient in files processing and files moments on UNIX server
  • Must be proficient in writing UNIX scripts
  • Must have worked in Agile teams for more than 1 year
  • Must be proficient in Agile process and personal priorities to follow them on day to day basis
  • Must have an Excellent communication skills
  • Must be at least trained in Hadoop EcoSystem tools, e.g., SPARK, HIVE, HUE, HDFS
  • Work experience in Hadoop teams and project is a HUGH PLUS
  • Understanding of ETL tools like DATASTAGE is mandatory
  • Understanding performance tuning of ETL codes (datastage)
  • Experience with ETL, Jobs, and Scheduling Maintenance
  • Ability to develop ER diagrams, identify primary and foreign keys, entities, attributes, relationships and business rules for data warehouse