ETL Developer

Job Summary

The Developer role is responsible for developing and supporting integration and automation solutions using Informatica, Unix scripting, PowerCenter mappings and workflows, IDQ mappings and mapplets, UDO transformations, and creation of complex XSDs. Serve as Informatica subject matter expert for team members and clients.

Responsibilities

• Responsible for establishing, developing, updating internal Enterprise software development standards and best practices for ETL development using Informatica and extension (including but not limited to Power Center mappings & workflow, IDQ mappings & mapplets, UDO transformations, creation of complex XSDs), Matillion, Snowflake, UNIX, Java, Shell scripting, Salesforce, Azure and Tableau)
• Analyze, plan, design, develop, test and implement innovative methods for advancing ETL processes.
• Responsible for partnering with Technical Manager to follow established Enterprise Software Development Life Cycle (SDLC) standards and maintaining the successful adherence to these standards across entire Technology Solutions team
• Monitors for technology advancements impacting Integration Center related tools (Informatica, Tableau, and Azure, etc. ) and make recommendations to drive efficiencies and ROI.
• Utilize skills of communication, presentation, time management, organization and planning to successfully achieve team goals and objectives
• Responsible for updating Integration Center documentation and best practices library, ensuring this is kept up-to-date for reference and training material