What are the responsibilities and job description for the Data Engineer position at Apollo ITS?
Job Title : Data Engineer
Duration : Long Term
Location : Falls Church, VA
Job Duties :
In this role, the Data Engineer is responsible for developing data flow architectures (designed by an ETL Architect) within various integration patterns for loading analytical structures (DW, DM, ODS etc.), or integrating and migrating applications (EAI). In doing so, the ETL Developer leverages industry-strength data movement technologies such as ODI, PENTAHO, TALEND, INFORMATICA or others.
Responsibilities :
- Configure and customize the chosen ETL tool for client installations
- Optimally leverage the ETL tool components for developing efficient solutions for data management, conversion, migration, and integration
- Develop overall design and determine division of labor across various architectural components (for example ETL tool vs. database)
- Deploy and customize Standard Architecture components
- Mentor client personnel; Train junior staff on the Integration Methodologies and related supplemental solutions
- Support development of task plans including schedule and effort estimation, under the guidance of an ETL Architect
- ETL experience using either Informatica or Data Stage
- Experience with Data Warehousing and Business Intelligence project implementations; Leadership experience a plus
- Experience in working directly with business customers
- SQL skills including complex query building and query performance tuning
- Data analysis skills - ability to dig in and understand complex models and business processes
- UDB, SQL Server, Oracle, My SQL, Netezza or Teradata database experience
- UNIX shell scripting skills (primarily in COBOL, Perl)
- Understanding of Data warehousing design concepts / skills
- Data profiling experience
- Strong ETL performance tuning skills; Ability to analyze and resolve performance issues within variety of operational environments quickly and efficiently
- Ability to analyze data concerning production volumes, batch schedules, and i / o statistics
- Microsoft Office (Outlook, Excel, Word, PowerPoint, Access) experience
- ETL experience using either Informatica or Data Stage or an equivalent technology
- UNIX shell scripting experience
- Dimensional data modeling skills
- Familiar with Agile Development Methodology
- StarTeam Software Configuration Management Tool
- Proficiency in scripting (in order of preference) : Korn, Perl
