Design and deliver advanced analytics solutions within Salesforce. Transform raw data into actionable insights, supporting key business operations and strategic goals.
About the role
- Informatica ETL Developer responsible for designing, developing, and maintaining ETL processes. Joining the Enterprise Data Warehouse team to support healthcare-related data systems.
Responsibilities
- Design and implement ETL solutions using Informatica PowerCenter to extract, transform, and load data from various agency sources.
- Automate data staging processes and optimize ETL job scheduling for performance and efficiency.
- Administer and support ETL environments, including development and production systems.
- Perform repository backups, recovery operations, and system maintenance.
- Develop mappings, mapplets, sessions, and workflows using a wide range of Informatica transformations.
- Monitor and troubleshoot ETL jobs across development, testing, and production environments.
- Write and optimize complex SQL queries and Unix Shell scripts for data marts and interfaces in Teradata.
- Collaborate with stakeholders to define requirements, document technical solutions, and support project planning.
- Participate in unit, integration, and system testing.
- Provide technical support, mentoring, and guidance to team members.
- Communicate project status and deliverables to leadership and clients.
- Continuously learn and apply new technologies to enhance system performance and capabilities.
Requirements
- 7+ years of experience with Informatica PowerCenter and ETL development.
- 5+ years of experience writing complex SQL and performance tuning.
- 5+ years of experience with Enterprise Relational Database Management systems (Teradata, DB2, Oracle, or SQL Server)
- 5+ years of Informatica PowerCenter administration experience.
- Strong communication, collaboration, and mentoring skills.
- Bachelor’s or advanced degree in IT, Computer Science, Mathematics, or a related field.
- Strong organizational and time management skills.
Benefits
- Telecommute (with occasional travel to Springfield, IL, two to three times per year)
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Senior Analytics Engineer transforming raw data into actionable insights for business teams. Collaborating across departments to deliver analytics solutions and ensure data quality.
Intern in Revenue Operations at CloudTalk analyzing sales and customer data for insights. Collaborating with teams for reporting and dashboard creation to support decision - making.
Analytics Developer at Intact Lab employing machine learning and data science. Collaborating with IT teams on projects to enhance customer experience in the insurance sector through analytics.
Lead ETL Architect developing, testing, and deploying solutions at S&P Global. Collaborating with teams and optimizing data processes in an environment focused on essential intelligence.
Analytics Engineer at UK's premier publisher assisting data - driven insights for customer understanding. Bridging gap between data engineering and analytics with clean, reliable data access.
Analytics Engineer designing and developing software solutions for complex data at OCLC. Collaborating with teams to enhance data access and analytics capabilities.
Analytics Engineer enabling data - driven decisions across clinical and operational functions at QualDerm Partners. Responsible for data collection, analysis, visualization, and stakeholder collaboration.
Lead Digital Analytics Engineer driving modernization of site analytics and data layer for multi - brand ecommerce. Architecting a unified measurement foundation and collaborating with various stakeholders across the organization.
SAP Analytics Developer managing and delivering SAP BW/BI solutions for Niterra. Collaborating with stakeholders to optimize business intelligence and data warehousing capabilities.