Find Jobs | Post Resume | my careerbuilder | Help
Senior IT Tech Lead/ ETL Lead/ Oracle Apps Developer

Job Description

Data Solutions is an IT Firm in Canton, MI.  Currently we have following multiple openings:

1. Senior IT Tech Lead – Canton, MI

  • Gather the requirements, negotiate the scope, approach and timeline with various stakeholders.
  • Estimate cost and budget based on application complexity.
  • Analyze the risks and provide mitigations to the business.
  • Design, develop, enhance and execute loadrunner scripts. Analyze test results and provide recommendations.
  • Provide consulting, mentoring, and training services to customers in areas of software testing.
  • Document Business Process Workflows, Test Plan, Test Strategy, Test Results.
  • Work closely with Production Managers, Technical Managers and Business Managers in planning, scheduling, developing, and executing performance tests.
  • Enhance the Performance Test Plans by incorporating Performance Testing Objectives, Scope, Approach, Environment, Methodology, Issue Tracker, Success Criteria etc.
  • Write LoadRunner Scripts using Web (HTTP/HTML) and Web Services protocols and enhanced scripts with C functions for both web applications and windows applications as well
  • Write Avalanche scripts for DNS and DHCP performance test and configure the tool. Write scripts in QTP, AutoIT to automate data bulking jobs

Require BA in Engineering, related field, or equivalent & 5 yrs recent exp as Performance testing and manual software tester and/or business analyst. Experience in developing technical presentations using PowerPoint & presenting to large audiences. Hands on exp with SDLC, working on Siebel Application, Restful services and Jason requests. Exp/knowledge in utilizing MS Office apps (MS Word, MS Excel, MS PowerPoint).

M-F, 40hrs/wk. Travel to client site may be req on a project basis. Email resume to Data Solutions Inc. at [Click Here to Email Your Resumé].


2. ETL Lead – Canton, MI

  • Requirements gathering of various external systems.
  • Preparation of ETL functional and technical design documents.
  • System testing, integration and UAT. Writing the SQL/PLSQL queries for extraction of data.
  • Working on building the Hierarchy which is flowed across various Data marts.
  • Review financial data such as Requisition, Purchase Orders, Vouchers, Contracts, Engagements and various other supply chain related information.
  • Work with Facts and Dimension tables to produce source - target mappings based upon business specs.
  • Develop Data Stage application jobs for data processing; loading and jobs scheduling using Data Stage Director.
  • Review ETL jobs in application releases to ensure that they perform efficiently with the resources available.
  • Perform Data Acquisition, Validation and Integration of various business applications
  • Assist developers and support staff with resolving problems with aborted jobs, locked jobs, space problems, large job log files, hung jobs, etc.

Require MS Electrical Engineering, related, or equivalent. Exp with Data Analysis, Design, Development, implementation of various apps using Ascential DataStage in Oracle, SQL Server, & Teradata, DB2 UDB, Flat Files. Exp in ETL/Data Warehousing apps, development, documentation, debugging, & Implementation. Strong Exposure to SQL, PL/SQL, UNIX shell scripts, Databases: Oracle 7.1/8.0/8i/9i, DB2 UDB, Teradata. Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, Surrogate Key assignment & change data capture.

M-F, 40hrs/wk. Travel to client site may be req on a project basis. Email resume to Data Solutions Inc. at [Click Here to Email Your Resumé].

3. Oracle Apps Developer - Canton, MI
  • Setup and develop interface with oracle order management/inventory/shipping modules; 
  • Work on AP/PO/AR and other financial modules on Oracle 11i and R12, support critical operation production system and data issues with end user; 
  • Integrate customer date with using TCA APIs with different spoke system; 
  • Work on MDM and integration with TIBCO and SOA layer, develop interface using PL/SQL packages, develop forms, report using discoverer and XML/BI Publisher5; 
  • Work with DBA for routine system maintenance for backup/refresh and performance tuning, 
  • Perform gap analysis study for migration, study requirements for SLA, integrate customer data using TCA APIs, generate discoverer reports based on users requirement, create new orders and customer through incoming flat files and customize interface program in OM and AR, perform setups for Oracle E-business suites modules like order management, TCA, inventory, payable modules.
  • Perform enhancement and performance tuning of movement schedule form and reports, design and development of reports, forms, PL/SQL procedure.
  • Create workbench and folders as per the client requirement using oracle discoverer, perform oracle database daily routine maintenance including standby database management, user management, backup and weekly cold backup routine, develop data feed and automation processes PL/SQL triggers, procedures and packages for the Oracle financial applications, write code in SQL, PL/SQL code to generate customer reports from Oracle Financials.
  • Design and development of various forms and reports for capturing customer data from the client offer information, work with business users in defining new requirements and needs, develop program in PL/SQL, SQL to merge the response coming from Oracle Financials and non-Oracle Financials database into a single response; 
  • Design and development of reports to generate on-line reports and reports on demand, work with the user group for providing on line support and use Oracle Applications Financials.

Require Associates degree, related field or equivalent plus 6 yrs of professional work exp or in the alternative a bachelor’s degree.  Must have exp working on Oracle system & app projects. Req Oracle Certified Professional & strong technical skills including Oracle Financial Applications, Oracle Apps R12, 11i, Oracle Reports 6i, OAF, SQL, PI/SQL, Toad.  


M-F, 40hrs/wk. Travel to client site may be required on a project basis. Email resume to Data Solutions Inc. at [Click Here to Email Your Resumé].

Job Requirements

Job Snapshot

Employment Type Full-Time
Job Type Information Technology
Education Not Specified
Experience Not Specified
Manages Others Not Specified
Industry Computer Software
Required Travel Not Specified
Job ID 0002445122
CareerBuilder Tip:
For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using you are agreeing to comply with and be subject to the Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.

Senior IT Tech Lead/ ETL Lead/ Oracle Apps Developer

Enter notes about this job: