Design, develop, and maintain high-performance ETL solutions using SSIS to support business intelligence and data warehousing needs
Write advanced and optimized T-SQL queries for data extraction, transformation, and loading
Troubleshoot and enhance existing SSIS packages to ensure reliability and performance
Monitor and support ETL processes across QA, UAT, and Production environments, including job monitoring and issue resolution
Integrate data from diverse sources such as RDBMS, APIs, FTPs, and cloud storage in various formats (CSV, JSON, XML, Parquet, etc.)
Utilize C# and Regex for complex data transformation tasks within ETL workflows
Analyze business requirements and deliver fully automated, scalable ETL solutions
Contribute to the development and refinement of ETL best practices, including data quality and cleansing standards
Provide accurate work estimates and deliver solutions in alignment with project timelines
Communicate effectively with the Data Engineering Manager regarding project status, risks, and dependencies
Collaborate with cross-functional teams to ensure data solutions meet business needs
Foster a culture of knowledge sharing and continuous improvement within the team
Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so