Overview Allied Consultants, Inc. is an Austin-based firm which has for 33 years been a top-tier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced ETL Developer to be a key resource on a technical services team. Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan. Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law. Offers of Employment are contingent on a successful background check Allied Consultants is an equal opportunities employer. • • Location of job: Onsite. Candidate must be local to Austin, TX • • Responsibilities Performs highly advanced (senior-level) ETL development work as part of a team on the Data Conversion Project at client. Client 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. Duties and Responsibilities Essential Functions: • Performs advanced ETL development work on data primarily residing in SQL Server • Translates rules provided by PeopleSoft developers (Oracle based) into efficient T-SQL scripts to load data into the target database on SQL Server • Troubleshoots, supports and maintains the ETL processes developed by the team • Designs, deploys, and manages standardized, centralized data sources • Helps to establish best practices for development, testing, migration and error handling of the ETL activities • Performs other duties as assigned Other Duties and Responsibilities: • May interact with outside vendors Essential Work Behaviors: • Impeccable written and oral communication • Communicates respectfully and works harmoniously with all co-workers, customers, and vendors. • Provides exceptional customer service. • Is flexible; able to work under pressure and; able to adapt to change; and able to work on multiple problems and tasks. • Takes initiative to prevent and solve problems. Knowledge, Skills and Abilities • Uses all knowledge, skills, and abilities to apply critical thinking to all aspects of the job. Critical thinking is a process of forming reasoned opinions through observation, information collection, interpretation, analysis, inference, evaluation, and other skills necessary to successfully meet performance standards of the job. • Experience with PeopleSoft HRMS or Finance packages preferred • Experience with ERD Modeling & Maintenance • Knowledge of RDBMS architecture and troubleshooting is desirable. • Knowledge of data mining methods Professional Expectations: • Attends all meetings, meets delivery deadlines and is available during client office hours. • Logs in and remains on agency Jabber during work hours. • Attends remote meetings with camera on unless prior arranged for camera off. • Coordinates leave and vacation with client lead. • Must dress appropriately for a business/business casual environment. • Communicates respectfully and works harmoniously with all co-workers, customers and vendors. • Provides exceptional customer service. • Is flexible; able to work under pressure and able to adapt to change; and able to work on multiple problems and tasks. • Takes initiative to prevent and solve problems. Qualifications Minimum (Required): • Bachelor’s degree in computer science, Engineering, or related business field. • 3 years of hands on experience in T-SQL and SSIS/SSMS development • 3 years of hands on experience in ETL development • 3 years of hands on experience moving and manipulating large data sets Preferred (Optional): • Experience in health/life insurance, accounting and financials, or investment data related activities • Experience with data tools (i.e. Visual Studio, SSIS, MSSQL) • Experience with Azure and agile iterations • Experience with ERP applications (i.e. PeopleSoft, etc.)