What are the responsibilities and job description for the SQL AND ETL DEVELOPER position at capgemini?
We are seeking an experienced SQL and ETL Developer with over 7 years of experience to join our dynamic team. The ideal candidate will be responsible for designing, developing, and maintaining SQL databases and Extract Transform Load (ETL) jobs, ensuring data integrity, and optimizing performance. You will work closely with data analysts, data scientists, and other stakeholders to support data-driven decision-making within the organization.
Key Responsibilities:
Work with cross-functional teams to understand business requirements and translate them into technical specifications.
Plan and manage project delivery scope, sprint planning, task assignment to developers and tracking completion.
Create and maintain documentation for database designs, processes, and procedures, as defined by CHUBB engineering and architecture.
Design, develop, and maintain SQL databases and data models.
Write complex SQL queries for data extraction, transformation, and loading (ETL).
Optimize SQL queries and database performance.
Ensure data integrity and security across all databases.
Troubleshoot and resolve database issues and performance bottlenecks.
Ability to work independently and Support Team members in a team-oriented, collaborative environment
Stay updated with the latest industry trends and technologies related to SQL and database management.
Must-Have Skills:
7 years of experience in SQL development and database management.
Excellent communication and collaboration skills.
Proficiency in writing complex SQL queries, stored procedures, and functions.
Strong understanding of database design principles and data modeling.
Experience with performance tuning and optimization of SQL queries.
Experience with Microsoft SQL Server 16 and above versions, and Azure SQL Database.
Experience with development of ETL jobs in SSIS
Knowledge of ETL processes and tools.
Experience with data warehousing concepts and practices.
Strong analytical and problem-solving skills.
Nice-to-Have Skills:
Experience with cloud-based database solutions (e.g., Azure SQL Database, Azure Synapse, Snowflake).
Experience with Informatica Intelligent Cloud Services (IICS)
Experience with data visualization tools (e.g., Power BI).
Knowledge of programming languages such as Python, or Java.
Knowledge of .Net programming.
Understanding of data governance and compliance standards.
Familiarity with Agile methodologies and project management tools.
Familiarity with NoSQL databases (e.g., MongoDB, Cassandra).
Education:
Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
The pay range that the employer in good faith reasonably expects to pay for this position is $34.67/hour - $54.18/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.
Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.
Salary : $35 - $54