Software Developer

Infinics Inc   Charlotte , NC   Full-time     Information Services / Technology (IT)
Posted on September 16, 2022

Infinics, Inc. has an opening for the position of Software Developer (Ref# SD830AK) to work in Charlotte, NC and various unanticipated locations throughout the U.S.

Job Duties:  Design, develop, implement, test, and maintain business and computer applications software or specialized utility programs, including ETL and enterprise data warehouse (EDW) applications, and major enhancement of existing systems.  Analyze user needs and design, develop, and test software solutions to meet those needs.  Work with business teams to understand the requirements and deliver ETL solutions for clients in maintaining the EDW.  Work on ETL mapping specification document and data mapping based on the business requirements.  Build DataStage jobs to read files from multiple vendors using complex flat file and sequential file stages and different operational databases.  Use DataStage for extracting, transforming, and loading (ETL) databases from various sources including Oracle, DB2, and flat files.  Prepare technical data flow proposals for enhancements and integration of existing code in production.  Collaborate with EDW team in high-level design documents for ETL process, data dictionaries, metadata descriptions, file layouts, and flow diagrams.  Work with EDW team in low-level design document for mapping the files from source to target and implementing business logic.  Extract data from flat files and transform according to the requirements and load into target tables.  Interact with Data Architects to define, create, and modify EDW data models.  Create ETL DataStage parallel jobs to extract and reformat and load in the data warehouse.  Execute pre- and post-session commands on source and target database using shell scripting.  Convert COBOL code to DataStage migration.  Develop complex SQLs to retrieve the data.  Tune transformations and jobs for performance enhancement.  Analyze and fix the code as part of testing.  Ensure the program continues to function normally through software testing and maintenance.  Document every aspect of the application or system as a reference for future maintenance and upgrades.  Use of IBM InfoSphere DataStage, Teradata, SQL, Autosys, Control-M, Oracle, DB2, SQL Server, UNIX shell scripting, Linux, and Windows.  Travel and/or relocation required.

Requirements:  This position requires a Master’s degree or foreign academic equivalent in Computer Science, Information Technology, Computer Engineering, CIS, MIS, or a related field.  Plus 2 years of experience in the job offered or 2 years in a related occupation including Software Engineer or related experience.  Position requires 2 years of experience with DataStage.  40hrs/week.

Application Instructions:  To apply, please MAIL resume to referenced address, ensuring to indicate the position reference code (Ref# SD830AK) for which you are applying.  Mail to:  Infinics, Attn: HR, 301 McCullough Dr., Suite 400, Charlotte, NC  28262.

Infinics Inc

Charlotte , NC