Carex is partnering with a Madison based partner to find an experienced Informatica Cloud ETL Developer. This role focuses on developing and optimizing data pipelines to support corporate data platforms, leveraging tools like Informatica, SQL, and Python. The ETL Developer will play a critical role in ensuring data quality, modeling efficiency, and the integration of analytic solutions.
What You’ll Do
- Develop scalable, innovative solutions for extracting, transforming, and moving data.
- Perform data profiling and analysis to enhance understanding and usability of datasets.
- Optimize data models using techniques such as normalization and table analysis, and review queries for efficiency.
- Present analytic model outcomes in business-friendly formats.
- Perform ETL/ELT processes for new and existing data sources.
- Conduct requirements gathering with business stakeholders to develop project roadmaps.
- Collaborate with the business to validate data quality and achieve baseline standards.
- Collect and compile data in response to ad hoc requests using various techniques.
- Create and maintain data mappings using code or GUI tools while adhering to established standards.
- Collaborate with pipeline developers and other team members on project initiatives.
What You’ll Bring
- Educational Requirements:
- Bachelor’s Degree in Computer Information Systems, Software Development, Analytics, Operations Research, Computer Science, or a related field.
- Required Experience:
- Minimum of 5 years of experience in a related field such as ETL Development/Engineering, analytics, or coding.
- Proficiency with Informatica ETL/ELT tools, including IDMC/Informatica Cloud, PowerCenter, and BDM/DEI products.
- Advanced SQL skills.
- Experience with the Snowflake Data Platform.
- Working knowledge of Python for ETL/ELT pipeline development.
- Preferred Experience:
- Experience integrating data from diverse sources such as APIs, Oracle, SQL Server, and flat files.
- Data modeling experience using tools like Erwin Data Modeler.
- Familiarity with Tidal Job Scheduling Software.
- Experience with Workday or HR domain data.
Carex Consulting Group is an equal opportunity employer. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, marital status, disability, gender identity, or Veteran status.
#LI-WR1