xStear Inc
Website:
xstear.com
Job details:
Company Description xStear Incorporation is a trusted provider of digital transformation solutions, helping businesses modernize and enhance their technology landscape. The organization focuses on guiding companies from traditional business models to digital-first operations to drive efficiency, productivity, and competitiveness. xStear Incorporation leverages a skilled and experienced team with deep expertise in the latest digital technologies and their practical application. The company partners closely with clients to align technology solutions with specific business goals and long-term growth strategies.
Overview:
Expertise in integrating SQL Server Integration Services (SSIS) workflows with the Snowflake cloud data platform, combined with strong PostgreSQL performance tuning, stored procedure optimization, and basic database administration capabilities. A strong background in developing, managing, and troubleshooting SSIS-based E TL processes designed to move, transform, and load data into Snowflake. This role will be key to ensuring that our data integration pipelines between on-premises environments, PostgreSQL databases, and Snowflake are reliable, scalable, and optimized for performance.
Key Responsibilities:
SSIS Package Development: Design, develop, and maintain SSIS packages that integrate with Snowflake and PostgreSQL, ensuring smooth data transfer and transformation.
ETL Processes: Implement ETL workflows using SSIS to extract data, transform it according to business logic, and load it into Snowflake.
PostgreSQL Performance Tuning: Analyze, troubleshoot, and optimize PostgreSQL query execution plans (EXPLAIN ANALYZE), indexing strategies, and parameter configurations to minimize resource consumption and eliminate bottlenecks.
Stored Procedure Optimization: Refactor and optimize complex PostgreSQL stored procedures, functions, and queries to ensure high throughput and execution efficiency.
Basic Database Administration: Perform routine PostgreSQL administrative tasks including user access management, database health monitoring, vacuum maintenance, and basic operational tasks.
Troubleshooting & Issue Resolution: Monitor SSIS workflows, PostgreSQL databases, and Snowflake data pipelines to troubleshoot and resolve data load errors, performance bottlenecks, or integration issues.
Snowflake-Specific SSIS Integration: Use Snowflake ODBC, ODI (Oracle Data Integrator), or Snowflake's native connector for SSIS to manage and optimize ETL jobs between SSIS, PostgreSQL, and Snowflake.
Data Performance Optimization: Optimize SSIS packages for highperformance data loads, ensuring the efficient use of Snowflake's micropartitioning, clustering, and caching mechanisms to minimize costs and improve query performance.
Monitoring & Automation: Set up job monitoring and automated alerts for failed SSIS packages, database performance degradation, or Snowflake pipeline failures. Take proactive measures to ensure data flows are uninterrupted and optimized.
Documentation & Knowledge Sharing: Create clear and concise documentation for SSIS packages, PostgreSQL scripts, ETL processes, and troubleshooting steps. Share knowledge with team members to ensure continuity and ease of maintenance.
Technical Skills:
SSIS (SQL Server Integration Services): Expertise in developing, managing, and troubleshooting SSIS packages, specifically for data extraction, transformation, and loading (ET L).
PostgreSQL Performance Tuning & Administration: Strong expertise in diagnosing slow queries, query execution plan analysis, index optimization, and basic administrative capabilities (user roles, table maintenance, health checks).
Stored Procedure Optimization: Proven experience writing, tuning, and refactoring complex stored procedures, functions, and advanced SQL queries for performance optimization.
Snowflake Integration with SSIS: Hands-on experience with integrating SSIS workflows with Snowflake, including using Snowflake's ODBC connector or native SSIS connectors (e.g., Attunity, SQL Server Integration Services Snowflake Connector).
ETL and Data Transformation: Proven experience building and supporting E TL processes within SSIS, handling data transformation, and ensuring data quality between on-premises sources (e.g., SQL Server, PostgreSQL) and Snowflake.
SQL: Proficient in writing complex SQL queries to interact with SQL Server, PostgreSQL, and Snowflake, including advanced joins, subqueries, and optimizations for performance.
Snowflake: Strong knowledge of Snowflake architecture, features, and data loading techniques, including data types, tables, clustering, and performance tuning best practices in Snowflake.
Data Warehousing: Solid understanding of data warehousing concepts, including dimensional modeling, star/snowflake schemas, and the design of data pipelines.
Cloud Platforms: Familiarity with cloud services such as AWS, Azure, or
Google Cloud, especially in relation to Snowflake's cloud-native capabilities.
Performance Optimization: Experience optimizing SSIS packages, database queries, and data pipelines for performance, including clustering, partitioning, and leveraging caching mechanisms.
Version Control: Familiarity with version control tools (e.g., Git, TFS) to manage SSIS packages, database migration scripts, and deployment scripts.
Click on Apply to know more.