ETL Lead 4-12+ Months Contract (Extendible) New York- NY Skills required " Data warehousing - 7+ years of experience " Informatica - expert level experience of 7+ years, need to know how/when to balance Informatica code with native Database code, proven experience in optimizing ETL processes " Oracle programming (PL/SQL) - strong intermediate level experience 5+ years " Database programming - in general needs to have over 10+ years of experience " Perl - intermediate (should be familiar and be able to enhance existing scripts) " Shell - intermediate (should be familiar and be able to enhance existing scripts) Partitions ...View Job Details

City & State: Release Comments: Prior experience with Revenue Solutions, Inc. DiscoverTax and/or Portfolio Warehouse software is required. Job Description: The following application tasks are expected to be executed by the Data Warehouse systems software programmer. All tasks will involve some degree of up front analysis prior to development or execution, as well as several phases of system and user acceptance testing. These tasks/skills do not include database administration support or technical infrastructure support tasks, as these responsibilities fall under a different support area within the SCDOR IRM organization. Work with SCDOR Operations & Support team to set up the new “Model Office/User Acceptance Test” environment, including virtual machines (servers) and databases. Install the PW software in successive environments, from “Sandbox” to “Development” to “Model Office/User Acceptance Test.” Apply release upgrades in all environments as they become available. Coordinate testing efforts in all environments; log defects and track until resolved. Create work items for other Data Warehouse team members as appropriate. Testing must include, at minimum: o Preparing and loading of data into the Data Warehouse using the Extract, Transform, and Load (ETL) tools. o Setting up and running the PW Associate and Grow (A&G) offline process for data cleansing and matching. o Development of tax calculations via the PW “Tax Calc” component. o Creating and executing “views” to be utilized by the PW audit selection process. o Testing all application level configurations and parameters for the PW product. In addition to items listed above, these include various system reference codes, workflow rules, scoring parameters, correspondence templates, as well as configuration of various 3rd party products such as Group 1, SSA, and DT Studio. o Testing of PW offline processes. These include primary indicator, legacy system gateway, nightly data refresh process, and collections scoring. Work with senior RSI onsite support and the RSI Solutions Center to diagnose and resolve issues, and to apply patches and hot fixes as needed. Prepare final package of software and data for migration to Production environment. Ensure that all installation tasks, test results, and component configurations are fully documented. SKILLS REQUIRED: The successful candidate will have, at minimum, the following skills: Experience and expertise in software installation and implementation. Experience and expertise in software testing; familiarity with testing methodologies and preparation of test plans. Experience and expertise in isolation and diagnosis of software defects, including use of diagnostic tools such as monitors and traces. Experience and expertise in gathering and analyzing business user requirements. Proficiency in Java development. Experience and expertise in SQL, including development of T/SQL queries and data manipulation. Expert knowledge of databases and relational database concepts. Experience with SQL Server 2005 required. Experience with Windows XP operating system and the Windows 2003/2008 server environment. Experience with Data Warehouse concepts, including the use of Extract, Transform, and Load (ETL) tools and creation of data marts. Ability to communicate clearly and concisely, both orally and in writing. Ability to establish and maintain good working relationships with business users, management, vendors, and peers. Strong organizational, multi-tasking, and time-management skills. Ability to complete assignments on time. Understanding of deployment methodology concepts including design, build, testing, and deployment. The individual will operate with very limited supervision, within standards and processes established for the SCDOR Data Warehouse and over-all Agency and IRM procedures. SCDOR systems include extremely sensitive and confidential information; position requires complete discretion and trustworthiness. The individual must be customer oriented, and attentive to the needs of Data Warehouse users. ...View Job Details

The successful candidate will work with the TPS team within Client to implement, maintain, and enhance its enterprise-level data architecture using Informatica PowerCenter ETL tool. The successful candidate will work as part of a team comprised of members of the technical staff to use test-driven development techniques to develop and implement ETL processes to support sequencing and analysis efforts. Specific responsibilities will include: · Work with Scientific Business Analysts and Data Modelers to understand requirements. · Design and develop sustainable database ETL applications to support those requirements. · Create technical design documents that capture source to target mapping, define transformation algorithms, and document data quality rules. · React to and correct day-to-day operational errors. Required Skills: · Demonstrated results and competence developing ETL processes using Informatica PowerCenter 8 or 9. · The desire to think broadly about their responsibilities and continually refine and improve the way they work, and be able to share that with others. · 2+ years of full time experience with ETL tools and processes, preferably in a scientific or technical environment involving 10+ TB of data. · The ability to read, write, and maintain SQL. · The ability to use a scientific process and data from tools such as Oracle Enterprise Manager (OEM) to identify and correct performance problems with ETL processes. · Ability to communicate across diverse audience of business analysts, architects, business users and technical project staff. Desired Skills: · B.S. or higher in Computer Science or other technical field. · 5+ years of full time experience with ETL tools and processes, preferably in a scientific or technical environment involving 10+ TB of data. · Experience with Object-Oriented methodologies, Test-First Development, Continuous Integration, and Agile Development processes. · Experience using KETTLE/Spoon. · Experience in software development using Oracle and XML. · Experience at physical database modeling. Desired skills/education/experience/attributes (ideal candidate): Candidates who succeed in this fast paced dynamic environment excel in the following competencies: · Functional Competency: Demonstrates broad knowledge of functional skills. Has the ability to perform at a high level of accomplishment and willingness to learn new technologies and practices. The ideal candidate will be a skilled, creative problem solver, independent of any specific technology. · Team Orientation: Works cooperatively with others. Encourages participation. Values the contribution of others. · Results Orientation: Gets things finished; identifies and overcomes obstacles. Balances the big picture with day-to-day activities/issues for their technology. Persistent in the pursuit of results. · Communication: Creates an environment that fosters open, frank communication. Clearly expresses oneself orally and in writing. Listens carefully, solicits other opinions. ...View Job Details

Data Modeler Duration 12 months Location Des Moines, IA Data Modeler that have used Power Designer (ETL tool) and preferably have worked on either OLTP or OLAP systems. Must have good communication and people skills, good analyst skills, and work good under pressure with multiple deadlines. Mapping experience is a must. Thanks & regards Vinod Kumar Sharma Technical Resource Specialist FCS Software Solutions Ltd. Phone Ext. 4260 Fax E-Mail: Yahoo IM: vinod.jewar Gtalk: vinod.jewar ...View Job Details

Description: Resource will have experience in Data Modeling and working with Entity Relationship Diagrams, Data Mining and the ability to assimilate data knowledge from various sources (Vendors, SMEs, Documentation, etc) in order to purge non-company data from Oracle, SQL Server and Sybase databases. ...View Job Details

Description: Resource will have experience in Data Modeling and working with Entity Relationship Diagrams, Data Mining and the ability to assimilate data knowledge from various sources (Vendors, SMEs, Documentation, etc) in order to purge non-company data from Oracle, SQL Server and Sybase databases. ...View Job Details

Position : Data Modeler Location : San Jose, CA Duration : 6+ Months Need Locals for F2F interview after telephonic Job Description: Responsibilities Work with Business System Analyst and business partners to understand conceptual data models and translate these into appropriate Logical Data models. Develop conceptual, logical, and physical data models for DW, Master and Reference Data, Decision Support. Work towards consistency across all Logical Data Models and build up an Enterprise Logical Data Model and common data model. Analyze the data models of Vendor provided/OTS packaged software and map this to Business requirements and Common Logical Data Model. Follow corporate best practices for Data Modeling. Analyze Project requirements for impact to Data models. Contribute to standards and frameworks for Data Modeling, data integration/ETL and reporting and ensure these are being consistently used in the design and development of all relevant solutions. As part of the Information Management Platform Engineering Team, contribute to develop the overall strategic plan and priorities for supporting business intelligence and performance management functions. Create, document, reconcile and maintain logical and physical models, reflecting the state and use of data across the business. Support a culture of clear data ownership across the organization. Work with data owners, users, and other business and IT roles to support the monitoring, management and ultimately improvement of data quality. Work towards the adoption of a consistent vocabulary across the organization based on an agreed Data Dictionary. Communicate to the rest of IT the role and opportunities of supporting consistent Data Modeling and an Enterprise Logical Data Model. Collaborate with other IM domains to drive business and technology innovation. Keep abreast of the business strategy, business plan and latest industrial trends. Mentor and train less experienced data modelers on data modeling best practices. Develop and implement strategies and methodologies in support of Master Data Management initiatives. Facilitate modeling sessions and design walkthroughs with DBA and development and QA team members. Work with Data Architecture team to ensure proposed database implementation conforms to the company's corporate data strategy. Support multiple projects and programs. Coordinate with on-site and offshore data modeling resources. Requirements 7+ years experience IT and 5+ year’s experience in transactional and dimensional data modeling experience. Demonstrated experience gathering and translating requirements into conceptual, logical and physical data models. 5 years of exposure working in a retail, software or enterprise business model. Solid understanding of Data Management principles. Knowledge of data modeling tools like Erwin, Embercado and SAP designer. Knowledge of relational databases and Reporting solutions. Knowledge of standard Business Processes. Knowledge of SAP ECC, BW, Salesforce and other standard applications desirable. Experience in data profiling and data analysis and able to define the common terms and rules. Attention to detail and maintaining high data quality standards. Well-developed analytical, problem-solving, and decision-making skills, leveraging both logic and creativity; strong troubleshooting skills; ability to identify patterns and generate ideas Focus on the end user's or customer's needs; ability to set expectations and understand end user behavior Ability to work well in an IT organizational environment with strong collaborative and team orientation Excellent customer service skills and strong interpersonal skills Excellent communication and documentation skills. ...View Job Details

They must be a SQL expert. SQL expert with over 10 years of experience with Data warehouse administration experience. Integrated Planning and Evaluation Provides complex integrated systems planning and recommends alternative technologies that will enhance current or anticipated information systems that support overall corporate and business goals. Oversees the development of plans for integration of new systems architecture into current infrastructure. Ensures the review and design concepts for new systems and develops and documents the technical design for the integration and implementation of the software. Oversees the development of plans for integration of new systems architecture into current infrastructure. Provides complex logical/physical input to Operations areas to enable integration of new systems into current infrastructure. Provides technical direction and support for complex, cross-functional configuration projects. Works on issues that impact design/selling success or address future concepts, products, or technologies. Serves as a technical resource to help define, estimate, and propose solutions for business problems. Determines how to leverage technology to create solutions that satisfy business requirements. Business Requirements Business Process Analysis. Ensures the appropriate business process assessment and analysis is completed to identify business process gaps and impacts as they pertain directly to projects and programs. Highly experienced at negotiating and collaborating with key project leaders to identify subject matter experts and resources necessary to complete business requirements. Strongly influences the business by demonstrating a clear understanding of the business needs and the technologies that can be used to appropriately accommodate their requirements. Brings structure to the process of requirements gathering. Uses standard techniques and tools to gather business and technical requirements in an organized and repeatable process. Understands purpose, data requirements, system of record and integration points of information systems for the design of Enterprise solutions. Designs the information and system architecture, integrating information systems into a larger solution. Validates design and manages the vision of the Enterprise solution. Functional & Application Release Requirements Provides direction and guidance to those assigned to defining functional requirements. Responsible for the content and quality of the functional requirements by facilitating reviews with subject matter experts. Ensures traceability is maintained to the higher level requirement for each functional requirement. Directs and coordinates the activities and resources necessary to drive the process deep enough to uncover the appropriate set of functional requirements. Development of Solution Recommendations/Alternatives Consults and directs identification of alternative uses of technologies that will enhance current or anticipated information systems and that support overall corporate and business goals that are appropriately aligned with the enterprise architecture. Identifies and recommends necessary changes to current business process. Keeps abreast of leading and emerging software products and technologies as well as industry standards that could support SH/healthcare business. Leverages existing skills and knowledge to research new technologies and methodologies. Compares and evaluates the design and capabilities of multiple system components (e.g., architecture, network, operations and communications May participate in outside standards setting organizations. Management of Client Expectations Communicates the business partners’ expectations toward the timeliness and quality of the work products being recommended. Accountable for the content, correctness, completeness, and accuracy of the deliverables. Solutions, Designs, Estimates, and Alternative Analysis Leverages knowledge, expertise and experience to facilitate the development of robust client solutions. Understands purpose, data requirements, system of record and integration points of information systems for the design of Enterprise solutions. Develops strategies and plans to assess impact and potential risk. Develops strategies for solution sharing and re-use solutions. Directs strategy development for the implementation of the solution, risk evaluation, and alternative solution design for large projects/programs/initiatives with cross portfolio implications. Designs the information and system architecture, integrating information systems into a larger solution. Validates design and manages the vision of the Enterprise solution. As well as Database development Builds databases, stored procedures and scripts in support of EDW solutions designed by Data Warehouse Architects. Supports development staff during the build of EDW. Recommends database and fields naming conventions. Assists in the development of database extracts. Documents database models, scripts, stored procedures, promotion procedures and system architecture. Establishes development guidelines designed to maintain optimum performance. Advises Information Management Solutions Architect in the creation of development guidelines. Takes a new perspective on existing solutions, recommending new procedures and processes to achieve results. Performance tuning and monitoring of databases Establishes guidelines for query structure to maintain adequate performance. Proposes and implements enhancements that will improve the performance, reliability and data integrity of the system. Reviews queries for performance issues. Identifies and performs routine maintenance to ensure high performance. Back-up and recovery Recommends back-up schedule and strategy. May set up and regularly monitors back-up as specified by SLA. Adheres to enterprise disaster recovery policies and procedures. Performs database restores from back-up. ...View Job Details

Data modeler Location: Des Moines, Iowa Job Description: Should be able to understand business requirements, translate them into data modeling requirements in IIW, and perform LDM and PDM activities. Hands-on experience with ERWIN tool. Should have experience in US Life Insurance and Annuities. ...View Job Details

Senior ETL Developer (with Python) Palo Alto, CA 6 Months+ Contract Our client is a cool company with a casual culture with high traffic web presence. They are hiring a Senior ETL Developer who loves being a teacher to others and being an integral member of a team of fellow brilliant BI Developers. Requirements: The Client has developed it's own home-grown tool using Python. Source Databases from where to pull data are Oracle 10g (primarily)/Mysql and some hive/hadoop. Good experience with data modeling is required. Any experience with working with homegrown tools is great. Strong communication skills. Any knowledge of algorithms is a plus. Exposure to hadoop/hive is a plus. Note: Need local candidates for inperson interview ...View Job Details

Title: Data Modeler Location: Worcester, MA Rate: $55/h ctc Duration: One Year Immediate The expert level data modeler must have 5+ years of data modeling experience in data warehouse environments including knowledge of Kimball methodology of designing Star Schemas with surrogate keys. Must have the ability to write queries and load sample data to the test physical model to validate the design before handing off to the ETL developers. The database environment is SQL SERVER 2008R2 Required Qualifications: Qualifications: Data Modeler Minimum Years Required: 5 ...View Job Details

Description: The expert level data modeler must have 5+ years of data modeling experience in data warehouse environments including knowledge of Kimball methodology of designing Star Schemas with surrogate keys. Must have the ability to write queries and load sample data to the test physical model to validate the design before handing off to the ETL developers. The database environment is SQL SERVER 2008R2 Required Qualifications (Keane Standard List): Qualifications: Data Modeler Minimum Years Required: 5 ...View Job Details

Founded in 1998, Matrix Technology Group is an ERP and IT consulting services provider. Matrix Technology Group provides Services into ERP, BI and Application Development. Our staff's Passion, service and dedication set us a apart from other IT firms. Our team is Dynamic and is focused to our Client needs. Our Team is geared to work with Consultants and our Clients to achieve higher performance. We want to work with you and want to welcome Candidates who are Talented, Passionate, and Dedicated and have Ambition to grow. One of our clients is looking for Opening Required: Data Modeler consultant/Worcester, MA /9months Please call me on this no Job description: The expert level data modeler must have 5+ years of data modeling experience in data warehouse environments including knowledge of Kimball methodology of designing Star Schemas with surrogate keys. Must have the ability to write queries and load sample data to the test physical model to validate the design before handing off to the ETL developers. The database environment is SQL SERVER 2008R2 ...View Job Details

Job Title : IIW Data modeler Work Location : Des Moines,Iowa. Duration : 8-10 Months Relevant Experience (Yrs) 6-8years Technical/Functional Skills: Should be able to understand business requirements, translate them into data modeling requirements in IIW, perform LDM and PDM activities. Hands-on experience with ERWIN tool. Should have experience in US Life Insurance and Annuities. IIW Data modeler - 1 position Generic Managerial Skills : Excellent Analytical Skills, ability to work under pressure, good communication skills. Start Date : 10th Feb'12 Thanks & Regards, Simon Technical Recruiter ITBMS Inc | Consulting. Knowledge. Solutions I 1967 Rte 27, Ste 27 | Edison | NJ 08817 Ph (O (F) | Email: ...View Job Details

Strong background in configurators, Modeling Business Rules and techniques involving solutions, product and services Knowledge on configurator tools like IBM Sterling, DRools, BigMachines Ability to solve complex problems involving multiple sub systems – including heuristic algorithms in rule engine Proficiency in core Java Experience with automated testing Must have outstanding written and verbal presentation skills Knowledge in java - reflection, code generation techniques is good to have. Should have basic SQL and database concepts Thanks Geetha ...View Job Details

Hi , Greetings from Computech Corporation, P.S. We are tier 1 vendors with Teradata Corporation Job Title : Physical Data Modeler Location : Charlotte, NC Duration : 6-12 Months Contract Job Description: Need a PDM with SQL expertise. Experience with Teradata is a must If you are interested, I would request you to send me your updated resume with the following details please: 1. Full Name: 2. Visa Status: 3. Present location: 4. Contact Details: 5. Available to start: 6. Total Experience: 7. Current Employer / Recent Employer: 8. Expected Payrate: Note: If this requirement does not match your needs, please do forward the same to your colleagues and friends to see if anybody would be interested and willing to move forward on this position. We would really appreciate the gesture here. Thanks and Regards, Dinakar B Computech Corporation Phone Ext: 7108 Email: Web:  ...View Job Details

Location: Santa Ana, CA Data Analyst ( Skill Set below): Exp. in gathering, writing and maintaining Business, Functional, Software Requirements/Specification docs. Maintaining Requirement Traceability Matrix Perform source system analysis, Gap analysis Coordinate with Business/Dev./QA/Architects/Data Modeler/SME/Stewardship teams Work in parallel with Data Modeler and provide required information, Validate the model Generate Data Mapping, Reference data, report templates Support Dev., QA, UAT phases ...View Job Details

Skills: Teradata dimensional Modeler Job Role / Responsibilities: . Should have 8-10 yrs of experience with at least of 5 yrs of Dimensional Modeling experience with TeraData background preferably. Must demonstrate high degree of technical expertise. Excellent analytical and troubleshooting skills. Outstanding communication skills and attention to detail ...View Job Details

Lead the development of the data model components to support the new reporting system solution; 7-8 years database architecture exp. required; previous experience with life science clients ...View Job Details

Strong background in configurators, Modeling Business Rules and techniques involving solutions, product and services Knowledge on configurator tools like IBM Sterling, DRools, BigMachines Ability to solve complex problems involving multiple sub systems – including heuristic algorithms in rule engine Proficiency in core Java Experience with automated testing Must have outstanding written and verbal presentation skills Knowledge in java - reflection, code generation techniques is good to have. Should have basic SQL and database concepts ...View Job Details

Lead the development of the data model components to support the new reporting system solution; 7-8 years database architecture exp. required; previous experience with life science clients ...View Job Details

This position is for Data Modeler, Please find the complete details below. Location: Jersey City, NJ Duration: 12 Months Hourly Rate:$Open Need for a data modeler on the Issuer Linking project within the Reference Data De-Duplication Program. This resource will be responsible for critical counterparty and reference data distribution components. They will be required for 1 year and must have the following skills: Data modeling MS SQL Stored Procedures Database Design Optimization of SQL Reference Data "Equal Employment Opportunity" ...View Job Details

Strong background in configurators, Modeling Business Rules and techniques involving solutions, product and services Knowledge on configurator tools like IBM Sterling, DRools, BigMachines Ability to solve complex problems involving multiple sub systems – including heuristic algorithms in rule engine Proficiency in core Java Experience with automated testing Must have outstanding written and verbal presentation skills Knowledge in java - reflection, code generation techniques is good to have. Should have basic SQL and database concepts ...View Job Details

Hi, Full Time- Data Architect/Modelers-Baltimore, MD We still need candidates for (4) Data Architect/Modeler (DS3), Task order 8 positions with solid BI experience. This is permanent position. These candidates will be located in Baltimore for the support activities. We also need (2) Requirement Analyst 3 (RA3) Task Order 8 candidates. These candidates will be located in Baltimore for the support activities. We are setting up phone interviews for these positions. Data Architect/Modeler (DS3), Task order 8 positions Requirements: Expertise in Data Warehousing and Business Intelligence area. Accomplished Data Warehouse Architecture, Data Modeler and Designer. 5+ years of experience with database design and modeling in a SOA environment 5+ years of experience extracting and documenting data requirements from business/functional requirements 5+ years of Strong experience with CA Erwin Data Modeler and CA Erwin Model Manager 5+ years experience with the development of reporting mechanisms Required skills and experience; Design and develop data stage models that promote efficiency, integrity and flexibility Ability to generate logical and/or physical data models from scratch based off business requirements is a must Demonstrated proficiency in Data-Management concepts, practices and procedures, extensive knowledge of DBMS in multi-tiered, Web/Client/Server environments, as well as extensive knowledge of data integration, data quality, multi-dimensional design and ETL tools, processes and methodology Specific experience with data warehousing in a DB2 environment Databases/systems to develop data mapping and design the ETL strategy Excellent analytical, problem solving and communication skills Strong verbal and written communication skills are critical. Candidate must be able to effectively interact with all levels of customer staff, and be able to flourish in a government contract setting Desired Skills; Experience with DB2 Version 9 J2EE Software Development experience Thanks & have a wonderful day Jenson Sebastian Sedna Consulting Group | Direct Email: | / Sedna Consulting Group is an E-Verified Company Save Paper Save Forests Please think ! before printing this mail Note: This email is not intended to be a solicitation. Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list. ...View Job Details

Skills Required: 3-5 years experience focus in Relational Data Modeling . Must possess experience with ERwin Data Modeling Suite Master of Data Management tools, concepts and practices is necessary. Candidates must be self-motivated and results-oriented with strong data modeling skills. Excellent communication, facilitation and negotiation skills are required. ...View Job Details