Need Systems Design Engineer

Hi, Hope you are doing great!

Please go through the below requirement, if you feel comfortable forward your updated resume then I can get back to you.

=====================================================================

Please send me your resumes at mark@corpemail.generalconsulting.us or call me at484-971-4881 for further details

 

 

Title: Systems Design Engineer

 

Location: Baltimore, MD

 

Duration: 6 Months

 

Job Description:

has an opportunity to place 2-3 resources for an existing client for a systems design engineers. This is a three position need in Baltimore. Please submit candidates who have K-12 or higher education experience .

To develop and maintain data structures and data in DAADS (Division of Accountability, Assessments and Data Systems) existing Educational Data Warehouse (EDW), OBIEE and Business Intelligence (BI) Reporting Edfacts reporting database, the Educational Data Operational Store, GIS Oracle Db. 11g and other DAADS relational and data mart database structures and sets. 1. Analyze complex K12 education accountability and performance reporting and data storage requirements with end users and OBIEE developers 2. Prepare data models that support the creation of K12 data structures, KPI development, and dashboard development in Oracle 11g using (ERWIN is used) 3. Create data structures for relational, star schemas, and data marts schemas. (ERWIN is used) 4. Prepare and execute Informatica ELT programs to maintain and transform existing and new data sets in and Oracle 11g environment 5. Create business data models in Oracle 11g, ERWIN, and Oracle OBIEE business model layer 6. Identify and resolve performance problems involving the applications databases and associated hardware. 7. Support and maintain operational procedures and practices. 8. Maintain database security and authentication. 9. Develop and monitor backup strategies. 10. Manage, plan, and configure data view for front-end processes. 11. Assist in setting long-range plans and goals for performance. 12. Design, update and implement new scripts and applications. 13. Provide operational and technical guidance as required. 14. Interact with developers on SQL, Oracle and DB2 support teams. 15. Develop and update reports using Cognos ® reporting tools. 16. Manage and support the entire data integration lifecycle using Informatica ®. 17. Develop and update reports using Microsoft Crystal Report and SQL Report. 18. Analyze and understands user requirements. 19. Modify existing software and creates appropriate Maryland SDLC documentation 20. Writes application software code and includes integrating with security subsystems maintained in Oracle Portal OID application. 21. Puts code into production. 22. Performs unit testing and support of quality assurance and user acceptance testing. 23. Creates technical documentation.

The preferred candidate will meet the following criteria: Part 1 ETL 1. Education - BS in computer science or related field. 2. At least five (5) years of experience designing and developing data warehousing database star schemas, 3N data forms using Oracle 10 g and 11g database 3. At least five (5) years of experience with Informatica ETL programming data, data imports, and data transformations. 4. At least five (5) years of experience programming in SQL and PL/SQL 5. At least three (3) years of experience analyzing user requirements and translating them into system data structure designs 6. At least two (2) years of experience with installing and administrating an Informatica ETL application environment 7. Possesses verbal and written communication skills in order to work with end-users. Part II OBIEE 8. Education - BS in computer science or related field. 9. At least five (5) years of experience designing and developing data warehousing database star schemas, 3N data forms using Oracle 10 g and 11g database 10. At least five (5) years of experience with OBIEE business layer modeling with skills in dimensions, hierarchies, parameters, alerts, drill downs, and custom calculations 11. At least three (3) years of experience analyzing user requirements and translating them into system designs using various design tools and techniques. 12. Possesses verbal and written communication skills in order to work with end-users. 13. At least five (5) years of experience designing and developing data warehousing database star schemas, 3N data forms, and OLAP cubes

 

 

Regards, 
Mark Williams

GENERAL CONSULTING SERVICES, 
Office: 484-971-4881 | Fax: 610-482-9315
mark@corpemail.generalconsulting.us

Gtalk:williams.gcs , Yahoo ID : williamsgcs

 

I sent this email through Google/Yahoo Groups. If you do not want to receive emails in future then please remove your id from that specific group.