ETL Informatica Developer

2 weeks ago


Austin, United States Indotronix International Corporation Full time
Client IT is continuing to develop an client Performance Portal pilot initiative with a goal to accomplish the following:
Implementation and configuration of the infrastructure for the performance portal pilot
Design, development, and implementation (DD&I) of the performance portal using an agile methodology for all standard SDLC phases that includes, but is not limited to:

o Validation of performance metric requirements

o Creation of Epics/User Stories/Tasks

o Automation of data acquisition from a variety of data sources

o Development of complex SQL scripts

o Testing - integration, load and stress

o Deployment / publication internally and externally
Operations support and enhancement of the Performance Portal pilot

This development effort will utilize an agile methodology based upon the approach currently in use at client for the Texas Integrated Eligibility Redesign System (TIERS). As a member of the agile development team, the worker responsibilities may include:
Filling the role of a technical leader, leading an agile development team through a project.
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 Power Center/IICS 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.
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.

Experience

17 Required Experience designing and developing complex Oracle SQL scripts that are fast and efficient

17 Required Experience in interfacing with ETL tools such as Informatica PowerCenter, IICS, ADF and supporting ETL jobs.

15 Required Experience writing UNIX scripts

10 Required Strong analytical and problem-solving skills with experience as a system analyst for a data analytics, performance management system, or data warehousing project.

10 Required Technical writing and diagramming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, and PowerPoint) and MS Project.

8 Required Experience with JIRA software

8 Required Experience making technical presentations and working closely with customers

8 Required Experience acquiring and integrating data from multiple data sources/technologies using Informatica Power Center for use by a Tableau data visualization object. Data source techs should include Oracle, SQL Server, Excel, Access and Adobe PDF.

8 Required Experience working with Snowflake

10 Preferred Excellent oral and written communication skills.

10 Preferred Effectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required.

10 Preferred Proven ability to write well designed, testable, efficient code by using best software development practices

5 Preferred Understanding of security principles and how they apply to healthcare data

4 Preferred Master's degree in Computer Science, Information Systems, or Business or equivalent experience.

2 Preferred Prior experience in the Healthcare Industry

Indotronix is an Equal Opportunity Employer
  • Informatica Developer

    3 weeks ago


    Austin, United States IDR Healthcare Full time

    IDR is seeking a Informatica 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 an ever-growing team-oriented culture, please apply today! Position Overview/Responsibilities for the Informatica Developer: Responsible for the installation,...

  • Informatica Developer

    2 weeks ago


    Austin, United States IDR Healthcare Full time

    IDR is seeking a Informatica 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 an ever-growing team-oriented culture, please apply today! Position Overview/Responsibilities for the Informatica Developer: Responsible for the installation,...

  • ETL Developer

    4 weeks ago


    Austin, United States PriceSenz Full time

    Job Title: ETL DeveloperLocation: RemoteJob Overview:We are seeking a highly experienced ETL Specialist for a remote opportunity. The ideal candidate will have over 8 years of experience and possess strong analytical and problem-solving skills, with a focus on data analytics, performance management systems, and data warehousing projects. This role will...


  • Austin, Texas, United States Diverse Lynx Full time

    Job Title: Informatica Cloud Solutions Architect Location: Austin TX (100% Onsite role from Day 1) Duration: Full Time/Permanent Job Overview: Key Technologies: IICS, SQL, Talend Studio, UNIX shell scripting, Data MigrationProficient in using JIRA, Confluence, and Microsoft Office Suite (including Microsoft Project and PowerPoint)Experience with Cloud and/or...

  • Data Engineer

    2 weeks ago


    Austin, United States Compunnel Full time

    Required Experience and Skills BS degree in Computer Science, Information Systems, Engineering, or equivalent professional experience Minimum 3 years of experience designing and implementing ETL technical solutions for complex data models using multiple data sources Minimum 3 years of experience with Informatica Cloud, Python, SQL, and PL/SQL ...


  • Austin, Texas, United States Informatica Full time

    Job Number: 37012Position Title: Senior IT Systems EngineerExternal Description:Build Your Career at InformaticaWe're looking for a diverse group of collaborators who believe data has the power to improve society. Adventurous, work-from-anywhere minds who value solving some of the world's most challenging problems. Here, employees are encouraged to push...


  • Austin, United States Informatica Full time

    Job Number: 37012 Position Title: Senior IT Systems Engineer External Description: Build Your Career at Informatica We're looking for a diverse group of collaborators who believe data has the power to improve society. Adventurous, work-from-anywhere minds who value solving some of the world's most challenging problems. Here, employees are...


  • Austin, Texas, United States Persistent Systems Full time

    About Persistent SystemsPersistent Systems is a renowned partner in Digital Engineering and Enterprise Modernization, leveraging extensive technical knowledge and industry insights to empower our clients to foresee and adapt to future challenges. Our diverse offerings and validated solutions provide a distinctive competitive edge, enabling clients to...


  • Austin, United States Informatica LLC Full time

    Job Number: 37012 Position Title: Senior IT Systems Engineer Build Your Career at Informatica We're looking for a diverse group of collaborators who believe data has the power to improve society. Adventurous, work-from-anywhere minds who value solving some of the world's most challenging problems. Here, employees are encouraged to push their boldest...


  • Austin, Texas, United States Informatica LLC Full time

    Job Number:37012Position Title:Senior IT Systems EngineerBuild Your Career at InformaticaWe're looking for a diverse group of collaborators who believe data has the power to improve society. Adventurous, work-from-anywhere minds who value solving some of the world's most challenging problems. Here, employees are encouraged to push their boldest ideas...


  • Austin, Texas, United States Persistent Systems Full time

    About Persistent SystemsPersistent Systems is a renowned partner in Digital Engineering and Enterprise Modernization, leveraging extensive technical knowledge and industry insights to empower our clients to stay ahead of the curve. Our innovative offerings and established solutions provide a distinctive competitive edge, enabling clients to foresee...


  • Austin, United States Cognizant Full time

    Title: Senior ETL Developer Cognizant (NASDAQ: CTSH) is a leading provider of information technology, consulting, and business process outsourcing services, dedicated to helping the world's leading companies build stronger businesses. Headquartered in Teaneck, New Jersey (U.S.). Cognizant is a member of the NASDAQ-100, the S&P 500, the Forbes Global 1000,...


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


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

  • SQL/ETL Developer

    1 month ago


    Austin, Texas, United States CLA (CliftonLarsonAllen) Full time

    CLA is a leading national professional services firm dedicated to creating opportunities for clients, employees, and communities. We offer wealth advisory, digital, audit, tax, consulting, and outsourcing services. Our culture values diverse perspectives and collaboration.Job Title: SQL/ETL Developer - LeadAbout the Role:Design, implement, and maintain...


  • Austin, Texas, United States Centraprise Full time

    Job Summary:Centraprise is seeking a highly skilled Machine Learning Engineer to join our team. As a Machine Learning Engineer, you will be responsible for designing, developing, and deploying machine learning models and systems that drive business value.Key Responsibilities:Design and develop machine learning models and systems that meet business...


  • Austin, United States Natsoft Full time

    Job Title: Informatica Intelligent Cloud Services DeveloperLocation: Austin, TXPosition Type: Full-Time (FTE)Technical Skills:Informatica IICS Platform ProficiencyData integrationData qualityCloud data integrationETL DevelopmentDesigning and developing ETL processesSQL and Database KnowledgeQuerying databasesUnderstanding relational databasesData...


  • Austin, United States Natsoft Full time

    Job Title: Informatica Intelligent Cloud Services DeveloperLocation: Austin, TXPosition Type: Full-Time (FTE)Technical Skills:Informatica IICS Platform ProficiencyData integrationData qualityCloud data integrationETL DevelopmentDesigning and developing ETL processesSQL and Database KnowledgeQuerying databasesUnderstanding relational databasesData...


  • Austin, Texas, United States Lorven Technologies Full time

    Job Title: Snowflake DeveloperJob Summary:Lorven Technologies is seeking an experienced Snowflake Developer to join our team. As a Snowflake Developer, you will be responsible for designing, developing, and managing data solutions using Snowflake to support our business intelligence and analytics needs.Key Responsibilities:Data Modeling and Development:...


  • Austin, United States The San Mateo County Bar Association Full time

    Commercial Counsel at Informatica - Redwood City Job Number: 25677 Primary Location: Redwood City, California US Alternative Location(s): Austin, TX; Cary, NC Travel Requirement: Limited At Informatica, we “DATA”. We Do Good, Act As One Team, Think Customer First, and Aspire For The Future. Informatica enables companies to unleash the power of data to...