Senior SQL - ETL Developer

Yesterday

Apply Now

Receive Emails with Similar Jobs

Concentrix

WebsiteLinkedInAll Job Openings

Renewals Management • Technical Support • Customer Care • Cross Channel Media • Sales and Marketing

10,000+

💰 Venture Round on 1995-01

Description

• 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

Requirements

• 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 • DB2 Database knowledge is a plus • Knowledge of Cloud Technologies is a plus

Benefits

• Enroll in many benefit programs, generally including private medical plans • Great compensation package • Retirement savings plans • Paid learning days • Flexible workplaces