Software Developer Position
Date Posted: 6/7/2024
Duties include: Analyze functional and technical specification documents and design use cases documents. Create Sessions and Workflows to load data from the Different Source Systems into Database which in turn feeds the downstream applications using tool Informatica Powercenter. Building ETL Informatica applications for receiving &processing data to build data warehouse/data mart environment for reporting and analytical purpose using tools like Informatica Powercenter, Sql and Scripting. Write complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance. Develop mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Aggregator, Update strategy and Sequence Generator. Modifying the existing ETL code and scripts as per the user requirements. Develop test plans to test scope and environments in different test phases and methodologies. Test the applications using manual and automated tools and manage defects with defect tracking tools. Responsible for Production Turnover for moving ETL Informatica objects (workflows/sessions, mappings), Database objects (functions, stored procedures, DDL queries), scripts from Test to QA to Prod. Serve as point of contact between the developer and the administrators for communications pertaining to successful execution of job.
This position requires a master’s degree in Computer Science or related.
Work location: Troy, MI
Apply: info@wiseitinc.com
Salary: $93,000
Reference: #533
Software Developer Position
Date Posted: 7/5/2023
Date Removed: 7/21/2023
Duties include: Perform end to end software development life cycle (SDLC) projects and activities. Planning and developing projects. Working in Agile Environment. Coding using ETL Informatica Tools and its components. Developing PL/SQL code using sql language Tools. Develop ETL design documents and High Level function documents. Be part of Development, Unit testing, Integration System, Performance and User acceptance testing, Deployment phase.
This position requires a master’s degree in Engineering Management, Computer Science, Software engineering or a related field.
Work location: Troy, MI
Apply: info@wiseitinc.com
Salary: $91,100
Reference: #1839
Data Engineer Position
Date Posted: 2/7/2023
Date Removed: 3/7/2023
Duties include: Understanding and analyzing functional and technical specification documents. Designing and presenting technical design. Building ETL Informatica Application for receiving and processing Healthcare files. Developing complex Informatica mappings and workflows to process the data using different transformations like UDT (Unstructured data transformation), connected and unconnected lookup, expression, aggregator, joiner, filter, normalizer, rank and router transformations etc. Developing Data Transformation (DT) Services for creating and validating EDI files (834, 837 etc.). In Informatica mapping calling DT Service through UDT for creating and validating EDI files (834, 837 etc). Setting up Partner, Account and Profile in Informatica B2B Data Exchange. Processing files through Informatica B2B Data Exchange. Building Windows scripts. Developing common Mapplets that can be used across the project. Unit testing, performance testing and tuning the code. Responsible for production deployment of ETL Informatica objects i.e. workflows/sessions, mappings, DT service, B2B DX Profile and Windows Script. Modifying the existing ETL code and scripts as per the requirements. Resolving and fixing the production issues. Participate in daily and weekly meeting to discuss new requirements, design, testing, performance and provide updates.
This position requires a master’s degree in Information Systems and Security.
Work location: Troy, MI
Apply: info@wiseitinc.com
Salary: $85,500
Reference: #532
Senior Systems Engineer Position
Date Posted: 1/11/2022
Date Removed: 2/11/2022
Duties include: Deployment, automation, management, and maintenance of AWS cloud-based production system and IBM middleware suite. Ensuring availability, performance, security, and scalability of AWS production systems and IBM HTTP Server, WebSphere application server etc. Management of creation, release, and configuration of production systems. Building infrastructure services in the cloud using automation with Terraform, Ansible and python. Deploying via Jenkins CI/CD pipelines for Infrastructure as a Code. Installing, configuring, and deploying on various middleware tools and technologies. Evaluation of new technology alternatives and vendor products. System troubleshooting and problem resolution across various application domains and platforms. Pre-production acceptance testing for quality assurance. Provision of critical system security by leveraging best practices and prolific cloud security solutions. Providing recommendations for architecture and process improvements. Definition and deployment of systems for metrics, logging, and monitoring on AWS platform. Designing, maintenance and management of tools for automation of different operational processes.
Position requires a master’s degree in Computer Science or Information Technology.
Work location: Troy, MI
Apply: info@wiseitinc.com
Salary: $80,200
Ref#: 1893
Senior Systems Engineer Position
Job Posting Date – 09/17/2022
Duties include:
- Deployment, automation, management, and maintenance of AWS cloud-based production system and IBM middleware suite. Ensuring availability, performance, security, and scalability of AWS production systems and IBM HTTP Server, WebSphere application server etc.
- Management of creation, release, and configuration of production systems. Building infrastructure services in the cloud using automation with Terraform, Ansible and python. Deploying via Jenkins CI/CD pipelines for Infrastructure as a Code.
- Installing, configuring, and deploying on various middleware tools and technologies. Evaluation of new technology alternatives and vendor products.
- System troubleshooting and problem resolution across various application domains and platforms.
- Pre-production acceptance testing for quality assurance.
- Provision of critical system security by leveraging best practices and prolific cloud security solutions. Providing recommendations for architecture and process improvements.
- Definition and deployment of systems for metrics, logging, and monitoring on AWS platform.
- Designing, maintenance and management of tools for automation of different operational processes.
Position requires a master’s degree in Computer Science or Information Technology.
Work location: Troy, MI
Apply : info@wiseitinc.com
ETL Informatica Developer Position
Job Posting Date – 09/16/2022
Duties include:
- Develop ETL workflows to collect data from multiple data sources based on mapping specifications provided to the developer and load into the Enterprise data warehouse.
- Provide assistance to developers regarding the use of ETL development standards relating to Python Etl and Informatica Etl. Assist project team with unit testing.
- Develop system test plans and perform full system testing prior to implementation. Work closely with technical leads, analysts and developers to design and implement Oracle solutions within a structured development process.
- Modify existing software to correct errors, to adapt it to new hardware or to upgrade interfaces and improve performance.
- Assist in continuous improvement efforts and enhancing project team methodology and performance.
- Work as part of the team to deliver on critical projects and work-related items. Identify problems, develop ideas, and propose solutions within differing situations requiring analytical, evaluative, or constructive thinking in daily work.
This position requires a master’s degree in Information Systems.
Work location: Troy, MI
Apply: info@wiseitinc.com
Software Developer Position
Job Posting Date – 12/20/2021
Duties include:
- Analyze functional and technical specification documents and design use cases documents.
- Create Sessions and Workflows to load data from the Different Source Systems into Database.
- Building ETL Informatica applications for receiving and processing data to build data warehouse/data mart environment for reporting and analytical purpose.
- Write complex SQL override scripts to improve the performance.
- Develop mapping logic Modify the existing ETL code and scripts as per the user requirements.
- Develop test plans to test scope and environments in different test phases and methodologies.
- Test the applications using manual and automated tools and manage defects with defect tracking tools.
- Responsible for Production Turnover for moving ETL Informatica objects (workflows/sessions, mappings), Database objects (functions, stored procedures, DDL queries), scripts from Test to QA to Prod.
- Serve as point of contact between the developer and the administrators for communications pertaining to successful execution of job.
- Resolve issues that cause the production jobs to fail by analyzing the ETL code and log files created by failed jobs on the Informatica server.
- Provide backup support of databases, ETL applications environments.
This Position requires a master’s degree in Computer Science or Information Security/Technology.
Work location: Troy, MI
Apply: info@wiseitinc.com
SOFTWARE DEVELOPER POSITION
Job Posting Date – 08/27/2021
Duties include:
- Gathering & Analysis to implement interfaces between the source systems and Data Warehouse.
- Design, Implementation and Testing to ensure that low level & high-level designs are meeting the RA requirements.
- Unit testing is performed for each & every requirement captured during RA phase.
- Transition, Warranty and Production Support to ensure smoother knowledge transition and that SLA’s are met in BAU phase.
- Estimation and Scheduling of the issues logged in BAU phase. Ensure all the Functional and technical documentation is maintained.
Position requires a master’s degree in Computer Science/Engineering or a bachelor’s degree in Computer Science/Engineering or the foreign equivalent with 5+ years of experience.
Work location: Troy, MI
Apply: info@wiseitinc.com
SOFTWARE DEVELOPER POSITION
Job Posting Date – 01/22/2021
Duties include:
- Understand technical requirements or constraints that exist in the client’s application environment.
- Discover, evaluate and recommend technical solution alternatives to the client, devising a cohesive strategy/approach for the project.
- Work on high availability/high concurrent user applications with exceptional load requirements and low downtime tolerance.
- Design the technical architecture that will be utilized for the proposed software application.
- Ensure that the technical architecture and approach effectively supports mission critical applications with 24/7 uptime requirements.
- Create code to address the most complex technical challenges that must be solved for a project.
- Provide technical input to other developers in advanced development techniques.
- Work with staff developers and sales professionals to assist in the estimation process for high budget project client proposals.
- Help to define and shape coding and development standards used by development teams.
- Conduct code reviews of other developers to ensure proper coding standards are being followed.
- Work with team of developers to ensure end-to-end delivery of projects on time.
- Perform research to maintain an understanding of the most recent technical developments and development techniques associated with their related competence areas.
- Provide ongoing technical consultation to address challenging support issues in development environments.
- Responsible for various aspects of ongoing support and maintenance engagements.
- Deliver training to client personnel of various skill levels and technical capabilities.
- Work closely with quality assurance resources to create test plans and ensure that issues are properly assigned, fixed, and regressed.
Position requires a master’s degree in Computer Science or Information Systems/technology
Work location: Troy, MI
Apply: info@wiseitinc.com
SOFTWARE DEVELOPER POSITION
Job Posting Date – 10/19/2022
Duties include:
- Analyze functional and technical specification documents and design use cases documents. Create Sessions and Workflows to load data. Build ETL Informatica applications for receiving & processing data to build data warehouse/data mart environment for reporting and analytical purpose using tools like Informatica Powercenter, Sql and Scripting.
- Write complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance.
- Develop mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Aggregator, Update strategy and Sequence Generator. Modifying the existing ETL code and scripts as per the user requirements.
- Develop test plans to test scope and environments in different test phases and methodologies.
- Test the applications using manual and automated tools and manage defects with defect tracking tools. Responsible for Production Turnover for moving ETL Informatica objects (workflows/sessions, mappings), Database objects (functions, stored procedures, DDL queries), scripts from Test to QA to Prod. Serve as point of contact between the developer and the administrators for communications pertaining to successful execution of job.
- This position requires a master’s degree in Computer Science or Information Systems Security.
- Work location: Troy, MI
- Apply: info@wiseitinc.com