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 e