Senior ETL Developer

Overview

On Site
Depends on Experience
Contract - W2
No Travel Required

Skills

ETL Developer
Extract Transform and Load
Informatica

Job Details

Luna Data Solutions, Inc. is seeking a Senior ETL Developer with deep experience in ETL process automation using Informatica to support a public sector client. This is a long-term contract opportunity to contribute to a high-impact government data integration initiative with a hybrid work schedule of 2 days onsite in Austin, TX, and 3 days remote.

***To be considered, you must currently reside within the Austin, Texas Metropolitan area***

You ll be an integral part of a cross-functional agile team focused on developing and maintaining a statewide data integration hub that supports performance measurement, analytics, and decision-making across agencies.

Key Responsibilities

  • Develop and automate ETL workflows using Informatica (IICS, IDMC, or PowerCenter)
  • Integrate data from multiple sources including Snowflake, Oracle, SQL Server, Excel, Access, Adobe PDF
  • Design and build complex, high-performance SQL scripts
  • Collaborate on the design and implementation of a dimensional data model
  • Support the development of Tableau dashboards by delivering clean, validated data
  • Participate in agile ceremonies and sprint planning
  • Perform data validation and QA, including automated verification using Python
  • Contribute to the design, testing, deployment, and documentation phases of the SDLC
  • Help maintain a Java-based internal dashboard site
  • Create and review technical documentation, user stories, and mockups

Required Skills and Qualifications

  • 8 yrs. of experience developing mappings and workflows to automate ETL processes using Informatica IICS, IDMC or Power Center.
  • 8 yrs. of experience 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.
  • 8 yrs. of experience designing and developing complex SQL scripts that are fast and efficient.
  • 8 yrs. of experience as a Data analyst for a data analytics, performance management system, or data warehousing project.
  • 8 yrs. of experience writing technical documentation and diagrams using modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, and PowerPoint) and MS Project.
  • 8 yrs. of experience designing and developing Python scripts for data testing and automation.
  • 8 yrs. of experience identifying, recording, and tracking defects throughout the development lifecycle, working with developers to prioritize and resolve issues.
  • 8 yrs. of experience collaborating with development teams to understand project specifications and contribute to the continuous improvement of quality processes.
  • 8 yrs. of experience developing and executing test plans, test cases, and test scripts based on project requirements to ensure comprehensive testing coverage.
  • 8 yrs. of experience identifying and communicating business risks relative to testing and implementation for evaluation by project teams and management.
  • Current residency within the Austin, Texas Metropolitan area.

Preferred Qualifications:

  • 4 yrs. of experience contributing to improving automation frameworks, including adding new features and enhancing test coverage
  • 4 yrs. of experience building or working with automated regression and functional test suites, ideally enhanced by AI 2 Preferred Experience working on AI platforms or validating AI-integrated products.
  • 2 yrs. of experience / familiarity with observability and testing infrastructure at scale.
  • 2 yrs. of experience driving innovation in software quality or test automation

What We Offer:

  • Competitive Compensation:
  • Generous Benefits Package including Medical, Dental, Vision, Disability, Flexible Spending Account (FSA) options, and more!
  • Hybrid work setting

This is a long-term contract opportunity in Austin, Texas and no sponsorship can be provided. Candidates must be able to pass a background check. Luna Data Solutions, Inc. (LDS) provides equal employment opportunities to all employees. All applicants will be considered for employment. LDS prohibits discrimination and harassment of any type regarding age, race, color, religion, sexual orientation, gender identity, sex, national origin, genetics, protected veteran status, and/or disability status.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.