ETL Consultant - Informatica/DataStage/Abinitio, SQL - (Immediate joiners only)

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.

Full-time