Etl Developer

Position Summary

The Senior Consultant will integrate and map customer data from client source system(s) to our industry-leading platform. The role will include, but is not limited to:

• Using strong technical data migration, scripting, and organizational skills to ensure the client data is converted efficiently and accurately to the insightsoftware (ISW) platform.
• Performing extract, transform, load (ETL) activities to ensure accurate and timely data conversions.
• Providing in-depth research and analysis of complex scenarios to develop innovative solutions to meet customer needs whilst remaining within project governance.
• Mapping and maintaining business requirements to the solution design using tools such as requirements traceability matrices (RTM).
• Presenting findings, requirements, and problem statements for ratification by stakeholders and working groups.
• Identifying and documenting data gaps to allow change impact and downstream impact analysis to be conducted.

Qualifications

• Experience assessing data and analytic requirements to establish mapping rules from source to target systems to meet business objectives.
• Experience with real-time, batch, and ETL for complex data conversions.
• Working knowledge of extract, transform, load (ETL) methodologies and tools such as Talend, Dell Boomi, etc.
• Utilize data mapping tools to prepare data for data loads based on target system specifications.
• Working experience using various data applications/systems such as Oracle SQL, Excel, .csv files, etc.
• Strong SQL scripting experience.
• Communicate with clients and/or ISW Project Manager to scope, develop, test, and implement conversion/integration
• Effectively communicate with ISW Project Managers and customers to keep project on target
• Continually drive improvements in the data migration process.
• Collaborate via phone and email with clients and/or ISW Project Manager throughout the conversion/integration process.
• Demonstrated collaboration and problem-solving skills.
• Working knowledge of software development lifecycle (SDLC) methodologies including, but not limited to: Agile, Waterfall, and others.
• Clear understanding of cloud and application integrations.
• Ability to work independently, prioritize tasks, and manage multiple tasks simultaneously.
• Ensure clients data is converted/integrated accurately and within deadlines established by ISW Project Manager.
• Experience in customer SIT, UAT, migration and go live support.

Additional information

All your information will be kept confidential according to EEO guidelines.