View Our Website View All Jobs

IT Engineer

IT Engineer

Dayton, OH

Prefer a Secret Clearance but must be eligible for a clearance.

The candidate should be familiar with the technical aspects of Extract, Transform and Load (ETL), Teradata, Informatica, Business Objects or Cognos.  The candidate must possess strong troubleshooting skills and problem solving abilities, with solid communication skills to accomplish the following specific duties:

Monitor and ensure system performance; make recommendations and inputs to improve performance, processes and automated reporting.
Monitor and troubleshoot regular data load processes to ensure availability and data accuracy
Experience with data loading techniques, including bulk load facilities, index and key creation, and dropping and truncating of tables
Administer and maintain the ETL / integration environment including performing configuration management and monitoring activities
Develop technical best practices for enterprise application integration, data quality, data cleansing, ETL and other data management activities
Provide data analysis and technical documentation for integration process, as needed
Analyze source system data to assess data quality; work with technical and business representatives to determine strategies for handling identified data anomalies
Consult with users to troubleshoot system issues, provide advice, direction and resolution
Serve as a coordinator for testing activities on a project, as required
Perform moderately complex-to-complex test data conditioning, regression testing and testing validation
Provide specific details and guidance on system defects escalated to development teams
Log, track and verify resolution of software and specification defects
Provide backend support and maintenance for the data warehouse, as requested
Work with business intelligence and data warehousing applications to manage and model data effectively
Understand complex extracts from Data Warehouse
Guide, train, instruct and assist others with technical issues
Create, prepare and implement systems quality assurance reviews for numerous applications
Design ETL / integration processes and develop source to target data mappings, integration workflows and load processes
Ability to design, create and load Cognos and Business Objects data structures and reporting
Conduct in-depth data analysis and evaluation to determine data quality issues

Experience developing, testing, and deploying ETL solutions using leading ETL tools (Informatica preferred)
Experience in best practices design of ETL / integration implementations in a high volume environment including software, database, and hardware tuning
SQL, PL/SQL and Oracle Database skills are required
Experience administering, optimizing and maintaining ETL environments
Hands-on experience and understanding of current development languages / toolsets
Excellent problem solving skills and strong attention to detail
Ability to work effectively in a rapidly changing, team-based environment
Understand data integration processes and how to tune for performance
Ability to develop work plans and follow through on assignments with minimal guidance
Ability to work with customers to obtain requirements and manage expectations
Outstanding communication and collaboration skills with business/technical communities
Understanding of Data Warehouse principles and best practices

BS / BA degree desired (preferably in a technical discipline)

Send resume to blea@latitudeinc.net

Read More

Apply for this position

Required*
Apply with Indeed
Attach resume as .pdf, .doc, or .docx (limit 2MB) or Paste resume

Paste your resume here or Attach resume file

150