13982 - ETL Engineer (onsite) - Austin, TX
Start Date: ASAP
Type: Temporary Project
Estimated Duration: 12 months with possible extensions
Work Setting: Hybrid 2 days per week onsite.
Required:
• Availability to work 2 days per week (Mondays and Wednesdays) at the Client’s site in Austin, TX (required);
• Experience developing mappings and workflows to automate ETL processes using Informatica IICS, IDMC or Power Center (8 years);
• Experience acquiring and integrating data from multiple data sources/technologies using Informatica for use by a Tableau data visualization object, including Snowflake, Oracle, SQL Server, Excel, Access and Adobe PDF (8 years);
• Experience designing and developing complex SQL scripts that are fast and efficient (8 years);
• Strong analytical and problem-solving skills with experience as a Data analyst for a data analytics, performance management system, or data warehousing project (8 years);
• Experience in 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 years);
• Experience in designing and developing Python scripts for data testing and automation (8 years);
• Experience identifying, recording, and tracking defects throughout the development lifecycle, working with developers to prioritize and resolve issues (8 years);
• Experience collaborating with development teams to understand project specifications and contribute to the continuous improvement of quality processes (8 years);
• Experience developing and executing test plans, test cases, and test scripts based on project requirements to ensure comprehensive testing coverage (8 years);
• Experience identifying and communicating business risks relative to testing and implementation for evaluation by project teams and management (8 years);
• Self-motivation, organized, time-management and deductive problem-solving skills (8 years);
• Experience working independently and as part of a team (8 years);
• Experience with multi-tasking along with attention to detail (8 years);
• Experience maintaining confidentiality and practicing discretion and caution when handling sensitive information (8 years).
Preferred:
• Experience contributing to improving automation frameworks, including adding new features and enhancing test coverage (8 years);
• Experience building or working with automated regression and functional test suites, ideally enhanced by AI (4 years);
• Experience working on AI platforms or validating AI-integrated products (2 years);
• Experience with observability and testing infrastructure at scale (2 years);
• Experience driving innovation in software quality or test automation (2 years).
Responsibilities:
• Understand business objectives and operational challenges, gather and document user requirements, evaluate alternative solutions through cost/benefit analysis, and translate needs into functional specifications for system development or improvement;
• Implement and configure the data integration hub infrastructure; design, develop, and deploy the hub using Agile methodologies, including the automation of data acquisition and integration from diverse data sources;
• Create complex SQL scripts and develop automation using Informatica IICS or PowerCenter to transform and load data into a dimensional model; build and maintain Oracle views and materialized views for efficient data access;
• Work closely with architects and the data engineering team to design optimal data solutions, define data acquisition strategies, and ensure the scalability and reliability of the integration hub;
• Verify and validate SQL scripts, automation workflows, and database views; develop automated methods for testing and validation to maintain data accuracy and process integrity;
• Enhance and maintain the Java-based website that delivers Tableau dashboards, develop interface mockups, validate with stakeholders, and ensure access control based on user roles;
• Engage in all Agile sprint ceremonies, assist in tool configuration, address technical issues, participate in design sessions, and produce and maintain comprehensive technical documentation to support ongoing development and future enhancements.