Data Warehouse Specialist

We motivate. We empower. We lead. We follow. We laugh. We succeed. ACS offers innovative and effective outsourcing solutions for clients around the world. We deliver higher quality, increased productivity, and lower costs. Can we do that for you? Sure we can. For business process outsourcing (BPO) and information technology outsourcing (ITO), ACS is not a product, we're services. We're people making technology work. We'd be glad to demonstrate the ACS advantage. Let us tell you about our world-class people, our company, and the "can-do" attitude that motivates us to deliver nothing less than the very best. Data Warehouse Specialist Job Description:We're Affiliated Computer Services, Inc. (NYSE: ACS), a premier provider of diversified business process outsourcing (BPO) and information technology outsourcing (ITO) solutions to commercial and government clients worldwide. Based in Dallas, ACS is a FORTUNE 500 company of 62,000 people supporting client operations reaching more than 100 countries.PositionThis position will work closely with the database team for the design, development and maintenance of enterprise data warehouse solutions for different customer affiliates.This position requires a seasoned, experienced professional able to resolve a wide range of issues in creative ways.ResponsibilitiesInclude but are not limited to:· System analysis and programming using PL/SQL procedures, Informix 4GL, TSQL, C, C++.· Develop and define Data warehouse business models and data transformation (ETL) strategies, including transformation procedures using extensive knowledge of Oracle PL/SQL, Shell scripting. · Plans, designs, develops and tests software systems or applications for software enhancements and new products· Using current programming languages and technologies, writes code, completes programming, and performs testing and debugging of applications· Works on complex issues where analysis of situations or data requires an in-depth evaluation of variable factors.· Exercises judgment in selecting methods, techniques and evaluation criteria for obtaining results.· Networks with key contacts outside own area of expertise.Requirements:· Demonstrated design and develop track record delivering scalable software solutions· Effective English written and verbal communication skills and ability to work in a team environment· Self-motivated and positive attitude · Oracle 9i/10G Certified Professional DBA· Knowledge of HRMS and PeopleSoft financials (ERP)· Experience with data warehouse in an ERP Environment, including PeopleSoft interfaces and security· Advanced experience in writing complex SQL and UNIX shell scripts· Extensive knowledge in all aspects of Oracle and SQL Server DBA experience· Extensive experience with Relational, Hierarchical and Network Data Base Management SystemsEducation and Typical Years Experience· Requires a Bachelors degree in Computer Science, or a related hard science (Math, EE, Physics, etc.) plus a minimum offour years of applicable software engineering experience. · 5-10 years experience in Physical and Logical data base design and implementation.ACS is an Equal Opportunity Employer and does not Discriminate against any applicant on the basis of race, color, religion/creed, national origin, gender, or sex, marital status, age, disability, use of a guide dog or service animal, sexual orientation, military/veteran status, or any other status protected by Federal or State law or local ordinance. People with disabilities who need a reasonable accommodation to apply or compete for employment with ACS may request such accommodations by calling or by sending an e-mail to accommodations@acs-.Job Experience:We're Affiliated Computer Services, Inc. (NYSE: ACS), a premier provider of diversified business process outsourcing (BPO) and information technology outsourcing (ITO) solutions to commercial and government clients worldwide. Based in Dallas, ACS is a FORTUNE 500 company of 62,000 people supporting client operations reaching more than 100 countries.PositionThis position will work closely with the database team for the design, development and maintenance of enterprise data warehouse solutions for different customer affiliates. This position requires a seasoned, experienced professional able to resolve a wide range of issues in creative ways. ResponsibilitiesInclude but are not limited to:· System analysis and programming using PL/SQL procedures, Informix 4GL, TSQL, C, C++.· Develop and define Data warehouse business models and data transformation (ETL) strategies, including transformation procedures using extensive knowledge of Oracle PL/SQL, Shell scripting. · Plans, designs, develops and tests software systems or applications for software enhancements and new products· Using current programming languages and technologies, writes code, completes programming, and performs testing and debugging of applications· Works on complex issues where analysis of situations or data requires an in-depth evaluation of variable factors. · Exercises judgment in selecting methods, techniques and evaluation criteria for obtaining results.· Networks with key contacts outside own area of expertise.Requirements:· Demonstrated design and develop track record delivering scalable software solutions· Effective English written and verbal communication skills and ability to work in a team environment· Self-motivated and positive attitude · Oracle 9i/10G Certified Professional DBA· Knowledge of HRMS and PeopleSoft financials (ERP)· Experience with data warehouse in an ERP Environment, including PeopleSoft interfaces and security· Advanced experience in writing complex SQL and UNIX shell scripts· Extensive knowledge in all aspects of Oracle and SQL Server DBA experience · Extensive experience with Relational, Hierarchical and Network Data Base Management Systems Education and Typical Years Experience· Requires a BaExpected Travel Time: None