Job Information
Concentrix Senior SQL/ETL Developer in Wichita, Kansas
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, Wichita, KS
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 (https://www.concentrix.com/resource/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 (https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12.pdf)
•Spanish (https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRightsSp6.12.pdf)
To request a reasonable accommodation please click here (https://jobs.concentrix.com/global/en/reasonable-accomodation) .
If you wish to review the Affirmative Action Plan, please click here (https://jobs.concentrix.com/global/en/affirmative-action) .