ETL Developer

2 weeks ago

Austin, United States Assyst Full time
ASSYST is seeking a highly skilled ETL Developer with expertise in Informatica IICS, IDMC, or Power Center to support our client in Austin, Texas.

This role involves designing, developing, and maintaining ETL processes for data acquisition, transformation, and integration to support enterprise-level data solutions. The ideal candidate will have a strong background in working with diverse data sources and developing performant ETL workflows, SQL scripts, and data models, as well as supporting data visualization tools such as Tableau.

Job type: Contract (Corp to Corp/C2C or 1099)
Job Location: Austin, Texas (Hybrid)

Please Note: Position will be 3 days remote with 2 day (Wednesday and Friday) required to be onsite at Austin, TX. Program will only accept local candidates for this position.

Responsibilities:
  • Develop mappings and workflows to automate ETL processes using Informatica IICS, IDMC, or Power Center.
  • Automate data acquisition and integration from multiple data sources, including Snowflake, Oracle, SQL Server, Excel, Access, and Adobe PDF.
  • Transform source data to fit into a dimensional model and create efficient database views/materialized views in Oracle.
  • Work with the Data Engineering Team to design and implement optimal data models and acquisition strategies.
  • Collaborate with architects and team members to implement designs, resolve technical problems, and validate solutions.
  • Participate in requirements and design sessions to interpret and address new business needs.
  • Design and develop complex, fast, and efficient SQL scripts to transform and integrate data.
  • Verify and validate SQL scripts, database views, and ETL workflows.
  • Develop automated solutions for testing, verification, and validation.
  • Actively participate in Agile sprint ceremonies, including backlog grooming, sprint planning, and retrospectives.
  • Utilize Agile methodologies to deliver iterative solutions.
  • Use tools like JIRA to manage sprint tasks and progress.
  • Enhance and maintain a Java-based web application providing Tableau dashboards.
  • Design and implement mockups for user validation.
  • Develop dashboards and reports using Tableau, connecting to external data sources.
  • Produce and maintain technical documentation, diagrams, and specifications.
  • Support and enhance the data integration hub infrastructure.
  • Assist with the implementation and configuration of development tools.

Requirements:
  • Bachelor's degree in Computer Science, Information Systems, Business, or equivalent experience.
  • 8+ years of experience developing ETL mappings and workflows using Informatica IICS, IDMC, or Power Center.
  • Strong SQL scripting skills and experience designing efficient, complex SQL scripts.
  • Proven experience acquiring and integrating data from diverse sources for use in data visualization tools like Tableau.
  • Hands-on experience designing and developing scripts using Python.
  • Strong analytical skills and experience as a system analyst for data analytics, performance management, or data warehousing projects.
  • Ability to troubleshoot and resolve ETL and data integration issues effectively.
  • Proficiency with technical writing and diagramming tools like Visio and Erwin.
  • Experience working in Agile sprint teams and familiarity with JIRA software.
  • Advanced knowledge of Microsoft Office Suite (Word, Excel, PowerPoint) and MS Project.
  • Experience in planning and delivering software platforms across multiple organizational units.
  • Strong oral and written communication skills.

Preferred Skills:
  • Knowledge of healthcare data security principles, including working with PII or PHI.
  • Prior experience with healthcare agencies or HHS organizations.
  • Familiarity with modern software components for data visualization or business intelligence.
  • Experience developing web applications using HTML, CSS, JavaScript, JQuery, and APIs.
  • Expertise in Tableau dashboard development and external data integration.


ASSYST is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law.

  • ETL Developer

    6 days ago

    Austin, United States Bickham Services Unlimited, LLC Full time

    Job DetailsBickham Services Unlimited, LLC is hiring a skilled Systems Analyst 3 to lead the development of a data integration hub in Austin, TX. The ideal candidate will have 8+ years of experience in ETL administration, Informatica IICS, Power Exchange CDC, and cloud-based CI/CD tools.The salary for this role is estimated at $48,500 - $62,000 per year,...

  • ETL Developer

    3 weeks ago

    Austin, United States IDR Healthcare Full time

    IDR is seeking a highly skilled and experienced ETL Developer to join one of our top clients in the public sector industry. If you are looking for an opportunity to join a large organization and work within a team-oriented culture, please apply today! Position Overview/Responsibilities for the ETL Developer: The ETL Developer role involves the...

  • Senior ETL Developer

    1 week ago

    Austin, Texas, United States TechnoGen Full time

    Job Description:We are looking for an experienced Senior ETL Developer to join our team at TechnoGen in Austin, TX. The ideal candidate will have 12+ years of experience in BI and data warehousing, with hands-on experience in Snowflake database and ETL development. Your expertise in performance tuning SQLs and proficiency in Python scripting will enable you...

  • ) ETL Developer

    3 months ago

    Austin, United States Saxon Global Full time

    Work Location: local to Chicago (Hybrid work schedule 3 days/week) Potential contract to hire opportunity-based on budget and need. Project Overview: Looking for an experienced DataStage ETL developer responsible for enhancing and supporting data ingest\egress integrations with Risk & Compliance Applications. Snowflake and Power BI knowledge required.This is...

  • ETL Developer

    2 weeks ago

    Austin, United States American Unit, Inc Full time

    ETL DeveloperAustin, TX - Hybrid12+ Months ContractThis development effort will utilize an agile methodology based on the approach currently in use at HHSC for the Texas Integrated Eligibility Redesign System (TIERS). As a member of the agile development team, the worker's responsibilities may include:Data acquisition from a variety of data sources for...

  • ETL Developer

    2 weeks ago

    Austin, Texas, United States Assyst Full time

    About the RoleThis is an exciting opportunity to work as an ETL Developer with ASSYST in Austin, Texas. As a key member of our team, you will be responsible for designing, developing, and maintaining ETL processes for enterprise-level data solutions.Key ResponsibilitiesDesign and develop ETL processes using Informatica IICS, IDMC, or Power Center.Automate...

  • ETL Developer

    1 week ago

    Austin, Texas, United States IDR Healthcare Full time

    About IDR HealthcareIDR Healthcare is a reputable healthcare organization seeking a skilled ETL Developer to join our team. This is an excellent opportunity for an experienced professional to work on a large-scale project and be part of a collaborative culture.Job DescriptionThe successful candidate will design, develop, and implement infrastructure for our...

  • ETL Developer

    3 weeks ago

    Austin, United States Mando Technologies Full time

    Mando Technologies is specializes in helping organizations make the most of their information assets. From acquiring, organizing, analyzing, and delivering data to closing the loop by integrating intelligence into the operations of the enterprise, Mando Technologies covers the full spectrum of Business Intelligence. Additional Information: Local Candidates ...

  • Cloud ETL Architect

    5 days ago

    Austin, United States Bickham Services Unlimited, LLC Full time

    Bickham Services Unlimited, LLC is looking for a skilled Cloud ETL Architect to design, develop, and deploy ETL pipelines using Informatica and IICS. The ideal candidate will have 8+ years of experience in ETL pipeline design, development, and deployment, as well as experience with cloud platforms (AWS S3, Azure Blob) and data quality/migration projects.The...

  • Data Engineer for ETL Pipeline Development

    4 weeks ago

    Austin, Texas, United States Omni Inclusive Full time

    Job Description:At Omni Inclusive, we are seeking a highly skilled Data Engineer to join our team. As a key member of our data engineering team, you will be responsible for developing and maintaining our ETL data pipelines in Google infrastructure.About the Role:We are looking for an experienced professional with a strong background in data engineering, SQL,...

  • Senior ETL Automation Specialist

    4 weeks ago

    Austin, Texas, United States Georgia IT Inc Full time

    Job Summary:Georgia IT Inc is seeking a highly skilled ETL Automation Specialist to join our team. As an ETL Automation Specialist, you will be responsible for designing, developing, and executing automated test plans and test cases for ETL processes and data warehouses. You will work closely with our development team to ensure that our data integration...

  • Data Scientist for ETL Pipeline Development

    4 weeks ago

    Austin, Texas, United States ApTask Full time

    About ClientThe client is a leading global IT services and consulting company, providing a wide range of services to clients in various industries. With a vast and diverse workforce, the company places a strong emphasis on employee training and development.It offers a comprehensive set of services, including:IT Services: Application development, maintenance,...

  • Senior Analyst ETL Developer

    1 week ago

    Austin, United States MMC Group LP Full time

    Job DescriptionJob DescriptionAre you an experienced ETL Developer with a passion for data integration and automation? We're looking for a Sr. Systems Analyst, Applications/Software Development - ETL Developer to join our client in a hybrid role, in the Austin, TX area. Position Details:Location: Hybrid (must reside in Austin, TX area and report...

  • Hybrid ETL Expert

    1 week ago

    Austin, Texas, United States MSys Inc Full time

    We are seeking an experienced Hybrid ETL Expert to join our team in Austin, TX. As a key member of our team, you will be responsible for designing, developing, and implementing ETL pipelines using Cloud Technologies, Data Warehousing Concepts, and Snowflake Platform Expertise.Estimated Salary:$145,000 - $175,000 per year, depending on qualifications and...

  • Enterprise ETL Expert

    1 week ago

    Austin, Texas, United States Bickham Services Unlimited, LLC Full time

    Job Summary:We are seeking an Enterprise ETL Expert to lead the design, development, and implementation of a data integration hub. The ideal candidate will have 8+ years of experience in ETL administration, Informatica IICS, Power Exchange CDC, cloud-based CI/CD tools, and automation using Python and shell scripting.About Bickham Services Unlimited,...

  • ETL Solutions Architect

    2 weeks ago

    Austin, Texas, United States Saxon Global Full time

    Saxon Global is seeking a highly skilled ETL Solutions Architect to join our team. In this role, you will design and develop large-scale data integration solutions using SSIS / SQL ETL technologies, and ensure that these solutions meet performance and scalability requirements.You will work closely with cross-functional teams to identify business needs and...

  • ETL Automation Engineer- Austin TX

    5 months ago

    Austin, United States Georgia IT Inc Full time

    Position: ETL Automation Engineer Location: Austin TX Duration: Contract Rate: DOE Required Skills: 8+ years of strong experience in ETL Testing, BI Testing Create, design, and execute the test plans and test cases which covers ETL Process and Data Warehouse validation Knowledge on Database objects and relational data models Knowledge of...

  • ETL Automation Engineer- Austin Tx

    5 months ago

    Austin, United States Georgia IT Inc Full time

    Position: Automation Engineer Location: Austin TX Duration: Contract Rate: DOE Required Skills: 8+ years of strong experience in ETL Testing, BI Testing Create, design, and execute the test plans and test cases which covers ETL Process and Data Warehouse validation Knowledge on Database objects and relational data models Knowledge of Informatica...

  • ETL Solutions Architect

    2 days ago

    Austin, Texas, United States Saxon Global Full time

    Job Requirements:To be successful in this role, you will need to have:Experience working with DataStage, SQL, Oracle Stored Procedures, Python, and Data Analysis.Strong knowledge of Snowflake and Power BI.Ability to develop and maintain code in ETL DataStage 11.7.Strong in PL/SQL and UNIX shell scripting.Experience working with XML transformation and...

  • TIERS ETL Developer/Systems Analyst 3

    2 weeks ago

    Austin, United States Neos Consulting Full time

    City : Austin State : Texas Neos is a leading Austin-based IT Staffing and Consulting firm, and was recognized as one of the Best Places to Work in Austin. Neos is seeking a TIERS ETL Developer/Systems Analyst 3 for a long-term contract with our client in Austin, TX. ONLY CANDIDATES LOCAL TO AUSTIN TEXAS NEED APPLY, HYBRID TWICE A WEEK Scope/Description...