Location: Toronto business core - hybrid
Salary Market Rate ++
Looking for an ETL Developer who has hands-on experience in data integration and database development using Talend and contributes to successfully deliver data integration or custom database development projects in the Greater Toronto Area
RESPONSIBILITIES
? Understand business requirements for data and information especially in the financial services industry.
? Design data integration or ETL processing using Talend, PL/SQL, or T-SQL for client engagements based on an approach that is holistic, scalable, pragmatic, and effective design of data processing.
? Extract data from transactional systems, transform data, and load data into target operating data stores or data warehouses.
? Develop Java user defined functions and/or stored procedures (Oracle PL/SQL or MSSQL T-SQL) as needed for complex transformation.
? Perform data profiling and data quality audit.
? Develop automated unit-tests.
? Integrate pipelines with Continuous Integration/Delivery framework as needed.
? Produce estimates for data analysis and mapping, design, development, and testing.
? Ensure compliance with business, data, and technical requirements.
? Ensure that client's enterprise architecture standards, policies, and procedures are followed.
REQUIREMENTS
? Minimum 5 years experience in Information Technology, participating in complex projects.
? Minimum Bachelors degree in Computer Science.
? Strong communication skills.
? Strong knowledge in data analysis, database development, data warehousing life cycle and data integration methodologies (ETL, ELT).
? Strong knowledge and extensive experiences using Talend.
? Strong programming experience in PL/SQL and/or T-SQL.
? Strong SQL programming knowledge in one of Oracle or Microsoft SQL databases.
? Knowledgeable in both relational and dimensional data modeling (with both Kimball and Inmon approaches).
? Work knowledge of Java programming language.
? Knowledgeable in UNIX shell scripting
? Working knowledge of one of data analytics tools (such as Microsoft Power BI).
? Knowledge in data management and Continuous Integration and Delivery (CI/CD) principles.
? Good overall business knowledge in financial industries (i.e. one or more in retail banking, commercial banking, capital markets, wealth management, insurance, pension fund, and fintech).
? Preferably exposures to Hadoop-based tools (e.g. Hive, Spark) and cloud computing concepts (Azure services).
? Ability to work independently and excel in a team environment.
MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.