Job Summary
This hybrid Sr Developer role focuses on designing and delivering robust data warehousing and integration solutions using SQL and TALEND ETL for an international organization. The role requires eight to ten years of experience in modern data practices translating complex business needs into scalable data pipelines that improve analytics reporting and decision making while ensuring reliability performance and long term maintainability across diverse enterprise systems.
Responsibilities
Talend & MSQL SSIS Data Integration
AWS RDS
MS SQL Server 2018 and later
PostgreSQL
S3 file storage
DynamoDB
TFS
GIT
- Design and implement scalable data warehousing solutions that consolidate diverse enterprise data into well structured models to enable accurate analytics and reporting across the organization.
- Develop and optimize complex SQL queries and stored procedures to support high performance data retrieval transformation and loading activities that directly serve business critical applications and dashboards.
- Build robust data integration workflows using TALEND ETL to orchestrate ingestion transformation and delivery processes that maintain data quality and consistency across multiple source and target platforms.
- Analyze existing data pipelines and warehouse structures to identify performance bottlenecks and then apply tuning strategies that improve throughput reliability and resource utilization for day to day operations.
- Collaborate closely with business and analytics stakeholders to translate data requirements into technical specifications and deliver solutions that provide trusted information for strategic and operational decisions.
- Create detailed technical documentation for data models mappings ETL jobs and operational procedures so that support teams and future developers can maintain and extend solutions with confidence.
- Implement rigorous data validation reconciliation and error handling mechanisms within ETL workflows to minimize data defects and ensure that downstream consumers receive complete and accurate information.
- Monitor daily data loads and batch processes in the hybrid work environment and proactively troubleshoot issues to minimize disruption to reporting cycles and dependent applications.
- Coordinate with infrastructure and database teams to plan capacity indexing partitioning and configuration changes that keep data warehouse environments secure performant and resilient.
- Apply industry standard coding practices version control and peer review processes to TALEND ETL jobs and SQL scripts to maintain code quality traceability and long term sustainability.
- Contribute to continuous improvement by evaluating new data integration approaches patterns and tools that can enhance efficiency maintainability and business value in hybrid work scenarios.
- Support incident and problem management by performing root cause analysis on data issues and propose targeted remediation steps that prevent recurrence and improve trust in enterprise data.
- Advise project managers and product owners on realistic effort estimates technical risks and dependencies related to data warehousing and integration so that delivery timelines and expectations remain aligned.
Qualifications
- Bring deep practical experience in enterprise data warehousing concepts including dimensional modeling slowly changing dimensions and data lifecycle management from at least eight years of focused work.
- Demonstrate advanced proficiency in SQL across major relational database platforms with strong capability in query tuning indexing and complex joins for large volume datasets.
- Show extensive hands on expertise in TALEND ETL including job design component selection error handling and deployment practices that support robust production data pipelines.
- Exhibit strong knowledge of data integration patterns such as batch streaming and near real time processing and understand when each pattern is appropriate for business scenarios.
- Apply sound understanding of data quality principles including validation standardization deduplication and reconciliation to maintain trusted data across the warehouse ecosystem.
- Utilize experience working in hybrid models that combine remote and office collaboration demonstrating effective communication and documentation to keep distributed teams aligned.
- Use familiarity with analytics and reporting tools at a conceptual level to design data structures and integration flows that meet the needs of business intelligence and data science stakeholders.
