Job Overview
We are currently seeking a Junior Informatica ETL Developer to join our team in Toronto, Ontario, Canada.
Key Responsibilities
• Perform data analysis, collect business requirements and identify business rules.
• Analyze, develop and support data integration, EDW and data management using Informatica, SQL, Oracle platforms and tools.
• Collaborate with data modelling team to define data integration logic.
• Create data mappings necessary to fulfill the requirements.
• Build and test new ETL programs to fulfill service requests.
• Automate ETL processes and pipelines using scripting and schedulers.
• Participate in unit testing, assist QA team in integration testing and support business team for UAT.
• Participate in code deployment and coordinate with different infrastructure teams during go-live, post-production and continued support of end product.
• Debug data quality issues by analyzing upstream sources and provide guidance to data integration team resolutions.
• Work closely with DBAs to fix performance bottlenecks.
Requirements
• Recent experience and clear responsibilities in an ETL / extracts / data engineering lead developer capacity.
• 3+ years of experience in data integration (ETL) with 2 or more in solution development using Informatica suite.
• 3 or more years of experience in RDBMS / data warehousing platforms on Oracle.
• Must have experience in Linux shell scripting to introduce automation as part of solution delivery.
• Strong SQL knowledge and ability to write most complex queries.
• Conceptual understanding of logical and physical data modelling is a must, and working experience is a plus.
• Ability to develop and maintain data integration/ETL specifications that states integration rules and mappings.
• Ability to use documentation tools such as MS Visio and MS PowerPoint to diagram integration data flows.
• Ability to communicate effectively with business and technical staff members.
