Description

You will design, develop, and implement integration and automation solutions using the Informatica stack and relational databases.

Responsibilities

  • Develop and support ETL processes including PowerCenter mappings, workflows, IDQ mappings, mapplets, UDO transformations, and complex XSDs.
  • Establish and update internal enterprise software development standards and best practices for ETL development.
  • Analyze, plan, design, and test methods for advancing integration processes.
  • Partner with the Technical Manager to ensure adherence to Enterprise Software Development Life Cycle (SDLC) standards.
  • Maintain and update integration documentation and best practices libraries for training and reference.

Required Skills

  • 7+ years of software development experience.
  • 7+ years of experience with relational databases and ETL processes (analysis, design, development, and testing).
  • Expert-level proficiency with Oracle SQL and PL/SQL.
  • Expert knowledge of the Informatica Stack, including PowerCenter, IDQ, and UDO transformations.
  • Hands-on experience with UNIX and Shell scripting.
  • Experience with Java, Salesforce, and Tableau.
  • Hands-on experience with Snowflake databases and creating ELT jobs in Matillion.
  • 7+ years of experience in data analysis and troubleshooting.
  • Strong understanding of data warehousing principles and data warehouse environments.
  • Proficiency with MS Excel and MS Access.

Preferred Skills

  • VBA development experience in Excel.

Education

Any Graduate