*Role:* Senior Data Warehouse Architect *Location:* Washington, DC
*Duration:* 6+ Months *Interview Type:* F2F *Job id:* 402179 *Complete Description:* The vendor will be required to provide a dedicated Data Architect/DBA – ETL Specialist resource. The Data Architect/DBA – ETL Specialist will lead the warehouse design, architecture, and implementation/integration effort, including data sourcing and transformation, leverage knowledge of current data warehouse and software development methodologies to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines. The Data Architect/DBA – ETL Specialist will be responsible for support of the data architecture that copies/transforms/loads data from disparate sources to the production databases. The individual will primarily maintain and extend the ETL architecture based on Oracle's PL/SQL and ODBC. Another key responsibility will be maintaining/extending the various data models. Responsibilities will also include secondary database administration for the multiple Oracle databases, some of which require experience with Data Warehouses software. · 6 years of experience delivering business intelligence solutions · 6 years of experience with OLTP and OLAP database models · 8 Years of experience as Oracle DBA administrating databases on Oracle including 11g RAC with ASM on Unix/Linux machines. · 3 Years of experience working as Data warehouse DBA. · 3 years of experience in dimensional data modeling. · 3 years of experience working as Development DBA. · 3 years of experience in PL/SQL. · 3 years of experience working as ETL developer, preferably Informatica. · 2 years of experience in shell scripting and VB scripting. · 1 year of experience working with REST APIs. · Experience working on different data formats (example; JSON/XML etc) · 1 year of experience working on NoSQL databases ( example; MongoDB, Hadoop, Cassandra, Accumulo etc ) *Skills:* *Skill* *Required / Desired* *Amount* *of Experience* *Expertise Rating* Oracle DBA administrating databases on Oracle including 11g RAC with ASM on Unix/Linux machines. Required 8 Years 3 - Expert Data warehouse DBA. Required 3 Years 3 - Expert dimensional data modelling. Required 3 Years 3 - Expert Development DBA. Required 3 Years 3 - Expert PL/SQL. Required 3 Years 3 - Expert ETL developer, preferably Informatica. Required 3 Years 2 - Proficient shell scripting and VB scripting. Highly desired 2 Years 1 - Basic experience working with REST APIs. Highly desired 1 Years 1 - Basic Experience working on different data formats ( JSON/XML etc) Highly desired 1 Years 1 - Basic experience working on NoSQL database and technologies ( example; MongoDB, Hadoop, Cassandra, Accumulo etc) Highly desired 1 Years 1 - Basic Experience delivering business intelligence solutions Required 6 Years 3 - Expert Experience with OLTP and OLAP database models Required 6 Years 3 - Expert *Please send me the Below Details along with the 2 Professional References to be considered for submission to the Client.* 1. Full Name: 2. Visa Status: 3. Availability: 4. Current Location: 5. Phone number: 6. Email: 7. Rate/Hr on W2/C2C/1099: 8. Phone Interview: 9. Face to Face interview: 10. Best time to reach: 11. Relocation: 12. If H1B, Visa Expiry Date: 13. Education Details: Degree: University: Month/Year: 14. Two Professional References: Client Name, Email id, Phone Number, Designation: -- *Thanks,* *Chandra* *T T Technologies* *Direct: 718-502-9424 | ALT: 703-468-4652* *EMAIL: [email protected] <[email protected]>| URL: *www.t3incorp.com <http://t3incorp.com/> -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/oracle-projects. For more options, visit https://groups.google.com/d/optout.
