Previous Job
Data Integration Engineer
Ref No.: 18-06331
Location: Glen Allen, Virginia
A Senior Data and Integration Engineer can:
- analyze problems and is an expert in at least two or more Data Management tools
- understand and develop  requirements for a system (mapping documents)

Essential Functions:
-Develops, test and maintains code using software development methodology and appropriate technologies for the system being used. 
-Works closely with Business Analysts to develop detail systems design and written test plans for online and report application programs.
-Performs analysis on projects and provides a project plan that shows the tasks needing to be completed and a time estimate for each task.
-Participates in design walkthroughs with appropriate focus groups and related users to verify accuracy of design in meeting business needs. 
-Prepares installation instructions and coordinates installation procedures.
-Supports and troubleshoots application code problems. 
-Provides status reports that give a detailed description of the current projects progress and indicates time devoted to each task of the project.
-Coordinates, guides and mentors programming efforts performed by in-house programmers or outside consultants to ensure that all programming is completed according to the project plan.

Role based competencies:
  • Development of interfaces/load process using Databases Oracle/SQL Server/Flat files
  • Highly Organized – weekly status reports and time reporting
  • Ability to learn new technologies and frameworks
  • Ability to collaborate and work with teams
  • Ability to analyze and troubleshoot issues
  • Collaborate with teams to identify and understand key information and data assets
  • Should have strong knowledge of Oracle, SQL Server
  • Should have working knowledge of Performance optimization and tuning tools.
  • Should be able to work in Agile and Waterfall based projects
Technical Skills:                          
  • Experience with ETL Tools such as Informatica, Snaplogic etc
  • Experience in UNIX shell scripting is a plus.
  • Experience in designing and architecting data interfaces is a plus
  • Experience in implementing Data Quality validations is a plus
  • Demonstrated ability in performance optimization - analysis of logs, traces, troubleshooting and performance tuning is required.
  • IDE such as Toad, SQL Developer
  • Knowledge of AWS resources and services is a plus
Cultural fit:
  • Strong Communication skills
  • Execution – Ability to develop quality code with limited oversight
  • Continuous Improvement
  • 5-7 years of working experience with Informatica, 2-4 years with Snaplogic
  • Should be proficient in Software Development Lifecycle
  • Ability and Prior experience in taking a product through the entire lifecycle of analysis, design, coding, testing and implementation and support is a plus.
  • Experience in health care industry is a plus
  • Experience with big data related technologies such as Hadoop, Redshift is a plus
  •  Bachelor's degree required.

Best Regards,
Kuldeep(KD) Singh
LanceSoft Inc.