Job Description
Lead the migration of data assets and workloads from a shared Snowflake environment to a new dedicated Snowflake platform while ensuring performance, security, and scalability. Design, develop, and support data pipelines using Informatica IDMC/IICS, DBT, Python, and AWS services including S3, Glue, Lambda, and DMS. Partner with engineering teams, architects, and leadership to provide project updates, troubleshoot issues, implement enhancements, and support ongoing platform maintenance. Act as a technical leader by mentoring junior and mid-level engineers, driving best practices, and evaluating new capabilities such as Snowflake Cortex AI and Openflow integrations.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
• 8-10+ years in Informatica/Data Engineering (real senior person and/or tech lead kinda)
• Strong Snowflake Admin// has to be SnowPro certified (would love a Snowpro cert)
• Strong UNIX/LINUX admin and shell scripting skills
• Experience with DBT (Data Build Tool)
• Experience in ETL tool Informatica Data Management Cloud (IDMC)/ IICS 🡪 NEED
• Informatica Experience (need good experience with) 🡪 NEED
• Programming In Python
• Experience in AWS services like DMS, S3, Glue, Lambda
• Culture fits // very nice and work hard and trains Jr/Midlevel folks and deals with management updates daily
• Migrating from existing shared snowflake environment to new one
Handling future maintenance of this as well
• Knowledge and ability to work with Cortex AI
• How to integrate with AWS for network capabilities
• Setting up connectivity to Openflow (would be big Plus if they have – its new)
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.