Data Architect and ETL Developer

Role Description

– Develop ETL mappings, interacting with large data processing pipelines in distributed data stores, using cloud-based ETL tools.
– Determine database structural requirements by analyzing client operations, applications, and programming, while reviewing objectives with clients and evaluating current systems
– Work with application DBA and modelers to construct data stores;
– Define database physical structure and functional capabilities to accommodate data integration requirements, security, back-up, and recovery specifications
– Ensure data is ready for use by consuming application, analyst and scientist using frameworks and microservices to serve data.
– Collaborate with data architects, modelers and IT team members on project goals
– Ensure optimum performance techniques for data integration, coordinate deployment actions, and document actions
– Integrate new data management technologies and software engineering tools into existing structures
– Maintain overall performance of components involved in Data Integration through ETL by identifying and resolving production and application development problems
– Answer user questions
– Provide maintenance and support to data integration and ETL components by coding utilities, and resolving problems

Position Requirements

Bachelor’s degree in Computer Science/Engineering

Hands-on experience working on ETL mappings, interacting with large data processing pipelines in distributed data stores, and distributed file systems using cloud-based ETL tools such as IICS and Azure Data Factory/SSIS.

Extensive experience coding complex SQL queries in one or more leading RDBMS e.g. Oracle, Azure Synapse, MS SQL Server, Postgres etc.

Advanced knowledge of Data Integration concepts and standard approaches

Strong leadership and communication skills

Ability to work independently once guidance and goals are provided

Experience with:

  •  Informatica Cloud Services (IICS), Informatica PowerCenter 10.x, Azure Data Factory
  • Postgres, Oracle 19c, Azure Synapse/SQL DW/ SQL DB, SQL Server 2016/2014/2012
  • Azure Microsoft Technologies, Unix, Linux, Windows

Desired:

Experience in one or more of the following technologies:

  • Data dictionaries
  • Data warehousing
  • Enterprise application integration
  • Metadata registry
  • Master Data Management (MDM)
  • Relational Databases
  • NoSQL
  • Semantics
  • Data retention
  • Structured Query Language (SQL)
  • Procedural SQL
  • Unified Modeling Language (UML)
  • XML, including schema definitions (XSD and RELAX NG) and transformations
  • Additional consideration will be given to those individuals who possess the following specific competencies (in no specific order): Tibco Data Virtualization, SAP BW/Hana
Apply now

Application Form

    The fields marked with "*" are required

    Attach your CV*
    Only PDF, DOC and DOCX files allowed. Maximum file size is 8MB.

    Attach your Cover Letter
    Only PDF, DOC and DOCX files allowed. Maximum file size is 8MB.

    I agree that my personal data can be processed in relation to my application, under the provided terms (Data Privacy Notice). I prefer to be contacted by: