Consultant - OGL96
Reports to company headquarters in Irving, TX. Work as Technical Lead (ETL & DWH) Subject Matter Expert, and manage projects involving cross platform technologies such as Informatica, Facets, Oracle, Netezza and Unix. Leverage experience and knowledge of complex IT systems and applications to Design, architect & develop ETL & DWH projects based on Informatica, Oracle, Netezza, Unix and Facets, etc. Review existing business process and provide technical consultancy for the enhancements needed as per new Business requirements. Suggest new business process models to simplify and improve the existing business processes. Architecting and Implement new, modify existing, and migrate legacy services to modern technology to meet business and technical requirements. Design, develop and support several interfaces to loading Data from various sources (Relational, XML and Flat File) into Data Warehouse & Data Marts using Informatica. Preparing the technical design document (TDD) and UTL. Responsible for technical environmental issues, changes needed on impacted objects as well on dimensional data models. Managing and implementing different Schemas (Star and Snowflake) to fit reporting, query and business analysis requirements for DWH (Data ware Housing). Lead projects using Applications Management competency and Project Management competency skills to take ideas from inception to delivery, estimation, schedule, and scope. Advise and implement Change Management wherever needed. Ensure Reusability of existing assets for cost reduction & improved efficiency. Use knowledge of Software development processes and project management methodologies to deploy and deliver the requirements of the projects. Involved in AGILE development cycles. Designed and coded application components using Agile scrum methodology. Perform and provide guidance on exhaustive Unit and Integrations testing, maintain detailed project and process documentations. Ensure delivery of quality standards by adhering to ETL (Extract Transform and Load), DWH (Data ware Housing) and agile Best practices. REQUIREMENTS: Bachelor’s degree in Computer Science, Information Technology, or related, and Seven (7) years of experience in design and development of applications, or related. Seven (7) years of experience in design and development of applications, or related, must include: Seven (7) years with Informatica; Oracle; UNIX; Windows family; FACETS; DWH; Agile; And Five (5) years of experience with: Netezza; Tidal; and Autosys.
Reports to company headquarters in Irving TX. Will work at various unknown client sites throughout the U.S. for up to 100% of the time. Must be willing to travel anywhere in the U.S. and may be assigned to work at client sites across the U.S. Can work remotely or telecommute.
EOE. 8AM to 5PM. M-F. 40. hrs/wk.
Job ID OGL96.
TO APPLY: Send resume to firstname.lastname@example.org. Reference Job ID OGL96 in subject of the email.in subject of the email.