Team Leader - Software

Key Responsibilities and Accountabilities

Data Integration & ETL Development

• Create and manage ETL workflows using DataStage or equivalent tools.
• Extract data from diverse source systems such as Files, SQL Databases, Oracle, DB2, etc.
• Transform and load data into target systems, ensuring accuracy and integrity.

Database & Data Warehousing Management

• Strong understanding of target systems: landing zones, transformation zones, data warehouses, and data marts.
• Ensure source-to-target mapping, data lineage tracking, and data reconciliation.
• Monitor and optimize database performance for ETL and reporting activities.

Technical Expertise

• Proficient in SQL programming and database management.
• Work with databases including MySQL, Oracle, PostgreSQL, Microsoft SQL Server, MongoDB, Redis, Elasticsearch, Cassandra, MariaDB, and IBM Db2.
• Collaborate with teams to maintain high data quality and consistency across platforms.

Process & Documentation

• Document workflows, data mappings, and transformation logic for reference and auditing purposes.
• Ensure adherence to organizational policies, standards, and best practices in data warehousing.