Software Developer-Informatica (IICS)

Vistra| tricor

A powerful combination

It’s never been a more exciting time to join our organisation. Tricor and Vistra have now merged to form one organisation, which means we’re now a powerhouse of over 9000 colleagues in 50+ jurisdictions across the globe. We’re seizing the opportunity to create a purpose-led organisation that will unlock significant value for our business, our clients, and our people.

We have an exciting opportunity for you to join our team as Software Developer reporting to the Lead, this full-time and permanent position is based in Mumbai, India and offers regional coverage, allowing you to make a significant impact to our technology department and its’ growth.

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

Company Benefits -

At our Vistra GSC office, we believe in putting our employees’ well-being first! We offer a hybrid working arrangement. Additionally, we provide attractive insurance benefits, excellent job exposure and career prospects.

If you are excited about working with us, we encourage you to apply or have a confidential chat with one of our Talent. Acquisition team members. Our goal is to make this a great place to work whereall our people can thrive. We hope you join us on this exciting journey