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.