Aetos Systems, Inc. ยท 2 days ago
Senior ETL Data Engineer
United States
Full-time
Remote
Senior Level
5+ years exp
Maximize your interview chancesBuilding MaterialEducation
No H1B
U.S. Citizen Only
Insider Connection @Aetos Systems, Inc.
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Create, maintain, and reverse engineer the Extract, Transform, and Load (ETL) procedures for the Data Warehouse (DW) environment using the Informatica PowerCenter suite.
Perform analysis of RDBMS tables and PowerCenter objects to answer questions pertaining to the data warehouse and the data transformations.
Create and maintain scripts and files that perform various functions on the Informatica integration servers. Use Putty or other Unix text editor to maintain Linux environment.
Maintain data model documentation (ERwin) if changes to the ETL require database changes, and develop, test, and deploy associated DDL.
Manage releases of changes to ETL, scripts, DDL, and scheduling components from Development to Test to Production.
Provide support for the Test, Certification, and Production DW environments.
Maintain Consolidated Data Model (CDM).
Any knowledge of Informatica Cloud Integration Services a plus
Provide ongoing development and maintenance of financial data marts and enterprise data warehouse using BI best practices, relational structures, dimensional data, structured query language skills, data warehouse and reporting techniques.
Collaborate with end users to identify needs and opportunities for improved delivery of data supporting agency financial operations and mission.
Convert business requirements and high-level data collection needs into well-specified ETL, analyses, reporting and visualizations.
Define and log work using JIRA.
Participate in recurring team meetings (Agile).
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Bachelor's degree in computer science, Software Engineering, or commensurate experience in a related field.
5+ years of experience using Informatica PowerCenter at development level (creating mappings, workflows, etc).
7+ years of relevant experience in ETL development support and maintenance.
Strong SQL (Oracle) abilities.
Proficiency in shell scripting.
ETL environment where Salesforce a source a plus.
ETL environment where Control-M used a plus.
2+ years of Informatica PowerCenter administration. If in a Linux environment a plus.
Knowledge or usage of Informatica IICS, EDC, and or AXON a plus.
Excellent analytical, organizational, verbal, and written communication skills.
Experience in gathering requirements and formulating business metrics for reporting.
Familiarity with Erwin data modeling tool.
Experience working in a Microsoft SharePoint environment.
Experience with AGILE and writing User Stories.
Must be able to present diagnostic, troubleshooting steps and conclusions to varied audiences.
Experience monitoring and maintaining enterprise Data Warehouse platforms and BI reporting services.
Candidate must be a US citizen and must be able to pass a security background check.
Candidate must reside in the US.
Preferred
Any knowledge of Informatica Cloud Integration Services a plus.
Banking and lending domain experience a plus.
Company
Aetos Systems, Inc.
Aetos Systems, Inc.
201-500 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase
