Job Description
Role: Technical Lead
Location: Chicago, IL (3 Days onsite/week)
Job Description:
Looking for a seasoned Data Warehousing and Snowflake ETL Specialist. The ideal candidate will have a proven track record of designing, developing, and implementing robust data warehouse solutions, with a strong emphasis on Snowflake, ETL tools, and secure data management. This role is ideal for professionals with diverse industry exposure, including Banking, Finance, Property & Casualty Insurance, and Media.
Key Responsibilities
• Design, develop, and implement Data Warehouse applications, focusing on transformation processes using ETL tools such as Informatica and SAP BODS.
• Automate scheduling for delta loads in Snowflake, ensuring efficient data updates and minimal downtime.
• Manage and secure data by creating standard and secure views in Snowflake.
• Configure user roles, navigation, and database objects in Snowflake; manage Virtual Warehouse creation and configuration.
• Efficiently load and query CSV and JSON data using COPY/INSERT, PUT, and GET commands from internal and external stages.
• Integrate data into Snowflake Raw and Prep layers using External Tables, Streams, and Tasks.
• Build SnowPipes, Tasks, and Streams; implement CDC (Change Data Capture) by task polling on streams.
• Work with various Snowflake table types: Permanent, Transient, Temporary, External, Dynamic, Event, and Hybrid Tables.
Experience: 5-8 Years .
The expected compensation for this role ranges from $60,000 to $135,000 .
Final compensation will depend on various factors, including your geographical location, minimum wage obligations, skills, and relevant experience. Based on the position, the role is also eligible for Wipro's standard benefits including a full range of medical and dental benefits options, disability insurance, paid time off (inclusive of sick leave), other paid and unpaid leave options.
Applicants are advised that employment in some roles may be conditioned on successful completion of a post-offer drug screening, subject to applicable state law.
Wipro provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. Applications from veterans and people with disabilities are explicitly welcome.
Reinvent your world. We are building a modern Wipro. We are an end-to-end digital transformation partner with the boldest ambitions. To realize them, we need people inspired by reinvention. Of yourself, your career, and your skills. We want to see the constant evolution of our business and our industry. It has always been in our DNA - as the world around us changes, so do we. Join a business powered by purpose and a place that empowers you to design your own reinvention.