Job Description :
RQ01171 - Software Developer - ETL Intermediate Toronto, ON Start Date 2021-04-01 End Date 2021-09-30 Rate: CAD $ 464/Day Assignment Type: Onsite Security Level: No Clearance Required # Business Days: 125.00 Description MSP Notes Shortlisting Date: Wednesday, March 17th at 2:00 pm EST Maximum number of Candidate Submissions: 1 (One) Must Haves: 3+ years experience with the Informatica Powercentre ETL toolset and script development where they have successfully designed and implemented complex workflows that integrate notification emails & roll-backs Demonstrated experience with Web services and XML development, SOAPUI, SQL Query Experience with Oracle 12x and in developing complex Oracle PL/SQL scripts to retrieve and format data to meet business requirements and design Nice to Have: Public Service Experience Role: Responsibilities/Assignment Deliverables 1. Design, develop and test an Informatica Powercentre Workflow (Job) to take new or updated data from a view in an Oracle Database, on a daily schedule, and copy to a temporary data store and email a designated business resource on successful completion or failure (Daily Catalyst Extract) 2. Design, develop and test an Informatica Powercentre Workflow (Job) to identify new & updated records in a temporary data store and then create & send a defined web service message to a specific target, on a scheduled basis (BN15 Search, BN15 Create, BN15 Update Messages) 3. Design, develop and test an Informatica Powercentre Workflow (Job) to identify new & updated records in a temporary data store, create a txt file based on a defined layout, send to a defined target via S/FTP, and email a designated business resource on successful completion or failureISED NUANS File, SO Reporting Extract File, & WSIB data file) 4. Design, develop and test an Informatica Powercentre Workflow (Job) pick-up a file from an FTP location, extract & load the records into a temporary data store and then create & send a defined web service message to a specific target, on a scheduled basis for each record in the file, and email a designated business resource on successful completion or failure (CTAR T2 return loading, MOF Default Notices) Responsibilities Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests. General Skills Experience in programming and analysis at the specified experience level Ability to collaborate with IT Professionals throughout the Software Development Life Cycle Experience in structured methodologies for the development, design, implementation and maintenance of applications Experience in design, code, test, debug and document applications Experience in the use of object and/or third generation language development tools Experience in one or more programming languages Experience in application design, latest design patters, deployment and troubleshooting Experience with relational and hierarchical database technologies Experience in the use of information retrieval packages using query languages Experience with one or more communications protocols Experience in structured methodologies for the design, development, implementation and maintenance of applications Experience eliciting and documenting information from diverse business area stakeholders and subject matter experts Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills A team player with a track record for meeting deadlines Desirable Skills Knowledge and experience with programming Internet-ready applications Knowledge and experience in rapid application development (RAD) methodologies Experience with middleware and gateways Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards Ability to provide user and system documentation as required Skills Experience and Skill Set Requirements Technical Tools - 35% Experience using Informatica Powercentre to create complex workflows that integrate notification emails & roll-backs 3+ years demonstrated experience with the Informatica Powercentre ETL toolset 3+ years demonstrated experience with ETL script development Demonstrated experience using Informatica tools to read inbound data from a web service Demonstrated experience using Informatica tools to create outbound web service messages from a traditional data source Programming Experience - 20% Experience with Web services and XML development and design Experience with software development tools such as SOAPUI, SQL query, Web Services Description Language (WSDL), SOAP Experience with data mapping and XML Parsing Oracle Database Experience - 10% Experience with Oracle 12X Experience in developing complex Oracle PL/SQL scripts to retrieve and format data to meet business requirements Experience with Oracle Database DML/DDL script development Public Sector Experience - 5% Experience working in a highly complex, unionized and multi-stakeholder environment. Understanding of OPS IT methodologies and standards
             

Similar Jobs you may be interested in ..