Software Developer|Informatica

Why Vistra

At Vistra, we believe our clients’ businesses and people can make a difference in the world. That’s why our work is focused on helping our clients act with confidence and speed to seize opportunity wherever it arises. As a global corporate service provider and fund administrator with more than 5,000 professionals in over 45 jurisdictions, we empower legal entities globally to work smarter, grow faster, act responsibly, protect capital and scale across borders — by doing what we do best: reducing risk and enhancing efficiency.

We support our clients over six sectors: Private Equity, Real Estate, Capital Markets, Corporate, Company Formation and Private Wealth and deliver value across three service lines:
• Governance, Risk and Compliance
• Advisory and Transaction Support
• Finance, Accounting and Administration

We grow when you grow, and we succeed when we work together across boundaries and borders, as one team. So, our promise to our clients is the same to you: working together, we will give you the confidence, the tools and the support to achieve your ambitions and leverage your unique skills — to seize your opportunity and help make a difference in the world.

You can also check out our LinkedIn Life page and our About us page to get a sense of Vistra’s culture and our values.

So, what do you think? If you are excited about working with us and think you can get the job done but not quite sure if you meet all the requirements 100%, we want to encourage you to give it a try OR have an informal chat with one of our Talent Acquisition representatives.

Our opportunity for you:

Software Developer, Mumbai-Vikhroli (West)

Purpose of the role:

To join the Data Platform team as a Software Developer developing user stories in Informatica (IICS) and fixing BAU Production tickets.

Scope:

Coding on ETL including Informatica Cloud

Key responsibilities:
• ETL Development skills, hands on role that will develop and deliver solutions that enable the collection, transformation and management of information from one or more sources.
• The ideal Developer for this role is able to handle end-to-end Data Warehouse and Data Integration by taking into consideration the business cases, objectives and requirements.
• Debug and tune data integration processes; analyse data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, dimensional surrogate key handling, exception data processing, troubleshoot and recommend improvements and alternate methodologies
• Participate in code reviews and ensure that all solutions are aligned to Software Developer pre-defined architectural and requirement specifications
• Provide L2 and L3 support of ETL processes to ensure timely completion and availability of data in data warehouse for reporting use. Analyses and resolves problems and provides technical assistance as is necessary. Implements corrective actions
• May prepare or review product documentation, written instructions or technical literature for accuracy and completeness
• Data Quality management
• Maintenance of business rules associated with data integration
• Participate in the fulfilment of ad-hoc data requests from internal business owners
• Participate in design reviews and provide input to the design recommendations; provide input to information/data flow, understand and comply with Project Life Cycle Methodology in all planning steps

Attributes & Skills:
• Can do attitude, with the ability to drive to success in both independent and group projects
• Demonstrated experience with data integration architectures, data analysis and implementation
• Demonstrated experience with ETL tools, including Informatica Cloud IICS
• Demonstrated experience with Enterprise level Data Warehousing
• Demonstrated experience with Snowflake and SQL
• Able to be agile in thinking and approach to solve the problem at hand.
• Experience Application Support and Maintenance
• Ability to work with other IT groups and business users

Relevant experience:

Minimum of 4 years’ experience working as a ETL developer in a change environment with a proven ability to handle L2/L3 production support and enhancements

Education/Professional Qualifications:

Engineering or Bachelor of Science Graduate

Join US!

Our promise to our clients is simple: we help them seize opportunity and make a difference in the world. It’s the same to you