Description

Job Description:

  • Contribute to and support the design, development, and maintenance of ETL processes using Informatica Cloud (IDMC).
  • Migrate Informatica PowerCentre v10.2 ETL code including embedded SQL and PL/SQL code developed using Oracle 11g and 19c.
  • Test migrated embedded SQL code and PL/SQL based stored procedures.
  • Performance-tune and optimize SQL queries and PL/SQL code for performance and scalability.
  • Conduct root cause analysis and resolve ETL issues, including performance tuning and recovery to achieve optimum baseline-based performance.
  • Perform data extraction, transformation, and loading (ETL) from various sources into data warehouses (star/snowflake schemas).
  • Translate technical specifications into fully tested applications and data pipelines.
  • Collaborate with vendors and project teams for unit testing, debugging, and validation of ETL processes.
  • Document technical designs, deployment guides, and support materials.
  • Participate in Agile/Scrum development cycles and iterative delivery.
  • Ensure compliance with data governance, security, and access control policies.
  • Provide post-implementation support and participate in knowledge transfer sessions.
  • Provide database administration including configuration, backup/recovery, user roles, and database synchronization.

Requirement/Must Have:

  • 10+ years of experience as a BI/ETL Developer.
  • 10+ years of experience developing and performance tuning SQL, T-SQL, PL/SQL, and advanced SQL query optimization.
  • 10+ years of experience with Oracle tools: EXPLAIN PLAN, TKPROF, OEM, RMAN, etc.
  • 5+ years of experience with relational databases including Oracle 11g and 19c.
  • 3+ years of hands-on experience with Informatica PowerCenter v10.2 administration.
  • 2+ years of experience with Informatica Cloud (IDMC) including migration from PowerCentre, asset management, and configuration of secure agents, schedules, organizations, sub-organizations, connections, users, and roles.
  • Hands-on Oracle 11g and 19c experience including configuration, user role setup, RMAN, data dumps, and Golden Gate synchronization.
  • Proficiency in data modeling (OLTP, OLAP, dimensional modeling).
  • Experience with REST/SOAP APIs, system integration, and cloud platforms (Azure, AWS, GCP).
  • Experience with data replication, data cleansing, and data quality assurance.
  • Excellent analytical, problem-solving, and communication skills.

Skills:

  • Strong understanding of Agile, SDLC, and DevOps practices.
  • Experience with Azure DevOps and version control systems.
  • Familiarity with enterprise methodologies and architecture.
  • Experience in public sector projects, especially in environmental or inter-jurisdictional data systems.
  • Understanding of information management principles and data governance

Key Skills
Education

Any Graduate

Back To Jobs