careers@CapSquare Systems


CapSquare Systems, Inc. has an opening for the position of Software Engineer (Ref# SE720HP) to work in Troy, MI and various unanticipated locations throughout the U.S. Job Duties: Design, develop, implement, test, and support computer applications software, including data warehouse and Business Intelligence (BI) applications. Interact with end users and client community to understand the business requirements and in identifying data sources. Responsible for all activities related to the design, development, implementation, testing, and support of ETL processes for large-scale data warehouses using IBM InfoSphere Information Server. Responsible for development in InfoSphere / DataStage environment and all aspects of reporting. Conduct requirement definition, solution development and implementation phase of reporting projects. Analyze data and design and develop scripts and SQL as needed. Develop, schedule, and monitor ETL jobs and sequences. Troubleshoot DataStage jobs, address production issues, and conduct performance tuning and optimization. Create UNIX shell scripting for data validation and schedule the DataStage jobs. Prepare job sequences for the existing jobs to facilitate scheduling of multiple parallel jobs. Write UNIX shell scripts and conduct scripting for the automation of various ETL scripts and for scheduling ETL jobs. Develop effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations. Document ETL test plans, test cases, test scripts, and validations based on design specifications. Involved in design and code reviews and extensive documentation of standards, best practices, and ETL procedures. Use of ETL, IBM DataStage, IBM InfoSphere Information Server & Information Analyzer, QualityStage, SSIS, Perl, Tableau, Cognos, Teradata, Netezza, SQL Server, Oracle, DB2, Oracle SQL Developer, UNIX, and Windows. Travel and/or relocation required. Requirements: This position requires a Masterís degree or foreign academic equivalent in Computer Science, Information Systems, or a related field. Plus 2 years of experience in the job offered or 2 years in a related occupation including Programmer Analyst or related experience. Position requires 6 months of experience with ETL, DataStage, SSIS, SQL Server, and UNIX shell scripts. 40hrs/week. Application Instructions: To apply, please MAIL resume to referenced address, ensuring to indicate the position reference code (Ref# SE720HP) for which you are applying. Mail to: CapSquare Systems, Inc., Attn: President, 1000 John R. Rd., Suite 200, Troy, MI 48083.

CapSquare Systems, Inc.
Attn: HR/Re: Job Code SE
1000 John R. Road, Suite 200
Troy, MI  48083

CapSquare Systems, Inc. is an equal opportunity employer