*Please share your consultant profile at **[email protected] <[email protected]>*
*Job Details:* *Job Title : ETL Technical Architect* *Location : Plymouth, MN* *Duration : 12+ Months* *Interview Process : **Phone + F2F (Must be Local)* *Only USC/GC* *POSITION OVERVIEW:* The Technical Architect is a hybrid position as compared to larger shops in the industry. It combines the role of architect, consultant, troubleshooter, extract, transform and load (ETL), application developer and EAI expert into a single position. However depending on the domain (Application, Data, System, Security), level of expertise may vary. · Define, analyze, and review architecture and technical requirements. · Involve and recommend enterprise’s server hardware, operating system for the enterprise data warehouse. · Participates in the drafting of Service Level Agreements (SLA). · Lead a team of developers and mentor junior team members. · Involve in enterprise application integration (EAI). This includes defining the opportunities for integration, selecting the tools, specifying the shared data & code resources, defining the interfaces and data-flows, and monitoring the success of said integration. · Responsible for defining the application tiers, frameworks, components types and interfaces. Also, creates the first-draft graphical template of UML design models used by the Project Architects. · Specifies and provides ownership of reusable application components or reusable application code. · Sets Data Policy and the technical solution for the management, storage, access, navigation, movement, and transformation of data. · Specifies recommended DBMS and ETL tools and technologies for structured and unstructured content. · Reviews the policies and work of the Data Base Administrators. · Provide framework, stewardship, governance, and decision making for the management of enterprise data for project development teams, business users and other stake-holders. · Balance short-term versus long-term actions, strategic versus tactical requirements, while continuing to move forward towards the strategic vision; participate in the road map to achieve the vision. · Develop standards, process flows and tools that promote and facilitate the mapping of data sources, documenting interfaces and data movement across the enterprise. · Provide architectural solutions covering data structures, sourcing, integration, security, and retention · Define governance and best practices around meta-data to ensure an integrated definition of data for enterprise information, and to ensure the accuracy, validity, reusability, and consistent definitions for common reference data. · Elicit requirements and translate the requirements into models by building conceptual, logical and physical data models. · Involve in data roadmap, current / target state for enterprise data. *EDUCATION/EXPERIENCE:* *Education Level**:* Bachelor's Degree - BS in Computer Science or related field MS a plus *Years of experience required**:* 12 years minimum experience in software development and database applications with a majority of this experience in data strategy, souring, modeling, integration, and architecture. 3 years minimum managing Agile development methodologies for data warehouse projects. Prefer Healthcare experience and/or Provider knowledge. *Specific types of experience required:* · Experience in data analysis, data profiling, data integration, and data quality. · Provide framework, stewardship, governance, and decision making for the management of enterprise data for project development teams, business users and other stake-holders. · Balance short-term versus long-term actions, strategic versus tactical requirements, while continuing to move forward towards the strategic vision; participate in the road map to achieve the vision. · Develop standards, process flows and tools that promote and facilitate the mapping of data sources, documenting interfaces and data movement across the enterprise. · Provide architectural solutions covering data structures, sourcing, integration, security, and retention. · Experience in data analysis, data profiling, data integration, and data quality. · Define governance and best practices around meta-data to ensure an integrated definition of data for enterprise information, and to ensure the accuracy, validity, reusability, and consistent definitions for common reference data. · Experience in tuning Data Warehouses. · Extensive experience in creating data warehouses, data marts, and modeling (3NF and dimensional). · Data modeling experience creating both dimensional and relational models; ERWIN experience is preferred. · Advanced knowledge of SQL, database performance, RDBMS, and Query tools. · Prior experience in ETL, reporting and analytics, and business intelligence tools is preferred · Prior experience in health care domain is preferred. · Prior experience using Agile Development for Data Warehouse projects · CBIP (certified business intelligence professional) from TDWI is nice to have. *Skills Required: Yrs**.* » Business Intelligence 10+ Yrs » Data Modeling 10+ Yrs » EAI 10+ Yrs » ERWIN 10+ Yrs » ETL 10+ Yrs » Process Flows 10+ Yrs » SQL 10+ Yrs » UML 10+ Yrs *Nilesh Awadhiya* *Sage Group Consulting, Inc.* *3400 Highway 35, Suite # 9, Hazlet, NJ 07730 * *Office: 732-767-0010 X 227* *Direct: 732-658-5828* *Fax: 732-658-5828* *Email : [email protected] <[email protected]>* *Website : www.sageci.com <http://www.sageci.com/>* *Gtalk: nilesh.awadhiya |Yahoo IM: n_awadhiya* -- You received this message because you are subscribed to the Google Groups "Oracle Users" 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-users. For more options, visit https://groups.google.com/d/optout.
