
Junior Informatica ETL Developer - Remote
- Halifax, NS
- Permanent
- Full-time
- Perform Data analysis, collect business requirements and identify business rules.
- Analyze, develop and support Data Integration, EDW and Data Management using Informatica, SQL, Oracle etc. 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 the service requests.
- Automate the 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 the upstream sources and provide guidance to data integration team resolutions.
- Work closely work with DBAs to fix performance bottlenecks.
- Recent experience and clear responsibilities in an ETL / Extracts / Data Engineering lead developer capacity.
- 3 plus 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 a 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.
- Certifications in ETL and Data Warehouse platforms.
- Domain experience in Healthcare.
- Data profiling and implementation of automated solutions for data quality checks.
- Bachelor's degree in Computer Engineering, Computer Science, Engineering, or related field of study