ETL Consultant - SQL - (Immediate joiners only)

Job description

Company Overview:

Innovya Technologies is a dynamic and growing software consulting firm that drives business automation with cutting-edge solutions. We help businesses quickly realize value from their technology and digital initiatives by delivering expert, context-driven product development.

Cultural Fit:

At Innovya, we thrive in a fast-paced, supportive environment where continuous learning, teamwork, and disciplined execution are key. If you're results-driven, growth-minded, and eager to make an impact, Innovya is the place for you!

Position Summary

The 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.

Shift Timings 2 P.M - 11 PM IST and 5 PM to 2 AM IST

Qualifications

• 3+ 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, DataStage, 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.