C2C - Hiring || SQL and ETL Lead Developer || Chicago, IL (Hybrid Onsite- Need Local)

Hi, Hope you're doing well. My name is Yashasvi, and I am a Team Lead from Empower Professionals Inc. We are sourcing for a SQL and ETL Lead Developer role in the client's Chicago, IL (Hybrid Onsite) and it is a long-term contract for at least 12 months and can be extended further as well. Role: SQL and ETL Lead Developer Locations: Chicago, IL (Hybrid Onsite) Duration: 12+ Months Contract Note: Candidate needs to be in the office 3-4 Days every week. Local or candidates from adjacent states only. Job Description: • 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). Thanks Yashasvi Hasija Team Lead | Empower Professionals ...................................................................................................................................... Yashasvi@empowerprofessionals.com | Phone: 732-356-8008 x 368 | Fax: 732-356-8009 LinkedIn: linkedin.com/in/yashasvi-hasija-6a745625b 100 Franklin Square Drive – Suite 104 | Somerset, NJ 08873 www.empowerprofessionals.com To subscribe or unsubscribe: https://send.empowerprofessionals.com/newsletter/subscribe/647186e8-bcb0-4f73-8f80-cb3daff9ad90