Are you ready to work with a team of like-minded leaders who both challenge and support you? If so, this is a great time to join our winning team! In 2021, CSpring was named a “Best Place to Work” by the Indiana Chamber and a “Top Workplace” by the Indy Star.
Our Data & Analytics team has an immediate opening for a full-time, Jr. ETL Developer. If the idea of working on challenging assignments with a team who is passionate about serving others and creating insights sounds exciting, this may just be the role you’ve been looking for!
Our consultants participate in meaningful projects that have an impact locally, nationally, and globally. As a CSpring Consultant, you will work with a team to develop state of the art solutions to business problems. You will interact with our clients and project teams, leverage your business and technical skills, discuss solutions with team members, and analyze client needs to develop important solutions. You will be a true partner to our clients, dedicated to making each client a raving fan.
____________________________________________________________________
**This role can be performed remotely but perference will be given to candidates who can work onsite in Springfield, IL.
Responsibilities:

• Use Informatica PowerCenter to Extract, Transform, and Load (ETL) source data from agency sources, applying numerous transformations to the data that are required, applying corrections to the source files and the addition to the EDW of any new fields requested via the change request process
• Automate the staging of data by scheduling scripts to run at optimal times enhancing overall system performance and efficiency
• Create, maintain, and support an ETL/Informatica architectural and system environment for development and production
• Perform domain/repository backups and recovery operations
• Implementing ETL jobs by creating mappings, mapplets, sessions, and workflows
• Working with different ETL transformations including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter
• Scheduling and monitoring ETL/Informatica jobs in a development, system testing, and production environment
• Developing proactive processes for monitoring capacity and performance tuning
• Supporting and advising the development teams on technical issues
• Troubleshoot production support issues post release deployment and come up with solutions
• Developing and maintaining complex SQL queries and/or scripts used to create data marts in Teradata
• Participating in project discussions to document and recommend alternative technical solutions or requirements
• Participating in unit, integration, and system testing
• Maintaining effective communication and relationships with all individuals involved with the project
• Learning new technologies as needed to be able to perform job duties effectively
• Providing status progress and meeting deliverables to leadership and to customers

Qualifications:

• Informatica PowerCenter / ETL Experience
• Complex SQL and Performance Tuning Experience
• Teradata Version 14+ experience including Teradata Utilities
• ETL / Informatica PowerCenter administrative experience
• Excellent verbal/written communication skills, end-client facing, team collaboration, and mentoring skills
• Strong organization skills and ability to set priorities and schedule work deadlines.
• Bachelors or Advanced Degree in a related field such as Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business

Preferred Skills:

• Data Warehouse experience
• Experience in Reporting/Analytics tool shall be a plus (SAP BO, Tableau, SAS, PowerBI)
• Experience in Windows, Unix/Linux scripting, R, or Python
• Experience in Informatica Data Quality (IDQ), Address Doctor, Metadata Manager
• Experience with State Medicaid / Medicare / Healthcare applications
• ETL/Informatica or SQL or BI or Teradata Certification
• Experience working in Agile
• Experience with Data Warehouse technologies within the domain of ETL/data integration, Business Intelligence, relational and multi-dimensional database systems

About CSpring:
CSpring is a growing, Indianapolis-based technology consulting firm focused on data-driven solutions. Our team aligns business goals with technology to make information accessible, reliable, and engaging via custom and integrated software, data platforms, and advanced analytics.
If you are committed, collaborative, consultative, and caring – you will fit right in with our team. We pride ourselves in working together and understand that the whole is stronger than any one of us individually. When you join CSpring, you become part of our family - our Ohana. When you're a part of our Ohana, we promise to communicate well, provide opportunities for growth, and most importantly, celebrate our successes together. Being part of CSpring’s Ohana means you will be informed, recognized, rewarded, and respected. You will also have lots of opportunity to develop strong relationships with our team at quarterly company update events, monthly outings, community service opportunities, learning lunches, and more.
CSpring offers a comprehensive compensation, training, and benefits package, including Paid Time Off, Medical/Dental/Vision/Life/Disability insurance on day one, and 401(k) with company match.
This position is not open to candidates residing in the state of Colorado.

Job Type: Full-time