What are the responsibilities and job description for the ETL-Informatica Developer position at Savan Group?
Savan Group is seeking an ETL-Informatica Developer to support a U.S. federal civilian agency to satisfy client requirements to maintain a data warehouse and support legacy systems to ensure continuity of operations and create and maintain dashboards and various data visualization tools to provide timely and relevant information to client leadership and decision-makers.
Role Responsibilities:
- Responsible for the daily operations and maintenance of the client’s reporting and data warehouse environment.
- Monitor successful completion of production and test batch jobs.
- Utilize Informatica PowerCenter Client to create a source to target mappings, workflows, and mapplets to load data into the data warehouse.
- Experience integrating data from client’s source applications so that data can easily be queried.
- Design and develop and maintain data warehouse and analytics architecture to support the agency’s business analysis and reporting.
- Conduct impact analysis of reports and data warehouse based on source system and data warehouse changes.
- Respond to clients’ ad hoc and recurring data calls to fulfill short-turn or scheduled requests for information from client leadership or relevant stakeholders.
- Mentor developers in coding complex queries, developing efficient code, creating reports, and designing technical solutions for obtaining accurate data.
- Research financial discrepancies between different source systems and between source systems and data warehouses, isolate the specific data issue, and communicate the problem to financial and IT staff.
- Update data models in Erwin.
- Present project status and provide demos to senior management.
- Analyze data in the data warehouse and determine logic to load data from various sources into a consolidated data mart for efficient and accurate agency-wide reporting.
Qualifications and Requirements:
- Bachelor’s degree in computer science, information systems, or 7 years of equivalent experience in a related field.
- Experience developing data models in Erwin.
- Experience developing ETL scripts in Informatica PowerCenter.
- Data warehousing experience.
- Must be able to perform as a Data Warehouse Developer/Administrator on large-scale database management systems, knowledge of computer equipment and ability to develop complex software to satisfy design objectives.
Preferred Qualifications:
- Possesses the ability to assume increasing responsibilities in enterprise data warehouse project information system design and management.
Job Location and Schedule
Remote/Hybrid
Application Process
Submit your application to the link on this page. Applicants selected for interviews will be notified by email or phone.
EOE, including disability and veterans.
Savan Group is an Equal Opportunity Employer and is committed to a workplace free of discrimination. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy), gender identity, and sexual orientation, national origin, age (40 or older), marital status, disability, genetic information, status as a protected veteran, or any other applicable legally protected characteristics.
If you are an individual with a disability and would like to request a reasonable accommodation for the employment process, please email your request to humanresources@savangroup.com. For more information about our company, please visit our website at www.savangroup.com.