Job Description
SQL AND ETL DEVELOPER
Capgemini - 3.7 Chicago, IL Job Details Contract $34.67 - $54.18 an hour 8 hours ago Benefits Health insurance Dental insurance Vision insurance Retirement plan Qualifications Data model design Azure SQL Database Commercial use (data warehousing systems) Performance tuning Data Integration (Data management) Cloud data warehouses Data modeling projects Data retrieval time improvement Schema design Stored procedures System tuning Cross-functional communication Full Job Description Chicago, IL, United States (On-site) Contract (6 months 10 days) Published 9 hours ago sql development performance tuning data modeling data warehousing Azure SQL database Reporting & Analytics ETL Development database design Programming & Development 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.
