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
Qualifications
Qualifications, Skills, and Experience
Minimum Bachelor’s degree in Computer Science or Information Systems7 + years of software development experience7+ years of experience using a relational database7 +years of ETL experience (analyze, plan, design, develop, test, implement, and change)Expert-level experience with Oracle SQL, PL / SQL, Informatica Stack (including but not limited to Power Center mappings & workflow, IDQ mappings & mapplets, UDO transformations, creation of complex XSD), UNIX, Java, Shell scripting, Salesforce, and Tableau7+ years of experience in data analysis and troubleshootingHands-on experience with Snowflake databases and creating ELT jobs in MatillionAbility to a manage a team with a high-volume workload, providing varying levels of support when required.Expert knowledge of MS Office tools, including MS Excel, and MS AccessExperience with data warehouses and sound understanding of data warehousing principlesVBA development experience in Excel a plusMust have strong technical, organizational and communication skills (both written and verbal)Must have robust, problem-solving capabilities, strong analytical skills, be flexible and able to handle multiple tasks concurrentlyAptitude for learning new technologies and learning on the fly