200+ applicants

Company

Concentrix Catalyst · 2 days ago

Senior SQL/ETL Developer

United States

Full-time

Remote

Senior Level, Lead/Staff

8+ years exp

Maximize your interview chances

Cloud ManagementConsulting

Insider Connection @Concentrix Catalyst

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Extract data from various sources, including databases, flat files, APIs, and other data repositories.

Utilize SQL queries to retrieve and manipulate data as needed.

Design and implement data transformation processes to clean, aggregate, and format data for analysis.

Apply business rules and logic to ensure data accuracy and integrity during the transformation process.

Load transformed data into target databases, data warehouses, or data lakes.

Ensure efficient data loading processes to optimize performance and minimize downtime.

Develop, test, and maintain ETL workflows using ETL tools (e.g., Informatica, Talend, SSIS).

Monitor ETL processes to ensure they run smoothly and troubleshoot any issues that arise.

Design and maintain database schemas, tables, and indexes to support data storage and retrieval.

Optimize SQL queries for performance and efficiency.

Implement data quality checks and validation processes to ensure the accuracy and reliability of data.

Identify and resolve data discrepancies and inconsistencies.

Create and maintain documentation for ETL processes, data models, and database structures.

Document data flow diagrams and data lineage for better understanding and compliance.

Work closely with data analysts, data scientists, and business stakeholders to understand data requirements and deliver solutions that meet their needs.

Collaborate with IT and data engineering teams to ensure data integration aligns with overall architecture.

Analyze and optimize ETL processes and SQL queries for performance improvements.

Monitor system performance and make recommendations for enhancements.

Provide support for data-related issues and assist in troubleshooting data discrepancies.

Respond to data requests and provide insights as needed.

Keep abreast of industry trends, tools, and best practices in data management and ETL development.

Participate in training and professional development opportunities to enhance skills.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQL Server developmentETL developmentVB.NETSSISPower Shell ScriptDB2 Database knowledgeCloud TechnologiesData transformationStored ProceduresPerformance Monitoring

Required

Minimum of 8+ years in information technology

Minimum education: Bachelors Degree

Minimum of 5+ years with VB.NET (Windows Form/EXE development, WCF Service), MS SQL Server development skills (Relational modeling, Stored Procedures, Performance Monitoring/Analysis)

Hands on experience with: Power Shell Script, SSIS (SQL Server Integration Services, Data transformation (ETL) and Stored procedures

2+ years with SQL Server development

SSIS, Power Shell