ETL Developer

ETL DeveloperApex Systems is currently seeking an experienced ETL Developer for an excellent job opportunity.The ETL Developer is responsible for the definition, development, and testing of the processes and programs necessary to extract data from the client's operational databases/files and deliver it to the desired target environments.Duties include extraction, transformation, cleansing and loading of data into a data warehouse, data marts, etc. The ETL Developer is experienced with all of the techniques used to manage and maintain a data warehouse environment. The ETL Developer defines the program specifications for the data migration processes, as well as the necessary test plans used to ensure successful execution. The ETL Developer is also responsible for managing the metadata associated with the ETL processes used to populate the data warehouse. Knowledge of data warehousing ETL procedures such as changing dimension strategies and use of surrogate values is a necessity.Depending on one’s performance, ability, and career goals, there will be ample opportunities to expand one’s skill sets beyond ETL development and into the various aspects of the IBM InfoSphere Information Server Suite, such as QualityStage, Information Analyzer, Change Data Delivery, Balance Optimizer, and Master Data Management.Job ResponsibilitiesResponsible for maintaining enterprise-grade platforms that enable data-driven solutions.Search for ways to automate and maintain scalable infrastructure.Ensure delivery of highly available and scalable systems.Monitor all systems and applications and ensure optimal performance.Analyzes and designs technical solutions to address production problems.Participate in troubleshooting applications and systems issues.Identifies, investigates, and proposes solutions to technical problems.While providing technical support for issues, develop, test, and modify software to improve efficiency of data platforms and applications.Monitors system performance to maintain consistent up time.Prepares and maintains necessary documentation.Participate in daily standups, team backlog grooming, and iteration retrospectives.Coordinate with data operations teams to deploy changes into production.Highest level may function as a lead.Other duties as assigned.Qualifications5+ years of experience in ETL (prefer experience with IBM DataStage), SQL, UNIX/Linux, Big Data distributed systems, various programming languages like Python, orchestration tools and processes or other directly related experience.Extensive experience in data migration, data analysis, data transformations, conversion, interface, large volume data loading (ETL techniques), database modeling, and performance SQL tuning.Significant experience in leveraging database tools to develop DDL scripts, stored procedures, and functions to create and alter database objects.Have a good understanding of entity-relational database design, including data normalization and ERD modeling.Experience working with Greenplum, Oracle, SQL Server, DB2, Teradata, and delimited text files would be helpful.Basic knowledge of Cloud computing, search technology, building real-time data pipelines, scheduling tools and processes.Hands on experiences with Git version control processes, data streaming technologies such as Kafka, and unstructured data handling preferred.Serve in the goalie (On-Call) rotation to support the Production environment.Good analytical, organizational, and problem-solving skills.Ability and desire to learn new technologies quickly.Ability to elicit, gather and analyze user requirements.Ability to work independently and collaborate with others at all levels of technical understanding.Able to meet deadlines.Good judgment and project management skills.Ability to communicate both verbally and in writing with both technical and non-technical staff.Ability to work in a team environment and have good interpersonal skills.Ability to adapt to changing technology and priorities.Must be able to interpret, validate and map business requirements to an appropriate solution.EEO EmployerApex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at ************* or View phone number on click.appcast.io.Required Skills: IBM DataStage, ETL, Python, SQL, LinuxAdditional Skills: Brand new tech center in Midvale, UTBackground Check: YesNotes: 40+ hrs/wk. 8 hour shifts can fall anywhere between 6A-6P shifts, plus an on-call rotation to support off hours and weekends. Average is 3-4 calls per night split among the team. (Their goal is to decrease this number to 1 call per night) Their on-site days are Tue, Wed, Thur.