Design, build and maintain complex ELT / ETL jobs that deliver business value.Extract, transform and load data from various sources including databases, APIs, and flat files using IICS or Python / SQL.
- Translate high-level business requirements into technical specs
- Conduct unit testing, integration testing, and system testing of data integration solutions to ensure accuracy and quality
- Ingest data from disparate sources into the data lake and data warehouse
- Cleanse and enrich data and apply adequate data quality controls
- Provide technical expertise and guidance to team members on Informatica IICS / IDMC and data engineering best practices to guide the future development of company Data Platform
- Develop re-usable tools to help streamline the delivery of new projects
- Collaborate closely with other developers and provide mentorship
- Evaluate and recommend tools, technologies, processes and reference
Architectures
- Work in an Agile development environment, attending daily stand-up meetings and delivering incremental improvements
- Participate in code reviews and ensure all solutions are lined to architectural and requirement specifications and provide feedback on code quality, design, and performance
Skills Required
ELT, Etl, data engineering , Data Integration, Api, Python, Sql, data quality control