Hope you are doing well!
This is Dinesh, representing Captevo Inc., We currently have an Data warehouse Architect with a major company located in Greensboro, NC.
Please review the job description below. If you are qualified and interested in pursuing this opportunity, please send me an e-mail with your Updated Resume; if you do respond via e-mail please include a daytime phone number so I can reach you. In considering candidates, time is of the essence, so please respond ASAP
Job Title: Data warehouse Architect
Location: Greensboro, NC
Duration: 1YEAR + months Contract
Interview Mode: Telephonic followed by F2F
Job Description:
Top 3 Skills required for this role:
- 5+ years of Enterprise Data Warehouse experience using an Oracle platform
- 5+ years of Data Modeling and Architecture experience
- Proven ability to work with and support the business.
VFS has requested an experienced Data Warehouse Architect to work on the design and implementation of VFS data warehouse solutions.
Job responsibilities:
- Work with the Data Warehouse team to translate business requirements into a technical architecture vision.
- Assist BI development team in the design of database solutions. Work with business owners and business users to understand and translate user requirements into logical data models, physical data model aligning with VFS global data models.
- Design and develop the architecture for data storage strategy, tool integration strategy, ETL strategy, data staging, movement and aggregation. Also work with Business Intelligence Analysts to develop information and analytic delivery and data quality strategy.
- Conduct profiling of data sources and determine cleansing and data quality rules.
- Work with BI team to incorporate business requirements into Models, Extract, Transformation and Load (ETL) processes. Manage Meta Data.
- Participate in the process of scheduling, extraction and loading of data to the Data Warehouse environment.
- Assist in the resolution of tuning and performance issues within the Data Warehouse environment.
- Administration of BI/ETL tools as necessary
Experience:
- A minimum of 5 years’ experience architecting large scale data warehouses using Oracle, knowledge of data vault architecture preferable.
- Experience in data profiling and data mapping to understand characteristics and availability of data in source system and how they map to data warehouse.
- Expert data modeling skills including conceptual, logical and physical model design. Experience with Operation Data Stores, Enterprise Data Warehouses and Data Marts.
- A comprehensive knowledge of the design and development of jobs using ETL, ELT and capture technologies. Be able to recommend the adoption of the right pattern for a given job and be able to speak to the pros and cons of each.
- Experience in populating Data Mart’s Fact tables and Dimensions, including the creation of Slowly Changing Dimension maintenance processes
- Expert RDBMS knowledge of Oracle (release 10g and 11g)
- At least 5 years of experience in Standard Query Language and a procedural language such as PL\SQL
- Provides expertise in devising, negotiating and defending the tables and fields provided in the database.
- Knowledge of Central Repository and Data Mart Architectures
- Familiarity with competing Data Warehousing philosophies and methodologies
SKILLS:
- Strong organizational skills with the ability to prioritize work effectively.
- Sound business judgment and decision making abilities.
- Customer Service and Quality focused with proven process improvement skills.
- Innovative problem solving, research and analytical skills.
- Effective written and verbal communication skills.
- Ability to work within and in support of a team environment.
Nice to have financial background – loans, leases, etc.
ETL tool = IBM Information Server
Looking forward to work with you!
Thanks & Regards,
Dinesh Duvvuru | Recruiter
Captevo Inc.,
Phone: (248) 237 7496
Disclaimer: We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e mails to you. We are sorry for the inconvenience
No comments:
Post a Comment
Thanks
Gigagiglet
gigagiglet.blogspot.com