Data Integration Job Description
Data Integration Duties & Responsibilities
To write an effective data integration job description, begin by listing detailed duties, responsibilities and expectations. We have included data integration job description templates that you can modify and use.
Sample responsibilities for this position include:
Data Integration Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Data Integration
List any licenses or certifications required by the position: ITIL, BS, ETL, SSL, SSH, TCP/IP, SQL, MS, EAI, AWS
Education for Data Integration
Typically a job would require a certain level of education.
Employers hiring for the data integration job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Education, Engineering, Information Technology, Business, Information Systems, Technical, Mathematics, Computer Engineering, Computer
Skills for Data Integration
Desired skills for data integration include:
Desired experience for data integration includes:
Data Integration Examples
Data Integration Job Description
- Help manage risk through identification of data quality issues and raise awareness to business and IT stakeholders
- Work with multiple internal teams
- Data integration and migration components and procedures
- Providing technical expertise, estimates, and recommendations to project managers
- Participating in requirements discussions and meetings as necessary
- Send out email test blasts
- Validate the deployment setup in campaign management tool
- Creation of vendor data feed
- Create data file for vendor as needed
- Scrub the file and reformat file
- Must be able to document requirements and solution modifications
- Strong written and verbal communication skills are highly preferred
- Candidate must be fluent in the English language
- Candidate may be asked to provide a writing sample
- Bachelor's degree in Computer Science, Engineering, related field or equivalent work experience
- 5+ years of hands-on experience with ETL technologies supporting, developing and optimizing complex data extract, transformation and load solutions
Data Integration Job Description
- Monitor health of database by running operational reports
- Investigate and remedy data discrepancies as needed
- Gather, understand and challenge requirements (functional nonfunctional)
- Perform data integration solution development tasks
- Advanced performance tuning of data integration solution
- Manage and operate developed solution via scheduler or orchestrator
- Support the pre-sale process communicate with the client
- Cooperate and develop internal repository of knowledge base
- Establish partnerships with key technology teams across the company to leverage existing technologies and processes, evangelize best practices
- Employ agile product development methodologies that accommodate changing business conditions and reduce time to market of solutions
- Driven to understand data models from a technical solution and business use perspective
- Motivated to influence the technical discipline direction, standards and processes
- Demonstrated ability to design, develop and deliver the simplest solutions to complex challenges
- Ability to work and collaborate directly with internal business partners
- Excited about working in a collaborative, dynamic and fast paced environment
- Proven experience to lead technical teams, mentor and oversee offshore developers
Data Integration Job Description
- Engages and communicates with cross-functional stakeholders involved in work streams impacting their areas of responsibilities
- Write scripts to retrieve data from non-proprietary systems using APIs
- Engages with technical and non-technical client contacts to acquire data extraction access and resources and install the data extract utility
- Trains clients how to use and configure the data extract utility
- Configures and monitors all ETL systems
- Troubleshoots and resolves issues with all ETL systems
- Facilitate technical issue resolution by interacting with clients and colleagues via both written and verbal communication
- Trains and coaches colleagues in the use of data collection and processing systems
- Tests new products and product updates
- Creates, maintains and updates ETL system documentation as needed
- Flexible and willing to take-on new challenges as assigned
- Experience with iterative, lean or agile development methodologies a plus
- Experience in leading other IT disciplines such as Database Administration, Front-end tools, Reporting tools
- Bachelor’s degree in Computer Science/Management Information Systems or equivalent from an accredited institution is strong preferred
- Three or more years of professional IT experience
- ETL Tool experience
Data Integration Job Description
- Leading a cross function team of IT developers managing and preparing data feeds for a data warehouse
- Defines and achieves the strategy roadmap for the program
- Ability to coach and mentor senior and mid-level functional staff on the development of projects plans
- Understand and meet partners’ data integration needs and offer solutions
- In close collaboration with molecule project teams and any other relevant technical groups identify and prepare integrated data for analysis by quantitative scientists
- Demonstrate skills and knowledge of relational database management system, Microsoft Access Database, Oracle Database Server, and others
- The Data Integration Developer is responsible for using approved programming languages, operating systems and source code to create, enhance, and maintain solutions that meet the identified functional and non-functional business requirements
- Code/build application solutions from specifications provided by Requirements Analysts and Data Integration Architect in support of Data Warehouse and Data Quality projects
- Develop, execute, and document results of unit tests and functional test coverage for assigned coding changes to ensure code quality
- Follow processes and procedures to ensure the quality of technical solutions
- Strong problem solving skills/aptitude for creative thinking
- Experience with technical requirements documentation
- Informatica Cloud and Salesforce.com administrator experience preferred
- Executes proficiently all tasks and responsibilities
- 2-3 years' experience with developing reporting modules, including dashboards and scorecards within a BI tool
- At least 5 years' experience with developing reporting modules, including dashboards and scorecards within a BI tool (Microstrategy, Cognos, Jaspersoft, Pentaho, or Tableau)
Data Integration Job Description
- Understands and participates in testing applications and ensuring quality products
- Perform documentation of all code changes
- Support Senior Data Integration Developers in compiling detailed activity task management including recording work effort and providing estimates of time to complete tasks
- Develop and maintain code repositories according to established version management approaches and methods as defined
- Follow code construction fundamentals for coding practices, guideline for use of data, control-related concepts, and error-detection practices
- Assist in identification and evaluation of risks
- Provide on-call support in support of Data Integration processes in production
- Perform production support activities including incident and problem management, code corrections, upgrades and patches
- Remain current on industry specific technologies and emerging trends
- Our consultants are expected to interact with key decision makers (CIO, IT Directors, ) at our clients to drive and deliver projects
- 7+ Years of managing/delivering large and complex IT projects
- Bachelor’s Degree in finance, economics, mathematics, engineering, CIS, MIS, or related field from a reputable, accredited university
- 8+ years of experience working with large volumes of medical claims data
- Collect multiple streams of data and decompose them into concise specifications
- Collaborate with technical experts and business units to determine the best possible reporting mechanisms
- Solid experience utilizing Tableau (or like product)