Informatica and SAS Lead Developer

Required Skills: • 12-15 years of Enterprise Data Warehouse ETL development. • 10 years of experience ETL development using various versions of Informatica Power center. • 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: • 12-15 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.