Who we are :

- In the last 10 years, we have put together an exceptional team and have delivered 200+ projects for over 80 clients ranging from startups to several fortune 500 companies. We are on a mission to solve some of the most complex business problems for our clients using some of the most exciting recent technologies, providing the best of learning opportunities for our team._
- We are data driven. We are passionate. We are innovators. We are Fresh Gravity._

Requirements :

- What You’ll Do**:

- Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.

- Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter and prepare corresponding documentation.

- Designs and builds integrations supporting standard data warehousing objects.

- Performs source system analysis as required.

- Works with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse.

- Implements versioning of the ETL repository and supporting code as necessary.

- Develops stored procedures, database triggers and SQL queries where needed.

- Implements best practices and tunes SQL code for optimization.

- Works with XML's, XML parser, Java and HTTP transformation within Informatica.

- Understanding the business rules and sourcing the data from multiple source systems using IICS.

- Designing and customizing data models for Data warehouse supporting data from multiple sources

- Technically strong in task flow design, dependencies,



and scheduling Hands-on experience in following stages (Lookup, unconnected Lookup, Expression, Join, Normalizer, Hierarchical stage, sort, Aggregator, etc.

- Implement data quality checks and standardization in the code.

- Extracting data and transforming the data based on user requirements using IICS.

- Deploy mappings that will run in a scheduled batch or real-time environment.

- Integrating data to/from On-premise database and cloud-based database solutions using Informatica intelligent cloud services.

- Working with cloud-based database solutions including Azure Synapse, Azure Data Lake Store, AWS Redshift, and Snowflake.

- Document all mappings, mapplets and rules in detail and hand over documentation to the customer.

Copyright©2025 | CONFIDENTIAL Page 3 of 3

- Collaborate with various business and technical teams to gather requirements around data quality rules and propose the optimization of these rules as applicable.

Skills & Experience we value :

- 3-6 years experience professionals
- Strong skills and robust experience in Informatica PowerCenter and IICS (Informatica Intelligent Cloud Services)
- Strong SQL skills and performance tuning capabilities.




- Excellent knowledge of the Informatica platform as a whole and the integration among different Informatica components and services.
- Excellent data analysis and data profiling skills using Informatica and Excel.
- Strong experience in infrastructure architecture, such as designing, hardware sizing, effort estimation and security.
- Good to have skillset: Experience with Azure, Data Warehouse.

Qualifications :

- Bachelor’s or master’s degree in computer science, Information Science, or a related field.

Why us :

- In addition to a competitive package, we promise rich opportunities for you to succeed, to shine, to exceed even your own expectations. In keeping with Fresh Gravity’s challenger ethos, we have developed the 5Dimensions (5D) benefits program. This program recognizes the multiple dimensions within each of us and seek to provide opportunities for deep development across these dimensions. Enrich Myself; Enhance My Client; Build my Company, Nurture My Family; and Better Humanity.

Benefits

In addition to a competitive package, we promise rich opportunities for you to succeed, to shine, to exceed even your own expectations. In keeping with Fresh Gravity’s challenger ethos, we have developed the 5Dimensions (5D) benefits program. This program recognizes the multiple dimensions within each of us and seek to provide opportunities for deep development across these dimensions. Enrich Myself; Enhance My Client; Build my Company, Nurture My Family; and Better Humanity.

📌 Consultant/ Sr. Consultant - Powercenter/ Etl & Iics (Pune)
🏢 Fresh Gravity
📍 Pune