ETL Informatica Analyst - State (Locals Only)

Position: ETL Informatica IICS Analyst

Location: Austin TX, 3 days remote with 2 day (Mondays and Wednesdays) required to be onsite

Duration: 12+ Months
Job Description:

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

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 data integration hub
  
  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
  8	Required	Experience developing mappings and workflows to automate ETL processes using Informatica IICS, IDMC or Power Center.
  8	Required	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.
  8	Required	Experience designing and developing complex SQL scripts that are fast and efficient
  8	Required	Strong analytical and problem-solving skills with experience as a Data analyst for a data analytics, performance management system, or data warehousing project.
  8	Required	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.
  8	Required	Experience in designing and developing Python scripts for data testing and automation.
  8	Required	Identify, record, and track defects throughout the development lifecycle, working with developers to prioritize and resolve issues.
  8	Required	Collaborate with development teams to understand project specifications and contribute to the continuous improvement of quality processes.
  8	Required	Develop and execute test plans, test cases, and test scripts based on project requirements to ensure comprehensive testing coverage.
  8	Required	Identify and communicate business risks relative to testing and implementation for evaluation by project teams and management
  8	Required	Self-motivation, organized, time-management and deductive problem-solving skills
  8	Required	Work independently and as part of a team
  8	Required	Multi-task along with attention to detail
  8	Required	Maintain confidentiality and practice discretion and caution when handling sensitive information
  8	Preferred	Contribute to improving automation frameworks, including adding new features and enhancing test coverage
  4	Preferred	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	Preferred	Familiarity with observability and testing infrastructure at scale
  2	Preferred	A track record of driving innovation in software quality or test automation