Discover jobs
Job Search
cloud developer
Title posted on indeed.com - Sr Developer - PL SQl
Posted on November 25, 2024 by Employer details nnovativ inc
Job details
*Nnovativ Inc* provides technology staffing and Digital Transformation Services for private and public sector organizations. We are currently seeking a *Senior Developer - PL/SQL *for our client in the Public Sector domain. We value our professionals by providing comprehensive benefits and the opportunity for growth. This is a 12 month Contract position with a possibility of extension. Job Types: *Full-time, Contract* Location: *Toronto, ON (Hybrid 3 Days from Office)* Role: *Senior Developer - PL/SQL * *Job Description:* *Position Overview* The Senior Software Developer will be responsible for providing subject matter expertise and hands-on technical leadership across all relevant systems. This includes designing, developing, and deploying end-to-end solutions in both on-prem and cloud environments. The role will focus heavily on PL/SQL development, improvement and maintenance while leveraging experience with Cognos and Informatica to enhance reporting, ETL, and integration capabilities. *Responsibilities* * Provide subject matter expertise and hands-on engagement for all relevant systems, identifying and implementing technical solutions. * Design, develop, and maintain stored procedures and reports, with a focus on PL/SQL performance tuning. * Create and refine functional and technical designs throughout the software development lifecycle. * Develop and execute unit tests, support System Integration Testing (SIT), and assist in Quality Assurance Testing (QAT). * Support production deployment activities, including conducting root cause analysis for production issues. * Develop and maintain all functional and technical design documentation. * Develop and optimize complex stored procedures, functions, triggers, and other PL/SQL database objects. * Design, develop, and implement ETL processes using Informatica PowerCenter to ensure efficient data extraction, transformation, and loading from various data sources. * Design and develop business intelligence reports, dashboards, and visualizations using Cognos to provide meaningful insights to stakeholders. * Collaborate with cross-functional teams to integrate Cognos reports and Informatica ETL processes into the overall solution architecture. *General Skills* * Strong experience in PL/SQL programming, including creating, optimizing, and troubleshooting complex database procedures, functions, and triggers. * Cognos V11.2 experience, including developing and optimizing reports and dashboards for high availability environments. * Experience in technical design, development, and delivery of specified technology solutions, including reports, interfaces, conversions, extensions, and customizations. * Ability to create and update technical design specifications based on project requirements. * Demonstrated experience in providing accurate estimations for project delivery timelines. * Experience designing, developing, and testing data conversion programs to ensure accurate and seamless data migrations. * Knowledge of enterprise architecture methodologies and tools for specified technology environments. * Hands-on experience with data integration using Informatica, including ETL design and development. * Experience developing integrated test scenarios, identifying test data, executing tests, troubleshooting issues, and documenting test results. * Expertise in providing technical leadership in managing stakeholder expectations and requirements. * Proficient in RDBMS concepts and experience in designing data models and ensuring data quality and consistency. * Strong experience with SQL development, tuning, and troubleshooting, including the use of relational databases such as Oracle, SQL Server, and DB2. * Strong experience designing, developing, and maintaining ETL processes using Informatica for data movement, transformation, and integration. * Experience in optimizing system performance through proactive monitoring and identifying bottlenecks across cloud and on-premise environmen- LocationToronto, ON
- Workplace information On site
- Salary$80.00 to $85.00HOUR hourly
- Terms of employment Term or contractFull time
- Starts as soon as possible
- vacancies 1 vacancy
- Source indeed.com #9539649054
Important notice: This job posting has been provided by a partner site. Job Bank is not responsible for this content.
Report a problem with this job posting
- Date modified: