Informatica ETL Developer_Remote in WI, IL

1 month ago

Madison, United States Beacon Hill Full time

Informatica ETL Developer (Remote, but must reside in Wisconsin, Illinios or Iowa)

JOB SUMMARY:

We are currently looking for an ETL Developer that works directly with business users to develop data pipelines from source applications to corporate data platforms (Data Warehouse/Lake) and optimize analytic solutions. This position will utilize Informatica development tools to create integrations or modify current integrations for various projects that are handed off to the Data and Analytics Services group.

ACCOUNTABILITIES

These accountabilities are not intended as a complete list of specific duties and responsibilities and does not limit or modify the right of any supervisor to assign, direct, and control the work of employees assigned to this job.

Primary Accountabilities

*Develops scalable, innovative solutions for extracting, transforming, and moving data.

*Performs data profiling and data analysis to assist in understanding the data.

*Optimizes data models through normalization, table analysis and review of queries.

*Presents outcomes of analytic models in a format easily understood by the business.

*Performs ETL/ELT functions for new or existing sources.

*Conducts requirements gathering with business stakeholders and users to plan a roadmap of project activities.

*Works with the business to assess the validity of the data and achieve minimum levels of quality.

*Gathers and compiles data using various data collection techniques in response to data requests.

*Creates code or GUI data mappings while following company data standards and approaches.

*Collaborates with others responsible for pipeline development. Supervision QUALIFICATIONS The requirements listed below are representative of the experience, knowledge, skills and/or abilities required to perform this job. Educational Requirements Education Level Field of Study Required/Preferred Bachelor's Degree Emphasis in CIS, Software Development, analytics, operations research, computer science or other applicable field

Required Experience

*5 years of direct experience in a related field (coding, ETL Development/Engineering, analytics, or research) *Experience with Informatica ETL/ELT tools, specifically PowerCenter, BDM/DEI, IICS products *Experience working with Snowflake and Snowpark

* Experience in developing data pipelines utilizing Python *Direct experience working with source APIs into a big data environment *Proficiency in SQL required.

Preferred Experience

*Data Modeling experience utilizing Erwin Data Modeling tool *Experience with Tidal Job Scheduling Software *Development experience with DBT *CI/CD Experience


Beacon Hill is an Equal Opportunity Employer that values the strength diversity brings to the workplace. Individuals with Disabilities and Protected Veterans are encouraged to apply.


If you would like to complete our voluntary self-identification form, please click here or copy and paste the following link into an open window in your browser:


Completion of this form is voluntary and will not affect your opportunity for employment, or the terms or conditions of your employment. This form will be used for reporting purposes only and will be kept separate from all other records.


Company Profile:


Beacon Hill Technologies, a premier National Information Technology Staffing Group, provides world class technology talent across all industries utilizing a complete suite of staffing services. Beacon Hill Technologies' dedicated team of recruiting and staffing experts consistently delivers quality IT professionals to solve our customers' technical and business needs.


Beacon Hill Technologies covers a broad spectrum of IT positions, including Project Management and Business Analysis, Programming/Development, Database, Infrastructure, Quality Assurance, Production/Support and ERP roles.


Learn more about Beacon Hill Staffing Group and our specialty divisions, Beacon Hill Associates, Beacon Hill Financial, Beacon Hill HR, Beacon Hill Legal, Beacon Hill Life Sciences and Beacon Hill Technologies by visiting


We look forward to working with you.


Beacon Hill. Employing the Future (TM)

  • WI Resident Informatica Technical Architect 4

    2 weeks ago

    Madison, United States Sundial Software Full time

    The State of Wisconsin is looking for a Technical Architect IV Top Skills (3) & Years of Experience: -3+ years of experience in Analysis, Design, Development, Implementation, Testing and Support of Data Integration Solutions using Informatica Intelligent Cloud Services (IICS) -3+ years of experience developing ETL integrations -3+ years of experience...

  • IICS (Informatica Intelligent Cloud Services) Architect with AWS ::: Madison WI

    2 weeks ago

    Madison, United States REDLEO SOFTWARE INC. Full time

    This role will primarily focus on analyzing, developing, implementing, Testing, and Supporting Data Integration Solutions using Informatica Intelligent Cloud Services (IICS), ideally on the AWS platform. Sample responsibilities:Mentor team on creating and implementing Informatica Intelligent Cloud Services (IICS) integrations.Contribute to IICS integration...

  • Informatica IICS Architect

    2 weeks ago

    Madison, United States Talent Groups Full time

    13+ years of experience with 3+ years of experience in Analysis, Design, Development, Implementation, Testing and Support of Data Integration Solutions using Informatica Intelligent Cloud Services (IICS).3+ years of experience developing ETL integrations -3+ years of experience implementing batch and real-time (event-based and API) data integration...

  • ETL Developer

    1 month ago

    Madison, United States Creative Financial Staffing Full time

    ETL DEVELOPER PERMANENT | NO SPONSOERSHIP AVAILABLE ABOUT OUR CLIENT Our client is a leading-edge technology company at the forefront of data management solutions, driving innovation in the field of information technology. Committed to fostering a culture of growth and development, they empower their employees to excel in a collaborative environment that...

  • Technical Architect IV

    2 weeks ago

    Madison, United States Vision It US Full time

    Job DescriptionJob DescriptionCandidates MUST be WI residents or willing to relocate to WI at their own expense prior to starting. This position can work 100% remotely (within the state of WI).UW-Madison's Division of Information Technology - Enterprise Business Systems is looking for an Informatica Intelligent Cloud Services (IICS) consultant with...

  • Senior Data Engineer

    2 weeks ago

    Madison, United States Alliant Energy Corporation Full time

    Alliant Energy is seeking a Senior Data Engineer (Snowflake/ Informatica) to play a crucial role in advancing the data and analytics practices within the organization. In this role, you will lead the design, development, implementation, enhancement, and maintenance of data pipelines across multiple technology platforms. Your expertise in Snowflake,...

  • Data Warehouse Developer

    2 weeks ago

    Madison, Wisconsin, United States Focused HR Solutions Full time

    Focused HR Solutions is seeking a skilled and experienced Data Warehouse Developer to join our client's team in Madison, WI.This is an 8-month contract position with the possibility of extension. We are open to both W2 and Corp-to-Corp arrangements.Responsibilities:Design, develop, and maintain data warehouse solutions using Informatica tools.Collaborate...

  • Senior Data Engineer

    2 weeks ago

    Madison, United States Alliant Energy Full time

    Bring YOUR energy to Alliant Energy! At Alliant Energy, our purpose is to serve customers and build stronger communities. We are passionate about powering beyond the market challenges of today, while powering what's next in energy. When our employees say "I am energy", it means they take pride in the work we do when disaster strikes, as well as all the days...

  • AWS platform engineer

    7 days ago

    Madison, United States Chelsoft Solutions Co Full time

    Job DescriptionJob DescriptionSpecialized Knowledge and Skills:Demonstrated experience with AWS services, including, but not limited to KSM, Glue catalog, Athena, IAM, S3, Logging (EMR, EC2 and RDS) Solid knowledge and understanding of multiple IT subject areas (e.g. development, configuration, deployment, testing, configuration, deployment, monitoring...

  • Database Management

    5 days ago

    Madison, United States People Link - TeamSoft Full time

    Job DescriptionJob DescriptionDatabase Management and Analytics AdminTeamSoft IT Solution’s client is looking for a contract-to-hire Database Management and Analytics Admin. This position is located in Greater Madison or La Crosse, WI, or can be fully remote. Database Management and Analytics Admin Job Summary:Administer and maintain data management,...

  • Data Warehouse Developer I

    3 months ago

    Madison, United States Information Resource group, Inc. Full time

    Job DescriptionJob DescriptionIRG is needing Data Warehouse Developer Location Madison WI Duration: 3 Years To apply send resume to ahague@irginc.net The candidate will be responsible for assisting in ETL design, development, testing, maintenance, metadata, and implementation of data warehouse initiatives. Understand user requirements, and implement...

  • Senior Data Engineer

    2 weeks ago

    Madison, United States RIT Solutions, Inc. Full time

    Senior Data EngineerMadison, WI Primary Skills API,Python,SQL Required Skills Job Description Client is seeking a Senior Data Engineer (Snowflake/ Informatica) to play a crucial role in advancing the data and analytics practices within the organization. In this role, you will lead the design, development, implementation, enhancement, and maintenance of...

  • Platform Engineer

    2 weeks ago

    Madison, United States Intelliswift Full time

    Job Title: Platform Engineer Location: Remote Duration: 6 months Contract Type: W2 only Pay Rate: $50-$60/Hour Job Description This position will be responsible for configuring, deploying, and maintaining data services capabilities, including Service Catalog EMR Clusters, GDC Sync Checkouts, EMR Clusters, Attunity Jobs, Informatica Servers, and Aurora...

  • Platform Engineer

    2 weeks ago

    Madison, United States Intelliswift Full time

    Job ID: 24-04758 Job Title: Platform Engineer Location: Remote Duration: 6 months Contract Type: W2 only Pay Rate: $50-$60/Hour Job Description This position will be responsible for configuring, deploying, and maintaining data services capabilities, including Service Catalog EMR Clusters, GDC Sync Checkouts, EMR Clusters, Attunity Jobs,...

  • Data Warehouse Developer

    1 week ago

    Madison, Wisconsin, United States Focused HR Solutions Full time

    About the Role We are seeking a skilled Data Warehouse Developer to join our client's team in Madison, WI. This is a fully remote position with an initial duration of up to 13 months, offering the possibility of extension. Responsibilities: Collaborate with stakeholders to gather requirements and develop technical specifications for ETL processes. Design...

  • LU - Data Warehouse Developer

    3 months ago

    Madison, United States Focused HR Solutions Remote Work Freelance Full time

    100% remote. Our direct client has an opening for an   Data Warehouse Developer 129720.This position is for up to 13 months with the option of extension, and the client is in Madison, WI.    Alteryx experience related to ETL, as many had experience based more on data prep. The manager is also looking for candidates with strong and recent SQL skills....

  • Physician- Geriatrics/Skilled Nursing Facility Program- Monroe Medical Group- Southern WI

    1 month ago

    Madison, Wisconsin, United States SSM Health Full time

    Physician- Geriatrics/Skilled Nursing Facility Program- Monroe Medical Group- Southwestern WI & Northern IL MarketsSSM Health Monroe Clinic Medical Group in Monroe is actively recruiting a flexible, part-time (.6 fte) Geriatrics/Skilled Nursing Facility Program Physician. This position is located in the Monroe area, and offers the opportunity to collaborate...

  • Public Health Researcher

    4 weeks ago

    Madison, United States Spherion-South Central WI & Northern IL Full time

    Salary: Market relatedReference: S_155885Spherion, in partnership with a local university and the Department of Health Services, Division of Medicaid Services, is providing staff support for the Department’s work on the National Core Indicators surveys, which supports the Department’s efforts to increase the number of youth and adults with disabilities...

  • Part-Time Nights + Weekends, Eastside Madison, WI

    4 weeks ago

    Madison, United States Options In Community Living Inc. Full time $10 - $17

    Job DescriptionJob DescriptionPart-Time Nights + Weekends, Eastside Madison, WI$17.25/hr; $10/hr overnight: Paid to sleep!Staff must be approved to drive an agency vehicle (except overnight)Staff must be 18 years old to work for OptionsPart-Time Positions:Tuesday + Friday 3pm-9pm, $17.25/hrEvery other Saturday and Sunday 10pm-8am, asleep overnightPaid time:...

  • Part-Time Nights + Weekends, Eastside Madison, WI

    1 month ago

    Madison, United States Options In Community Living Inc. Full time

    Job DescriptionJob DescriptionPart-Time Nights + Weekends, Eastside Madison, WI$17.25/hr; $10/hr overnightStaff must be approved to drive an agency vehicle (except overnight)Staff must be 18 years old to work for OptionsPart-Time Positions:Tuesday + Friday 3:00pm-9:30pm, $17.25/hrEvery other Saturday and Sunday 10:00pm-8:00am, asleep overnightPaid time:...