Senior Analytics Engineer designing scalable data models and optimizing data pipelines at Klar. Collaborating with cross - functional teams to ensure data quality and mentorship of business analysts.
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
Analytics Engineer Associate at Teragonia designing and developing advanced analytics for private equity clients. Collaborating closely with clients and team to deliver tailored solutions.
Engagement Manager leading a team of analytics engineers to develop advanced analytics solutions for private equity clients in Toronto. Driving value creation through innovative insights and strategic analytics.
Senior Analytics Engineer developing scalable analytics models for real - world health data. Leading strategic initiatives and mentoring teams in a hybrid environment in London.
Analytics Engineer making data an operational tool at Newsec's Göteborg office. Strengthening the use of data and collaborating closely with Product Managers.
Join knowmad mood as a Data Engineer / Analytics Engineer focusing on data processing for hotel business analytics. Collaborate within a mature data team on technological modernization strategies.
Senior Analytics Engineer at Simply Business designing data models and building infrastructure for AI and ML enhancement. Collaborating with engineering and product teams to integrate new data sources.
Data Analytics Engineer focused on building ETL pipelines and data models at Prodigy Finance. Working with AWS Redshift, Python, and SQL in a hybrid team.
Data Analytics Engineer driving innovative data solutions at Northern Trust. Collaborating on architecture, client satisfaction, and technology transformations with a global team in a hybrid role.
Analytics Engineer transforming raw data into actionable insights to support decision - making in data marketing. Working with various data technologies in a hybrid internship role in Paris.