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
  • Same Department prior experience is Desirable, and Recent projects
  • Please include candidate's copies of certifications related to this position
  • Position will be 3 days remote with 2 day (Wednesday and Friday) required to be onsite at the location listed above. Program will only accept LOCAL ONLY candidates for this position

Project Scope:
The Department of Information Resources (DIR) requires the services of an ETL Developer hereafter referred to as Workers, who meets the general qualification of Systems Analyst 3, Emerging Technologies and the specifications outlined in this document for Health and Human Services Commission (HHSC) Information Technology.
Responsibilities:
This development effort will utilize an agile methodology based upon 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 responsibilities may include:
  • Data acquisition from a variety of data sources for multiple uses.
  • Developing complex SQL scripts to transform the source data to fit into a dimensional model, then to create views and materialized views in Oracle.
  • Developing automation with Informatica IICS or Power Center to pull data from external data sources and transform it to fit into a dimensional model.
  • Collaborating with other members of the Data Engineering Team on the design and implementation of an optimal data design.
  • Verification and validation of SQL scripts, Informatica automation and database views.
  • Developing automated means of performing verification and validation.
  • Participating in all sprint ceremonies
  • Work closely with the Architects and Data Engineering Team on implementation designs and data acquisition strategies.
  • Enhance and maintain the Java web site that provides Tableau dashboards to an array of users with different roles.
  • Develop mockups and work with customers for validation
  • Working closely with other members of the team to address technical problems
  • Assisting with the implementation and configuration of developmental tools
  • Producing and maintaining technical specifications, diagrams, or other documentation as needed to support the DD&I efforts
  • Participation in requirements and design sessions
  • Interpreting new and changing business requirements to determine the impact and proposing enhancements and changes to meet these new requirements
  • All other duties as assigned.
  • Understands business objectives and problems, identifies alternative solutions, performs studies and cost/benefit analysis of alternatives.
  • Analyzes user requirements, procedures, and problems to automate processing or to improve existing computer system: Confers with personnel of organizational units involved to analyze current operational procedures, identify problems, and learn specific input and output requirements, such as forms of data input, how data is to be; summarized, and formats for reports.
  • Writes detailed description of user needs, program functions, and steps required to develop or modify computer program. Reviews computer system capabilities, specifications, and scheduling limitations to determine if requested program or program change is possible within existing system.
  • Implementation and configuration of the infrastructure for the data integration hub
  • Design, development, and implementation (DD&I) of the data integration hub using an agile methodology for all standard SDLC phases that includes, but is not limited to:
  • Validation of performance metric requirements
  • Creation of Epics/User Stories/Tasks
  • Automation of data acquisition from a variety of data sources
  • Development of complex SQL scripts
  • Testing - integration, load and stress
  • Deployment / publication internally and externally
  • Operations support and enhancement of the data integration hub

Mandatory Skills:
  1. 8 Years of Experience developing mappings and workflows to automate ETL processes using Informatica IICS, IDMC or Power Center.
  2. 8 Years of Experiencing acquiring and integrating data from multiple data sources/technologies using Informatica for use by a Tableau data visualization object. Data source techs should include Snowflake, Oracle, SQL Server, Excel, Access and Adobe PDF.
  3. 8 Years of Experience designing and developing complex SQL scripts that are fast and efficient
  4. 8 Years of Strong analytical and problem-solving skills with experience as a system analyst for a data analytics, performance management system, or data warehousing project.
  5. 8 Years of Technical writing and diagraming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, and PowerPoint) and MS Project.
  6. 8 Years of Experience in planning and delivering software platforms used across multiple products and organizational units.
  7. 8 Years of Experience designing and developing scripts using Python
  8. 8 Years of Experience on an agile sprint team
  9. 8 Years of Experience with JIRA software

Desirable Skills:
  1. 8 Years of Experience with Excellent oral and written communication skills.
  2. 6 Years of Experience with Proven ability to write well designed, testable, efficient code by using best software development practices
  3. 4 Years of Experience with Understanding of security principles and how they apply to healthcare data
  4. 4 Years of Experience with state-of-the-art software components for a performance metrics data visualization or business intelligence environment
  5. 4 Years of Effectively self-manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required.
  6. 4 Years of Bachelor's degree in Computer Science, Information Systems, or Business or equivalent experience.
  7. 3 Years of Prior experience in the Healthcare Industry
  8. 2 Years of Prior experience with an HHS agency
  9. 2 Years of Prior experience working with PII or PHI data
  10. 2 Years of Experience with Web Applications and programming languages such as HTML, CSS, JavaScript, JQuery and API's
  11. 2 Years of Experience creating website/user interfaces by using standards HTML/CSS practices
  12. 2Years of Experience with Functional knowledge or hands on design experience with Web Services (REST, SOAP, etc.)
  13. 2Years of Experience developing dashboards and reports using Tableau, including connecting to external data sources.

  • 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 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...

  • 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...

  • 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...