ETL Data Management

2 weeks ago

Austin, United States RedSalsa Technologies, Inc. Full time

Title: Systems Analyst 3

Location: Austin, TX
Duration: 12+ Months
Client: 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 master data management solutions, in support of the Health and Human Services Commission (HHSC) 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 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 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.

Contribute the development of ETL processes, particularly those targeting HHSC s 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.

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.

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.

  1. CANDIDATE SKILLS AND 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 Data Management (Informatica)

  • ETL Developer

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

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

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

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

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

  • Data Management

    2 weeks ago

    Austin, United States Cogent Data Solutions Llc Full time

    Hello, Cogent Data Solutions LLC trying to reach you regarding a job opportunity. The role is Data Management ( Systems Analyst ) for one of our direct clients. Please take a look at the job description below and please send your updated resume. Role: Data Management ( Systems Analyst )Location: Hybrid , Tuesdays ( Onsite ) - Austin, TX ( Local Only )...

  • Sr Data Engineer

    6 days ago

    Austin, Texas, United States Horizontal Talent Full time

    Join our dynamic team as we seek a Senior Data Engineer with a focus on finance to bolster our client's Data and Analytics division. This role offers an exhilarating chance to contribute to the evolution and modernization of analytics We're on the lookout for individuals with exceptional communication skills, adept at engaging with stakeholders at all levels...

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

  • Data Management Specialist

    2 weeks ago

    Austin, United States COGENT DATA SOLUTIONS LLC Full time

    Hello,Cogent Data Solutions LLC trying to reach you regarding a job opportunity. The role is Data Management ( Systems Analyst ) for one of our direct clients. Please take a look at the job description below and please send your updated resume.Role: Data Management ( Systems Analyst )Location: Hybrid , Tuesdays ( Onsite ) - Austin, TX ( Local Only )Client...

  • Data Management Specialist

    2 weeks ago

    Austin, United States COGENT DATA SOLUTIONS LLC Full time

    Hello,Cogent Data Solutions LLC trying to reach you regarding a job opportunity. The role is Data Management ( Systems Analyst ) for one of our direct clients. Please take a look at the job description below and please send your updated resume.Role: Data Management ( Systems Analyst )Location: Hybrid , Tuesdays ( Onsite ) - Austin, TX ( Local Only )Client...

  • Data Engineer

    2 weeks ago

    Austin, United States Russell Tobin Full time

    Job DescriptionJob DescriptionLocation: Remote/Prefers someone to work in the central time zonePay Range: $55.00 - 67.00/hour W2Contract Duration: 12+ Potential to extend Summary:Client Commerce Engineering Operations is building next-generation business analytics and decision support capabilities to enable modern, data-driven engineering management and...

  • Lead Data Engineer

    1 month ago

    Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: The Fraud Analytics unit within the Data Reviews Division of the Office of Inspector General (OIG) is responsible for performing innovative and advanced data analytics to detect fraud, waste and abuse in state health and human services programs such as Medicaid, the Childrens Health Insurance Program (CHIP), Supplemental Nutrition...

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

  • Sr. Cloud Data Architect

    1 month ago

    Austin, United States snipeHIRE Full time

    Job DescriptionJob DescriptionCOMPANYOur client specializes in digital enablement and digital transformation solutions for Fortune companies. Using industry-leading data engineering, process mining and automation platforms, they help large enterprises become more process-efficient and improve their end-customer experience by incorporating the use of RPA, AI...

  • Sr. Cloud Data Architect

    1 month ago

    Austin, United States snipeHIRE Full time

    Job DescriptionJob DescriptionCOMPANYOur client specializes in digital enablement and digital transformation solutions for Fortune companies. Using industry-leading data engineering, process mining and automation platforms, they help large enterprises become more process-efficient and improve their end-customer experience by incorporating the use of RPA, AI...

  • Senior Manager, Data Engineering

    2 weeks ago

    Austin, United States Unity Full time

    Role Description The opportunity Corporate Data builds and serves data products, which empower teams across the company to know our customers and deliver the best experience for all our users who aspire to build & grow content in real-time 3D, from games to movies, architecture, and beyond. We are seeking an experienced engineering leader to lead...