| ETL Developer or Analyst at Austin, TX at Austin, Texas, USA |
| Email: [email protected] |
| From: Raj Khan, convextech.com [email protected] Reply to: [email protected] Hi, Hope you are doing good.!! Please let me know if you are interested in the below position.!! Position : ETL Developer Analyst 3 Location : Austin, TX (Client is currently under a hybrid model, which involves at least 2 days in the office, and the other days working from home (Days to be in office to be negotiated with your manager). Full-time Remote work possible in rare occasions and must have proven ability to deliver or on-premise will be expected. Duration : 6 months contracts Visa: USC/GC Interview : Phone / video Job Description: Public Sector Our best client, the Employees Retirement System of Texas (ERS) is looking for multiple ETL Developer Analysts. If you have any exclusive candidates that meet/exceed these requirements, please let me know and Ill get the forms to you for completion. Here are the details. JOB DESCRIPTION/MINIMUM REQUIREMENTS: 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. 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. Qualification Requirements Education/Special Requirements: Bachelors degree in computer science, engineering, or related business field. Experience and Training Three (3) years of hands on experience in T-SQL and SSIS/SSMS development Three (3) years of hands on experience in ETL development Three (3) years of hands on experience moving and manipulating large data sets Preferred Qualifications 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.) 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 the 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 Best Regards Md. Raj khan US IT Recruiter ConvexTech Inc. Email: [email protected] Keywords: information technology green card Colorado Maryland Texas |
| [email protected] View all |
| Wed Aug 23 19:49:00 UTC 2023 |