Location: Pasadena, CA / Pleasanton, CA Total number of resources needed: 3 Minimum Requirement Bachelor's Degree or Master Degree in computer engineering. 6 years of strong experience in Informatica development required. 1 year of strong experience with Informatica version 8.x. Should have or able to effectively coordinate with various teams including offshore. Strong written and oral communication skills required. Demonstrated ability to work independently and collaborative, as needed, and to appropriately prioritize required. Self-motivated and able to grasp new concepts quickly required. Ability to resolve problem; take initiative, and to identify and propose new tasks and procedures required. Have very strong analytical skill set ...View Job Details

Looking for Data architect, in Boston, for six months project. Please send the resume @ or call at • Exposure to Basic Relational Database Concepts - basic types of databases,data integrity, the relational model,etc • Ability to understand basics of DBDesign , Logical modeling , Normalization & De-Normalization Techniques • SQLConstructs Ablility to understand and implement Data Types, Basic SQL SELECTStatements, Restricting and Sorting Data, Single-Row Functions, Joins,Aggregate and Group Functions, Sub-Queries, Creating & Managing DB Objects,Manipulating Data (DML), Constraints, Views • SQL Query Tuning Basics:Understanding of SQL Tuning concepts like SQL Statement Processing Basics,Explain Plan Basics, SQL Trace and TKPROF Basics, Indexes and Basic AccessMethods Basics, Introduction to the Optimizer Basics, Optimizer Hints Basics,Optimizer Hints Basics, Gathering Statistics Basics • Adv SQL Basics: Able tounderstand and implement Datetime Functions, Advanced Subqueries, HierarchicalQueries,DDL & DML Extensions, Transaction Management • Tools Level 1 usage •Database Programming Basics: Ability to understand and implement DeclaringVariables, Executable Statements, Control Structures, Composite Data Types,Explicit Cursors, Handling Exceptions, Creating Procedures, Creating Functions,Creating Database Triggers • Adv Database Programming: Ability to understandand implement Collections, Multilevel collections, Ref Cursors, BulkProcessing, Bulk Bind and Bulk Collect, DBMS_OUTPUT, UTL_FILE, Performanceaspects in PL./SQL • Exposure to Basic Relational Database Concepts - basictypes of databases, data integrity, the relational model,etc • Ability tounderstand basics of DB Design , Logical modeling , Normalization & De-Normalization Techniques • Woking knowledge of DB Design/Modelingtechniques(Logical and Physical DB modeling) •SQL Constructs Ablility tounderstand and implement Data Types, Basic SQL SELECT Statements, Restrictingand Sorting Data, Single-Row Functions, Joins, Aggregate and Group Functions,Sub-Queries, Creating & Managing DB Objects, Manipulating Data (DML),Constraints, Views • SQL Query Tuning Basics: Understanding of SQL Tuningconcepts like SQL Statement Processing Basics, Explain Plan Basics, SQL Traceand TKPROF Basics, Indexes and Basic Access Methods Basics, Introduction to theOptimizer Basics, Optimizer Hints Basics, Optimizer Hints Basics, GatheringStatistics Basics • Adv SQL Basics: Able to understand and implement DatetimeFunctions, Advanced Subqueries, Hierarchical Queries,DDL & DML Extensions,Transaction Management • Tools Level 1 usage • Adv SQL & SQL Tuning Techniques:Ability to implement Tunning Concepts/Techniques like Explain Plan, Accessmethod, Generate SQL Trace and TKPROF report, Forcing Index Hints, GatherStatistics, Managing Optimizer Statistics, Using Indexes, Using Plan Stability,Using Application Tracing Tools, SQL Access Advisor • Database ProgrammingBasics: Ability to understand and implement Declaring Variables, ExecutableStatements, Control Structures, Composite Data Types, Explicit Cursors,Handling Exceptions, Creating Procedures, Creating Functions, Creating DatabaseTriggers • Adv Database Programming: Ability to understand and implementCollections, Multilevel collections, Ref Cursors, Bulk Processing, Bulk Bindand Bulk Collect, DBMS_OUTPUT, UTL_FILE, Performance aspects in PL./SQL • AdvDatabase Programming: Ability to understand and implement Advanced ExplicitCursors, Managing Subprograms, Creating Packages, Oracle Supplied Packages,Adv. Triggers, Managing Dependencies • SQL Developer Tool for DatabaseProgramming • Tools Level 1 Usage • Able to use TOAD for Database Development•SQL Constructs Ablility to understand and implement Data Types, Basic SQLSELECT Statements, Restricting and Sorting Data, Single-Row Functions, Joins,Aggregate and Group Functions, Sub-Queries, Creating & Managing DB Objects,Manipulating Data (DML), Constraints, Views • SQL Query Tuning Basics:Understanding of SQL Tuning concepts like SQL Statement Processing Basics,Explain Plan Basics, SQL Trace and TKPROF Basi ...View Job Details

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

I have an urgent requirement of Data Analyst in NY.Please go through the below requirement and forward me the matching resumes with contact details ASAP Job Title : Data Analyst Location : Syracuse, NY Duration : 5+ Months contract Requirements: XML Data Mapping Relational Database Modeling (in CA ERWin) Oracle SQL Some experience with COBOL and Copybook for integration purposes. (Must have) Experience with DTCC APPSUB flat file formats is highly desirable ...View Job Details

Position: Sr Informatica Developer (with version 8.x. Location: Pasadena, CA / Pleasanton, CA Start: Immediate Minimum Requirement • Bachelor's Degree or Master Degree in computer engineering. • > 6 years of strong experience in Informatica development required. • > 1 year of strong experience with Informatica version 8.x. • Should have or able to effectively coordinate with various teams including offshore. • Strong written and oral communication skills required. • Demonstrated ability to work independently and collaborative, as needed, and to appropriately prioritize required. • Self-motivated and able to grasp new concepts quickly required. • Ability to resolve problem; take initiative, and to identify and propose new tasks and procedures required. • Have very strong analytical skill set If you are interested Please send me Updated Resume with following details: Full Name: Contact No: E-mail: Current Location: Willing to relocate: Availability: Visa status: Expected Rate: Thanks and Regards, Komal Singh E-Solutions Inc O Fax Email: Yahoo IM: komalsingh_26 ...View Job Details

Required Skills: 1. Informatica Suite including: 2. Informatica Power Center version 8.6 or higher 3. Power Exchange version 8 or higher 4. Microsoft 2005/2008 SQL Integration Services 5. Data Warehousing design techniques 6. Data analysis, source system analysis and data mapping 7. Microsoft SQL Server 2005/2008 8. Windows Server 2003 1. The Informatica ETL Developer is a position requiring demonstrated experience using the Informatica Suite of tools including Power Center and Power Exchange as well as SQL Server Integration Services (SSIS). 2. This position will develop Extract, Transformation and Loading (ETL) procedures for implementing data integration and data migration tasks in support of Data Warehousing and other data integration projects. 3. In addition to new development, responsibilities will also include support of operations and maintenance, as well as 24x7 production supports on a rotational basis. 4. Collaboration skills with technical team members and customers is important to assist in developing user requirements from both internal and external clients into functional capability that will represent client to external parties and provide assurance of the management of resources. Sufficient to create the following: 1. ETL procedures, batch processes, scheduling; troubleshooting problems and making suggestions for performance tuning and system integrity. Data models and database design techniques, including relational and dimensional modeling. 2. Effectively map source to target data to meet business/system requirements. SQL stored procedures and advanced SQL queries. 3. Develop functional and technical requirements documents for diverse audience (technical and non-technical), including migration, implementation and test plans. ...View Job Details

START: ASAP END: 4/30/2010 with potential to extend RATE: $55/hour all inclusive. 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

Required Skills: 1. 5+ years of experience in Informatica PowerCenter 2. Strong experience in designing and developing of mappings, transformations, sessions and workflows in PowerCenter 3. Strong experience in performance tuning for Informatica processing 4. Expertise in best practices and development standard for Informatica implementation 5. Experience in Informatica Power Exchange implementation and administration 6. Strong experience in SQL and PL/SQL 7. Experience in Oracle, SQL Server, Sybase, or other relational database 8. Proficiency in relational database design, data warehousing and database administration 9. Experience in Oracle Designer, Visio design tools 10. Experience in database performance tuning 11. Experience TOAD, Oracle Enterprise Management development tools 12. Experience in Unix Shell Scripts 13. Experience in configuration management and code version control 14. Experience with Sun Solaris, Digital Unix, HP-UX, Windows NT/2000 15. Good written and verbal communication skills 16. Good technical and problem solving skills; 17. Excellent oral & written communication skills 18. Bachelor’s degree or Master’s degree in Computer Science, or equivalent experience Desired Skills: Experience in financial service industry is a plu ...View Job Details

** QUALIFICATION RATINGS ** 3-4 years software development experience * 4+ Yrs. Ability to document business processes * 3 (Moderately Strong) of 5 (Expert) Ability to multi-task * 5 (Expert) of 5 (Expert) Ability to translate high level business requirements into functional and system requirements 4 (Very Strong) of 5 (Expert) Excellent knowledge of Software Development Lifecycle (SDLC) * 3 (Moderately Strong) of 5 (Expert) Knowledge of SQL for querying databases * 3 (Moderately Strong) of 5 (Expert) Knowledge of testing tools, such as Mercury Quality Center * 3 (Moderately Strong) of 5 (Expert) Strong analytical skills * 4 (Very Strong) of 5 (Expert) Excellent knowledge of Microsoft Office * 5 (Expert) of 5 (Expert) Visio * 4 (Very Strong) of 5 (Expert) ...View Job Details

Job Title:EDW Test Analyst Job Location:WA Duration:3+ Months Primary Skills:TeraData Technical/Functional: Techno Functional Total Experience:5 Years Relevant Experience:4 years Required Skills &Job Description: Experience in developing, and executing test cases, test status and test result documents are required. Experience in testing many multi-layer data warehouse on Unix, Windows and Teradata systems. Minimum Required Skills: * Strong expertise testing data warehouses * Experience in logical and physical database design * Strong expertise with Oracle10g, SQL Server 2005, Analysis services, Teradata V2R6, ETL Development Tools like Infomatica v8.1.1 and OLAP analysis * Working knowledge of SQL, Unix and Perl * Ability to read the log files to identify issues/errors in scripts * Knowledge of key data warehousing processes * Experience testing Business Objects and Crystal Report * Data quality analysis experience * Experience in generating test script based on BRD and FSD * Write and present high quality test deliverables, reports, and other documents for internal and/or external audiences * Ability to work on multiple project concurrently * Experience in working with developers and project’s team members * Experience working with Test Director or Quality Center * Experience in writing well described step by step defects * Experience in providing test status * Understanding of projects development life cycle and SDLC or Agile * Clear writing and communication skills * Self-motivated with ability to work independently or as a team member Preferred skills: * Wireless Industry knowledge desirable * Quick Test Professional (QTP)or Automation skills * working knowledge of RUP methodology ...View Job Details

Top Skill Sets: Informatica-6-8 years development experience-must have experience with Serializer, XSD and Parser. Lead experience and background in Java is a plus. Position Description: Experience Level: 4 year degree and 7+ years technical experience with 5+ years web experience or equivalent combination of education and experience. Description: Acts in a lead technical role providing technical guidance and consultation with developers, clients and IT management for web systems environments. Provides the strategy and design for projects associated with web and e-commerce application installations, upgrades and deployments. Utilizes advanced technologies and methods to integrate web systems with existing systems, enabling the creation of new or expanded web enterprises. Develops new documentation and departmental technical procedures. Directs the gathering of performance statistics to assist in determining hardware and communication tools needed to support projected transaction volumes, response time and system availability targets. As an escalation point, provides guidance and direction to less experienced staff in resolution of! highly complex technical problems involving the maintenance and/or creation of web sites and e-commerce applications and their integration into the existing systems environment. Leads projects, allocates and manages resources and manages the work of less experienced staff. Assures quality, security and compliance requirements are met for supported area and oversees creation of or updates to and testing of the business continuation plan. To provide guidance on implementing Informatica Data Transformation including experience with DT Serializer, XSD and Parser. Provide post implementation support and facilitate knowledge transfer to support staff. Lead evlaution of Infomratica DT for future projects. Contract to hire preferred but open to straight contract. Web Development : Java, Web Development : EJB / J2EE, Source Code Control : ClearCase, Systems Administration : UNIX ...View Job Details

We have an immediate need for a strong Informatica ETL developer with experience in Power Center and Power Exchange. Required Skills: 1. 5+ years of experience in Informatica PowerCenter 2. Strong experience in designing and developing of mappings, transformations, sessions and workflows in PowerCenter 3. Strong experience in performance tuning for Informatica processing 4. Expertise in best practices and development standard for Informatica implementation 5. Experience in Informatica Power Exchange implementation and administration 6. Strong experience in SQL and PL/SQL 7. Experience in Oracle, SQL Server, Sybase, or other relational database 8. Proficiency in relational database design, data warehousing and database administration 9. Experience in Oracle Designer, Visio design tools 10. Experience in database performance tuning 11. Experience TOAD, Oracle Enterprise Management development tools 12. Experience in Unix Shell Scripts 13. Experience in configuration management and code version control 14. Experience with Sun Solaris, Digital Unix, HP-UX, Windows NT/2000 15. Good written and verbal communication skills 16. Good technical and problem solving skills; 17. Excellent oral & written communication skills 18. Bachelor’s degree or Master’s degree in Computer Science, or equivalent experience Desired Skills: Experience in financial service industry is a plus ...View Job Details

****** Very Urgent Requirement ******** Position: Informatica Architect Location: San Francisco, CA – INPERSON REQUIRED Duration: 6-12 months Rate: $55/Max Interview: Telephonic followed by face to face Start: IMMD “US Citizen, Green Card Holder, EAD local to or nearby to San Francisco, CA are encouraged to apply, we are unable to sponsor H1B at this point of time” We need Informatica Architect with 8-10 years of overall experience. · Architecting Mapping transformation logic and Processes in Informatica · PowerCenter Integration Tool · Entity and Multidimensional Data Modeling techniques Thanks and Regards, Augustin Ahmed T Ext. 202 | F | e: | w: Locations: Dallas | Singapore | Bangalore | Hyderabad ...View Job Details

Reply to- or POSITION: Data Modeler (Staging Data Modeling) LOCATION: Thousand Oak, CA START: ASAP END: 4/30/2010 with potential to extend 3 to 6 months 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. Thanks & god bless. Twinkle kaur Business Development Manager Infolabs, Inc. (p) (f) ...View Job Details

Job Title: Technology Specialist Sr, Location: Southfield, MI Desired Start Date: 2/15/2010 Estimated End Date: 8/15/2010 KEY SKILLS: SKILLS # YEARS USED LAST USED WHERE USED Data Modeling Strong Oracle 10G Strong SQL and PLSQL ORM - Object Relational Mapping Knowledge of BPM (Business Process Modeling) DESCRIPTION: Working independently within guidelines, leads the design and implementation of complex logical data models and practices for data capture, data dictionary design and overall data integrity. Has experience in OLTP (Online Transaction Processing) and data warehouse modeling. Directs quality control and auditing to ensure accurate and appropriate use of data. Works with other subject matter experts to develop data storage strategies to support company needs. Enforces data definition standards, architectures and policies. Administers and manages data definitions within data repository. Designs and provides support of data repository. Designs and provides support of data modeling for client server or web systems development. Maintains data dictionaries and resolves problems. Extensive creativity required across areas of expertise. A high proficiency level in specific job related skills is required. Use of Informatica is highly preferred. Minimum 5 years related experience preferred. Bachelor’s degree in related field required. TECHNICAL SKILLS: • Strong Oracle 10G required • Strong SQL and PLSQL required • Strong understanding of Web languages (ORM – Object Relational Mapping) required • Experience of knowledge of BPM (Business Process Modeling) preferred ROLE DEFINITION: This individual is responsible to ensure project deliverables are completed according to the project timeline and adhere to the respective IT organization’s Quality Review process. It is very important that this individual is highly self motivated, very fast in learning new technologies and very good at problem solving. The individual must be very detail oriented and assume an “own it” type of attitude. Governance • Provides day-to-day technical leadership of the project or component build including deliverable development and technical issue resolution. Project management • Supports the delivery lead and primary technical specialist / lead in identifying detailed tasks and effort estimates for the work plan. • Monitors and reviews the respective IT team deliverables / tasks and timeframes. Resource Management • Identifies the types of skills needed and the level of expertise for resources. Risk and Issue Management • Identify and communicate technical issues. • Resolve and escalate technical issues. Communication • Acts as primary channel of communication to the delivery lead and primary technical specialist / lead for project related status, issues, and risks – representing all technical units. Delivery • Provides technical direction and support for the project team. • Ensures the project and deliverables are built to the approved design. • Assists in the preparation and conducting of technical review meetings and activities. • Reviews and approves the high-level design documentation for the project. • Ensures project team members follow the QR processes, policies, procedures, and standards established by the COMPANY. • Responsible for maintaining the integrity and quality of the changes made by the project team/vendor. • Coordinates testing in conjunction with the test lead. EDUCATION AND CERTIFICATION RECOMMENDATIONS: Bachelor degree in Computer Science or Healthcare required EXPERIENCE REQUIRED: 5 – 7 years relevant experience Experience leading package integration projects Experience in working with geographically dispersed project teams EXPERIENCE PREFERRED: 5 + years of package integration experience Healthcare insurance industry knowledgeable ...View Job Details

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

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

Project Description: In this role you will build be responsible for developing Target-source data mappings, DataStage data transformation, and ETL experience REQUIRED. In this role the developer will also be developing scripts, interfaces, extraction programs, and packages. Experience in legacy applications a plus. Candidate has to demonstrate the ability to take a set of business requirements, identify the resource systems where they reside, apply business rules and transformation logic and build load files. These files will then be used to load and update the Data repository. Required Experience: - Extensive Experience in using DataStage 8.1/8.0/7.5. - Business Analysis experience - Excellent knowledge in Fully Life Cycle ETL approaches. - 5+ years experience with Oracle. - Strong Development/Testing background - XML - MQ Series ...View Job Details

Industry : Bio Pharma POSITION: Data Modeler (Staging Data Modeling) LOCATION: Thousand Oak, CA START: ASAP Duration: One month with potential to extend 3 to 6 months 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. If you are interested please respond me with your updated resume ASAP. Regards, Vijay  ...View Job Details

POSITION: Data Modeler (Staging Data Modeling) LOCATION: Thousand Oak, CA START: ASAP END: 4/30/2010 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

Job Duties : Identifies and assesses potential data sources,Identifies and understands source data systems, Maps data elements between source system and data warehouse Database: Access Excel Sequel SQL Server Oracle Education Level: High School Diploma or Equivalent Technical Development Specialties: Data Warehousing Technical Development Specialties: Batch Data Communications Data Dictionary Data Dictionary DynPro Linking Data Structures Data Tables ...View Job Details

Need a senior level data warehouse analyst/modeler who is a self motivator and able to work independently as well as in groups. This person must possess excellent communication skills and be able to gather data requirements from business and technical users for a data warehouse environment. They must also possess source to target data mapping skills. This role will primarily be gathering data requirements and doing data mapping/high level design as well as some data modeling. Previous Wells Fargo/mortgage knowledge preferred. PowerDesigner and Teradata experience a plus. ...View Job Details

Requirement: Hands on experience in a Data Quality tool like Trillium, Dataflux which should include creating projects, tuning cleansing, standardization and matching rules Proficient in Data Profiling Must have clear understanding of Trillium or Dataflux Architecture Must understand technically how Data Quality integrates with Master Data Hubs (Customer, Contact, Product) Should be able to perform complex Data Analysis Candidate should have direct exposure working with Oracle Applications 11i Experience developing in Oracle-based tools. PL/SQL, SQL ...View Job Details

ORACLE Data Architect/Consultant Data Architect is reqd. knowledge of ETL tool is must (datastage preferable) ------------- "• Exposure to Basic Relational Database Concepts - basic types of databases,data integrity, the relational model,etc • Ability to understand basics of DBDesign , Logical modeling , Normalization & De-Normalization Techniques • SQLConstructs Ablility to understand and implement Data Types, Basic SQL SELECTStatements, Restricting and Sorting Data, Single-Row Functions, Joins,Aggregate and Group Functions, Sub-Queries, Creating & Managing DB Objects,Manipulating Data (DML), Constraints, Views • SQL Query Tuning Basics:Understanding of SQL Tuning concepts like SQL Statement Processing Basics,Explain Plan Basics, SQL Trace and TKPROF Basics, Indexes and Basic AccessMethods Basics, Introduction to the Optimizer Basics, Optimizer Hints Basics,Optimizer Hints Basics, Gathering Statistics Basics • Adv SQL Basics: Able tounderstand and implement Datetime Functions, Advanced Subqueries, HierarchicalQueries,DDL & DML Extensions, Transaction Management • Tools Level 1 usage •Database Programming Basics: Ability to understand and implement DeclaringVariables, Executable Statements, Control Structures, Composite Data Types,Explicit Cursors, Handling Exceptions, Creating Procedures, Creating Functions,Creating Database Triggers • Adv Database Programming: Ability to understandand implement Collections, Multilevel collections, Ref Cursors, BulkProcessing, Bulk Bind and Bulk Collect, DBMS_OUTPUT, UTL_FILE, Performanceaspects in PL./SQL • Exposure to Basic Relational Database Concepts - basictypes of databases, data integrity, the relational model,etc • Ability tounderstand basics of DB Design , Logical modeling , Normalization & De-Normalization Techniques • Woking knowledge of DB Design/Modelingtechniques(Logical and Physical DB modeling) •SQL Constructs Ablility tounderstand and implement Data Types, Basic SQL SELECT Statements, Restrictingand Sorting Data, Single-Row Functions, Joins, Aggregate and Group Functions,Sub-Queries, Creating & Managing DB Objects, Manipulating Data (DML),Constraints, Views • SQL Query Tuning Basics: Understanding of SQL Tuningconcepts like SQL Statement Processing Basics, Explain Plan Basics, SQL Traceand TKPROF Basics, Indexes and Basic Access Methods Basics, Introduction to theOptimizer Basics, Optimizer Hints Basics, Optimizer Hints Basics, GatheringStatistics Basics • Adv SQL Basics: Able to understand and implement DatetimeFunctions, Advanced Subqueries, Hierarchical Queries,DDL & DML Extensions,Transaction Management • Tools Level 1 usage • Adv SQL & SQL Tuning Techniques:Ability to implement Tunning Concepts/Techniques like Explain Plan, Accessmethod, Generate SQL Trace and TKPROF report, Forcing Index Hints, GatherStatistics, Managing Optimizer Statistics, Using Indexes, Using Plan Stability,Using Application Tracing Tools, SQL Access Advisor • Database ProgrammingBasics: Ability to understand and implement Declaring Variables, ExecutableStatements, Control Structures, Composite Data Types, Explicit Cursors,Handling Exceptions, Creating Procedures, Creating Functions, Creating DatabaseTriggers • Adv Database Programming: Ability to understand and implementCollections, Multilevel collections, Ref Cursors, Bulk Processing, Bulk Bindand Bulk Collect, DBMS_OUTPUT, UTL_FILE, Performance aspects in PL./SQL • AdvDatabase Programming: Ability to understand and implement Advanced ExplicitCursors, Managing Subprograms, Creating Packages, Oracle Supplied Packages,Adv. Triggers, Managing Dependencies • SQL Developer Tool for DatabaseProgramming • Tools Level 1 Usage • Able to use TOAD for Database Development•SQL Constructs Ablility to understand and implement Data Types, Basic SQLSELECT Statements, Restricting and Sorting Data, Single-Row Functions, Joins,Aggregate and Group Functions, Sub-Queries, Creating & Managing DB Objects,Manipulating Data (DML), Constraints, Views • SQL Query Tuning Basics:Understanding of SQL Tuning concepts like SQL Statement Processing Basics,Explain Plan Basics, SQL Trace and TKPROF Basi ------------------- ...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

Qualified candidates please send resumes to or feel free to call me at. Excellent SQL skills are required. ETL testing experience is a must. Congos testing experience is required. Business Intelligence knowledge is required. Healthcare experience is preferred. UNIX scripting is preferred. Automation experience is preferred. The candidate should be able to work independently. 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. Bachelor’s Degree in Computer Science, Information Systems or other related field, or equivalent work experience in similar work environment.Minimum 6 years of IT work experience. Testing background and hands on experience with test tools. Work toward certifications including: CSQE or CSQA preferred, professional test tool certification (Mercury, Rational, Compuware) Deliverable: Analysing requirements and developing as well as executing test cases for ETL and Cognos Reports Excellent SQL skills are required. ETL testing experience is a must. Congos testing experience is required. Business Intelligence knowledge is required. Healthcare experience is preferred. UNIX scripting is preferred. Automation experience is preferred. The candidate should be able to work independently. 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. Bachelor’s Degree in Computer Science, Information Systems or other related field, or equivalent work experience in similar work environment.Minimum 6 years of IT work experience. Testing background and hands on experience with test tools. Work toward certifications including: CSQE or CSQA preferred, professional test tool certification (Mercury, Rational, Compuware) Deliverable: Analysing requirements and developing as well as executing test cases for ETL and Cognos Reports Excellent SQL skills are required. ETL testing experience is a must. Congos testing experience is required. Business Intelligence knowledge is required. Healthcare experience is preferred. UNIX scripting is preferred. Automation experience is preferred. The candidate should be able to work independently. 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. Bachelor’s Degree in Computer Science, Information Systems or other related field, or equivalent work experience in similar work environment.Minimum 6 years of IT work experience. Testing background and hands on experience with test tools. Work toward certifications including: CSQE or CSQA preferred, professional test tool certification (Mercury, Rational, Compuware) Deliverable: Analysing requirements and developing as well as executing test cases for ETL and Cognos Reports Qualified candidates please send resumes to or feel free to call me at. ...View Job Details

Required skills: SAS WITH TERADATA EXPERIENCE   7+ years of demonstrated success in data or business analytics, including managing a team High-level proficiency in SAS, SPSS, SQL Server and other analytical tools Highly analytical with proven track record in data-rich analysis with the ability to translate complex analytics to business-shaping actions that are understood by business users Experience managing global customer analysis is preferred Extremely strong communication skills to deliver meaningful insights from complex analysis to explain analytical outcomes and technical roadblocks in business terms Ability to efficiently manage and implement quick-turnaround, tactical projects as a team Thanks and Regards, Sanjay Bobba Spectraforce Technologies Inc Contact  ...View Job Details

High level Requirements ====================== Advanced SAS certification Good Communication SAS 9.x familiarity SAS EG Knowledge SAS Miner is plus Education in Statistics or computer science Project management experience Offshore/on-site handling good RDBMS knowledge Above position requires excellent communication skills with SAS knowledge; candidate will act as interface across different development modules. ...View Job Details

Position: Sr Informatica Developer Location: Pasadena, CA / Pleasanton, CA Total number of resources needed: 2 Start: Immediate Bachelor's Degree or Master Degree in computer engineering. > 6 years of strong experience in Informatica development required. Should have or able to effectively coordinate with various teams including offshore. Strong written and oral communication skills required. Demonstrated ability to work independently and collaborative, as needed, and to appropriately prioritize required. Self-motivated and able to grasp new concepts quickly required. Ability to resolve problem; take initiative, and to identify and propose new tasks and procedures required. Have very strong analytical skill set ...View Job Details

Role : Database Analyst 5 Location : Minneapolis, MN or Des Moines, IA Duration : 18 months Rate : Competetive Looking for (EAD's/GC's/Citizens Only) No H1B's please. Position Description: Experience Level: 4 year degree in IT or related field and 8+ years related experience or equivalent combination of education and experience. Description: > 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. > Leads complex projects. > Need a senior level data warehouse analyst/modeler who is a self motivator and able to work independently as well as in groups. > This person must possess excellent communication skills and be able to gather data requirements from business and technical users for a data warehouse environment. > They must also possess source to target data mapping skills. > This role will primarily be gathering data requirements and doing data mapping/high level design as well as some data modeling. > Previous Wells Fargo/mortgage knowledge preferred. > PowerDesigner and Teradata experience a plus. Platform and Skill Set Expertise: > Database Development : OLAP, > Design Skills & Tools : Data Modeling, Data Warehouse > Analysis Skills : Business Analysis --------------------------------------------------------------------------------------------------------- * *If you are interested please reply me with following details-: Latest word format resume: Rate Information all inclusive on W2: SSN (Last 5 digits): Birth date and month: Current Location: Availability for in-person interview if required on own expenses (Yes/No) and when: Availability to join: Visa Status (Citizen, Green Card or EAD): If you have any questions feel free to call me ...View Job Details

Title: Dataware House Business Intelligence OBIEE Consultant Lead with strong PM capabilities. Hands on in DWBI and at least 5-6 years on Informatica ETL Oracle APPS and OBIEE experience. Domain experience in Operations and Supply Chain preferable. ...View Job Details

Duration: 5+ Months There will be an F2F interview after a telephonic round. 10 years of experience in Systems Development and/or Applications Support. 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

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

BI Analyst 6 Month Contract New York, NY Rate: $42/hr The BI Analyst’s role is to examine and evaluate information requirements for various business units across the organization, investigate information issues and reporting problems, and assist in support of various production processes . * This individual will use proven knowledge of specialized reporting tools, SQL, and database techniques to perform data analysis and develop reporting structures as required. * Assignments may involve unstructured investigation and analysis to respond to a business information need. * The BI Analyst is also responsible for proactively generating and compiling information in reports, spreadsheets, or files based on his or her findings, complete with recommended improvements to – or new requirements for – business processes, operational procedures, and their corresponding reporting structures * Ability to document and present results appropriately for senior/executive management. Position responsibilities: Key areas of responsibility will include: * Conduct data pulls and perform customized data analysis * Work with the data warehouse and/or non-BI data sources to perform investigations. * Develop rapid understanding of business issues and determine the data needed to support investigations and/or reporting to support those issues. * OEM, Retail, Listener Care, Subscriber Analytics, Finance, Marketing, and Revenue Assurance Reporting and Investigations as assigned * Develop and automate reporting packages for multiple audiences; critical success factors include the abilities to: o Understand all relevant data sources o Extreme attention to details and data accuracy o Provide complete reporting solutions using data analysis and SQL data mining techniques o Work independently and research innovative solutions to challenging technical problems Requirements : * Strong communication skills and business savvy are essential. * Technical data analysis and reporting skills are crucial, including advanced knowledge/skills in the use of SQL in SQL Server and Teradata environments, advanced skills in MS Excel and Access, and intermediate knowledge of Cognos 8.4 report development. * 5-7 years work related experience required * Must have the ability to interpret logical and physical database diagrams. ...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

***********88 Need locals for in-person interview *********** We need Informatica Architect with 8-10 years of overall experience. · Architecting Mapping transformation logic and Processes in Informatica · PowerCenter Integration Tool · Entity and Multidimensional Data Modeling techniques ...View Job Details

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. Thanks, Prince M Amtex systems Inc, Nyc, NY Ph(W) :  ...View Job Details

Position title: ETL developer Location: Atlanta, GA Duration: 6 month Fill this skill metric with the submission Skill Matrix: SQL Server: years SSIS: years SSRS: years SSAS: year Currently we are looking for an expert with proven experience in developing Data Warehouse solutions with in-depth understanding of BI technologies tools and methods Required Skills: • 8-10 years of experience developing system solutions for Enterprise Data Warehouse/Business intelligence projects with dashboards, scorecards, KPIs in SQL Server environment • Must have expert skills with all aspects of SQL Server development including: SSIS, SSRS, SSAS, Business intelligence, SQL Server Management studio etc… • Expert level experience with ETL sourcing data from multiple data sources into target DW structures, Operational data stores and normalized design • Experience working with multidimensional models, OLAP cubes, ROLAP, star and snowflake schemas • Strong database design skills for performance optimization, partitions • Experience and understanding of: Service Oriented Architecture (SOA), Business Rules Engines, XML, Component design • Ability to understand and implement UML models • Primary focus is development, testing and implementation though some design work may be required • Strong problem solving, analytical and communication skills • Ability and desire to take an ownership of the project, to work in a fast paced environment with minimum supervision Technology stack: • SQL Server 2008 suit (SSIS, SSRS, SSAS, BI development studio) • .NET environment • Microsoft SharePoint • T-SQL • ORACLE PL/SQL ...View Job Details