ETL Developer

2 weeks ago

Austin, United States Allied Consultants (Texas) Full time

Overview:

Allied Consultants, Inc. is an Austin-based firm which has for 32 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced ETL Developer to be a key resource on a technical services team.

Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan.

Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law. Offers of Employment are contingent on a successful background check

Allied Consultants is an equal opportunities employer.

Responsibilities:

The Developer position will be an Information Technology (IT) resource that will assist in the development of data transformations, particularly targeting master data management solutions, in support of the client's Center for Analytics and Decision Support's, Enterprise Information Management (EIM) team. As a secondary requirement, the candidate should be familiar with technical and business metadata management and the related acquisition and administration requirements for Informatica Enterprise Data Catalog (EDC) and Informatica Axon.

The Developers responsibilities may include:

  • Working with subject matter experts (SMEs) across agencies to collect and update technical and business metadata.
  • Load collected technical business metadata into EDC and Axon.
  • Administer EDC and Axon
  • Develop ETL in Informatica Power Center and Informatica data quality.
  • Develop data quality processes and scorecards.
  • Perform outreach and communication with source systems to support change management automation adopted by source systems.
  • Review and assessment of the design, implementation and management of security access roles and privileges for all types of metadata consumers.
  • Identification and documentation of business processes.
  • Other duties as assigned.

Essential Job Functions:

  • Contribute the development of ETL processes, particularly those targeting clients Master Data Management (MDM) solution. Coordinate and communicate with cross-agency SMEs to review and confirm technical metadata gaps. Participation and knowledge in the development of processes and guidelines for Metadata Management - change management, metadata access and sharing. Communicate successfully with technical and non-technical groups to facilitate the coordination of project activities. Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned. (10%)
  • Knowledge Skills Abilities:
  • Experience with using and administering Informatica Enterprise Data Catalog and Axon.
  • Experience Developing ETL with informatica Power Center and Informatica Data Quality.
  • Experience with Oracle DDL and DML.
  • Experience with SQL and data analysis.
  • Experience with security and data quality metadata.
  • Skill in communicating effectively - orally and in writing.
  • Ability to assess and utilize metadata information.
  • Ability to manage competing priorities, work under pressure, negotiate among multiple parties, resolve conflicts.
  • Ability to establish and maintain effective working relationships internally and externally.
  • Ability to work cooperatively and effectively in a team environment.
  • Ability to exercise judgment and work independently with limited direction. Ability to work on multiple projects or project assignments.

Registration or Licensure Requirements:

N/A

Initial Selection Criteria:

Required: Graduation from an accredited four-year college or university. Strong Informatica Metadata Manager experience. Strong EDC and Axon experience. Strong ETL development skills in Informatica Power Center and Data Quality. Strong SQL Experience. Experience with Oracle Databases. Experience with the Healthcare business domain. Experience working with Texas Medicaid Management Information System (MMIS) data and Texas Integrated Eligibility Redesign System (TIERS). Familiarity with agile software development lifecycle.

**Position is expected to extend into FY25, Sept 1st.**

Qualifications:

Minimum Requirements:
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

Years

Required/Preferred

Experience

10

Required

Enterprise data analytics, integration, and management, working with data warehouse and data governance technologies

5

Preferred

Informatica administration experience including installation, configuration, upgrades, problem handling, and business continuity support

5

Preferred

Proven ability to implement data integration best practices and conventions

5

Preferred

Understanding of IT data security

5

Preferred

Excellent communication, presentation, interpersonal, and organizational skills

5

Preferred

Comfortable working both independently and within cross-functional, collaborative teams

4

Preferred

Scripting knowledge (Java, Python, Perl, PowerShell, Bash, SQL)

4

Preferred

Hands on experience configuring EDC and Axon, including but not limited to business glossaries, dashboards, policies, search, process maps, and advanced scanners

3

Preferred

Experience creating scripts to automate system administration tasks, schedules, and deployment activities

3

Preferred

Knowledge of source-to-target data lineage mapping and automated harvest methods

2

Preferred

Experience administering Informatica Axon or similar data governance portal solutions

2

Preferred

Experience administering Informatica Enterprise Data Catalog or similar automated metadata harvest and enrichment solutions

2

Preferred

Experience administering Informatica Data Quality or similar data profiling, cleansing, scorecard, and identity resolution solutions

2

Preferred

Linux administration experience

2

Preferred

Proficiency in reading data payloads in JSON and XML format

1

Preferred

Informatica vendor certification on EDC, Axon, and/or IDQ administration within the past 3 years

1

Preferred

Understanding of DAMA DMBOK data management framework

1

Preferred

Experienced in Scaled Agile Framework (SAFe) methods of software delivery lifecycle (SDLC)

1

Preferred

Knowledge of cloud infrastructure solutions (Azure, AWS, OCI)

1

Preferred

Experience with Git version control system

1

Preferred

Experience with large-scale data Infrastructure as a Service (IaaS) environments

1

Preferred

Informatica Master Data Management experience

1

Preferred

Informatica PowerCenter experience (mappings, workflows)

1

Preferred

Informatica Data Quality ETL experience (mappings, workflows)

  • ETL Developer

    5 days ago

    Austin, United States IDR Healthcare Full time

    IDR is seeking a 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 an ever-growing team-oriented culture, please apply today! Position Overview/Responsibilities for the ETL Developer: Contribute the development of ETL processes, particularly those...

  • ) ETL Developer

    3 weeks 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...

  • Informatica ETL Developer

    2 weeks ago

    Austin, United States Sriven Systems Inc. Full time

    Position: Informatica ETL DeveloperLocation: Austin 1 day onsite in a week (Tuesdays)Duration: 12 Months The Developer s responsibilities may include: Working with subject matter experts (SMEs) across agencies to collect and update technical and business metadata.Load collected technical business metadata into EDC and Axon.Administer EDC and AxonDevelop ETL...

  • ETL Developer

    3 days ago

    Austin, United States Tekfortune Inc Full time

    Title - ETL Developer (with performance tuning experience) Location - Austin (Remote OK) JD For Performance Engineer (Data) Skill and Experience Required Experience in consuming large data volume Advance SQL skills Optimize strategy process for data handling for aggregation tables (Minimize processing time for large data volume) Experience in data loading...

  • ETL Engineer

    2 weeks ago

    Austin, United States RevOpsforce Full time

    Job DescriptionJob DescriptionAbout RevOpsforce:RevOpsforce is a revenue operations workforce management firm supporting clients to unlock revenue potential through solutions that better align people, processes, data, and technology. We empower organizations with cutting-edge revenue operations management systems, seamlessly aligning sales, marketing, and...

  • ETL Engineer

    2 days ago

    Austin, United States RevOpsforce Full time

    Job DescriptionJob DescriptionAbout RevOpsforce:RevOpsforce is a revenue operations workforce management firm supporting clients to unlock revenue potential through solutions that better align people, processes, data, and technology. We empower organizations with cutting-edge revenue operations management systems, seamlessly aligning sales, marketing, and...

  • ETL Database Architect

    2 weeks ago

    Austin, United States Indotronix International Corporation Full time

    OTHER SPECIAL REQUIREMENTS CANDIDATE SKILLS AND QUALIFICATIONS: • Must possess strong written, verbal, and interpersonal communication skills. • Must be able to work independently in a team environment with local and remote teams. • Must possess knowledge of project management methodologies both traditional and Agile/Scrum • Must possess...

  • Senior ETL Informatica with Axon

    2 weeks ago

    Austin, United States HireBlazer Full time

    Role: Senior ETL Informatica with AxonLocation: Austin, TX (Hybrid)Contract: 15+ MonthsJob Description:The Developer s responsibilities may include: Working with subject matter experts (SMEs) across agencies to collect and update technical and business metadata.Load collected technical business metadata into EDC and Axon.Administer EDC and AxonDevelop ETL in...

  • ETL Data Management

    2 weeks ago

    Austin, United States RedSalsa Technologies, Inc. Full time

    Title: Systems Analyst 3 Location: Austin, TXDuration: 12+ MonthsClient: State of TX Position will be 4 days remote with 1 day (Tuesdays) required to be onsite at the location listed above. Description:The Developer position will be an Information Technology (IT) resource that will assist in the development of data transformations, particularly targeting...

  • Sr ETL Informatica Developer( Need State Client Exp

    2 weeks ago

    Austin, United States Nextgen Information Services Full time

    Job DescriptionThe Developer position will be an Information Technology (IT) resource that will assist in the development of data transformations, particularly targeting master data management solutions, , Enterprise Information Management (EIM) team. As a secondary requirement, the candidate should be familiar with technical and business metadata management...

  • ETL Informatica Axon Admin Developer

    2 weeks ago

    Austin, United States Chandra Technologies, Inc. Full time

    Job Description:***Corp to Corp Resumes are accepted.Location Requirement:The primary work location will be 701 W. 51st Street, Austin, Texas 78751.Position will be 4 days remote with 1 day (Tuesdays) required to be onsite at the location listed above. Program will allow candidates who are within the state (Any location within the State of Texas). Candidates...

  • Snowflake Developer

    2 weeks ago

    Austin, United States Lorven Technologies Full time

    Hi Role: Snowflake Developer Location: Austin, TX / Charlotte, NC – South & North- Onsite C2C Job Description: Job Overview: We are seeking an experienced and highly skilled Snowflake Developer to join our dynamic team. The ideal candidate will have a strong background in data engineering, database management, and a deep...

  • Sr Tableau Developer

    1 week ago

    Austin, United States Info Way Solutions Full time

    Role : Sr Tableau DeveloperLocation : Austin,TX(Onsite)Bachelor’s degree in Computer Science, Information Systems, Data Science, or related field.Minimum of [9+] years of hands-on experience with Tableau development.Proficient in SQL and experience with database design and development.Strong analytical skills with the ability to collect, organize, analyze,...

  • Sr Tableau Developer

    1 week ago

    Austin, United States Info Way Solutions Full time

    Role : Sr Tableau DeveloperLocation : Austin,TX(Onsite)Bachelor’s degree in Computer Science, Information Systems, Data Science, or related field.Minimum of [9+] years of hands-on experience with Tableau development.Proficient in SQL and experience with database design and development.Strong analytical skills with the ability to collect, organize, analyze,...

  • Salesforce Developer

    4 days ago

    Austin, United States Redzara.us Full time

    Overview: (Local only - Citizen or green card holders only) Contract to hire position. We are seeking a skilled Salesforce Developer to join our team. As a Salesforce Developer, you will be responsible for customizing, developing, and supporting solutions on the Salesforce platform to meet business needs. **Duties**: - Collaborate with stakeholders to...

  • 100% remote - IT Support Specialist (SQL, ETL) - Direct Client - Immediate Interviews

    1 day ago

    Austin, United States Accion Labs Full time

    One of my direct clients, a leading provider of electronic healthcare payment solutions, is looking for an IT Support Specialist (SQL, ETL).Complete onsite from day 1Skills - SQL server 2012+, Troubleshooting & Production support, Active batch or any job scheduler experience, Understanding read and troubleshoot Stored ProceduresRate - DOEDuration - 12+...

  • Senior Developer

    2 months ago

    Austin, United States Lorven Technologies Full time

    Hi, Our client is looking for a Senior Developer - Python with a Long-Term Contract project in Austin - TX - Onsite below is the detailed requirement. Job Title: Senior Developer Location: Austin - TX Duration: Contract Role Required Skills: Python, Analytics , AWS, Basic Java Job Description Bachelor's degree in Computer...

  • Remote Ab Initio Developer

    3 weeks ago

    Austin, United States Meridian Technologies Full time

    Meridian Technologies is seeking an Ab Initio Developer for the Army Military Pay program to perform conversions, interface development, documentation, and unit testing using various Ab Initio tools. You will participate in the development, integration, and deployment of solutions. This role is responsible for designing, developing, and supporting...

  • Informatica Developer/Administrator

    2 weeks ago

    Austin, United States Esolvit, Inc. Full time

    Job Title: Informatica AdministratorLocation: Austin, TX (Hybrid) 4 days remote with 1 day (Tuesdays)Duration: Long termClient: HHSC- Texas Health and Human Services Commission The Developer s responsibilities may include: Working with subject matter experts (SMEs) across agencies to collect and update technical and business metadata.Load collected technical...

  • Data Warehouse Developer

    1 month ago

    Austin, United States Atechstar Full time

    Responsibilities Understands complex business problems and develops logical and physical database models to support design of enterprise systems which support and facilitate the transfer of data from operational to analytical systems. Uses SQL Server Relational Database Engine and the T-SQL query language to create new database objects as needed including...