Tomorrow is the last date of submission. I would appreciate if you let me know by today in the evening or tomorrow morning. We have an urgent requirement with our direct client for Data Architect. Please send resume to New Req for a Data Architect Location: Seattle Duration 1-2 years 1. Mandatory and Highly Desirable Experience and Qualifications A. Mandatory Experience and Qualifications: · BA in Computer Science, Engineering, or related field, MA preferred · 5 years experience in database design, data flow definition, data modeling, and canonical modeling. · 5 years experience working with SQL Server 2000 and 2005 releases, specifically including T-SQL language, back-up/recovery/maintenance tasks, performance tuning and transactional replication. · 3 years experience working with DTS and SSIS. · 3 years experience integrating data from multiple disparate systems. · 3 years experience working Windows Server OS, hardware, and networking fundamentals. · Excellent verbal and written communication skills. · Solid team player with demonstrated successes in a group environment and ability to lead technical projects in addition to being a technical resource. · Demonstrate strong skills in customer satisfaction. B. Highly Desired Experience and Qualifications: · Experience with financial systems or UW systems a plus. · Excellent verbal and written communication skills. · Microsoft Certification (MCDBA) a plus. · Familiar with Microsoft Visual Studio, Business Intelligence Development Studio and C# or VB in a .NET environment. · Solid team player with demonstrated successes in a group environment and ability to lead technical projects in addition to being a technical resource. · Demonstrate strong skills in customer satisfaction. -- Thanks & Regards Harry Arora TGCL (Tech Global Consulting Lines,LLC) Fresno,California,USA Ph Email:- Visit us:  ...View Job Details

Skill Set Expertise: Must be Certified in Informatica. Required technical skills include Oracle and Informatica. Must have experience with DataWarehousing (work will be on the Global Data Warehouse.) Knowledge of VB, ACCESS, .Net C# and other Microsoft tools would be helpful. This individual should have at least 5 years experience in IT with proven competence in coding as well as strong analysis, design and testing skills. ...View Job Details

Successful candidate will have demonstrated ability and experience at a University in statistical research and data analysis with developing reports for internal and external audiences for institutional research. Additionally, the candidate will have data modeling and or mining skills by engaging in data retrieval and organization analysis for a variety of institutional and public purposes that support university planning, policy and public accountability needs. Minimum Qualifications: Bachelor’s degree in discipline that emphasizes statistics, research methods and/or information systems. Three years of experience in statistical research, data analysis and interpretation, and developing reports for internal and external audiences. Experience with database querying, spreadsheet software and relational databases. The successful candidate will have demonstrated ability to work with persons from diverse backgrounds. Experience with a data modeling tool or other data mining software tool. Higher education experience (Campus Solutions). ...View Job Details

Data Architect Location: Scotts Valley, CA Duration: 6 weeks Description: I'm looking for a Data Architect, someone who truly understands how data flows between applications, databases, and across the network in general, for a client of mine in Scotts Valley. There are multiple applications and portals, 12 in all, that aren't connecting and talking with each other properly. The applications and systems vary, but are mostly running in Java and Oracle. We DON'T need an application debugger or a DBA, we need a Data Architect! Ideal candidate will have at least 5-8 years of Data Architecture experience who is currently local to the SF Bay Area and is authorized to work within the United States for any employer ...View Job Details

Deliverables: Assist TrueComp Support Team in Monthly Data File Processing, Data Loading, and Pipeline processing; Review and Analyze Health Care’s compensation related compensation / reporting system requirements (FSD) and Issues; Configure changes to existing Compensation business rules or Actuate reports based on issues identified by TrueComp users Develop New Reports based on Projects Requirements and Change Requests Configure and unit test reports and /or compensation business rules in the TrueComp or Actuate and TrueInformation® applications as documented; Complete unit testing with mockup data and present results and documentation to Philips TrueComp Support Team; Support the System Test; Assist Health Care in User Acceptance Test reported defect resolution; Participate in production rollout up to, but not necessarily beyond, go live Knowledge and Experience: 1. 3 to 5 years of related Business experience in Finance, HR, Incentive Comp, IT 2. 2 to 4 years experience with Callidus / TrueComp Incentive Compensation Software and Datamart (Prefer Callidus certified consultant) - TrueComp Version 5.1.4 3. 2 to 4 years experience with Actuate software 4. 2 to 4 years experience with Oracle PL/SQL and stored procedures ...View Job Details

Duration:18 months and starts March 29, 2010. Ideally, I need a 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

As a Lead Developer, your focus will be to lead a team of developers to develop and test mission critical enterprise applications that meets the needs of the business. As the Lead Developer you will have direct and indirect management of resources and accountability for coordinating delivery of offshore and onshore resources for various modules and assignments. The Commercial Card IT department is committed to developing cutting edge technology with high quality, innovative developers. Responsibility: Adhere to Commercial Card IT coding standards, procedures, and techniques. Contribute to the technical code and design documentation. Understand/apply reusable code design, leverage application architecture/framework capabilities and functionality, and design/develop solutions that are highly reliable, scalable, and perform to meet business-defined service levels. As a development lead, you will also be responsible for conducting code reviews and ensuring quality solutions are built and tested. Advanced knowledge of Java programming language, J2EE technologies, application servers, software architecture, open-source technologies, and software development methodology. We currently use Spring, Hibernate, Ehcache, JSP, WebLogic application servers, Oracle 11g databases, Solaris, AIX and Windows operating systems. Qualifications: Software Development Experience – DataStage 6+ years Mature design pattern usage - 3+ years of Project Experience Mature design, coding, testing and debugging skills Working knowledge of web services technology and SOA practices Other Useful Experience: UCM, ClearCase, ClearQuest, RUP, SOA, XML technologies Experience with offshore or offsite models ...View Job Details

Purpose/Summary: Under the general direction of the Manager of Data Warehouse, the Senior Data Warehouse Developer will assist with short and long-term analysis, design, development and implementation of projects for the corporate data warehouse. The successful candidate will possess significant skill in methods, best practices and standards related to data management, data movement, conceptual and physical database design, and data warehousing business intelligence technologies. Working closely with the DBA team and other data warehouse developers, the Senior Data Warehouse Developer will work to achieve the best performance and efficiency possible for our Analytics and BI business customers. General Duties/Essential Functions: ? Provide time and cost estimates for architecture design and development on data warehouse projects ? Provide recommendations on system and architecture changes to improve performance and efficiency and see these recommendation through to implementation ? Complete development of solutions using Oracle Data Integrator Enterprise Edition (ODIEE). Background Requirements: ? Minimum of 5 years of data warehouse analysis, design and development experience (7-10 years preferred) ? Minimum of 10 years of overall Information Systems experience required ? Expert level knowledge of ETL tool Oracle Data Integrator Enterprise Edition required ? Experience with Oracle required ? Business Analyst experience on multiple data warehouse projects preferred ? Developer experience on multiple data warehouse projects ? Practical expertise in full lifecycle database design and dimensional design concepts. ? Proficiency in SQL coding and troubleshooting ? 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 ? Expert Knowledge of Kimball data warehouse design recommendations ? Knowledge of Unix Scripting and SAS preferred ? Bachelor’s degree preferred Abilities and Skills Profile: ? Able to identify potential impact of a project across multiple systems ? Able to conduct development cost analysis ? Able to convey complex information in a timely and easily understood manner throughout all levels of the organization ? Able to translate policies and strategic objectives into clearly documented and actionable steps; takes action to improve efficient workflows to meet customer needs ? Actively supports team decisions; evaluates new ideas objectively based on their merits; willing to act upon and support initiatives ...View Job Details

Need a Data Warehouse Lead Developer for client in Brookfield, WI. The project is for 18 months. Need a Data Warehouse Lead Developer with experience in report analysis and creation and reviewing of SQL monitoring tools. Must have experience as business analysis, working directly with users from design through implementation Must have SQL Server 2008, SQL Server Development using TSQL, SQL Server BI tools, SQL Server Reporting Services, SSIS and SSAS. ...View Job Details

Informatica Developer Good knowledge of Oracle, UNIX ...View Job Details

Locals ONLY Duties: The Statistical Programmer Analyst II applies intermediate level programming techniques and helps plan, design, develop, implement, and maintain software for the monitoring, reporting, and analysis of clinical trials. Prepares and distributes summarized information to the study team. Reviews and implements data warehouse and database designs. Skills: Capable of implementing these deliverables in clear, efficient SAS code for the purposes of data analysis and reporting. Computer Systems: UNIX, edit/execute makefile, Oracle Clinical or equivalent clinical DM system, and relational database theory. Desktop: Basic Word/Excel/PowerPoint. Regulatory: Basic knowledge of FDA/ICH guidelines and the software development life cycle. Experience dealing with FDA/regulatory requests. Clinical Trials: 2+ years of Pharma/biotech preferred. Understands Biometrics roles in clinical trials. Understands data flow. Communication: Capable of clear and timely written/verbal communication and listening/understanding with Implementation Team (IT), SP department. Effectively expresses concepts and positions in individual and informal group situations. Presents ideas in an organized and concise manner. Education: Bachelors. SAS: 4+ years (2+ with a Masters); SAS/BASE, macros, PROC SQL, advanced data step, PROC REPORT, PROC TABULATE, and basic SAS/GRAPH. Statistics: Knowledge and application of p-values, confidence intervals, linear regression analysis, basic general linear models, frequencies, survival analysis, non-parametric analysis. ...View Job Details

Domain knowledge in one of the Business Areas needed for this implementation Order to Cash (Primary)\Forecast to Delivery (Secondary) Implementation to Support (Primary)\Idea to Offering (Secondary) Financial Services (Primary)\Offering to Order (Secondary) Experience with designing and implementing generic ETL streams that perform common data manipulation tasks on data sourced from a variety of sources in different formats. Must possess strong ETL design and development experience including working with third-party ETL tools. Experience building Enterprise Data Warehouses. Experience providing leadership to a development team Strong written and verbal communication skills. Can work with track leads to understand requirements and high level designs, write low level designs. Can work with minimum supervision and multi-task on a wide variety of functionality, issues, and projects ...View Job Details

ETL consultant with Abinitio Experience Location: Hartford, CT Duration: 5+ Months Rate: $45/hr on C2C/1099 There will be an F2F interview after a telephonic round. They are looking for a consultant who has experience with ETL and AbInition (Ab initio). Under broad direction, responsible for managing the following functional areas, multiple technology, major system (e.g., process simulation, document management, payroll, etc.) and the development/acquisition, maintenance, and support of applications in those areas. Provide direction to projects, assessing and mitigating risks, and reviewing and approving all requirements/specifications, estimates, system designs, software technology decisions, completed systems, and activities associated with providing support to customers and clients, often involving performing project setups, analyses, designs, etc., for/with customers. Assist general management with requirements associated with strategic and annual business planning, budgeting, cost control, software licensing. Provides input on administrative policies, procedures, technology, priorities, and such. Undergraduate degree in CS, MIS, BA, or Engineering and 10 years of experience in Systems Development and/or Applications Support. Thanks & Regards Joshua Elliot Lead IT Recruiting Manager Phone Extn.174 Mail id: Gmail: Join my Network: "Never Forget, God Almighty will provide all your needs…...." ...View Job Details

Informatica Administotor ...View Job Details

Job Title: Informatica Administrator Location: Wyomissing, PA Start Date: Immediate 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: Employer Details: Thanks and Regards, Komal Singh E-Solutions Inc O Fax Email: Yahoo IM: komalsingh_26 ...View Job Details

If you have any data sage LEAD level candidates, please send them over ASAP. JPMorgan Chase is looking to hire more---they quality of candidates they are getting are not strong enough. These people need to be VERY strong. There will be F2F interviews after phone screens and they will hire ASAP ...View Job Details

Position: DataStage Developer Lead Location-Deerfield, IL. Duration: 6 Months Local Candidates Preferred** · Participates in meetings with project managers, technical support, and clients to identify and specify system requirements and processes improvements. · Perform all application support lead functions such as ticket management and issue resolution. · Uses specialized skills and technical expertise to assist users in resolving a system problem, or escalates problem to a more experienced systems analyst in accordance with service level agreements. · Assists M&S resources in providing alternative solutions and recommending the best solution based upon fact discovery and management. · Requires 6 + years strong IBM DataStage experience on Windows platform (Sr Level Position) · IBM DataStage 7.5 and 8.1 Server Edition · Oracle PL/SQL · DOS Scripting · Strong Documentation Skills · Knowledge of Cegedim Dendrite CRM Pharma applications is a Plus · Requires 5 + years of strong experience in Oracle PL/SQL. · Prefers experience with DOS scripting · Must have Oracle knowledge for performance tuning · Experience with Data archival strategies would be a plus · Experience with DataStage 8.1 upgrade · Full functional knowledge of ETL solutions for legacy systems Skills: ...View Job Details

looking for 8 + years of total IT experience 6+ years of informatica experience with MES Manufacturing exectuion systems. strong experience with oracle, pl/sql, sql server strong experience of informatica with MESA/DB2 is just ...View Job Details

Duration: 6mth+ Job Description: Seeking a highly motivated individual to be involved with other team members in the support and development of enhancements for a data warehouse system. An individual in this role can expect to interact frequently with the business units to understand requirements and to gather feedback during the design, development and testing of solutions. Required Skills: The successful candidate will have a bachelor’s degree in Computer Science or business equivalent degree. Knowledge of finance and business systems would be helpful. Required technical skills include Oracle and Informatica. Must have experience with DataWarehousing (work will be on the Global Data Warehouse.) Knowledge of VB, ACCESS, .Net C# and other Microsoft tools would be helpful. This individual should have at least 5 years experience in IT with proven competence in coding as well as strong analysis, design and testing skills. The right individual will exercise solid project management skills to support and guide projects through the entire software development life cycle. Candidates should be capable of working independently or as a member of a team. Strong communication and interpersonal skills are required. Additionally, this individual must be able to work on multiple projects concurrently. ...View Job Details

Duration: 5+ Months There will be an F2F interview after a telephonic round. They are looking for a consultant who has experience with ETL and AbInition (Ab initio). Under broad direction, responsible for managing the following functional areas, multiple technology, major system (e.g., process simulation, document management, payroll, etc.) and the development/acquisition, maintenance, and support of applications in those areas. Provide direction to projects, assessing and mitigating risks, and reviewing and approving all requirements/specifications, estimates, system designs, software technology decisions, completed systems, and activities associated with providing support to customers and clients, often involving performing project setups, analyses, designs, etc., for/with customers. Assist general management with requirements associated with strategic and annual business planning, budgeting, cost control, software licensing. Provides input on administrative policies, procedures, technology, priorities, and such. Undergraduate degree in CS, MIS, BA, or Engineering and 10 years of experience in Systems Development and/or Applications Support. ...View Job Details

Position : Sr. Informatica Tester Location : Bensenville, IL Duration : 6+ Months Discription: Client is looking for a strong Sr. Informatica Tester, with development knowledge, having at least 8 years of overall IT experience and 6 years in Informatica ASAP Required Informatica 8.5 or higher Experienced in a Unix environment with Oracle as backend Experience with scripting Experience with Mystro scheduler ...View Job Details

Title: Informatica ETL Developer Location: San Francisco, CA Duration: 6 Months Local candidates only! In person interview! Description: - Informatica ETL Developer in Oracle DB environment - Strong Data Warehouse background recent experience for the last 2-3 years - Good SQL writing/Tuning experience (Oracle Database is used) - Experience handling large volume of data - 15-20 Terabytes per day - Scripting experience Unix Shell, Perl, Python Regards Ejaz Talent Acquisition Manager Symphony Enterprises LLC (Tel (Fax) | WMBE & NWBE Certified Company A Member of Women's Business Enterprise National Council (WBENC) and National Association of Women Business Owners (NAWBO) ...View Job Details

Hi There, Greetings to you, Job title: Data warehouse and BI Start date – Immediate Duration: contract (6+ months) Work location – San Jose, CA Required skills: Hands on in DWBI and at least 8-10 years on Informatica ETL with Oracle APPS and OBIEE experience. Domain experience in Operations and Supply Chain preferable. Kindly, send your updated resume with contact info and best possible rate ASAP. ...View Job Details

Details are as follows: Title : AbInitio ETL Specialist Requirement : AbInitio - ETL, metadata Location : Hartford, CT Rate : $55-60/Hour Duration : 6 months Description: 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 into . 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

The project is 18 months and starts March 29, 2010. Ideally, I need a 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. I wonder if you or perhaps a colleague might be interested. ...View Job Details

Duration: 5+ Months There will be an F2F interview after a telephonic round. They are looking for a consultant who has experience with ETL and AbInition (Ab initio). ...View Job Details

Under broad direction, responsible for managing the following functional areas, multiple technology, major system (e.g., process simulation, document management, payroll, etc.) and the development/acquisition, maintenance, and support of applications in those areas. Provide direction to projects, assessing and mitigating risks, and reviewing and approving all requirements/specifications, estimates, system designs, software technology decisions, completed systems, and activities associated with providing support to customers and clients, often involving performing project setups, analyses, designs, etc., for/with customers. Assist general management with requirements associated with strategic and annual business planning, budgeting, cost control, software licensing. Provides input on administrative policies, procedures, technology, priorities, and such. Undergraduate degree in CS, MIS, BA, or Engineering and 10 years of experience in Systems Development and/or Applications Support. ...View Job Details

My client is looking for 8+ years of total IT experience, 6+ years of informatica experience and strong experience with oracle, pl/sql, sql server, strong experience of informatica with MESA/DB2 is must, Excellent communication skill ...View Job Details

Ideally, I need a 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

Duration: 5+ Months There will be an F2F interview after a telephonic round. They are looking for a consultant who has experience with ETL and AbInition (Ab initio). Under broad direction, responsible for managing the following functional areas, multiple technology, major system (e.g., process simulation, document management, payroll, etc.) and the development/acquisition, maintenance, and support of applications in those areas. Provide direction to projects, assessing and mitigating risks, and reviewing and approving all requirements/specifications, estimates, system designs, software technology decisions, completed systems, and activities associated with providing support to customers and clients, often involving performing project setups, analyses, designs, etc., for/with customers. Assist general management with requirements associated with strategic and annual business planning, budgeting, cost control, software licensing. Provides input on administrative policies, procedures, technology, priorities, and such. Undergraduate degree in CS, MIS, BA, or Engineering and 10 years of experience in Systems Development and/or Applications Support. ...View Job Details

Duration : 5+ Months There will be an F2F interview after a telephonic round. They are looking for a consultant who has experience with ETL and AbInition (Ab initio). Under broad direction, responsible for managing the following functional areas, multiple technology, major system (e.g., process simulation, document management, payroll, etc.) and the development/acquisition, maintenance, and support of applications in those areas. Provide direction to projects, assessing and mitigating risks, and reviewing and approving all requirements/specifications, estimates, system designs, software technology decisions, completed systems, and activities associated with providing support to customers and clients, often involving performing project setups, analyses, designs, etc., for/with customers. Assist general management with requirements associated with strategic and annual business planning, budgeting, cost control, software licensing. Provides input on administrative policies, procedures, technology, priorities, and such. Undergraduate degree in CS, MIS, BA, or Engineering and 10 years of experience in Systems Development and/or Applications Support. ...View Job Details

Job Title : DATA WAREHOUSE ENGINEERS Location : PHOENIX, AZ Duration : 4 Months Contract to Hire Rate : $35/hour Requirement: Experience with Data warehouse is must. Should have following exp Informatica, ETL, BI Suite of Tools, Microsoft Performance Point Tool, Microsoft DW Suite Tool, Unix, Oracle, Hadoop, Statistical Analyst, Cloud computing ...View Job Details

HI We have this position with our client in Richmond, VA If interested please send me your updated profile with Contact / Rate expectation info ASAP Job Title: Ab Initio Developer with Teradata Experience Duration: 06+ months Location: Richmond VA Description: Master Level ETL Specialist to manage Enterprise-level AbIntio and Teradata environments. Candidate should have in-depth knowledge of backup and performance management, writing and managing scripts run in UNIX environments, full development lifecycle for AbInitio development, etc. • Responsible for the design, development and administration of transactional and analytical data constructs/structures. • Included within those responsibilities are the areas of data access and delivery technologies. • Includes expertise in data mining, Extract Transform Load (ETL), design and documentation of data movement schemes, and mapping between applications. • Usually includes experience in Ab Initio or other ETL products. • May include experience in logical data model development The environment needs the candidate to have an understanding and experience in Teradata development and Unix scripting. • A bachelor's degree or above in MIS, Computer Science or related field and Teradata certification is highly preferred. • 5+ years Technology specific experience (multiple technologies). • 2-3 years experience in domain. • Develops advanced domain specific technology solutions and guides their development into a final product. • Leads multiple work-streams in delivering solutions • Works independently • Data mapping experience in implementation and design (5+yrs.) • ETL experience in implementation and design (5+yrs.) • Demonstrated ability to lead end to end ETL project and team • Ability to effectively communicate across multiple levels (Executive Sponsors to team members). Thanks & Regards, S.Raj Kumar | Building Rocks. Working Together | 101 Morgan Lane Suite 303 | Plainsboro NJ 08536. X 601 (Work (Cell (Fax) | E-mail: | Website: Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you do not wish to receive our e-mails and/or lists, please contact the sender by reply e-mail / click on the link below and press SEND: mailto: subject=Remove_me.Please, and destroy all copies of the original. Any inconvenience caused is regretted. ? Please help to save a tree and only print this email if absolutely necessary. Thank you. ...View Job Details

Job Details: Job Title : ETL Consultant Duration : 6 Months Contract Position Location : Raleigh,NC NOTE : Need US Citizens & Green Cards Only Job Description : The ETL Consultant specializes in the design and development of the ETL environment, processes, programs, and scripts to acquire data from source systems and apply the data to the tables in the database. This individual must have the skills necessary to understand the overall data warehouse architecture. The ETL Consultant designs and builds the ETL environment with the specific toolset required by the client. The ETL Consultant may also provide input to the database designer to optimize the data loading of the physical database. The ETL Consultant may be the Lead Consultant on a project; Additional Job Description: The candidate must be a quick study and be able to assimilate themselves into a project quickly. Must be a quick study on a data model. Must know Teradata BTEQ and the ability to modify and write from scratch ETL SQL. The above skills must be recent (i.e. within the last year. The candidate must have been working on Teradata for the last 3 years. Regards, Vinod V-Soft Consulting Group, Inc. Phone Ext: 163 Email:  ...View Job Details

My Client is looking to hire an Informatica ETL Developer for a 6-12 Month Contract Position. Skills Required ETL, Informatica, SQL2005 / 2008, SSIS, SSRS, SSAS XML DB2 (Desirable) Job Responsibilities Informatica ETL Developer, Data Warehouse concepts and able to write SQL Queries (preferably DB2) required. Our workflows and mapping rules are fairly complex. The consultants we are looking for should also be familiar with using XML data as source and target as well as flat files and a mixture of both. Ability to merge several flat files into one XML file. Populated a target XML file in several workflows or mappings Complex processing/mapping rules. ...View Job Details

***W-2 Requirement*** MUST be a US Citizen, Green Card or Work Authorization Holder ? Demonstrated administration, installation, and support experience with DataStage (Information Server) in an AIX, Solaris, or Linux operating system environment ? Must be proficient in UNIX scripting ? Solid knowledge and experience with database standard concepts, practices and procedures ? Excellent verbal and written skills ? Strong problem solving capability ? Superior documentation skills ? Strong ability to work across organizational boundaries ? Passion for troubleshooting and resolving customer/product issues ? Ability to handle multiple projects simultaneously ? Ability to share knowledge with team members, cross train, and works well with other engineering and architecture groups ? Experience developing ETL performance tuning and best practice guides are a plus ? Keywords ? Education Advanced degree in Computer Science or a related discipline and/or eight to ten years IT experience Duties DataStage Engineer/Manager: a. Implements and administers IBM's DataStage and Information Server suite of products on AIX, Solaris or Linux operating systems The successful candidate must have demonstrated hands-on experience with: b. product installation and maintenance c. setting up and administering environments d. troubleshooting and problem diagnosis e. performance tuning and capacity planning f. documenting operational processes and mentoring ...View Job Details

***W-2 Requirement*** MUST be a US Citizen, Green Card or Work Authorization Holder Must have working experience with Data Stage V8.1 ? Experience with IBM Information Server desired, DataStage(V8.1), QualityStage, Information Analyser ? Knowledge in writing SQL ? Data mapping: source to target : target to multiple formats ? Experience in the development of data extraction and load processes in a parallel framework ? Understanding of normalized and de-normalized data repositories ? Defining ETL standards & processes ? Ensuring timely delivery of required ETL tasks ? Performance tuning of ETL jobs ? Data standards and metadata management. ...View Job Details

Sr. Data warehouse Developer to join their BI team to help and mentor the team with the data modeling(logical/physical) data loading and extraction for several BI initiatives. Lookin for someone with a minimum of 6 years experience working in a Microsoft Datawarehouse environment with experience with MS ETL tools (SSIS, DTS). Prefer to have someone with healthcare insurance experience (claims) but will also consider other insurance claims experience. (P&C, Life, LTC, Pharamacy Benefits Mgt, Hospital) ...View Job Details

Title : Datawarehousing Informatica Developer Location : NY Downtown (Phone+ Face-Face) Duration : 6-12 months Required : Locals Description: ny - downtown 6-12 months in person int atleast 1 recent project should be from finance Experience in Data Warehouse (DW&BI) application development across various business domains, Project management experience across business domain and DW platform. Working on data governance, data integration, and data quality solution for enterprise information architecture. Designing ETL (Informatica) Business Objects Reporting ...View Job Details

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 NYMEX integration. Individual will be responsible for developing ETL mappings for STATS 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 Nymex fee and volume data into CME Group’s data warehouse Develop ETL maps using Informatica to integrate Nymex 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

Experience with Guidewire Data Models Experience with Claim Conversion into Guidewire Claim Center experience / knowledge of the Guidewire Data Models and Claims conversion within a Guidewire environment Experience in Large Scale Migrations Data Profiling and Data Mapping 5 – 7 years experience required ...View Job Details

The client will need a face-2-face after a successful phone screen Duration: 5 month duration (extension very possible) Under broad direction, responsible for managing the following functional areas, multiple technology, major system (e.g., process simulation, document management, payroll, etc.) and the development/acquisition, maintenance, and support of applications in those areas. Provide direction to projects, assessing and mitigating risks, and reviewing and approving all requirements/specifications, estimates, system designs, software technology decisions, completed systems, and activities associated with providing support to customers and clients, often involving performing project setups, analyses, designs, etc., for/with customers. Assist general management with requirements associated with strategic and annual business planning, budgeting, cost control, software licensing. Provides input on administrative policies, procedures, technology, priorities, and such. Undergraduate degree in CS, MIS, BA, or Engineering and 10 years of experience in Systems Development and/or Applications Support ...View Job Details

Title : Data Analyst Location: Dover, NH Duration: 6 months+ Positions: 3 Client is looking for a Data Analyst with the following skills: • Experience with Guidewire Data Models • Experience with Claim Conversion into Guidewire Claim Center • Experience in Large Scale Migrations • Data Profiling and Data Mapping If you are interested, please respond your consultant’s updated resume with contact details at the earliest. ...View Job Details

Title: ETL Specialist 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 into 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 Drug Screening Required: Yes Background Check Required: Yes ...View Job Details

Looking for a senior Cognos BI, data warehouse, reporting specialist. Responsible for designing and developing analytic and reporting solutions using COGNOS tool suite including Framework Manager metadata models, Report Studio, Query Studio, Analysis Studio. Design the scheduling, distribution, and refresh for reports, views. Serve as a technical expert on COGNOS solutions; recommend ways for the user base to maximize the value of available functionality. ...View Job Details

Experience in Data Warehouse (DW&BI) application development across various business domains, Project management experience across business domain and DW platform. Working on data governance, data integration, and data quality solution for enterprise information architecture. Designing ETL (Informatica) Business Objects Reporting ...View Job Details

Required Skills: Service Type à Service / Work Description Required Lead Role ( 5+ Yrs) Support role (2-4 yrs) Fundamental Skill à Specialized in Informatica 7.1.x / 8.1/8.6 in a Platform Support - Production Support role Small Enhancementsà Small enhancements and support to current workflow / PL SQL / Scripting Platform / Services / Jobs Monitoringà Platform/Server monitoring ; Services monitoring ,Job Monitoring covering Automated and Manual process. Software version control (in support break-fix)- Environment/Application Environment Setup à accounts/permissions/tools/parameters/load-service balancing Maintenance - plans/schedules/execution Unix server health checkà Unix / Windows server health / monitoring check ; Log server Checking / monitoring Service Availabilityà Monitor Job failure notifications and respond as defined in the Manual Exposure to Manual/Automated Monitoring Alert and notification on Database or Informatica server unavailability System Failuresà Monitor source systems /Data failures and raise Work orders for restoration Cross System SLA Monitoringà Notification / Update downstream systems for any delays or SLA miss and restating of Jobs Updatesà Software updates and patch upgrades for server and services Data Quality checkà Conduct periodic Data Quality check using Informatica services and or SQL based manual checks for applications that require the health check Performance Optimizationà Identify Server level performance issues and apply optimization techniques to maintain and improve performance Unix job and Informatica Job schedulingà Unix job and Informatica Job scheduling Assets and Contentsà Manage Informatica repositories, Folders, Create support documents Security and privilegesà Create User, Role, profile Code Migrationà Code Migration from one environment to another . Documentation of changes Incident Logà Incident response and resolution Preparing Incident resolution documents - IRG/AOG Creating incident log for known issues Problem identification and resolutionà Problem identification and resolution Create RFC for bug fixin ...View Job Details

Need two candidates. Locations: Chicago,IL and Washington DC. *** In-Person Interview required for both the locations. Responsible for developing and executing formal test plans to ensure the delivery of quality software applications. Involved in test planning, writing test cases/scripts, test case automation and test execution. Design, write and edit test plans to ensure software functions as designed. Review system use cases and functional specifications with the appropriate business analyst. Identify potential problems, omissions and open issues and attend walkthroughs and attend signoff meetings. Serve as a coach and mentor to the department staff regarding how to develop and execute a test plan. Serve as a process improvement leader for the QA department. Responsible for identifying areas for improvements, implementing process improvements and ensuring long term compliance. Act as the lead in managing QA participation in sunset reviews. Set policies, standards and procedures for cross-teams system development life cycle, workflow and the interfaces with Product Verification. Partner with team to prepare comprehensive QA project plan, estimates as well as the implementation for phases of projects. Monitor the schedule of testing phases for all projects based on project specifications, scope, and coverage. 6+ years of experience. ETL testing experience, SQL skills, stored procedures, Data Warehousing, PL/SQL, Toad, and MS SQL Server. UNIX skills in an AIX Environment Experience. UAT (user acceptance testing). Excellent Communication skills. ***DataStage Experience will be a huge plus. *** In-Person Interview required for both the locations. ...View Job Details

HI, Please find the below requirement. Req : Teradata DBA Location : Richmond, VA Rate : $45/hr Duration : 6 months+ Description: This position is for a senior level database administrator, preferably Teradata administrator, who is responsible for design, development and administration of large scale (500Gb - 2TB in size) analytical & transactional data structures on various databases like Teradata, SQLServer, DB2 and Oracle. Included within those responsibilities are the areas of data access and delivery technologies. Duties include but not limited to: Logical data modelig, physical dabase design, implementation and testing of large scale database structures Map business requirements into system requirements Performance monitoring and tuning including SQL optimization and tuning Shell and Batch scripting Software installs and upgrades Experience: 5+ years of relevant work experience Good understanding and hands on exprience in logical data modeling and data warehouse concepts Indepth experience in deriving optimized physical data models from the logical data model provided Indepth experience in security administration using roles and profiles mechanism Hands on experience on performance tuning of complex SQLs Indepth knowledge of Teradata utilities such as Multiload, Fastexport, BTEQ, Fastload and TPump Solid understanding of Teradata client tools such as SQLAssistant, Performance Monitor, Teradata Manager and Teradata Administrator Hands on experience in using MSSQLServer, Oracle and DB2 databases Hands on experience in using MS Office products and Windows XP or higher version of OS Solid verbal and written communication skills Additional Requirements: Teradata Certification is a must and any other DB certifications might add value Prior COF experience is desired but not necessarily required Familiarity with ETL tools like AbInitio, Datastage, Informatica Financial domain experience is a plus but not necessarily required Ability to work independently and communicate across multiple levels (Product owners, Executive sponsors, Team members) Work experience in Agile methodology is a plus Should be a very good team player THanks, Dinesh ext 208  ...View Job Details

ETL and Ab Initio Consultant Hartford, CT 5+ Months $40/hr on W2 Best Under broad direction, responsible for managing the following functional areas, multiple technology, major system (e.g., process simulation, document management, payroll, etc.) and the development/acquisition, maintenance, and support of applications in those areas. Provide direction to projects, assessing and mitigating risks, and reviewing and approving all requirements/specifications, estimates, system designs, software technology decisions, completed systems, and activities associated with providing support to customers and clients, often involving performing project setups, analyses, designs, etc., for/with customers. Assist general management with requirements associated with strategic and annual business planning, budgeting, cost control, software licensing. Provides input on administrative policies, procedures, technology, priorities, and such. Undergraduate degree in CS, MIS, BA, or Engineering and 10 years of experience in Systems Development and/or Applications Support ...View Job Details