Overview
Skills
Job Details
Phone/Skype Hire. Onsite from Day 1 / Hybrid.
Location: Austin, Texas
Duration: 6+ months
Must have current LinkedIn profile.
Responsibilities
The client is continuing to develop an data integration hub with a goal to accomplish the following:
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:
- Validation of performance metric requirements
- Creation of Epics/User Stories/Tasks
- Automation of data acquisition from a variety of data sources
- Development of complex SQL scripts
- Testing integration, load and stress
- Deployment / publication internally and externally
Operations support and enhancement of the data integration hub
As a member of the agile development team, the worker responsibilities may include:
- 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 IICS or Power Center 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.
- Enhance and maintain the Java web site that provides Tableau dashboards to an array of users with different roles.
- 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.
Skills Needed
| 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 |