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.