RQ09467 - Sr. Software Developer - ETL

Job Description

<p><strong>RQ09467 - Sr. Software Developer - ETL</strong></p> <p><strong>St. Clair West, Toronto</strong></p> <p><strong>Hybrid work: 3 days per week and 2 days remotely.</strong></p> <p><strong>Contract (8 months)<br></strong></p><p>A highly skilled and experienced ETL Developer to design, develop, and maintain robust data integration solutions. The ideal candidate will have deep expertise in Informatica PowerCenter v10.2 and Informatica Intelligent Data Management Cloud (IDMC), PL/SQL, and data warehousing, with a strong background in performance tuning, troubleshooting, and cloud migration. This role involves working closely with business analysts, developers, and stakeholders to ensure high-quality data delivery and system integration.<strong ></strong></p> <p><strong>Must-Haves</strong></p> <ul><li>10+ years of experience as a <strong>BI/ETL Developer.</strong></li><li>10+ years of experience developing and performance tuning<strong> SQL, T-SQL, PL/SQL</strong> and advanced<strong> SQL </strong>query optimization.</li><li>10+ years of experience with <strong>Oracle tools: EXPLAIN PLAN, TKPROF, OEM, RMAN</strong>, etc.</li><li>5+ years of experience with relational databases including<strong> Oracle</strong> including<strong> Oracle 11g and 19c.</strong></li><li>3+ years of hands-on experience with <strong>Informatica PowerCenter v10.2</strong> administration</li><li>2+ years of experience with<strong> Informatica Cloud (IDMC)</strong> including PC to IDMC migration; asset management; and configuration of secure agents, schedules, orgs and sub-Orgs, connections, users and roles</li><li>Hands-on<strong> Oracle 11g and 19c experience </strong>configuring, user roles setup, RMAN, data dumps, and Golden Gate synchronization</li><li>Proficiency in data modelling (OLTP, OLAP, dimensional modelling).</li><li>Experience with <strong>REST/SOAP APIs</strong>, system integration, and cloud platforms <strong>(Azure, AWS, GCP).</strong></li><li>Experience with data replication, data cleansing, and data quality assurance.</li></ul><p><strong>Nice-to-Have:</strong></p><ul><li> Strong understanding of <strong>Agile, SDLC,</strong> and <strong>DevOps</strong> practices.</li><li>Experience with <strong>Azure DevOps </strong>and version control systems.</li><li>Familiarity with <strong>OPS (Ontario Public Service)</strong> methodologies and enterprise architecture.</li><li><strong>Experience in public sector</strong> projects, especially in environmental or inter-jurisdictional data systems.</li><li>Understanding of Information Management principles and data governance. </li></ul>