Hello, Please go through the below job requirement and let me know your interest. Position: Data Modeler/Data Architect Skills: Dimensional data modeling Normalized Models CA Erwin Data analysis SQL Teradata Requirements-gathering ETL (Informatica) BI Reporting Thanks/Regards, Sumant, || IT-SCIENT || Phone || Fax || Email: || Web: || ...View Job Details

The Data Architect/DBA Team Lead will work on the Citywide Data Warehouse (CityDW) team working with the development team and databases that encompass the CityDW. The Data Architect/DBA Team Lead supports, designs and builds databases, data warehouses, assists with data acquisition, conversion, and creates interfaces. The Data Architect/DBA Team Lead will also work with the Districts Architects to optimize organizational goals through enterprise standards. The team, lead will also be a hand on resource and will be involved in DBA activities. The program provides a centralized access point for enterprise wide data with a focus on providing data that enables decision support and government transparency. A primary stakeholder is DC Government’s CapStat program (capstat.oca.dc.gov), a Mayoral initiative designed to help make the DC government accountable to its residents by providing access to information of interest to its citizens and by making the government operations as transparent as possible. Behavior Characteristics: Excellent written, oral communications, interpersonal skills. The Ability to work as a team player. Must be well versed in communicating to both technical and non-technical persons. Required / Desired Skills Experience as a DBA Experience as a Database Architect Experience as Lead Database Administrator Experience as an Oracle DBA Experience as a DBA supporting development teams Experience and expertise in data modeling and database design Experience creating, maintaining, updating database documentation Experience in full life cycle development of applications. Experience with Oracle backup and recovery Experience with disaster recovery, monitoring, troubleshooting, Experience writing and debugging complex PL/SQL procedures and packages Experience designing backup solutions using RMAN. Experience with data warehouse business intelligence projects Experience as a project manager leading a DBA team Experience with data warehousing in an Oracle environment Experience working with Oracle in a Microsoft Environment Experience with visual basic scripts Nice to have Experience with local/state government projects Nice to have Experience with Informatica as Data Warehousing solutions Nice to have Oracle Certified Professional 10g or 11g by Oracle Corporation Oracle Certified Professional 9g by Oracle Corporation Nice to have ...View Job Details

Hello, Please go through the below job requirement and let me know your interest. Position: Data Modeler/Data Architect Skills: Dimensional data modeling Normalized Models CA Erwin Data analysis SQL Teradata Requirements-gathering ETL (Informatica) BI Reporting Thanks/Regards, Sumant, || IT-SCIENT || Phone || Fax || Email: || Web: || ...View Job Details

Data Profiling for data warehouse Strong SQL skills - mail call 4 months, Chicago, IL 3-5 years experience in Data Profiling for data warehouse Strong SQL skills -- application dba level DB2 database Healthcare experience a preferred Strong DB2 - h2 create tables, knows stored procedures - this is strongly preferred, but not req good general database skills Focus on Data analysts - "profiling" is a skill that a data analyst would do. Coming up with statistics about data in a table. Please revert back with resume, rate, availability, and contact details at Regards ============== Roopinder RJT Compuquest Inc . 23440 Hawthorne Blvd.Suite 210 Torrance, CA 90505 Email : CALIFORNIA | ILLINOIS | WISCONSIN | TEXAS | COLORADO | NEW JERSEY | INDIA RJT Compuquest is focused on providing IT Professional Services across the United States. RJT Compuquest offers an array of services in SAP solutions, Oracle Applications and Quality Assurance. This message may contain confidential information. If you are not the addressee, or authorized to receive this message on the addressee's behalf, you must not use, copy, disclose, or take any action based on this message or any information herein. If you received this message in error, please inform the sender immediately by replying to this email and deleting it thereafter. Thank you for your cooperation ...View Job Details

Title: Informatica Administrator Location: MA Duration: Long Term Rate: Open (Keep it very competitive) Job Description : Client is looking for a senior-level Informatica Administrator with Informatica v9 upgrade experience. They are running 4 VM instances on Red Hat Linux. Resource should be able to do configuration, set-up, and initial administration of the v9 environments, then do a hand-off to the staff Informatica admins. Consultants has to set-up and configure the High Availability Grid Option. The environments that need to be upgraded are Dev, Test, Performance, Production, VM Sandbox, and D.R. Best Regards, Ashley SVG IT Voice x 304 Cell Fax Email:  ...View Job Details

Hi My Name is John; I am with Optimal Business Group. We have the following opportunity for you. Please review the detail job description and get back to me ASAP. Informatica Expert Issaquah, WA 6+ months Rate: Lowest Best Need Informatica expert who had used Informatica on AIX and has some background on IBM Smart Analytics System • Expert in Informatica • Should have strong background in ETL mapping • Should have worked on Informatica on DB2 database in AIX environment • Should have ETL experience in Partition DB2 • Should be very familiar with AIX platform We need the following information for above mentioned position: Full Name:- Skills strong on :- Current location:- Availability:- Contact Details:- Email:- Visa Status:- Rate Per Hour:- Employer Details (Name, Email, Phone):- We need two client references from two different clients for all the submissions: Reference #1 Name E-mail contact Phone No Client Name Relationship Reference #2 Name E-mail contact Phone No Client Name Relationship Please respond back with updated resume so that I can proceed with submission with your resume Thanks & Regards, Edwards John Optimal Business Group, Inc 11813 Macon street Beltsville, MD 20705 Work  ...View Job Details

Dear Consultant, I am trying to reach you regarding an opportunity copied below. Please revert back to me if you are available & interested in below opportunity with word version of your resume, best time & number to contact you. Please feel free to contact me to discuss more about this opportunity. Just In case if you are not available and interested then please send me a copy of your resume along with your availability. May be in future we can get in touch To know more about us, please visit Job Title Data Architect Experience Level 8+ years Location Phoenix, AZ Start Date Immediate Duration Long Term Job Description • Performs structured data requirements analysis and data modeling in support of application development for relational and reporting databases. Supports the development of Enterprise Data Architectures. Uses proven methodologies for analyzing and presenting data. Responsible for managing metadata quality and integrity across platform and enterprise models, as appropriate • Experience working independently as an Application Data Modeler, Business Analyst and/or business partner where the majority of time was spent analyzing business data requirements. • Understanding of the full development project lifecycle and a project lifecycle methodology • Responsible for data architecture deliverables; may be involved in various phases of the development life cycle. • Defines and maintains data architectures, data standards, and guidelines About Systel - Systel Inc. is one of the leading providers of Information Technology Services with offices distributed globally. Systel has combined group strength of 300+ strong resource base deployed in Fortune 500 companies across the globe for more than a decade in ERP, BI, IMS, Web and Content Management technologies. SYSTEL INC. IS AN EQUAL OPPORTUNITY EMPLOYER. Thanks & Regards Mallik Resourcing Specialist Systel Inc. Phone Toll Free: 1-888-8SYSTEL Fax E Mail:  ...View Job Details

Job Title : SAS Analyst Relevant Experience (Yrs) : 4 yrs – 6 yrs Technical/Functional Skills : SAS Data Mining, SAS Enterprise Guide, P&C Insurance Domain, Modeling Concepts, Data Analytics, Microsoft Excel, Visual Basic (Macros) Experience Required : - Minimum of 4 yrs of experience in Data Mining, Report Generation, Data Analytics - Experience in working on P&C Insurance Data Roles & Responsibilities : - Generate Reports for Product Management - Suggest and Implement changes to improve the Report generation process - Perform Analytics - Contribute to long term strategic initiatives, provide inputs for improving the report generation projects - Develop proof of concepts to judge the ease of best suitable solution - Work with Project Management for developing project plan, resource allocation, monitoring and reporting the progress - Co-ordinate work packages with different team members at onsite and offshore Generic Managerial Skills : Task Planning and Scheduling Status reporting. Education : Masters (Preferred) Work Location : San Antonio, Texas ...View Job Details

Must be within driving distance for face-to-face interviews The Technical Lead role is focused on platform specific systems development activities. They are responsible for supporting the definition and ensuring adherence to platform specific reference architectures. They develop, review and approve all technical designs and participate in architecture related discussion for the platform. The Technical Lead may assist in the development activities for complex maintenance items and/or projects. Mentoring new and existing team members on architectural standards will be high priority for Technical Leads. They may analyze and assist in the design of databases within an application area. In addition, Technical Leads must be able to utilize their skills across development groups to independently apply general IS process enhancements and system implementations. It is expected that they will be the technical thought leaders on application strategy for their particular platforms, while driving and executing best in class development practices. Data Warehousing Expert within 6 Months 6 + Years SQL Server within 2 Years 1 - 2 Years Informatica PowerCenter within 6 Months 4 - 6 Years Systems Analysis & Design within 6 Months 4 - 6 Years ...View Job Details

Data Modeler Duration : 3 month(s) Location : Merrillville, IN Skill & Job Description Data Modeler We are looking for someone with data modeler experience working in a data warehouse for a utilities client. They will need to have experience working for a gas company as a data modeler. ...View Job Details

Informatica Administrator with Informatica v9 upgrade experience. We are running 4 VM instances on Red Hat Linux. We need a season resource to be able to do the configuration, set-up, and initial administration of the v9 environments, then do a hand-off to the staff Informatica admins. We also need this person to set-up and configure the High Availability Grid Option. The environments that need to be upgraded are Dev, Test, Performance, Production, VM Sandbox, and D.R. Location : Western MA ...View Job Details

Description : I have an urgent need for a senior-level Informatica Administrator with Informatica v9 upgrade experience. We are running 4 VM instances on Red Hat Linux. We need a season resource to be able to do the configuration, set-up, and initial administration of the v9 environments, then do a hand-off to the staff Informatica admins. We also need this person to set-up and configure the High Availability Grid Option. The environments that need to be upgraded are Dev, Test, Performance, Production, VM Sandbox, and D.R. ...View Job Details

First Lead position: The Technical Lead role is focused on platform specific systems development activities. They are responsible for supporting the definition and ensuring adherence to platform specific reference architectures. They develop, review and approve all technical designs and participate in architecture related discussion for the platform. The Technical Lead may assist in the development activities for complex maintenance items and/or projects. Mentoring new and existing team members on architectural standards will be high priority for Technical Leads. They may analyze and assist in the design of databases within an application area. In addition, Technical Leads must be able to utilize their skills across development groups to independently apply general IS process enhancements and system implementations. It is expected that they will be the technical thought leaders on application strategy for their particular platforms, while driving and executing best in class development practices. Database Platforms Data Warehousing Yes 1 Expert Within 1 Year 4 - 6 Years Database Platforms SQL Server No 3 Intermediate Within 2 Years < 1 Year Miscellaneous Informatica PowerCenter Yes 1 Expert Within 6 Months 4 - 6 Years Miscellaneous Systems Analysis & Design Skills Yes 1 Expert Within 2 Years 2 - 4 Years Second lead position: Database Platforms Data Warehousing Yes 1 Expert Within 6 Months 6 + Years Database Platforms SQL Server No 3 Intermediate Within 2 Years 1 - 2 Years Miscellaneous Informatica PowerCenter Yes 1 Expert Within 6 Months 4 - 6 Years Miscellaneous Systems Analysis & Design Skills Yes 1 Expert Within 6 Months 4 - 6 Years ...View Job Details

Data Analyst w/ Informatica ETL,SQL and Some Billing system Exp as client is migrating from one billing system to another Multiple Spots Available,,,Should be able to start from Next Week... 6 Months+ Charlotte NC ...View Job Details

Title: Sr. INFORMATICA Developer Duration: 6 months Location: Alameda, CA Start: ASAP Work Experience and Requirements: • Minimum 5 years experience with INFORMATICA • Extensive experience with Oracle Database • Must have Experience with database architecture and Informatica administration People skills: Must be flexible, open to suggestions, self-motivated, eager to learn and goal oriented Must be comfortable dealing with ambiguity and uncertainties Strong communication and analytical skills Strong interpersonal skills and team player ...View Job Details

Job Requirement: • Data Profiler will leverage specialized software tools to explore and analyze various characteristics of very large data sets to identify patterns, dependencies, and data quality issues that are meaningful to the successful execution of the data conversion and MDM project. • Various statistics will be calculated and data relationships mapped, reported upon, and visually presented. • Relevant insight and conclusions will be drawn from the analysis and appropriate recommendations will be made to the conversion project team. • IBM Information Analyzer software experience is a must have skill. • The Data Profiler will have extensive experience working with, manipulating, understanding, deriving knowledge from, and visually representing complex data sets. • Strong data quality and data analysis background is expected. Interview Process: Telephonic followed by In-Person!!! About Amtex Systems Inc Amtex Systems Inc is a leading information technology (IT) consulting and solutions leader with Hundreds of satisfied clients nationwide. We offer the successful candidate the opportunity to work for our clients in either full-time or Contract positions. We pride ourselves in our strong commitment to client satisfaction, and our focus on helping our employees find their next job. Please Visit us on the web at Looking forward to hear from you very soon as this is an urgent requirement. ...View Job Details

Hi, We have this following position, Please send me your resume immediately. Job Title Data Architect Location Phoenix, AZ Start Date Immediate Duration 6 + months Rate DOE Job Description:- Must Have Skills: Performs structured data requirements analysis and data modeling in support of application development for relational and reporting databases. Supports the development of Enterprise Data Architectures. Uses proven methodologies for analyzing and presenting data. Responsible for managing metadata quality and integrity across platform and enterprise models, as appropriate • Experience working independently as an Application Data Modeler, Business Analyst and/or business partner where the majority of time was spent analyzing business data requirements. • Understanding of the full development project lifecycle and a project lifecycle methodology • Responsible for data architecture deliverables; may be involved in various phases of the development life cycle. • Defines and maintains data architectures, data standards, and guidelines Jeet Singh Next Level Business Services, Inc. Phone: | Fax: Email: | Web:  ...View Job Details

Technical consultant to help with performance tuning an implemented operational data store and data warehouse integrated with an ERP. This position is responsible for analyzing, troubleshooting and implementing performance improvements to an operational data store and data warehouse deployed on Oracle database base and application server technologies. Consultant must be able to identify performance challenges associated with reporting queries in Oracle, Cognos processing, and/or ETL processes, recommend remediation approach(es), and as required execute the accepted remediation activity. The successful candidate will have experience in being a database administrator with experience in Cognos, Oracle RDBMS, Oracle PL/SQL, Oracle Virtual Private Database and Oracle Warehouse Builder who would have developed, implemented and performance tuned complex data warehouses and data stores built on Oracle technology. Required skills: 10+ years of database and data warehousing experience in a complex IT environment. Ability to work with the undefined and unexpected in client-facing situations Knowledge of "best practices" for operational data store and enterprise data warehouse performance testing and tuning Ability to work independently, manage expectations and provide effective issue resolution May sometimes work as an independent contributor, and sometimes leading a team of a few consultants Oracle RDBMS, Oracle Warehouse Builder, and PL/SQL experience Cognos query and application server tuning experience Database administration Oracle Virtual Private Database performance tuning Troubleshooting and performance tuning large, complex ETLs Collaboration with diverse people, processes and technology Strong verbal and written communication Comfortable presenting Attention to detail Proven ability to plan and execute projects on time and within budget ...View Job Details

THIS IS A FULL TIME PERMANENT POSITION AT TX Job Title : SAS Analyst Relevant Experience (Yrs) : 4 yrs – 6 yrs Technical/Functional Skills : SAS Data Mining, SAS Enterprise Guide, P&C Insurance Domain, Modeling Concepts, Data Analytics, Microsoft Excel, Visual Basic (Macros) Experience Required : - Minimum of 4 yrs of experience in Data Mining, Report Generation, Data Analytics - Experience in working on P&C Insurance Data Roles & Responsibilities : - Generate Reports for Product Management - Suggest and Implement changes to improve the Report generation process - Perform Analytics - Contribute to long term strategic initiatives, provide inputs for improving the report generation projects - Develop proof of concepts to judge the ease of best suitable solution - Work with Project Management for developing project plan, resource allocation, monitoring and reporting the progress - Co-ordinate work packages with different team members at onsite and offshore Generic Managerial Skills : Task Planning and Scheduling Status reporting. Education : Masters (Preferred) Work Location : San Antonio, Texas Salary: $60 - 65K Thanks Raj  ...View Job Details

We are looking for a Sr. Ab Initio Developer with below mentioned skills. Skills Required: -Excellent hands-on exposure to Ab Initio ETL -AbInitio Implementation, Abinitio design. -Experience creating ETL specifications and mapping documents -Proficiency in Oracle SQL, PL/SQL & Unix scripting -Excellent understanding of DWH concepts -Designing the graphs -Good communication Skills. Location: Jersey City/Warren - NJ ...View Job Details

Hi , This is an excellent opportunity to join an innovative and growing enterprise. Take your career to the next level and turn your interest into action by send your updated Word copy of resume and best number to reach by during the day. Senior Data Modeler Location : Columbus, OH Duration : 6-12 Months REQUIREMENTS: Senior Data Warehouse Data Modeler for and extended consulting. You’ll need strong 3NF and Dimensional Data Modeling expertise and be skilled in designing/building effective Data Warehouse/Business Intelligence solutions Experience with the design of large scale ETL solutions integrating multiple source systems, must have experience with Unstructured Data. Exposure to ETL tools such as Informatica / PowerCenter, PowerExchange CDC, PowerConnect for Web Services. Familiarity with Layered Data Architecture concepts Solid understanding of IBM DB2 V9.5 Infosphere DW/BI features. Must have experience in understanding dimensional data model key structures to achieve optimal performance. Strong facilitation skills to engage subject matter experts to define Data/Analytical requirements and conduct data modeling design reviews with cross functional project teams Ability to communicate design solutions to both technical and non-technical audiences Experience in developing data sharing standards and architecting scalable service oriented solutions Must be proficient in using entity relationship modeling tools such as ERWIN Adheres to Data Architecture standards Understand how data is used as a Strategic Asset Experience with large Teradata implementations a plus Experience with MS Analysis Services a plus Experience with Business Objects XI R3 a plus Thanks and Regards. . . Neev Roy , Sr. Technical Recruiter, CAT Technology Inc. Committed to Human Excellence Through IT 377 Route 17 South Hasbrouck Heights, New Jersey Voice x 283 Fax Email 2 : Visit us at  ...View Job Details

Hi , This is an excellent opportunity to join an innovative and growing enterprise. Take your career to the next level and turn your interest into action by send your updated Word copy of resume and best number to reach by during the day. MDM System Analyst Duration: 6-12 months location:San Francisco, CA Requirements: *Collect information to analyze and evaluate existing or proposed systems. *Prepare detailed flow charts and technical diagrams outlining legacy systems capabilities and processes. *Write technical requirements for new systems *Strong technical skills. Ability to look into existing systems to uncover technical requirements. *Experience with performance, security, and non-functional requirements. Thanks and Regards. . . Neev Roy , Sr. Technical Recruiter, CAT Technology Inc. Committed to Human Excellence Through IT 377 Route 17 South Hasbrouck Heights, New Jersey Voice x 283 Fax Email 2 : Visit us at  ...View Job Details

Work Experience and Requirements: · Minimum 5 years experience with INFORMATICA · Extensive experience with Oracle Database · Must have Experience with database architecture and Informatica administration Technology Skills & Knowledge: 1. ER Data modeling and concepts 2. Best practices for common ETL design techniques such as change data capture, key generation and optimization 3. Fluency in SQL 4. Capable of capturing and modeling complex business cases in terms of tables and relationships 5. Capable of converting a relational data model to a dimensional one 6. Knowledge of star and snowflake schemas 7. Capable of designing maps for flexibility and performance 8. Extract, Transform and Load Coding (ETL) 9. Experience with data quality, data profiling, metadata management and reporting 10. Understand database concepts of referential integrity, indexes and keys and table metadata 11. Ability to query source and target databases for unit testing 12. Working knowledge of data modeling is preferred People skills: Must be flexible, open to suggestions, self-motivated, eager to learn and goal oriented Must be comfortable dealing with ambiguity and uncertainties Strong communication and analytical skills Strong interpersonal skills and team player Essential duties and responsibilities include the following: Design and construct large ETL maps, workflows etc.. Integrate new data with existing warehouse structure and continuously improve how the system functions. Design and code the ETL Administration processes, ETL maps to enable initial load and incremental processing, error and exception handling, restart ability and recovery, data cleansing, validation and monitoring Analyze, design, build and support current and new data feeds from various data sources to the data warehouse. Work with the current Data Warehouse data model, extending and improving it for flexibility, performance and accuracy Model and design data marts or Cubes to meet specific department reporting needs Create Entity Relationship models to capture business concepts Create Metadata mapping for technical and process data lineage reporting Work closely with the Cognos Report Analysts, Data Warehouse Administrator, Oracle DBA, Business System Analysts and Project Managers. ...View Job Details

1. 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. 2. Preparing and loading of data from the past three years into the Data Warehouse using the Extract, Transform, and Load (ETL) tools. 3. Setting up and running the current system for data cleansing and matching of these files. This includes configuring the match keys with consultation from the business users and Data Warehouse team. 4. Working to resolve data records that result in exception items that cannot be loaded into the Data Warehouse. 5. Creating and executing “views” to be utilized by the staff 6. Performing database utility functions, such as SQL Server Analytical Services for OLAP , development of stored procedure, DTS, SSIS, etc. as needed for loading and analysis of data. 7. The individual will operate with very limited supervision, within standards and processes established for the Data Warehouse and Client procedures. Client systems include extremely sensitive and confidential information; position requires complete discretion and trustworthiness, as well as knowledge of federal requirements for handling of confidential data. The individual must be customer oriented, and attentive to the needs of Data Warehouse users. Skills required: 1. Experience and expertise in gathering and analyzing business user requirements. 2. Proficiency in Java development. 3. 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. 4. Experience with Windows XP operating system and the Windows 2003/2008 server environment. 5. Experience with Data Warehouse concepts, including the use of Extract, Transform, and Load (ETL) tools and creation of data marts. 5. Ability to communicate clearly and concisely, both orally and in writing. 6. Ability to establish and maintain good working relationships with business users, management, vendors, and peers. 7. Strong organizational, multi-tasking, and time-management skills. Ability to complete assignments on time. 8. Understanding of deployment methodology concepts including design, build, testing, and deployment. Please visit . ...View Job Details

Logical and physical model ETL and data warehousing Location : Austin TX Fulltime Permanent position ...View Job Details

Data analyst 5 months Minneapolis, MN Required: 1. 5+ years SQL experience, preferably in multiple flavors (e.g. DB2, Oracle, MS Access) 2. 5+ years SAS experience 3. 5+ years DB2 experience (import/Export, building tables, joining tables, pass-through SQL & working with large datasets) 4. Knowledge of database concepts, e.g. ETL, reading data models, writing and tuning SQL queries, Indexes 5. Excellent problem solving and analytical skills to enable working with specialized technology teams on root cause analyses of failures Preferred 1. Search Engine Optimization (SEO) experience 2. Skill in Search Engine Data, text/data mining, categorization, taxonomies ...View Job Details

We need an Informatica expert who had used Informatica on AIX and has some background on IBM Smart Analytics System • Expert in Informatica • Should have strong background in ETL mapping • Should have worked on Informatica on DB2 database in AIX environment • Should have ETL experience in Partition DB2 • Should be very familiar with AIX platform ...View Job Details

Need Informatica Administrator Location: Charlotte, NC Position: Permanent Required Skills: Informatica Administration, RDBMS, Repository Management Should have extensive experience in Informatica Servers Administrations. Should have good idea of managing Informatica Power Center, Informatica Metadata Manager and Informatica Data Quality repository. Additional experience with Database administration will be preferred. ...View Job Details

Hi, Informatica Consultants in Raleigh-Durham, NC. Start is ASAP and will last for 5+ MONTHS. need solid communication skills...will also check references ...... $43.00/hr max According to the client, here is what they are looking for: 1. Parameter files 2. Aggregate Transformation 3. Source Qualifier The required skill set includes: - Informatica (more in a process mode than batch mode) - Oracle 8.x - PL/SQL - Unix / HP shell scripting - Dimensional data modeling - Source data analysis - ETL design (src-tgt mapping, workflow) - Sarbanes Oxley (Sarbox) knowledge - Shows initiative / an ability to attack problems on their own - Must have solid communication skills ...View Job Details

The following application tasks are expected to be executed by the Data Warehouse systems/application analyst ETL specialist. 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. • Preparing and loading of data from the past three extract years of the IRS Business Master File (BMF) and Business Returns Transaction File (BRTF) into the Data Warehouse using the Extract, Transform, and Load (ETL) tools. • Setting up and running the Discover Tax Associate and Grow (A&G) offline process for data cleansing and matching of these files. This includes configuring the A&G match keys with consultation from the business users and SCDOR Data Warehouse team. • Working to resolve BMF/BRTF records that result in Research queue items that cannot be loaded into the Data Warehouse. • Creating and executing “views” to be utilized by the Discover Tax audit selection process. • Performing database utility functions, such as SQL Server Analytical Services for OLAP , development of stored procedure, DTS, SSIS, etc. as needed for loading and analysis of data. ...View Job Details

We are looking for Informatica Administrator Consultants with our client. This is a fast moving requirement and we can arrange interview within 24 hrs of submittal Job Title : Informatica Administrator Work Location : Charlotte, NC Salary : $75K Relevant Experience (Yrs) : 3-4 Yrs Technical/Functional Skills : Informatica Administration , RDBMS, Repository Management Experience Required : 7-10 Years Roles & Responsibilities : Should have extensive experience in Informatica Servers Administrations. Should have good idea of managing Informatica Power Center, Informatica Metadata Manager and Informatica Data Quality repository. Additional experience with Database administration will be preferred. Generic Managerial Skills : N/A Education : Bachelor of Engineering We have good hold on the client and this is a fats moving requirement. If you are interested then send your resume to tusharp at abiscos dot com We can arrange the interview in 24hours for the right profile. ...View Job Details

osition: SAS HCM ADMIN Location: Thousand Oaks, CA Duration: 3 months CTH or Permanent/Fulltime Skills: Expert SAS Production support ADMIN with more than 5 years of experience in Large Datawarehouse environments. Handson Production support environment. Expert in Data analyses and Data recovery. Good communication skills and handson Production experience. ...View Job Details

ETL Developer with VB, VBA, SAS Work Location: Delaware Duration: 6+ Months ETL Developer with VB, VBA, SAS: • Informatica experience. • A high level of knowledge and experience with MS-Access is required. • Strong formal training in Relational Database Design and Normalization. • Strong Sql Server SSIS experience. • A high level of knowledge and experience with Microsoft Access Sql, Sql Server 2008, T-Sql, Stored Procedures/Triggers. • Extensive experience with VB6 and VBA. • Extensive experience with Web applications, ASP, HTML, and Javascript. • Experienced in full software development life cycle planning, requirements analysis, architecture, and programming. • Experience with SAS programming. • A high level of knowledge of the insurance and/or financial business. • Must be proficient with the Microsoft Office Suite of applications and possess the capability of producing professional-looking documentation, flowcharts, and proposals. • Microsoft Certified Professional in Sql Server database design and implementation is preferred. • Minimum 7 years in IT/MIS with a minimum of 5 years of database design and implementation will be accepted. ...View Job Details

Location: Baltimore, MD (locals preferred, F-2-F Interview req) Duration: 10 months +++ Rate: Best Data Analyst Skills: • Must have 8+ years of experience as a Data Analyst • This is for a Billing Data Conversion project. • Must have data conversion and data quality experience with either Oracle or SQL Server. • They will be involved with data cleansing and conversion activities, and work closely with the data analysts on the project. • Must have excellent communication (oral and written) skills ...View Job Details

Title: Informatica / Composite (BC) Start Date: 08/31/2010 Bill Rate: # of Openings: 1 Position Type: Contract Locations: New York, NY Description: Department Overview About Brokerage Firm Capital Brokerage Firm Capital is the investment banking division of Brokerage Firm. With a distinctive business model, Brokerage Firm Capital provides large corporate, government and institutional clients with a full spectrum of solutions to their strategic advisory, financing and risk management needs. Brokerage Firm Capital has offices around the world, employs over 23,000 people and has the global reach, advisory services and distribution power to meet the needs of issuers and investors worldwide. Main Function Global Technology IT provides support to the firm’s platforms and infrastructure in all regions of the world on a 24/7 basis. Our ability to maintain stability in volatile markets and during heavy load conditions is critical to the smooth functioning of the firm’s activities. Proactive testing and root cause analysis continuously improves our technology platforms and reflects in the bottom line of the business. The global presence often necessitates extended work hours throughout the week and occasionally on weekends. In addition to primary functions, team members also take on a role of 2nd level engineering support in an event a production issue requires escalation. Team members never hesitate to take ownership of problems and remain responsible for their systems and actions in a shared environment of commitment and excellent service. The Brokerage Firm Capital Middleware team consists of Communication and Integration Middleware disciplines in London, New York and Singapore regions. This position consists of working within the Integration Middleware Team, delivering expert services on the data integration technologies using Informatica and Composite. The role covers all aspects of the service delivery including: Middleware consultancyDevelop proof-of-concept projects to demonstrate the product to internal customers, do performance tuning to ensure acceptable levels of application performance. Conduct reviews of Informatica code and provide constructive feedback to development teams. Project requirements analysisInterpretation and understanding of functional specifications. Good understanding of functionality and standard functions. Ability to assist designers with integration of IBM Websphere MQ and TIBCO EMS into technical designs. Unit/Systems Testing and DocumentationAssist in preparation of unit tests for Informatica projects and services. Execution of unit test cases and documentation of results. Providing support during QA and UAT test phases. Vendor ManagementWork directly with the vendor in those instances where resolution to development issues or bugs can’t be reached internally. Evaluate new products and manage releases internally. DR invocation/testingAssist with DR testing in post-development prior to application going live. Main Duties This position consists of providing Integration Middleware Engineering services to Brokerage Firm Capital with a focus on development with Data Integration technologies using Informatica and Composite. This position requires ability to manage a team, analyze project requirements and to perform development and implementation tasks using the shared Informatica and Composite farms. Additional responsibilities include technology and skills transfer within the team and throughout the development community and an ability to troubleshoot Data Integration and Federation related problems. Primary technologies that require expert level proficiency: · Informatica PowerCenter 8.x, batch and real-time · Informatica Data Quality, B2B Data Transformation, Data Explorer · Informatica Metadata · Linux/UNIX operating systems, including: command line operations, shell scripting, fault analysis, etc. · RDBMS and SQL, very comfortable with database theory, engineering and SQL and PL/SQL Other Technologies include: · Composite Integration Server · Microsoft SSIS · Java J2SE/J2EE, JDBC, Eclipse IDE, etc. · XML/XSLT/XQuery · Communication Middleware – IBM MQ, Tibco EMS Technologies where proficiency is desired: XML/XSD/XSLT Web Services (SOA) Well familiar with Linux, Windows and Solaris operating systems. Level of workable expertise with LDAP/AD implementations. Resource must have hands on experience in support of medium to high complexity Informatica shared farm deployments or similar technology. He or she should have good grasp of enterprise level technology concepts like fault-tolerance, DR and horizontal vs. vertical scalability. Resource has to be goal-oriented, ready and willing to learn new technologies and master them on the job. Ability to effectively communicate with his peers, clients and superiors is absolutely essential to his duties as is ability to build and maintain quality professional relationships within the Firm. He/she must be willing and able to work during non-business hours, including weekends, for various reasons to accommodate business sensitive service consumers. Person Requirements Qualifications /Education:Degree Educated with a Computer Science Background Degree Educated with a Scientific Background with IT experience in a financial environment ...View Job Details

Technical Skills/Requirements: Erwin Model Mart version 7 Data Modeling for Oracle databases Source data analysis Data profiling Create mappings of source to target data Physical and logical data modeling Erwin data modeling Oracle database design Teradata database design ...View Job Details

Senior Oracle Data Architect Position • 5+ years experience Oracle Database Architecture/Administration • 3+ years of data modeling and application database design experience • 1+ years experience with ERwin ERD tool to model, generate scripts and compare models with physical databases ...View Job Details

Description: . About 8 years of IT Experience . Must have at least 5 + years of Informatica experience . Must have strong skills in SQL / PLSQL . Must be local to bay area as there will be in person interview for this position . Must be able to start immediately . Excellent communication skills. Thanks & Regards Jay Brar Technical Recruiter Symphony Enterprises LLC Email : (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

SCOPE OF PROJECT Background and Summary: The South Carolina Department of Revenue (SCDOR) has implemented a Data Warehouse and related software components for purposes of tax and revenue compliance and analysis. The Data Warehouse also serves as a primary data source for other business intelligence activities. This work involves proprietary software from Revenue Solutions Inc. (RSI), particularly their DiscoverTax (DTAX) and TaxMaster products, and other third party tools. Primary inputs to the Data Warehouse are the state extract files provided to states by the IRS. To date, the Data Warehouse implementation has utilized the IRS files relating to Individual Income Tax, but has not utilized the files relating to Business taxes. At this time an experienced ETL (Extract, Translate, and Load) specialist is needed to load three years’ worth of IRS Business Master Files and Business Return Transaction Files into the Data Warehouse to prepare for analysis and compliance programs. Specific Duties and Responsibilities: The following application tasks are expected to be executed by the Data Warehouse systems/application analyst ETL specialist. 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. • Preparing and loading of data from the past three extract years of the IRS Business Master File (BMF) and Business Returns Transaction File (BRTF) into the Data Warehouse using the Extract, Transform, and Load (ETL) tools. • Setting up and running the DiscoverTax Associate and Grow (A&G) offline process for data cleansing and matching of these files. This includes configuring the A&G match keys with consultation from the business users and SCDOR Data Warehouse team. • Working to resolve BMF/BRTF records that result in Research queue items that cannot be loaded into the Data Warehouse. • Creating and executing “views” to be utilized by the DiscoverTax audit selection process. • Performing database utility functions, such as SQL Server Analytical Services for OLAP , development of stored procedure, DTS, SSIS, etc. as needed for loading and analysis of data. SKILLS REQUIRED: The successful candidate will have, at minimum, the following skills: • 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, as well as knowledge of federal requirements for handling of confidential data. The individual must be customer oriented, and attentive to the needs of Data Warehouse users. ...View Job Details

Sr. Software Developer - SAS Enterprise Data Integration Studio Washington, DC 12 months Contract Requirements: 5+ years experience using SAS Enterprise Data Integration Studio and DataFlux dfPower Studio. ...View Job Details

Informatica developer with SFDC Skills Required: Informatica SFDC extracts using Informatica ...View Job Details

Please send qualified consultants at Job Title Very Senior Informatica Consultant LOCATION Rockville, MD Duration Very Long Term Rate Competitive Required skills: Need a very Senior Informatica Consultant. The clients wants someone with over 8 years of PowerCenter experience and then the following skills 1) Data Modeling 2) Oracle (PL/SQL) 3) Unix (Sun Solaris) They need someone very senior (Over 10 years of total IT experience and someone that has led small teams of 2-4 people) This is a contract opening that will go past 2011 and maybe even well into 2012. Manager is reviewing resumes tomorrow morning, so we would to have them submitted before end of today, or they will be part of the second round which will be next week. INTERVIEW PROCESS : The interview schedule is a phone screen first and then a face to face. The phone screen is technical and last 30 minutes, the face to face is more comprehensive, but technical in nature (scenario based questions) that last about 1 hour and 15 minutes. Consultant should be available to work onsite long hours. (Average 50-55 hours a week). Some weekends and evenings as well. We do bill for every hours they work. Please send qualified consultants with resume,contact nos.,email id,current location & rates. Prefer Email Over Phone Regards, Deep Pande  ...View Job Details

Datawarehouse Developer Pay $35/hr (Rates are Flexible for a right match) Client: Catalina Marketing Corp Loc: Saint Petersburg, FL * Start Date: 9/3/2010 * End Date: 9/2/2011 Job Description: Data Warehouse Developer The Data Warehouse Developer is responsible for design, development and support of applications which load data into the Netezza DBMS platform. Core programming capabilities include C, UNIX Shell and SQL languages. The primary developer focus is application enhancements and ongoing process improvement to meet customer needs and minimize operational maintenance of the programs. ADDITIONAL RESPONSIBILITIES: • Provide Database Administration for DBMSs under the domain of Database Architecture to support enterprise-wide initiatives. • Perform development tasks including: - software installation and configuration - documentation - on-call support to ensure database availability - software patches and upgrades - automate manual tasks - performance tuning • Coordinate with DBAs, Developers, System Administrators and other customers • Investigate new technologies that would supplement the ETL environment EDUCATION: Bachelors’ degree or equivalent experience EXPERIENCE: • 3+ years experience in hardware and software management • Database background required (minimum 3 years) • Experience with the software development lifecycle including: requirements gathering, design, coding, testing and production support • Application Development experience SPECIAL SKILLS: • Strong understanding of relational database technology • Experience with the software development lifecycle including: requirements gathering, design, coding, testing and production support. • Good understanding of SQL in accessing and manipulating data • General understanding of system architecture. • Understanding of general programming concepts • Basic analytical and problem solving skills • AutoSys Job Scheduling • SyncSort for unix • ‘C’ Programming • Unix shell scripting ...View Job Details

Experience: 5+ years design and development experience in data warehousing. 3 to 5 years of experience in data architecture and logical modeling. Strong conceptual, relational and dimensional data modeling skills. Ability to translate business needs into technical solutions. 5+ years overall IT application development implementation experience. Excellent communication skills, both written and verbal. Skills: Data modeling expertise and a thorough understanding of logical modeling concepts. Advanced knowledge dimensional modeling for data marts and warehouses. Knowledge of physical design for large-scale enterprise systems. Knowledge of relational concepts. Knowledge of business rule interpretation and ETL concepts. Knowledge of business reporting and BI tooling concepts. Strong organization and analysis skills. Strong communication skills. Knowledge in Insurance/Finance a plus. Knowledge of ER/Studio, ERwin or similar modeling Responsibilities: Strategically design the information architecture for the data warehouses, data marts, and data stores, while ensuring high levels of data availability Create conceptual, logical and physical data base models for data warehouses/marts. Work closely with report developers and analysts interpreting reporting requirements and collaborating on reporting designs. Coordinate with other technical staff to develop database architectures, ETL standards, and quality assurance policies and processes. Responsible for data acquisition and access analysis and design. Develops process for capturing and maintaining metadata. Coordinates new data development ensuring consistency and integration with existing warehouse structures. Assess and cultivate strategic goals for data warehousing in conjunction with the key stakeholders. ...View Job Details

One of our leading health care client in Sacramento, CA looking for Senior Data warehouse/ETL consultant. Successful candidate will have 7-10 years of experience in Data warehouse, seven years of experience ETL/Informatica design and development and two years of experience in Business Objects and Cognos. Experience with Unix, Oracle or DB2 is required. Client: HP Location: Sacramento, CA Duration: 6-12 Months Rate: $60/hr C2C we get Status: US CITZEN ONLY- No Green Card or EAD or H1b Interview: Phone Interview and they will hire. ...View Job Details

Guaranteed Interview & Immediate Start Length: 6 months w/option for additional time Requirements: 1. Must have 3-5 yrs experience on Informatica v 7.x-8.x --Very experienced, 2. 3 year experience as an Informatica lead 3. Must be able to interface effectively with all levels of the organization. 4. Must have excellent interpersonal skills and be strong and effective communicator. Good writing skills and ability to multi task in the support of this project. Important Note: Telephonic / Face to Face Interview ...View Job Details

Job Title : Informatica Administrator Relevant Experience (Yrs) : 3-4 Yrs Technical/Functional Skills : Informatica Administration , RDBMS, Repository Management Experience Required : 7-10 Years Roles & Responsibilities : Should have extensive experience in Informatica Servers Administrations. Should have good idea of managing Informatica Power Center, Informatica Metadata Manager and Informatica Data Quality repository. Additional experience with Database administration will be preferred. Generic Managerial Skills : N/A Education : Bachelor of Engineering Work Location : Charlotte, NC ...View Job Details

Jersey City, NJ 6-12 months duration phone and face to face Datastage hand-on and architect (not just developer) Strong on data modeling and database design/sql etc Has been responsible for entire DW project – not just development of ETL Qualifications: 7 to 10 years of experience as a data warehouse developer and architect Expert level knowledge of Data Stage and database modeling. Proficient in writing and tuning SQL for DB2 UDB. Past experience in leading DW projects (development as well as on-going maintenance work) Ability to lead discussions and see them through completion critical. Reacts to project adjustments and alterations promptly and efficiently Must be a self-starter, a team player Strong attention to quality and detail Strong interpersonal skills Preferred: Experience with Cognos or any other reporting tool Experience with mainframes is a plus Understanding of IBM’s IIW data model is a plus Thanks & Regards Rachel S Amtex Systems Inc, . ...View Job Details

Client is Medco in Wyckoff, NJ. Long term project: the duration is 1 - 3 years. Start date asap InfoSphere MDM Administrator This position is for a System Administrator with InfoSphere Master Data Management (MDM) server 9.0.1 support experience. Hands-on support and trouble shooting during business hours, on call occasionally. Expected to contribute to establishing best practices. Must have: InfoSphere MDM server 9.0.1 support experience AIX hands-on experience DB2 UDB DataStage Tier 2 production support experience Websphere clusters Nice to have: Ab Initio Data Power XML engine Pega HP OpenView or other monitoring experience AIX high availability (HA) experience ...View Job Details

Successful candidate will have 7-10 years of experience in Data warehouse, seven years of experience ETL/Informatica design and development and two years of experience in Business Objects and Cognos. Experience with Unix, Oracle or DB2 is required. Location: Sacramento, CA Duration: 6-12 Months Status: US CITZEN ONLY- No Green Card or EAD or H1b Interview: Phone Interview and they will hire. ...View Job Details