Overview:
Allied Consultants, Inc. is an Austin-based firm which has for 33 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced Senior 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.
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
* 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's 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's lead.
* Must dress appropriately for a business/business casual environment.
* Communicates respectfully and works harmoniously with all co-workers, customers and
* 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):
Years
Skills/Experience
Bachelor's degree in computer science, engineering, statistics, or related business field
3
Hands on experience in T-SQL and SSIS/ SSMS development
3
Hands on experience in ETL development.
3
Hands on experience moving and manipulating large data sets.
Preferred (Optional):
Years
Skills/Experience
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.)
Share this job:
Share this Job
