Data Warehouse Developer (SAS Developer)

Role: Data Warehouse Developer (SAS)Location: Dallas, TX (100% Remote Work)Type – Contract

Experience level : 8+ yearsMust have skills : Hands on development experience with SAS Base, SAS Data Integration (SAS DI), Enterprise Data Warehouse ETL development, Informatica PowerCenter, SQL, Oracle, Teradata, UNIX shell scripting, On-call support.

Required Skills:• 8 years of Enterprise Data Warehouse ETL development.• 6 years of experience ETL development using various versions of Informatica PowerCenter.• 10 years of experience with proficiency in SQL with Oracle and/or Teradata Databases.• 10 years of experience working with dimensional data marts as well as OLTP databases• 10 years of experience with data analysis and research as well as data validation• 5 years of experience as a SAS Base programmer & DI developer is a plus.• 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.• Enjoys team collaboration and participation.• Writes efficient, re-usable, optimal, and well documented code.• Updates management on project/activity status as requested and escalates issues quickly.

Desired Skills:• 8 years of Enterprise Data Warehouse development and support.• 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.• Simplifies difficult concepts for non-technical users.• Demonstrated aptitude towards learning and self-improvement by taking training courses, completing certifications• Experience in shell scripting• Experience using git• Experience with CI/CD using Jenkins or similar tools• Understanding of different protocols like ssh, sftp, scp etc.• Moderate level understanding of connectivity using RSA keys and key based encryption• Moderate understanding of oracle PL/SQL• Moderate level SQL tuning skills by looking at explain plan etc.

General Duties and Tasks:• Individuals possess domain, technical or process authority in- their subject area.• They manage projects critical to the company.• Influences business and technology strategy by understanding business needs industry, trends and prioritizing IT resources.• Oversees the overall application architecture integrity and maintains the architectural vision for the organization.• Provides strategic technical and architectural leadership to the client’s organization.• Key interface between IT and key business users / senior leadership in defining IT solutions based on business needs.• Serves as technical expert to senior leadership in the client’s IT organization and functional user groups.• Initiates and drives major changes in architecture, methodology or programming procedures that have significant impact within IT and across the entire organization.

Key Skills

• SQL