Senior SQL/ETL Developer

Job Title:

Senior SQL/ETL Developer

Job Description

We’re Concentrix. A new breed of tech company — Human-centered. Tech-powered. Intelligence-fueled. We create game-changing solutions across the enterprise, that help brands grow across the world and into the future. We are trusted by clients across all major sectors, from up-and-coming success stories to iconic Fortune Global 500 brands in over 70 countries spanning 6 continents.



Our game-changers:



* Challenge Conventions



* Deliver outcomes unimagined



* Create experiences that go beyond WOW



If this is you, we would love to discuss career opportunities with you. In our Concentrix Catalyst team, you will work with the engine that powers the experience design and engineering capabilities at Concentrix. A leading global solutions company that reimagines everything CX through strategy, talent, and technology. We combine human-centered design, powerful data, and strong tech to accelerate CX transformation at scale. You will be surrounded by the best in the world providing market leading technology and insights to modernize and simplify the customer experience. Within our professional services team, you will deliver strategic consulting, design, advisory services, market research, and contact center analytics that deliver insights to improve outcomes and value for our clients. Hence achieving our vision.



Concentrix provides eligible employees with an opportunity to enroll in many benefit programs, generally including private medical plans, great compensation package, retirement savings plans, paid learning days, and flexible workplaces. Specific benefits plans will vary by country/region.



We’re a remote-first company looking for the absolute best talent in the world. Experience the power of a game-changing career.

#LI-Onsite

Responsibilities:

Data Extraction:

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

•                     Utilize SQL queries to retrieve and manipulate data as needed.

Data Transformation:

•                     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.

Data Loading:

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

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

ETL Process Development:

•                     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.

Database Management:

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

•                     Optimize SQL queries for performance and efficiency.

Data Quality Assurance:

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

•                     Identify and resolve data discrepancies and inconsistencies.

Documentation:

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

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

Collaboration:

•                     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.

Performance Tuning:

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

•                     Monitor system performance and make recommendations for enhancements.

Troubleshooting and Support:

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

•                     Respond to data requests and provide insights as needed.

Staying Updated:

•                     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.

Qualifications:

•                     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

•                     DB2 Database knowledge is a plus

•                     Knowledge of Cloud Technologies is a plus

#LI-Onsite

#ConcentrixCatalyst

Location:

USA, KS, Work-at-Home

Language Requirements:

Time Type:

Physical & Mental Requirements: While performing the duties of this job, the employee is regularly required to operate a computer, keyboard, telephone, headset, and other office equipment. Work is generally sedentary in nature.

If you are a California resident, by submitting your information, you acknowledge that you have read and have access to the Job Applicant Privacy Notice for California Residents

Concentrix is an Equal Opportunity/Affirmative Action Employer including Disabled/Vets.

For more information regarding your EEO rights as an applicant, please visit the following websites:

•English

•Spanish

To request a reasonable accommodation please click here.

If you wish to review the Affirmative Action Plan, please click here.