Job description
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 organization’s 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.
Work Mode – Hybrid (2-3 days in a week working from office)
Shift Timings – 5 PM to 2 AM IST (should be flexible to the EST/PST hours when required)
Qualifications
- 6+ years of 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 Informatica, 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 Project Manager to scope, develop, test, and implement conversion/integration
- Effectively communicate with 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 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 client’s data is converted/integrated accurately and within deadlines established by Project Manager.
- Experience in customer SIT, UAT, migration and go live support.
Industry* Information Technology & Services
Employment Type
Full-time