Fiserv has flagged the Conversion Analyst job as unavailable. Let’s keep looking.

Lead Consultant - Conversion Analyst – Hyperion Consultant with MySQL experience

Genpact

With a startup spirit and 115,000+ curious and courageous minds, we have the expertise to go deep with the world’s biggest brands—and we have fun doing it. We dream in digital, dare in reality, and reinvent the ways companies work to make an impact far bigger than just our bottom line. We’re harnessing the power of technology and humanity to create meaningful transformation that moves us forward in our pursuit of a world that works better for people. Now, we’re calling upon the thinkers and doers, those with a natural curiosity and a hunger to keep learning, keep growing., People who thrive on fearlessly experimenting, seizing opportunities, and pushing boundaries to turn our vision into reality. And as you help us create a better world, we will help you build your own intellectual firepower.

Welcome to the relentless pursuit of better.

Inviting applications for the role of Lead Consultant - Conversion Analyst – Hyperion Consultant with MySQL experience!!

Required a skilled and experienced professional to join our team as a Data Conversion Analyst with excellent Hyperion and My SQL knowledge.

  • Mandatory - The resource should have skills on both Hyperion and MySQL development. 

Responsibilities

This role is critical in the context of our enterprise resource planning (ERP) system migration project, where you will be responsible for exporting the data from Hyperion for GL Actuals, Budget, Plan, Forecast, CapEx and Workforce planning. 

Also need to perform impact analysis on existing multiple boundary applications building MYSQL scripts, work on the functional and technical design documents with cross functional team members and transforming data from our existing environments and many other sources.

The candidate should be responsible for doing the validation of converted data in multiple environments. 

Data extraction 

Extract data from Essbase data targets to flat files(excel/csv) into EPBCS.

Extract data from MySQL database to the excel or CSV files. 

Write and optimize complex SQL queries to retrieve, analyze, and manipulate data quickly and efficiently. 

Develop, maintain, and optimize stored procedures, triggers, and functions to support custom application requirements. 

Optimize SQL queries and data extraction processes to enhance performance and minimize downtime during the migration. 

Transformation:

Transform and cleanse extracted data to meet the format and quality standards required for the boundary applications. Implement data mapping and conversion rules as per the project's specifications. 

Data Validation: 

Create Pre-validation and Post-validation reports for business validation. 

Perform data validation and quality checks to ensure that the extracted data meets the migration criteria. 

Documentation: 

Maintain detailed documentation of the data extraction and transformation processes, including data mapping, and any data-related issues encountered. 

Maintain clear and comprehensive documentation of database processes, procedures, and configurations. 

Collaboration: 

Collaborate with cross-functional teams, including boundary application consultants, and ERP business analyst, to understand the migration requirements and coordinate data conversion efforts. 

Troubleshooting: 

Identify and resolve any data extraction challenges that may arise during the project.

Qualifications we seek in you!

Minimum Qualifications

Bachelor’s degree in computer science, Information Technology, or a related field. 

Experience in Hyperion planning and Essbase consultant. 

Experience in data conversion on previous projects will be an added value. 

Proficiency in writing complex SQL queries and optimizing the scripts. 

Experience in performance tuning and query optimization. 

Solid understanding of stored procedures, triggers, and functions. 

Knowledge of data conversion best practices. 

Strong problem-solving and troubleshooting skills. 

Excellent communication and collaboration abilities. 

Preferred Qualifications:

Hyperion certification

Experience with other financial planning and analysis tools such as SAP BPC, Oracle PBCS, or Anaplan

Experience with ETL tools such as Informatica or Oracle Data Integrator

Experience with cloud-based solutions such as Oracle Cloud or AWS

Experience with programming languages such as Java or Python

Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation. For more information, visit www.genpact.com . Follow us on Twitter, Facebook, LinkedIn, and YouTube.

Furthermore, please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a 'starter kit,' paying to apply, or purchasing equipment or training.

Read Full Description
Confirmed 23 hours ago. Posted 30+ days ago.

Discover Similar Jobs

Suggested Articles