Senior Consultant-ETL,Informatica(5:00pm to 2:00am)
- Full-time
Company Description
About Us:
insightsoftware is a leading provider of software solutions for the Enterprise Information Management market. Our Magnitude Software family of solutions dramatically accelerates time-to-value for your Enterprise Information Management needs including query, reporting, analysis, and master data management for enterprise Applications, with a low total cost of ownership. We’re busy evolving the way people and organizations manage information. Our technologies help companies access and analyze their data no matter where it resides-all from a single point of entry. The Magnitude Software integrated suite of products is designed to boost productivity by empowering end users and decision makers with secure access to the right data at the right time, allowing them to easily build their own custom reports and make timely decisions.
Job Description
Insightsoftware (ISW) is a growing, dynamic computer software company that helps businesses achieve greater levels of financial intelligence across their organization with our world-class financial reporting solutions. At insightsoftware, you will learn and grow in a fast-paced, supportive environment that will take your career to the next level. The Data Conversion Specialist is a member of the insightsoftware Project Management Office (PMO) who demonstrates teamwork, results orientation, a growth mindset, disciplined execution, and a winning attitude.
Location: Hyderabad (Work from Office)
Working Hours: 5:00 PM - 2:00AM IST or 6:00 PM to 3:00 AM IST. should be ok to work in night shift as per requirement.
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 client’s 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
Education Requirements
- Bachelor’s degree in computer science, information systems, or equivalent
- 7 years of Information Technology experience (preferred)
- 4 years of experience as a data conversion specialist or similar position
- Excellent English written, oral and presentation skills.
** At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the country where the position is located. **
insightsoftware About Us: Hear From Our Team - InsightSoftware (wistia.com)
Background checks are required for employment with insightsoftware, where permitted by country, state/province.
At insightsoftware, we are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, national origin, gender, sex, gender identity or expression, sexual orientation, age, citizenship, marital or parental status, disability, veteran status, or other class protected by applicable law. We are proud to be an equal opportunity workplace.