Job Summary:
SIRITECH SOLUTIONS CORP is seeking an experienced ETL Developer to support enterprise data migration and modernization initiatives. The role involves converting legacy SAS code into Snowflake SQL and developing Talend-based ETL pipelines within a banking environment, ensuring data quality and integrity across enterprise data platforms.
Responsibilities:
• Analyze complex SAS code, macros, and batch workflows to understand business logic and data transformations
• Refactor, optimize, and convert legacy SAS processes into Snowflake SQL and Talend ETL pipelines
• Design and develop Talend ETL/ELT jobs for enterprise data ingestion, transformation, and loading into Snowflake
• Implement Talend transformations including tMap, tJoin, tAggregateRow, and tFilterRow to support business logic processing
• Create and maintain source-to-target mapping documents (MapDocs) and transformation logic documentation
• Develop parameterized Talend jobs using context variables for DEV, QA, and PROD environments
• Build and manage Snowflake data pipelines using SQL, stored procedures, and automated tasks
• Implement incremental load processing and Change Data Capture (CDC) logic for large datasets
• Perform data profiling, validation, reconciliation, and quality checks between source and Snowflake systems
• Troubleshoot ETL failures, resolve data issues, and optimize performance bottlenecks in Snowflake and Talend pipelines
• Optimize Snowflake queries and Talend workflows for scalability, performance, and cost efficiency
• Ensure enterprise data delivery meets SLA/OLA timelines and release requirements
• Collaborate with QA teams, Data Modelers, business teams, and stakeholders during UAT, deployments, and post-production validation
• Support enterprise migration and modernization activities involving Snowflake and Talend ecosystems
• Maintain transformation logic, technical documentation, and ETL development standards
• Participate in release management, testing, deployment support, and production readiness activities
• Support continuous improvement of ETL performance, scalability, and data quality practices
• Collaborate across technical and business teams to ensure seamless delivery and issue resolution
Qualifications:
Required:
• Minimum 810+ years of strong hands-on ETL/Data Engineering experience required
• Strong expertise in Snowflake, Talend, PySpark, SQL, Unix/Linux, and SAS code analysis/conversion
• Strong experience designing and developing ETL/ELT pipelines and enterprise data workflows
• Experience converting SAS processes into Snowflake SQL and Talend pipelines
• Hands-on experience implementing Talend transformations including tMap, tJoin, tAggregateRow, and tFilterRow
• Experience implementing CDC logic, incremental loads, and large-scale data processing solutions
• Strong data profiling, validation, reconciliation, and data quality experience
• Experience optimizing Snowflake queries and Talend jobs for performance and cost efficiency
• Experience with AWS/Azure cloud platforms and enterprise data ecosystems
• Strong troubleshooting, debugging, and stakeholder collaboration skills
• Experience supporting enterprise migration and modernization initiatives required
Preferred:
• Strong enterprise data integration and release support experience preferred
• Experience collaborating with QA, business, and Data Modeling teams preferred
Company:
SiritechSolutions Corp (“Siritech”) is an IT professional services firm providing expertise to empower clients’ businesses. Founded in 2023, the company is headquartered in Tampa, Florida, US, , with a team of 51-200 employees. The company is currently Growth Stage.