Data Warehouse Developer

Job Description:

Must have : SAS Base, SAS DI, Teradata BTEQ, SQL, UNIX, 24 x 7 on-call support rotation experience

Join an enterprise data warehouse team environment with focus on customer-centricity, quality, forever learning and teamwork. If you enjoy all of these values and can work completely remote, this could be a position for you.
ETL / Data Movement Developer will need at minimum 10 years of ETL development experience with SAS BASIC, SAS DI and Teradata BTEQ experience. Possess a firm understanding of data warehouse design, ETL processes and automated scheduling. Always provide prompt and clear communications regarding data and schedule impacts. Provide appropriate escalations for risk avoidance and potential SLA breaches.

Required Skills:
• 6-8 years of Enterprise Data Warehouse ETL development.
• 5 years of experience as a SAS Base programer & DI developer.
• 5 years of experience with proficiency in SQL with Teradata and/or Oracle Databases.
• Experience in creating scripts using UNIX shell scripting to execute Teradata utilities is a plus.
• Expert at documenting ETL logic and workflow processing.
• Experience in working within systems development lifecycle and release management, releases.
• Develops and applies project management techniques with waterfall and agile methodologies.
• Experience in participating in 24 x 7 on-call support rotation providing primary and secondary support to daily data loads and miscellaneous incidents. Guarding to meet all data load and reporting SLA’s.
• Excellent written and verbal communication skills.
• Develops statements of problems and requirements. Can translate both business to technical and technical to business written and verbal communications.
• Able to work independently in all of the above areas of knowledge.
• Experience working with UNIX.
• 5 years of designing, developing and maintaining IBM/Tivoli Workload Scheduler (IWS).
• Designs, codes, tests, debugs and documents data warehouse ETL or reporting code according to NTT Data and customer standards, policies, procedures, security and compliance requirements.
• Understands and foresees implications of decisions.
• Understands the core business process and purpose of the functional area.
• Minimum 2-3 years experience in working within a virtual team. Also, experienced in working with minimal direction.
• Manages multiple assignments and processes.
• Writes efficient, re-usable, optimal, and well documented code.
• Updates management on project/activity status as requested and escalates issues quickly.

Desired Skills:
• Provide innovation in their thought process.
• Enhances own knowledge through training, understanding business trends and objectives.
• Knowledge of industry and business principles for rental car business.
• Interacts with business users, IT, vendors and customers to define current and future application requirements.
• Anticipates and prevents potential problems.
• Extends capabilities by working with senior staff/experts within and outside the internal organization.
• Experience using git
• Moderate level SQL tuning skills by looking at explain plan etc.

Duties/Responsibilities:
• Individuals have a deep understanding of their own area.
• They have a limited understanding of related subject areas.
• They manage critical projects with general direction and may allocate some work to others. • Supports large and critical software applications within the organization.
• Viewed as a technical expert or advisor for one or more applications.
• Participates on (and may lead) projects where analysis of systems or data requires an in-depth evaluation of complex business process, system process, and
industry standards. Regularly mentors and reviews work of less experienced team members.
• Executes schedules, costs and documentation to ensure assigned projects come to successful conclusion.
• Initiates corrective action to stay on project schedules.
• Possesses and applies broad knowledge of applications programming principles.
• Competent to analyze diverse and complex problems.
• Competent to work in all phases of applications programming.
• Knowledge includes advanced work on standard applications programs including coding, testing and debugging.
• Advanced ability to effectively troubleshoot program errors.
• Advanced understanding of how technology decisions relate to business needs