Role - Data Architect
Location – Hillsboro, Oregon
Duration – 6-9 months
Mode: Phone and Skype
Responsibilities:
- Support financial analysis, planning and reporting functions by performing data management, programming, analytic and consultative activities including database, documentation and data trending assessment.
- Design, develop, QA and update data integration, profiling, and cleansing routines. Ensure all relevant metadata is captured and/or updated.
- Provide related modeling, mapping, and process assistance for structured and unstructured data.
- Design, develop, test, QA and update data integration (ETL, replication, change data capture), Data design/modeling, data profiling, and data profiling processes.
- Update and maintain metadata repositories and dictionaries. Responsible for creating, validating, and/or updating source-to-target maps.
- Help perform source analysis and supports departmental process improvement initiatives.
- Assist with logical and physical model design, source-to-target mapping, use cases, and other development processes and artifacts.
- Identify data subject areas, entities, attributes, relationships, information types, and domains.
- With project team, design and communicate logical and/or physical models and designs.
- Responsible for supporting identification of physical implementation requirements, including normalization techniques and referential integrity or dimensional techniques.
- Assist with defining, maintaining, and enforcing data architecture, definitions, and standards.
- Participate in data policy, standards, and procedure development processes. Perform code reviews, data model reviews, and testing.
- Establish standards and best practices.
- Work with IT partners to perform periodic system and database operational tests, audits, and tuning.
- Responsible for promoting understanding of data quality concepts and methods. Identify, document, and recommend solutions for poor quality data.
Qualifications:
- 5-8 years of related experience.
- Intermediate knowledge of database concepts, methodologies, and architectural approaches.
- Intermediate knowledge of knowledge of database concepts, methodologies, and architectural approaches. SQL and Oracle (preferred).
- Extensive knowledge of knowledge of database systems and administration, including security, development and testing support, modeling and logical design, database design, and qualify control.
- Demonstrate strong quantitative, analytical, and problem solving skills, with ability to adapt to new methods, techniques, and procedures.
- Intermediate knowledge of logical and physical data modeling and data modeling tools.
- Expert in complex SQL statements, Microsoft Access, SQL databases, VB programming language, Excel, Data Warehousing, ETL and possibly Crystal Reports. Proficient in Microsoft Office products (Word, PowerPoint, and Project). Knowledge of Business Objects, Crystal Reports, SSRS and/or Cognos is preferred. Extensive knowledge of Oracle ETL, replication, change data capture and other data integration techniques and technologies.
- Experience with Microsoft SQL Server 2008 Suite of tools (SQL SMS, SSIS, SSRS, SQL Server BI Studio, etc) helpful but not required.
- Ability to work effectively in a team environment.
- Excellent verbal and written communication skills required.
Bachelor's Degree in MIS, Computer Science or related field required.
Garima Gupta | Technical Recruiter | Apetan Consulting LLC
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at https://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment