Hello,
Hope you are doing good.
Position: ERS (DPA) ETL Developer 3
Location: Austin, TX (Onsite)
Duration: 12+ Months
Client: Loblolly/State of Texas
Job Description:
General Description:
Performs highly advanced (senior-level) ETL development work as part of a team on the Data Conversion Project at ERS. ERS has embarked on a multi-year project to convert data from their legacy PeopleSoft system to a cloud solution. The ETL development work will be extracting data from an Oracle database and transforming/loading it to an in-house SQL Server database. Extensive T-SQL skills will be key to the process.
Category
Details
Essential Functions
- Performs advanced ETL development work on data primarily residing in SQL Server
- Translates rules from PeopleSoft developers (Oracle) into efficient T-SQL scripts
- Troubleshoots, supports, and maintains ETL processes
- Designs, deploys, and manages standardized, centralized data sources
- Helps establish best practices for development, testing, migration, and error handling of ETL activities
- Performs other duties as assigned
Other Duties and Responsibilities
- May interact with outside vendors
Education/Special Requirements
- Bachelor's degree in computer science, engineering, or related business field
Experience and Training
- 3 years hands-on experience in T-SQL and SSIS/SSMS development
- 3 years hands-on experience in ETL development
- 3 years hands-on experience moving and manipulating large data sets
Preferred Qualifications
- Experience in health/life insurance, accounting, financials, or investment data related activities
- Experience with data tools (Visual Studio, SSIS, MSSQL)
- Experience with Azure and agile iterations
- Experience with ERP applications (PeopleSoft, etc.)
Knowledge, Skills and Abilities
- Applies critical thinking to all aspects of the job
- Experience with PeopleSoft HRMS or Finance packages preferred
- Experience with ERD Modeling & Maintenance
- Knowledge of RDBMS architecture and troubleshooting desirable
- Knowledge of data mining methods
...for over 25 years. We are growing, and need to add to our brewing team. We are serious about innovation and quality. Our production brewery consists of a 20 BBL Brewhouse, multiple 20, 40 and 60 BBL fermenting vessels and bright beer tanks, a Wild Goose Evolution Canning...
...At Heirloom Hospitality Group, our purpose is Cultivating Relationships & Experiences through the fanatic pursuit of Enlightened Hospitality ." We are dedicated to creating an environment that promotes creativity, passion, and a genuine sense of community. We are seeking...
...Unlimited Growth Potential : Whether part-time or full-time, our top agents earn between $1,000 and $10,000 (or more!) per month.... ...Leads: Reach out to potential clients who have shown interest in life insurance options. Present Solutions : Schedule appointments over...
QA Analyst to join our team of Microsoft 365, SharePoint, and web developers. This staffer will assist in testing web applications for SharePoint solutions M365 integrations to ensure functionality, usability, and web accessibility. They'll also assist in basic troubleshooting...
...OVERVIEW Resort Pool Attendants must maintain a clean and sanitary pool area as well as ensure that all safety equipment is present at and around the pool area at all times. JOB DUTIES Tests and balances pool chemicals. Documents as required by state and local...