Hi All,
Below is the list of open jobs for the day, *Please respond only to tmar...@idexcel.com <tmar...@idexcel.com>* *We cannot consider H1B, looking for US Citizens on GC* *Candidate cannot be out of US for last 5 years for more than 6 months to obtain clearance* *All are public trust clearance jobs* 1. Data Warehouse Informatica Developer with Teradata Experience 2. Oracle Consultant 3. Sr PL/SQL Developer 4. Database administrator- 5. C# Developer 6. Business Objects Developer 7. Sr. Java Developer 8. Senior level PL/SQL developer Senior level PL/SQL developer Indianapolis IN USA 46249 10 Months contract **Candidate MUST be a US Citizen** Public Trust This requisition is for a senior level PL/SQL developer with stored procedure expertise. Candidate requires a strong background working with complex PL/SQL and stored procedures. Leads and coordinates the design, development, implementation and support of business and/or technical information technology solutions of multiple client systems into a Continuous Controls Monitoring. Position requires strong technical and functional background in order to analyze and summarize data in relationship to particular business processes. Candidate will need to: • Understand business processes, such as Procure to Pay, Order to Cast, General Ledger, Purchase Card, Time and Expense, Human Resources and Inventory control, as realized in ERP systems down to the table level. • Build data models which represent the business process to be analyzed. • Work with data from multiple legacy systems • Build formal data transformations or mappings of ERP system tables and formal business rules/compliance checks within a Continuous Controls Monitoring system language. • Implement, debug, and validate performance of source-to-target data transformations and business rules. • Work with multiple business intelligence packages to build reports and dashboards. • Support customer support efforts, including periodic interaction with the customer. Job Title : Sr. Java Developer Job Location : St. Louis MO Job Type : 12 Months contract Required Skills: · 5+ years advanced computer programming skills in Java, Java Servlet, Javabean, EJB, OO Design, HTML. · Advanced working skills in programming with SQL or Oracle. · Experience writing JUnit test-cases and building test-suites. · 5+ years of experience in systems analysis and working closely with business customer · Significant working knowledge with the RAD/Eclipse/WebSphere · Familiarity with J2EE technology, such as JNDI, JMS, RMI, JNDI, XML, XSL, XSL-FO and JDBC · Experience with code versioning and change management concepts · Experience with full life-cycle software applications development (i.e., design, construction, testing, and implementation) · Experience with requirements definition and specifications design · Experience analyzing functional requirements in Sprints to write component detailed design technical documents. · Able to design and build systems that are integrated with other client systems · Demonstrates an expert level of proficiency in the use of computer languages and utilities necessary to support application development Preferred Skills: · Able to perform the complete system life cycle using the Agile Scrum Methodology phases from project initiation, analysis and requirements, design, coding, testing and implementation · Able to adhere to client development standards and SOX compliance · Ability to communicate to a wide variety of audiences, both business and technical · Proven ability to develop and maintain system documentation · Ability to work independently with minimal direction · Bachelor’s degree or equivalent --- Business Objects Developer with Teradata Experience Must be a US citizen, level of trust security clearance will be required to be obtained. Candidate must be on site in Rancho Cordova, CA or Pontiac, MI 12 Months contract Business Objects developer with BO Administrator experience that will work as part of the team that will migrate an existing data warehouse from z/OS DB2 environment to a Teradata database. This initial support is to convert all Deski reports to Webi and complete the planning component for the preparation of the BO upgrade and overall migration. The overall project will incorporate the configuration for the following applications. o Informatica PowerCenter – Extract-Transform-Load (ETL) tool o Business Objects XI – Data Access Reporting tool o Dundas Dashboard – Dashboard tool o SAS – Advanced Analytics tool o Teradata database Key Responsibilities This role will be the lead developer for the overall migration efforts including the following: • Identify, track and convert scheduled reports - Deski to Webi report conversion • Create and/or update source to target specifications and other documentation as part of the design and development process. • Designs, prepares and executes unit test cases to ensure programs and systems meet business and technical requirements. • Overall installation, configuration and set-up of the Business Objects 4.1 including identifying and validating hardware specification. • Engages and collaborates with the DBA teams to improve query performance. • Mentors and educates colleagues with respect to BO Universe and report design and implementation practices • Communicate and coordinate with multiple vendors, team and client about project status including issues, risks and milestone dates. • Follow defined standards, processes and procedures used on the account. • Work independently to troubleshoot technical and data issues. • Manage multiple tasks and ensure deadlines are met. • May support production support activities Qualifications Experience • Bachelor’s degree or equivalent experience and a minimum of 12 years of related experience. 7 or more years of Business Objects or Data Access tool experience -BO upgrade to 4.1 a plus • 5+ years of experience with SQL, PL/SQL, and Teradata Stored Procedural Language (SPL) • 2+ years of experience with Teradata Data Warehouse Architecture • Knowledge of data warehousing, data governance processes, data quality processes, testing methodologies, reporting tools, application development • Multi-platform and multi-system integration experience. • Demonstrated record of success with problem-solving skills, creativity, and the ability to manage multiple priorities • Experience with the full project lifecycle from conception to implementation and support • Must be U.S. citizen and will be required to complete a background check and pass a National Agency Check – Level of Trust Desired Experience • Experience with mainframe z/OS (JCL, COBOL, etc) and DB2 is highly desired. • Proficiency with metadata, data modeling and data quality tools an asset. • Working knowledge of Information Management, Business Intelligence, Health Care Analytics a plus. • Experience migrating DB2 mainframe database/data to Teradata database a plus. • Ability to analyze business cases, extract requirements and understand business needs -------- C# Developer- HPJP00059902 St. Louis City, Missouri Contract position Description The client seeks a C# .NET Application Developer with strong business acumen to support a complex application for our client in St. Louis, MO. Local candidates preferred for interview. Required Skills: A minimum of 5+ years developing in C# .Net Advanced computer programming skills in C# Advanced computer programming skills in Microsoft.Net Experience with XML Experience with XSLT Experience with Web services Experience with Object Oriented Programming techniques Preferred Skills: Experience developing/supporting accounting systems would be helpful Experience with code versioning and change management concepts Experience with full Agile life-cycle software applications development (i.e., design, construction, testing, and implementation) Demonstrated ability to lead others and manage multiple assignments simultaneously ------------ Database administrator- HPJP00059903 St.Louis, MO. Contract position Description: The client seeks a Database Administrator with experience to support more than 200 applications using widely diverse platforms/infrastructure at their facility in St.Louis, MO. Required Qualifications: · DB2 Database experience · Mainframe experience · Database Definition Language (DDL) · Be able to create tables and indexes. · Be able to lookup indexes, stored procedures and triggers for a specific table. · Structured Query Language (SQL) · Be able write complex queries to extract data from DB2 database · Design indexes for existing applications, choosing when to add or remove indexes · Help developers improve the performance of that query by tweaking it or modifying indexes · Advise developers on the most efficient database designs (tables, data types, stored procedures, functions, etc.) · Ensure that new database code meets company standards for readability, reliability, and performance · Physical and logical data modeling · Database normalization and de-normalization · Monitoring databases for reliability and performance · JCL · Preferred Qualifications: · Proven ability to develop and maintain documentation · Bachelor's Degree in Computer Science, MIS, Engineering or related field · Ability to work independently with minimal direction · Ability to communicate to a wide variety of audiences, both business and technical --------------- Job Title: Sr PL/SQL Developer - HPJP00060115 Job Duration: 6 Months CTH Job Location: San Mateo CA Public Trust or Secret Clearance The client seeks an advanced PL-SQL developer with Oracle experience for our client located in San Mateo, CA. Job Details: · 5+ years advanced computer programming skills in PL/SQL. · Advance working skills in programming with ANSI SQL for Oracle Database. · Able to coordinate the creation Technical Requirement Documents (TRD), Rough Order of Magnitude (ROM), Requirement Traceability Metric (RTM) · Must have experience with relational database theory and data modeling and should be experienced with Oracle. · Must have a solid knowledge of database internals, data structures, and tuning strategies. · Experience in working with large amounts of data, solid working experience with large transactions. · Experience in tuning database packages, stored procedures as part of fine-tuning the application. · Knowledge of Unix Operating System and Utilities · Able to provide debugging and code analysis support · Able to support implementation of application software releases and other related activities · Able to perform knowledge transfer and walkthrough · Able to troubleshoot production problems Preferred Skills: · Able to perform the complete system life cycle using the Agile Scrum Methodology phases from project initiation, analysis and requirements, design, coding, testing and implementation · Able to adhere to client development standards and SOX compliance · Ability to communicate to a wide variety of audiences, both business and technical · Proven ability to develop and maintain system documentation · Ability to work independently with minimal direction · Bachelor’s degree or equivalent --------- Oracle Consultant San Diego, CA US Citizen or Green Card required - Please no H1B candidates 12+ Months Position Details: Manage Break Fix tickets, Work Requests, Enhancement projects. Should possess Good communication and analytical skills Should have created documentations using AIM or OUM methodology for the Oracle E-Business suite modules. Understand customer requirements and advise project team on highly specialized, complex solutions architecture and implementation. Well versed with Projects and Grants module along with GL, AR, P2P. Skills Required: Oracle Application Framework (OAF) Oracle Forms Oracle Reports BI Publisher PL/SQL, Packages, Procedures etc. Oracle Financials suite Optional Skills: Experience with R12.2 version of Oracle EBS. Oracle Workflow Development experience. Experience with large ERP migration/conversion projects. Experience with SQL performance tuning and optimization. Oracle Fusion Middle Ware (FMW) integration. Job Responsibilities: Day to day tasks will require OAF development, PL/SQL, Oracle Forms & Reports Development, BI Publisher reports, Develop and Debug code modules within the EBS framework. Candidate should have strong OAF skills to support existing OAF applications as well as work on new enhancements. Strong Troubleshooting, performance tuning and maintenance of existing Oracle codebase is expected. Job functions will also require the candidate to work on some weekends and evenings to support EBS maintenance activities. Oracle Forms customization, Workflow Builder experience is desired. Candidate will need to be a self-starter, flexible, good communication skills and be able to work well in a team. __________ Data Warehouse Informatica Developer with Teradata Experience Candidate location preferred be on site in Rancho Cordova, CA. Alternative site located in Pontiac, MI 24 Months contract Public Trust or Secret Clearance Must be a US citizen and ability to pass level of trust security clearance Specialist level ETL (Informatica) technical developer will work as part of the team that migrates the Health Care Information Warehouse (IW) data structures from the mainframe to a Teradata V15.10 database. The following HNFS Information Warehouse components will be used: • Informatica PowerCenter V10 – Extract Transform Load (ETL) tool • Business Objects XI 4.x– Data Access Reporting tool • Dundas Dashboard – Dashboard tool • SAS 9.4 (Office analytics, Access Interface to Teradata) • Teradata database V 15.10 • Microsoft SQL Server database Typical Duties: • Create or modify Informatica workflows • Assist development teams to maintain all data sources and data storage options. • Coordinate with application team and develop all ETL processes. • Administer all requests and analyze issues and provide efficient resolution for same. • Design program specifications and perform required tests • Prepare program and system implementation for all Informatica programs. • Evaluate all functional requirements and map documents and perform troubleshoot on development processes. • Collaborate with application groups to prepare effective solutions for all programs. • Documents all technical specifications and associate project deliverables. • Design all test cases to provide support to all systems and perform unit tests. Skills and Qualifications • Bachelor’s degree and 10 or more years of ETL experience with Informatica PowerCenter is required; at least 2 years with version 9.x or 10. • Worked as ETL (Informatica) development on a large scale project for minimum of 5 years. • Strong experience in setup, installation and configuration of ETL (Informatica) tools using Teradata. • Strong experience with SQL and Teradata databases, preferably version 15.10. • Strong UNIX and shell scripting experience is required. • 7+ years of experience with SQL, PL/SQL, and Teradata Stored Procedural Language (SPL). • 3+ years of experience with Teradata Data Warehouse Architecture. • Knowledge of data warehousing, data governance processes, data quality processes, testing methodologies, reporting tools, application development. • Multi-platform and multi-system integration experience. • Demonstrated record of success with problem-solving skills, creativity, and the ability to manage multiple priorities • Experience with mainframe z/OS (JCL, COBOL, etc) and DB2 is highly desired. • Proficiency with metadata, data modeling and data quality tools an asset. • Working knowledge of Information Management, Business Intelligence, Health Care Analytics a plus. • Experience migrating DB2 mainframe database/data to Teradata database a plus. • Ability to analyze business cases, extract requirements and understand business needs.. • Strong analytical, problem solving and communication skills. Thanks & Regards, *Tom Martin | Lead Recruiter* *IDEXCEL Inc*., 459 Herndon Parkway, Suite 11, Herndon, VA-20170. *Direct*: 703.230.2631 | *Fax:* 703.880.7584 *Email:* tmar...@idexcel.com | www.idexcel.com -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at https://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
