Lead Software Engineer

P1C3STSDesign, develop, and maintain ETL processes to extract data from multiple source systems (databases, APIs, flat files, etc.)Transform and cleanse data to meet business and technical requirementsLoad data into target systems such as data warehouses, data lakes, or BI platformsDevelop and optimize data pipelines for performance, scalability, and reliabilityEnsure data quality, integrity, and consistency across systemsPerform data validation, reconciliation, and error handlingCollaborate with business analysts, data architects, and stakeholders to understand data requirementsTroubleshoot and resolve data-related issues and performance bottlenecksImplement logging, monitoring, and alerting mechanisms for ETL workflowsMaintain technical documentation, data mappings, and workflow designsResponsibilitiesOversee ETL pipeline development, execution, and reliabilityEnsure data quality, integrity, and consistency across systemsDrive performance optimization and scalability of data workflowsCollaborate with stakeholders to align data solutions with business needsGovern data processes, compliance, and continuous improvement initiativesAdvanced SQL & Data TransformationETL Tools (Informatica / Talend / SSIS / DataStage)Scripting/Programming (Python, Shell)Data Warehousing Concepts (Dimensional Modeling, Star/Snowflake)