Programmer / ETL Developer (SQL, Python, SSIS)

Programmer/ETL Developer Orange County, CA Direct Hire with our Client Job ID 2 Remote or onsite if local Solugenix is assisting a clie...

Programmer/ETL Developer

Orange County, CA

Direct Hire with our Client

Job ID 2

Remote or onsite if local

Solugenix is assisting a client, a prestigious Large Insurance Company, in their search for a Programmer/ETL Developer. This is a direct-hire opportunity based out of Orange County, CA.

The Programmer/ETL Developer will be responsible for implementing modern ETL pipelines and automated data flows to populate the data warehouse and streamline legacy data flow processes. Manage multiple projects with internal business partners and external parties. Provide input/suggestions to implement operational and service improvements to support the business and Data Warehouse team.

Qualifications:

• Bachelor's degree in Computer Science or Engineering
• 3-5 years of experience in a SQL ETL/Python related position
• Specific Skills/Knowledge:
  • T-SQL Server.
  • Python experience automating data flows.
  • Pandas library required.
  • Database experience, including knowledge of SQL (SQL Server, MySQL, PostgreSQL) NoSQL.
  • Knowledge of data flows through web APIs and web services.
  • Experience with Source Control and DevOps is a huge plus.
• Develop and maintain ETL/ELT packages using SQL Stored Procedures, SSIS, and python for OLTP, OLAP, and unstructured data services.
• Work with the Enterprise Data Warehouse (EDW) team, developing and maintaining data models to support corporate reporting needs.
• Strong T-SQL skills, writing and optimizing queries, stored procedures, and scheduling jobs.
• Create custom python automation to automatically process data from different sources (Ex: FTP sites, external websites).
• Experience or inclination to develop OLAP cubes is a huge plus.
• Participate in the agile/scrum process and meet goals.

About the Client

Our client is one of the world's leading large Insurance company is based out of Orange County, CA.

About Solugenix

For over 50 years, Solugenix has been a global technology development and services firm with locations in California, Arizona, India, and the Dominican Republic. As a pioneer in Professional Staffing and IT Consulting, we have partnered with some of the biggest global corporations across many industries. Our history was built on a foundation of partnerships with global brands like McDonald's, Microsoft, CIT Group, Johnson & Johnson, Herbalife, Sony Pictures Entertainment, and many others who look to Solugenix to be their trusted partner in providing professional staffing, non-IT, and IT solutions.

We live our core values in everything that we do, starting with "doing the right thing" for our employees/contractors and "committing to client success". This is a big part of how we continue to make lists like " 2019 Forbes Small Giants ". We also forge strategic partnerships with vendors and corp-to-corp candidates (C2C) that share our core values and encourage you to partner with us.

In addition to generating ground-breaking, industry-defining solutions for our clients and our own projects, we partner with clients with whom we share core values and a common professional culture to help them find talent for their valuable opportunities. At Solugenix, we invest in the personal development and growth of every individual. While this is a position with one of our esteemed clients, Solugenix will continue to invest in your personal growth and development, providing you with a successful career as well as ensuring client success .