Warren NJ 6-12 months phone and face to face Client is looking for ETL, Data Modeling, Erwin and experience with Basel 2 open positions---interviews will start quickly. Warren NJ 6-12 months phone and face to face Client is looking for ETL, Data Modeling, Erwin and experience with Basel 2 open positions---interviews will start quickly. ...View Job Details

3+ years experience with WebFocus Development Tools (ex. Developer Studio, Managed Reporter and Report Caster) - Must be current with latest version * Strong understanding of data warehouse concepts, designs and approaches * Strong understanding of Cubes and Dimensional Data * Strong ability to extract data from numerous sources and summarize into reporting tables * Good communication is required * Analytic, problem-solving and decision-making skills * Any experience with COGNOS is a plus NOT a must * SQL and/or DB2 experience and knowledge of relational DBs ...View Job Details

Title: Sr. Business Technical Analyst/ DataStage Designer Duration: 9-10 Months Location:Oak Brook, Chicago,IL Requirements: - At least 5 years experience in a BTA/BSA role in BI arena - At least 3 years of DatatStage designer/Sr. developer experience. - Strong Datawarehousing and OLAP reporting knowledge. - Strong DataStage design and development skills. - Good communication (written & oral) and presentation skills. - Expected to multi task across projects; good time management and organizational skills - Exposure to Teredata and MicroStrategy will be an advantage. ...View Job Details

This is for my direct client opening for a SAS Administrator - Reston, VA. This is a permanent position. The Salary range is DOE. Job Duties: Work as a tool administrator for Reportworks application and SAS 9.1.3 SP4 on Solaris 10. Reportworks is an in-house developed application using SAS 8.2 on AIX, Tomcat and Apache. The tool administrator plans, coordinates and implements the product upgrades and maintenance, troubleshoot system related problems, and will be responsible for the overall availability of the tools infrastructure and the environment. Other responsibilities include maintaining the tools roadmaps, presenting technical briefing to the support staff, developers and the management. Specific duties include: - Coordinate/perform major system upgrades and patches for underlying SAS infrastructure. - Maintain configuration data, user access and control within all applications. - Maintain the production/ DEV / UAT and testing environment - Serve as subject matter expert (SME) for SAS and Reportworks. - Perform minor customization and develop interfaces if required. - Conduct annual BCP exercises. Assist with capacity and disaster recovery planning and execution. - Work closely with UNIX and Storage administrators for routine operations such as performance tuning, upgrades and backup. - Manage vendor relationships with SAS (acquiring new patches, upgrades and promotes industry best practices) - Maintain Service level agreements with both customer and support organizations. - Maintain licenses and provides monthly metrics on the tool usage. - Maintain and document Data Profiles/ Engineering and architecture. - Coordinate the Prod/Non-Prod infrastructure deployments. - Support the third tier support call. - Completes/Follows/Maintain the segregation of duties (SOD), Sarbanes-Oxley (SOX) and/or audit compliance. - Troubleshoot and provide support for SAS 8.2/9.1.3 deployed on AIX/Solaris 10, Tomcat and Apache. Successful candidate should possess the following qualifications: - 3+ years with SAS 8.2/9.1.3 and 1+ years with SAS Business Intelligence. - 2+ years working with Apache/Tomcat or J2EE technology. - 2+ years working with UNIX and 6+ years of progressive IT experience. - Application Development background - Strong System administration skills (Unix/Windows). - Strong Scripting experience (Batch/Perl/Shell) - Strong verbal and written communication skills - Must be able to work effectively in a team environment. Please complete the following skills-matrix and send back with your updated resume. Full Name: Degree Major: Total IT exp: Total experience as SAS Administrator: Total experience with SAS 8.2: Total experience with SAS 9.1.3: Total experience with SAS Business Intelligence: Total experience with Apache/Tomcat OR j2EE: Total experience with UNIX: Total experience in Application Development: Total experience in System Administration (Unix/Windows): Total experience with in Scripting (Batch/Perl/Shell): Total experience with Reportworks: Current Salary: Expected Salary: Day Phone #: Evening Phone #: Cell Phone #: Availability: Current City/State: Work Status (US Citizen / Green Card / Others): Are you ready to relocate on your own expenses (Yes/No)? ...View Job Details

Job Title : DW Tech Lead ( BO focus) Skill req : BO Developer/Admin Strong BO skills, data analysis, Business Objects Designer, create new Data Warehouse/Analytical solutions Job description: Defines, designs and develops systems to support real-time trading, deal structuring and risk management. Investigates analyzes, documents and resolves issues surrounding complex financial products and models. Liaises with research. ****Contact*** Khushboo  ...View Job Details

Main Responsibilities: Meet with business stakeholders and other technical team members to gather and analyze application requirements Design data integration solutions to satisfy application (business and technical) requirements Implement data integration solutions using Informatica PowerCenter. Provide written status reports to management regarding project status, task, and issues/risks Design, develop, and maintain database applications for the Wealth Management group Work with product managers, project managers, and other development team members on a daily basis to analyze requirements, design, and develop database applications. Desired Skills: Experience in financial service industry is a plus ...View Job Details

We have a need to hire a Data Warehouse Business Intelligence Reporting Consultant for the Sacramento area. Qualified candidate will have the following experience: 5 years experience Enterprise Architect. 5 years experience with Oracle Business Intelligence Suite 2 years experience with Troux (understand how to access and build architected information modeled in Troux) Minimum of 2 years experience with MS Office Suite (Word PowerPoint, Project, Visio and Excel) 2 years experience as a Data Model Analyst 2 years experience on how to plan and publish ad a work break down schedule. At least 2 years experience with Enterprise Oracle Portal Excellent client interface communication; verbal and written ...View Job Details

Positions : 2 Technical Skills & Knowledge: The ideal candidate should have exceptional Strong technical, Communication and possess the specific technical/application expertise listed below Significant IT experience – 8 years Experience Data warehouse Modeling, PowerDesigner, Teradata, OLAP, Previous Wells Fargo experience ...View Job Details

Need for a BI Consultant. Face to face interview reqd in WA. ...View Job Details

Job Description: Informatica ETL Developer The ETL Developer role will help with developing the foundational technical architecture support for deploying a new Informatica environment in Informatica 8.3. This person will also play a key role in developing the data integration solutions for the Client's integration Projects. Individual will be responsible for developing ETL mappings for Client's mainframe elimination project using Informatica. Person should have strong background in Data Warehousing, dimensional modeling and Oracle (PL/SQL) development to integrate Informatica processes to work in conjunction with existing PL/SQL ETL processes. Responsibilities Integration Tasks: Design strategy to integrate Client fee and volume data into Client's data warehouse Develop ETL maps using Informatica to integrate Client fee and volume data Develop process to move Informatica packages from Dev to QA and Production. Standards Development: Document Create Best Practices document for transformation usage Document best practices for tool usage strategy comparing Java, PL/SQL vs. Informatica Document Create ETL Standards Naming Conventions Map Design Standards Metadata Management Standards Best practices for handling slowly changing dimensions Infrastructure/Production Support Tasks: Develop Disaster Recovery Develop restart recovery processes and procedures Document Repository Setup and usage Standards and Mapping Standards Develop code migration standards and procedures Support Environment Migrations Document Security Architecture Development Support Task: Development and manage cross team scheduling standards and thread management (Manage Cross Team Runbook) Develop Shared components Develop File Management and Input/Output Feed hub Develop Batch control processes Design/Develop Shared Error/exception/reject management handling Develop Target Record Deletion Process Design and Develop shared mapplets for time, input/batch control, load processes Skill sets required: 4+ Years developing Informatica solutions in a Unix/Linux environment Experience with high volume datasets from various sources (Cobol, Text Files, XML, Relational) Experience with multi-threading and parallel processing using Informatica Experience with common Data Warehousing terminology Experience using Informatica integrated with web services Experience in developing and documenting environment setup processes, procedures and shared components Experience supporting multi-team environments Experience with general scheduling tools such as UC4 ...View Job Details

Client is looking to hire a Data Warehouse Business Intelligence Reporting Consultant for the Sacramento area. Qualified candidate will have the following experience: 5 years experience Enterprise Architect. 5 years experience with Oracle Business Intelligence Suite 2 years experience with Troux (understand how to access and build architected information modeled in Troux) Minimum of 2 years experience with MS Office Suite (Word PowerPoint, Project, Visio and Excel) 2 years experience as a Data Model Analyst 2 years experience on how to plan and publish ad a work break down schedule. At least 2 years experience with Enterprise Oracle Portal Excellent client interface communication; verbal and written ...View Job Details

Very Very Immediate Need For Below Position !!!! Job Title : Data Modeler (Staging Data Modeling) Location : Thousand Oak, CA Duration : 4/30/2010 with potential to extend 3 to 6 months Rate : $55 On C2C Required Skills: Resolve gaps between the requirements and the technical specifications. Provide traceability document to ensure source data is aligned to requirements. Reverse engineer the source systems, model in ER Studio, publish the DDL for implementation in Teradata and provide metadata for source/target mappings. Produce data model solutions meeting technical specifications and business requirements according to the established designs. Conducts data model reviews. Technical domain includes conceptual, logical, and physical data modeling. ...View Job Details

7+ years of ETL development and data warehousing experience Strong preference for experience with TIBCO Data Exchange ETL (previously named Embarcadero DTStudio) Deep knowledge in pervasive ETL toolset (Informatica/Ascential) may be substituted including system administration and change management. Strong ability in ETL performance tuning in an Oracle environment Experience in Unix scripting Familiarity with ETL testing an quality assurance methods Web-based application development, framework object development experience, Oracle Relational Databases and J2EE platform development a plus BS in CS or MIS required or related experience ...View Job Details

We have a need to hire a Data Warehouse Business Intelligence Reporting Consultant for the Sacramento area. Qualified candidate will have the following experience: 5 years experience Enterprise Architect. 5 years experience with Oracle Business Intelligence Suite 2 years experience with Troux (understand how to access and build architected information modeled in Troux) Minimum of 2 years experience with MS Office Suite (Word PowerPoint, Project, Visio and Excel) 2 years experience as a Data Model Analyst 2 years experience on how to plan and publish ad a work break down schedule. At least 2 years experience with Enterprise Oracle Portal Excellent client interface communication; verbal and written ...View Job Details

7+ years of Cognos development and data warehousing experience 7+ years with Oracle PLSQL Strong ability in reports performance tuning in an Oracle environment Experience integrating Cognos security components with external security components (LDAP, OAM, AD) Knowledge of Oracle security structures, OAM and OID, preferred Familiarity with ad hoc and pre-generated reports testing and quality assurance methods ...View Job Details

Need senior information architect that will work cross functionally across Client to develop logical architecture. They will need to analyze core platform data and identify gaps between the current and future state of project. Need the ability to create detailed design of the IA reference architecture. This posting is for an INFORMATION ARCHITECT Client is currently looking for a senior data architect with hands-on development skills to lead enterprise information architecture modeling efforts. The candidate should have strong experience in Data Architecture, Data Governance, SOA and in developing enterprise data models, data mapping documents, and semantic modeling. As part of this effort, the consultant will: Facilitate solution definitions by synthesizing information across multiple domains Drive data analysis efforts to define common data formats to support specific projects Engage/Assemble/Define a data governance strategy to resolve data terminology/definition issues Perform conceptual data modeling and data mapping Conduct data quality assessments to validate solution options Produce supporting project documentation Requirements 7+ yrs experience in the IT profession, with 3+ years serving in an information architecture role 3+ yrs experience with Data Management, Data Integration and Data Quality efforts 5+ yrs conceptual, logical and physical data modeling experience at the enterprise level 5+ yrs experience with large relational databases in a high performance environment Experience with Informatica PowerCenter, PowerExchange, and MQ Series is highly desirable Experience with Healthcare industry is strongly preferred Strong communication/documentation skills and ability to work at many different levels throughout the organization Qualifications BS/BA degree in computer or information science discipline required Five years of experience in architecture/design in relevant technology disciplines; five years of experience in information technologies preferred 3+ years experience with Data Integration tools, projects, etc. Proven ability to lead cross-enterprise initiatives Health care industry experience preferred Please note this postion is for a INFORMATION ARCHITECT Designs and builds relational databases. Develops strategies for data acquisitions, archive recovery, and implementation of a database. Cleans and maintains the database by removing and deleting old data. May require a bachelor's degree in a related area. 8-10+ years of experience. Demonstrates expertise in a variety of the field's concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. May provide consultation on complex projects and is considered to be the top level contributor/specialist. ...View Job Details

10+ years of experience with very good communication Strong OBIEE Architecture skills Ability to design OBIEE solution and experience working with Oracle BI Apps a must Knowledge of Oracle ERP – 11i CRM Install Base and Contract Data from BI perspective is expected Knowledge of other Oracle ERP modules such as Financials, QTC is expected Knowledge of Salesforce.com integration in BI is expected Ability to design an enterprise-wide data integration strategy Analysis of application and data integration problems, provide solutions and recommend corrective actions. Any Security company or Data centre or Infrastructure data Analytics project experience will be a plus ...View Job Details

I need a very GOOD Infomatica resource in NY financial domain is must have local resources ...Direct Clients ...View Job Details

Minimum requirement: at least 5 years of SAS programming experience of claims and/or electronic medical record databases in the pharmaceutical industry, and/or CRO health-related consulting company, and/or academia. Must be proficient in SAS macro and SQL. Must be able to execute multi-step data management tasks, recognize technical problems and solve with minimal assistance. Job Description The Sr. SAS Programmer, Global HEOR and Clinical Epidemiology, will be responsible for the following: Perform SAS programming and analyses for epidemiology and HEOR using large medical claims and electronic medical records databases. Assist in developing analysis plan and summarizing and synthesizing results into reports and publications. Assess technical feasibility of database studies and required resources and timelines. Conduct review of existing data, including literature review, for the purpose of developing study concepts. Create, modify and execute plans to validate database studies as necessary, and document steps taken in accordance with standard procedures. Clean and merge data from multiple files (e.g., medical, pharmacy, enrollment, lab). Act as data consultant to other SAS programmers and researchers. ...View Job Details

Job Title: Sr. SAS Developer Location: Atlanta, GA Job Type: Contract / Fulltime (Permanent) Job Description: Need Sr SAS Developer with EXPERT in SAS MODELING (very important and must) . Please send me resume with following detail: Full Name: Contact #: E-mail: Current Location: Relocation [Yes/No]: Availability: VISA Status: Expected Rate: Total Exp: Relevant Exp: Thanks & Regards, Ram Prakash E-Solutions Inc. Phone Fax  ...View Job Details

Need 10+ years to total IT experience, 5+ years of DataStage experience, 3+ years of integration with SAP (R/3, ECC) experience, RTL a plus. Description: Provide the definitive technical solutions to the development, maintenance, and enhancement of business applications, providing specialized technical or business knowledge to projects to integrate SAP and Non SAP systems using DataStage (InfoSphere). Experience with Ready To Launch (RTL) a plus. Identify causes and implementing solutions to business problems in a multifunctional project, assessing and communicating issues of technology impact on the business. They also apply a broad knowledge of various technical functions to accurately anticipate organizational impacts. They share responsibility with other team members to ensure on-time product delivery. ESSENTIAL DUTIES AND RESPONSIBILITIES: Strong DataStage technology skills required to provide architecture and design solutions in the areas of Build and Governance. Strong leadership skills to manage a team of developers. Knowledge of ETL development using InfoSphere-DataStage as the tool set. Experience in integration with SAP (R/3, ECC) system using DataStage. Experience in Ready To Launch (RTL) a plus. Knowledge of data warehousing architecture, including modeling needed to support it. In-depth knowledge of Systems Development Life Cycle with a strong emphasis on the following: Engagement, Analysis, Design, Development and Deployment. Possess good coaching skills. Knowledge of network architectures and systems performance consideration. Working level knowledge of software development, systems life cycle methodologies; rapid application development techniques preferred. Proven track record in workflow, application functionality enhancements. Strong verbal and written communication skills, with an ability to express complex technical concepts in business terms. Strong analytical, problem-solving, and conceptual skills. Solid teamwork and interpersonal skills, ability to work well on cross-functional project teams and foster team commitment to tasks. Under the guidance of the manager, collaborate with company customers, staff members, IT colleagues, and other stakeholders to define detailed customer requirements and system interfaces, assess available technologies, and develop and present solutions. Provide technical consulting support on projects or system issues. Participate with other IT members, customers, and other stakeholders in new product reviews, tests, and pilots. Collect and analyze business requirements for large, multifunctional projects. Perform feasibility studies, translating requirements into an appropriate design, identify conflicting business practices and integration issues, suggesting alternative solutions. Foster and maintain good relationships with customers and IT colleagues to meet expected customer service levels. ...View Job Details

Title: SAS Programmer Duration: 12 months Location: Waukegan, IL (MUST be local to Chicago/N. suburbs) Start: ASAP Interview: F2F/Phone Rate: $35/hr all inc. 1) Minimum requirement: at least 5 years of SAS programming experience of claims and/or electronic medical record databases in the pharmaceutical industry, and/or CRO health-related consulting company, and/or academia. 2) Must be proficient in SAS macro and SQL. 3) Must be able to execute multi-step data management tasks, recognize technical problems and solve with minimal assistance. Job Description The Sr. SAS Programmer, Global HEOR and Clinical Epidemiology, will be responsible for the following: 1) Perform SAS programming and analyses for epidemiology and HEOR using large medical claims and electronic medical records databases. 2) Assist in developing analysis plan and summarizing and synthesizing results into reports and publications. 3) Assess technical feasibility of database studies and required resources and timelines. 4) Conduct review of existing data, including literature review, for the purpose of developing study concepts. 5) Create, modify and execute plans to validate database studies as necessary, and document steps taken in accordance with standard procedures. 6) Clean and merge data from multiple files (e.g., medical, pharmacy, enrollment, lab). 7) Act as data consultant to other SAS programmers and researchers. MAJOR RESPONSIBILITIES: Responsible for creating, performing statistical analysis on, and maintaining the integrity of the analytic databases POSITION ACCOUNTABILITY/SCOPE: Exercises judgment in selecting innovative, practical methods to achieve problem resolution. Failure to obtain results or erroneous decisions or recommendations would typically result in serious delays and considerable expenditure of resources. PROBLEM SOLVING: SAS programming and analytical problem solving skills required. Education Requirements Minimum BS degree. MS or MPH in statistics/biostatistics preferred. ...View Job Details

5 years experience Enterprise Architect. 5+ years experience with Oracle Business Intelligence Suite 2 +years experience with Troux (understand how to access and build architected information modeled in Troux) Minimum of 4 years experience with MS Office Suite (Word PowerPoint, Project, Visio and Excel) 2 years experience as a Data Model Analyst 2 years experience on how to plan and publish ad a work break down schedule. At least 2 years experience with Enterprise Oracle Portal Excellent client interface communication; verbal and written ...View Job Details

Skill set should be: Description: 5 years of system integration experience using xml from either a business or technology perspective 5 years of Business Analysis / Data Modeling experience Technically savvy (knows XML, can adapt to super user tools, XSL a plus) ...View Job Details

Location(Two Locations specified): Minneapolis, MN (or) Des Moines, IA Leads the planning, analysis, design, implementation, maintenance, and control of the organization's server-class databases. Consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction. Handles and leads various large-scale or highly complex data/database management activities including one or more of the following: designing highly complex logical and/or physical databases; leading highly complex data modeling, mapping, integration, and capacity planning efforts; developing management policies, procedures and standards; and business requirements identification, analysis and development. Provides mentoring, guidance and general oversight to less experienced staff in a variety of database design, administration and or modeling activities. Power Designer and Teradata experience a plus. ...View Job Details

This position is primarily an expert Sr. ETL Developer. Candidates must have over 7 years experience at Enterprise-level ETL architecture and development using Informatica (currently on v8.5). Ability is required to work in setting strategy and standards, through logical and physical modeling into actual implementation. A minimum of 5 years with SQL and PL/SQL on Oracle is required. A minimum of two years working with Unix and Unix shell scripting is required. The Diagnostics Division is kicking off several enterprise-level IT initiatives, all of which involve complex data models. The proper ETL architecture, standards, and best practices are critical for the success of these major initiatives going forward. This position is needed to collaborate with existing ETL resources to set the ETL architecture, standards, and best practices using cutting edge industry standards. This position will also be involved in ETL Development and mentoring of other ETL developers. This person will be interacting with all levels of divisional IT management, architects, project managers, BSAs, DBAs, business customers (data consumers), etc. Based on this extensive interaction, superb verbal and written communication skills are required. Excellent interpersonal skills, teamwork skills, problem solving skills, and being a detail-oriented self-starter and self-motivator are all required. ...View Job Details

Location : Raleigh-Durham, NC Required Skills : The client has asked me to begin a search for senior ETL developers Informatica Oracle 8.x Unix/HP (Unix will be more important than HP) TOAD ...View Job Details

Sr. Data Warehouse Lead Developer with experience in report analysis and creation and reviewing of SQL monitoring tools. The resource must have experience as business analysis, working directly with users from design through implementation and must have SQL Server 2008, SQL Server Development using TSQL, SQL Server BI tools, SQL Server Reporting Services, SSIS and SSAS. ...View Job Details

Sr SAS Developer with EXPERT in SAS MODELING Location:Atlanta,GA Hire:Contract Thanks & Regards Abhishek Sinha e-Solutions Inc Ph E-mail: Thanks & Regards Abhishek Sinha e-Solutions Inc Ph E-mail: ...View Job Details

Need Sr SAS Developer with EXPERT in SAS MODELING (very important and must) . 6+ Months Contract rate low Atlanta, GA Thanks & Regards Jamal Tariq E-Solutions Inc. Ph Fax E-mail: ...View Job Details

Data Mart with Murex Trading System Data Mart , Murex Trading System , MXML or XML. Cedar Rapids, IA Face to Face Interview is in NY. 6 – 12 Months ...View Job Details

Title: Sr. Informatica Developer with MS SQL Server and SAP BW Experience Location: Reno, NV Duration: 6+ Months Rate: Open Required Skills: • Need Sr. ETL/Informatica Developer with MS SQL Server and SAP BW Experience • Must be strong hands of MS SQL Server Experience required • Informatica SAP R3/BW Connector • Informatica Power Center 8.x • Informatica Administration • Excellent communication skills ...View Job Details

Provide the definitive technical solutions to the development, maintenance, and enhancement of business applications, providing specialized technical or business knowledge to projects to integrate SAP and Non SAP systems using DataStage (InfoSphere). Experience with Ready To Launch (RTL) a plus. Identify causes and implementing solutions to business problems in a multifunctional project, assessing and communicating issues of technology impact on the business. They also apply a broad knowledge of various technical functions to accurately anticipate organizational impacts. They share responsibility with other team members to ensure on-time product delivery. ESSENTIAL DUTIES AND RESPONSIBILITIES: - Strong DataStage technology skills required to provide architecture and design solutions in the areas of Build and Governance. - Strong leadership skills to manage a team of developers. - Knowledge of ETL development using InfoSphere-DataStage as the tool set. - Experience in integration with SAP (R/3, ECC) system using DataStage. - Experience in Ready To Launch (RTL) a plus. - Knowledge of data warehousing architecture, including modeling needed to support it. - In-depth knowledge of Systems Development Life Cycle with a strong emphasis on the following: Engagement, Analysis, Design, Development and Deployment. - Possess good coaching skills. - Knowledge of network architectures and systems performance consideration. - Working level knowledge of software development, systems life cycle methodologies; rapid application development techniques preferred. - Proven track record in workflow, application functionality enhancements. - Strong verbal and written communication skills, with an ability to express complex technical concepts in business terms. - Strong analytical, problem-solving, and conceptual skills. - Solid teamwork and interpersonal skills, ability to work well on cross-functional project teams and foster team commitment to tasks. - Under the guidance of the manager, collaborate with company customers, staff members, IT colleagues, and other stakeholders to define detailed customer requirements and system interfaces, assess available technologies, and develop and present solutions. - Provide technical consulting support on projects or system issues. - Participate with other IT members, customers, and other stakeholders in new product reviews, tests, and pilots. - Collect and analyze business requirements for large, multifunctional projects. - Perform feasibility studies, translating requirements into an appropriate design, identify conflicting business practices and integration issues, suggesting alternative solutions. - Foster and maintain good relationships with customers and IT colleagues to meet expected customer service levels. - 10+ years to total IT experience, 5+ years of DataStage experience, 3+ years of integration with SAP (R/3, ECC) experience, RTL a plus. ...View Job Details

Essential Duties: - Implement logical and physical models for all layers of the data warehouse data model - Develop and implement data migration scripts - Participate in performance tuning activities including partitioning strategies, indexing strategies, and SQL optimization - Map data elements of data sources into the domain data models. - Determine and document business rules to be applied to data cleansing. - Coordinate with development/implementation team to improve model formats and approaches with regard to implementation issues. - Maintain BDM and LDM model - Plans and implements strategies for bundling software for loads into multiple environments. - Assists in all aspects of implementation of normalized Relational and Multi-dimensional Data Models. Computing Skills: MS Office tools (MS Word, MS Excel, MS Project) Data modeling tools such as ERwin Extensive knowledge of Data Integration and BI topics Synthesize complex or diverse information Read, analyze, interpret general business periodicals, professional journals, technical procedures or government regulations Identify and resolve problems in a timely manner Responsibilities: • Responsible for conducting data analysis and data modeling. • Assists higher level team members to ensure development efforts integrate with the production of the enterprise data architecture. • Knowledge of data system platforms and database programming languages, inter-process communications, and the replication process between databases • Understanding of enterprise data architecture principles • Advance knowledge of tuning methods • Knowledge of Data Extract-Transform-Load skills (e.g Data Mapping using Informatica tool) • SQL skills (e.g., tuning SQL queries) • Strong data analysis skills (e.g., identifying data sources and needs), • Troubleshoots or addresses significant limitations or problems of technology applications • Uses judgment and creativity and sound technical knowledge to obtain and recommend solutions. • Ability to tailor information to multiple user audiences, including customers and senior management • Must be able to interact with customer to set and meet project goals with only general instruction. • Outlines potential cost/savings outcomes of technology use • When faced with critical problems or issues, acts decisively to pursue resolution • Ability to work on ‘stretch’ work assignments and act decisively when faced with critical problems • Must be able to work with multiple groups to resolve data issues • Provides constructive feedback to the team, suggesting actions to improve individual and team performance • Assists the team to accomplish its goals beyond his/her assigned work Bachelor of Science Degree and 7+ years of experience or equivalent ...View Job Details

Need Sr SAS Developer with EXPERT in SAS MODELING (very important and must) . Contract / full time Atlanta, GA If you are interested for this position please send me your updated resume with following details. Full Name: Contact No: E-mail: Current Location: Willing to relocate: Availability: Visa status: Expected Rate: For details Contact Payal E-Solutions Inc. Desk Email: Linked in: Yahoo IM: payal_kdo ...View Job Details

Job Title - Initiate MDM Technical Consultant Job Description Working in this position, this individual will provide technical expertise across the MDM work-stream for bringing multiple sources of data into a central data hub. This individual will act as an expert in architectural design, technical requirements, and production deployment and in guiding project teams on key technological decisions, architectural standards and best practices. Will promote, support, and standardize usage of MDM. Will be responsible for directly working with Business System Analysts, ETL analyst, Data Stewards to capture and document requirements, build use cases and will participate hands-on in design and development of components, services, standards and methods. Qualifications - 8-10 years information technology/systems development experience required. - Must have hands-on experience in architecting, designing and maintaining enterprise-scale, MDM implementation. - Should have 3+ experience in MDM architecture with Initiate Systems. HA environment is a must. - Candidate should be able to ensure successful implementation of MDM components. - Handon experience on Informatica 8.6 ETL tools & administration is a big plus. - 3 + years messaging architectures, Web Servers/services, Application Server - Experience with the Initiate technology stack and APIs. - Work closely with other analysts/engineers and develop performance metrics and associated guidelines and best practices. - Ability to work effectively on a variety of development platforms such as Solaris, Linux. - Experience designing, building, and maintaining test frameworks using common tools, such as JMeter ...View Job Details

Description: We are looking for consultant with Data conversion experience from PeopleSoft to SAP environment. Need 2 Informatica resources who have conversion experience from PeopleSoft to SAP environment. Start date: mid-April for both Duration: 6 months Location: Houston, TX ...View Job Details

Location – Sacramento, Ca Duration – 6 months •5 years experience Enterprise Architect. •5+ years experience with Oracle Business Intelligence Suite •2 +years experience with Troux (understand how to access and build architected information modeled in Troux) •Minimum of 4 years experience with MS Office Suite (Word PowerPoint, Project, Visio and Excel) •2 years experience as a Data Model Analyst •2 years experience on how to plan and publish ad a work break down schedule. •At least 2 years experience with Enterprise Oracle Portal •Excellent client interface communication; verbal and written ...View Job Details

General Duties/Essential Functions: q Provide time and cost estimates for architecture design and development on data warehouse projects q Provide recommendations on system and architecture changes to improve performance and efficiency and see these recommendation through to implementation q Complete development of solutions using Oracle Data Integrator Enterprise Edition (ODIEE). Background Requirements: q Minimum of 5 years of data warehouse analysis, design and development experience (7-10 years preferred) q Minimum of 10 years of overall Information Systems experience required q Expert level knowledge of ETL tool Oracle Data Integrator Enterprise Edition required q Experience with Oracle required q Business Analyst experience on multiple data warehouse projects preferred q Developer experience on multiple data warehouse projects q Practical expertise in full lifecycle database design and dimensional design concepts. q Proficiency in SQL coding and troubleshooting q Experience in DW specific disciplines such as Data Quality and Cleansing, Data Governance, Metadata usage and management, and Master data management. Responsible for data warehouse system performance in several environments q Expert Knowledge of Kimball data warehouse design recommendations q Knowledge of Unix Scripting and SAS preferred q Bachelor’s degree preferre ...View Job Details

Required skills: Design and develop the data transformations for source system data extraction; data staging, movement and aggregation; information and analytics delivery; data quality handling Generation and administration of system test plans Mentor, develop, train and assist team members Possesses a minimum of (4) four years of relevant ETL tool experience with leading ETL tools such as Informatica Should have worked on at least two large projects using Informatica Project description: Specific needs for particular skill sets to supplement current team on-site in the area of ETL (Informatica) Currently the ETL team supports the data integration activities for many different applications and development projects within the areas of data warehousing and some operational applications. There are multiple projects in which the ETL resources will be participating, in order to satisfy AHM’s requirements. These projects require the unique technical qualifications of having experience with ETL, RDBMS, XML and Informatica software. The current ETL environment consists of multiple Informatica Powercenter Repositories and Powercenter Integration Services on different servers in a heterogeneous environment with many different source and target platforms. ...View Job Details

Send your resume to ; Client is seeking to work only on W2 ( NO Corp to Corp). Position: Informatica Architect (784839) Location: Richardson, TX Duration: 12+ Months contract The main role is to design Informatica solutions for an enterprise level data warehouse. Experience in large data warehouse environments with complex Processing requirements Excellent knowledge of SQL/Oracle and relational databases Excellent knowledge of ETL concepts Ability to help interview business and understand their business requirements Ability to document the business requirements Full Description: Excellent knowledge of SQL/Oracle and relational databases Excellent knowledge of ETL concepts Ability to help interview business and understand their business requirements · Ability to document the business requirements Ability to review business requirements and provide business analysis to develop technical requirements and database design considerations Demonstrated experience integrating systems in multi-user, multi-platform, multitasking operating systems environments Developing High level design/Detail level documents Required skill 1 Informatica PowerCenter Required skill 2 Strong experience in SQL/PLSQL with any Oracle as database. Required skill 3 Unix · Excellent Communication Skills. · Excellent technical skills for technologies mentioned below. Must be able to work flexible hours when required. Objectively distinguish between alternative methods to achieve maximum effectiveness. A logical mind which can systematically organize and consolidate scripts for workaround and production support. Ability to perform multiple tasks simultaneously. A positive attitude and consistently demonstrated willingness to help others. A self starter who will pursue assignments with interest and enthusiasm. Skill/Role Level Years Preference Informatica Expert 5.0 Required SQL (Structured Query Language) Expert 5.0 Required UNIX Expert 5.0 Required Oracle Expert 5.0 Required ETL (Extract Transform Load) Expert 5.0 Required Architect Expert 5.0 Required Informatica Powercenter Expert 5.0 Required Let me have the following details: Date of Availability: Rate per hour on W2: Current Location: Updated Resume: Appreciate, if you can refer your friends for this position. I am looking forward to hear from you… Best Regards, Murali Mohan, MGL Americas Inc, Versatech Consulting Inc., Direct Ext. # 2006 | Fax | |||| 1249 South River Road, Suite 102, Cranbury, NJ 08512 ...View Job Details

Title: Data Analyst Location: Washington, DC Duration: 3 Months+ The individual will perform analysis to identify the lineage/ data flow on data elements, document the lineage and other meta data for inclusion in metadata repository. Assist in testing, from data governance perspective, of METADATA and data quality tools. The incumbent may assess business operations and processes of assigned office or business unit to document procedures, information flows and handoffs, decisions, communications pathways and the like. In a support function will create, design, and format technical specification documentation including architecture diagrams, process flows, and other information or processes needed to describe required system changes for development, QA, and other internal customers. This individual will perform analysis and document findings. The following skills are desirable: -Ability to review and understand data architectures and data models -Data Governance performance metrics scorecard development -Ability to develop processes and procedures for governing data movement, data integrity, metadata and other components of data management -Ability to develop data specific requirements to support projects across the enterprise and perform testing of data management tools that support data governance functions. -Perform data profiling, data quality rules development and assessment using data quality and metadata tools ...View Job Details

We have a need to hire a Data Warehouse Business Intelligence Reporting Consultant for the Sacramento area. Qualified candidate will have the following experience: •5 years experience Enterprise Architect. •5 years experience with Oracle Business Intelligence Suite •2 years experience with Troux (understand how to access and build architected information modeled in Troux) •Minimum of 2 years experience with MS Office Suite (Word PowerPoint, Project, Visio and Excel) •2 years experience as a Data Model Analyst •2 years experience on how to plan and publish ad a work break down schedule. •At least 2 years experience with Enterprise Oracle Portal •Excellent client interface communication; verbal and written ...View Job Details

Job Details: Job Title: Business Intelligence Architect Location: 2 Year Contract Job Type: Downtown Manhattan, NY REQUIREMENTS • We need a BI architect with a Microsoft discipline/background. • SSIS, SSRS, SSAS • Financial services background. you can reach me at syed dot mokheed at benvia dot com ...View Job Details

Business Intelligence Duration : 5 month(s) Location : MI, Detroit Skill & Job Description Must be an INDEPENDENT CONTRACTOR Location: Start Date: 3/22/2010 Estimated End Date: 8/31/2010 We are looking for an experienced architect to provide technical guidance and leadership for several projects in Business Intelligence Proven architectural experience for a Data Warehousing project (minimum 3 years) Full knowledge of data warehouse design concepts and development best practices Proven experience with database technologies, data architecture, data analysis, and modeling Practical experience with common modeling and development tools (e.g. ERWIN, Informatica, Oracle) The candidates will be asked to describe past project work and be able to demonstrate their knowledge as part of the interview process. ...View Job Details

Duration: 6-12+ months The responsibilities of an AbInitio - ETL Specialist include: Sourcing the data from the operational systems . Applying the business transformation rules. Preparing a database-loadable file for the Data Warehouse. Management of the deployment of the data acquisition tool(s). Contributing the technical metadata to the metadata repository . A brief description of each of these responsibilities follows. The AbInitio ETL Specialist will extract data destined for the Data Warehouse from the operational systems that store the data. The specific tasks are: Work with the source system analysts to understand the windows available for data extraction Program, test, implement and maintain any data extraction programs necessary to extract the data from the operational systems needed to be moved to the Data Warehouse The Data Warehouse Application Programmer is responsible for applying transformation rules as necessary to keep the data clean and consistent and therefore usable by the user community. Specific tasks include: Participation in design sessions chaired by data stewards and/or IT personnel where decisions are made involving the transformation from source to target. Programming the data acquisition tool with the rules to be applied to the data. Ensuring the correct application of the business rules through data query after the data is loaded into the Data Warehouse. Mentoring junior or inexperienced developers in the use of the AbInitio tool with the intention that these individuals will gain the necessary skills to be effective in future projects Following the data extraction and rules application, the file(s) will need to be made ready for loading into the Data Warehouse. This is the responsibility of the Data Warehouse Application Programmer. Specific duties include: Obtaining complete knowledge of the physical database schema Preparing the files needed to load each table that has been designated to receive files from operational systems rather than direct input from data stewards Programming the data acquisition tool(s) with the tables to load the files. Working with the Data Warehouse Database Administrator to ensure the file loads properly into the Data Warehouse The metadata repository will contain technical metadata such as data sources and transformation rules applied. The AbInitio ETL Specialist will be responsible for the entry and maintenance of this information. ...View Job Details

Role: PWI Meta Data Administrator/Project Manager Location: Boston Duration: 3.5 - 4 months Strong communication skills required First few week’s position will be strategic in nature analyzing current Infrastructure. Remaining time will be spend performing Metadata Administration. Metadata center DAG, automating capture using Metadata tools. ETL, DB2, Consultant must be both functional as well as a strong administrator. Client will not consider a purely technical consultant. Job Description: Oversee creation and maintenance of MetaCenter repository databases. Enforce internal processes to optimize the use of meta data administration tools. Understand the organization’s usage patterns and processes to establish the blueprint in MetaCenter or any other repository of choice. · Implement folder structure for meta data content in Meta Center. · Set up access control templates aligned to data governance roles and PWI organization. · Set up MetaCenter User Access and permissions aligned to data governance roles. Adhere to change control processes: coordinate changes to content in a given environment in a controlled and organized manner. Manage the flow of meta data to and from Development, Test, and Production environments. Make approved extensions to the repository schema. Facilitate automated relationship connections between objects in MetaCenter. Assist business users with meta data input as required. Check content submissions against standards: · Data Modeling best practices · Meta data compliance & completeness · Data Description and Naming Standards · Process quality and completeness Create standard queries and meta data reports – extracts of meta data per constituency, published via portal or other mechanisms: e.g. · Glossary of Terms · Standard Data Definitions · Keyword Glossary: Terms and Std. Abbreviations · Where-used impact reports · Basic Lineage Ensure that meta data server content backup is scheduled to be performed per SLA. Participate in testing content restore capabilities. Liaise with DAG for maintenance and enhancement requests. Job Requirements: Minimum 3-4 years of data management experience Knowledge of meta data standards, especially data description and naming standards Familiarity with at least one commercial meta data repository product. Experience and understanding of meta data objects that are typically found in meta data repositories. For example: · Data Models: Conceptual, Logical, Physical · ETL: Informatica processes – to what level of detail? Informatica also has its own tool repository. · BI reporting environments · Databases o Data Sources – internal and external i.e. record-keeping systems, Industry code sets o Data Targets – Data Warehouse, Data Marts o Reference data servers o Database Views Highly process-focused individual. Ability to create simple scripts as required to provide useful meta database functionality or customization that may not be available “out of the box”. ...View Job Details

Position : Data Modeler (Staging Data Modeling) Location : Thousand Oaks, CA Duration : 2 Months (with potential to extend.) Required Skills: Collaborate with the BIBA and BDA to resolve gaps between the requirements and the technical specifications. Provide traceability document to ensure source data is aligned to requirements. Reverse engineer the source systems, model in ER Studio, publish the DDL for implementation in Teradata and provide metadata for source/target mappings. Produce data model solutions meeting technical specifications and business requirements according to the established designs. Conducts data model reviews. Technical domain includes conceptual, logical, and physical data modeling. ...View Job Details

Position :Data Modeler Location:Thousand Oaks, CA Duration:1+ month contract Job Description: Collaborate with the BIBA and BDA to resolve gaps between the requirements and the technical specifications. Provide traceability document to ensure source data is aligned to requirements. Reverse engineer the source systems, model in ER Studio, publish the DDL for implementation in Teradata and provide metadata for source/target mappings. Produce data model solutions meeting technical specifications and business requirements according to the established designs. Conducts data model reviews. Technical domain includes conceptual, logical, and physical data modeling. ...View Job Details

SAS Consultants Required ...View Job Details