Job Description

Aetos LLC is seeking a Senior Informatica ETL Engineer team member to join an existing team providing Extract, Transform and Load (ETL) solutions to a government client. The ideal individual will have 5+ years of experience with Informatica PowerCenter. Must be responsible for successful technical delivery and support of Data Warehousing, Data Migration and Transformation, and Business Intelligence projects using an Agile project management methodology. The duties of this role will include all aspects of data processing, storage, and ingestion, as well as data analysis and visualization of relative multi-program data. 

Qualifications

Responsibilities:  

ETL/Data Warehouse: 

• 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). 

Education & Qualifications 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.  
• Banking and lending domain experience a plus.   

See more jobs at AETOS

Apply for this job

Job Description

Aetos LLC is seeking a Senior ETL Data Engineer team member to join an existing team providing Extract, Transform and Load (ETL) solutions to a government client. The ideal individual will have 5+ years of experience with Informatica PowerCenter. Must be responsible for successful technical delivery and support of Data Warehousing, Data Migration and Transformation, and Business Intelligence projects using an Agile project management methodology. The duties of this role will include all aspects of data processing, storage, and ingestion, as well as data analysis and visualization of relative multi-program data. 

Qualifications

Responsibilities:  

ETL/Data Warehouse: 

• 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). 

Education & Qualifications 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.  
• Banking and lending domain experience a plus.   

See more jobs at AETOS

Apply for this job

Job Description

AETOS is seeking a Business Intelligence / Data Warehouse Technical team member to join an existing team providing business intelligence solutions to a government client.  The ideal individual will have 5+ years of industry experience. Must be responsible for successful technical delivery of Data Warehousing and Business Intelligence projects using an Agile project management methodology.

Qualifications

Responsibilties:

• Maintain, troubleshoot, and develop new enterprise business intelligence (BI) service offerings, content creation, and value propositions to support and improve Government business processes.
• Collaborate with end users to identify needs and opportunities for improved delivery of data supporting agency financial operations and mission.
• 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.
• Administer and troubleshoot BI reporting tool installations: Hyperion, OBIEE, Tableau.
• Provide end-user support and encourage user adoption. Act as Tier 1 support for end-users of BI tools. Train and support end-user analysts. Direct users to training material and available resources.
• Convert business requirements and high-level data collection needs into well-specified analyses, reporting and visualizations.
• Define and log work using JIRA.
• Participate in recurring team meetings (Agile)

Education & Qualifications Required: 

• Bachelor’s degree in a related field
• 5+ years of relevant experience
• Excellent analytical, organizational, verbal, and written communication skills.
• Experience in gathering requirements and formulating business metrics for reporting.
• Experience developing and troubleshooting BI reports.
• Experience administering BI tools including Hyperion, OBIEE, Tableau.
• Experience working in a Microsoft SharePoint environment.
• Experience with AGILE and writing User Stories
• Must be able present diagnostic, troubleshooting steps and conclusions to varied audiences.
• Experience using Informatica PowerCenter a plus but not necessary
• Experience monitoring and maintaining enterprise BI reporting services.

Banking and lending domain experience a plus but not necessary

See more jobs at AETOS

Apply for this job

Job Description

Aetos LLC is seeking a Senior Full-Stack Data Engineer team member to join an existing team providing business intelligence and Extract, Transform and Load (ETL) solutions to a government client. The ideal individual will have 5+ years of experience. Must be responsible for successful technical delivery and support of Data Warehousing, Data Migration and Transformation, and Business Intelligence projects using an Agile project management methodology. The duties of this role will include all aspects of data processing, storage, and ingestion, as well as data analysis and visualization of relative multi-program data.

Responsibilities: 

Data Warehouse/ETL:

• Create and maintain the Extract, Transform, and Load (ETL) procedures for the Data Warehouse (DW) environment using the Informatica PowerCenter suite. Any knowledge of Informatica Cloud Integration Services a plus 

• 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). 

Business Intelligence:

• 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. 

• Maintain, troubleshoot, and develop new enterprise business intelligence (BI) service offerings, content creation, and value propositions to support and improve Government business processes. 

• Collaborate with end users to identify needs and opportunities for improved delivery of data supporting agency financial operations and mission.  

• Support and troubleshoot BI reporting tool installations including: Hyperion, OBIEE, Tableau, etc. 

• Provide end-user support and encourage user adoption. Act as Tier 1 support for end-users of BI tools. Train and support end-user analysts. Direct users to training material and available resources. 

• Convert business requirements and high-level data collection needs into well-specified analyses, reporting and visualizations. 

Recurring Tasks for all areas include: 

• Define and log work using JIRA. 

• Participate in recurring team meetings (Agile). 

Qualifications

Education & Qualifications Required: 
 

• Bachelor’s degree in Computer Science, Software Engineering, or commensurate experience in a related field.  

• 5+ years of relevant experience. 

• Excellent analytical, organizational, verbal, and written communication skills. 

• Experience in gathering requirements and formulating business metrics for reporting. 

• Proficiency in computer programming and coding: SQL, Linux shell scripting. 

• Familiarity with Erwin data modeling tool. 

• Experience data mapping using Informatica PowerCenter. 

• Experience developing and troubleshooting BI reports. 

• Experience administering BI tools including Hyperion, OBIEE, Tableau, etc. 

• 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. 

• Banking and lending domain experience a plus.  
   

See more jobs at AETOS

Apply for this job