Consultant/ Sr. Consultant - PowerCenter/ ETL & IICS
Who we are:
Founded in 2015, Fresh Gravity helps businesses make data-driven decisions. We are driven by data and its potential as an asset to drive business growth and efficiency. Our consultants are passionate innovators who solve clients’ business problems by applying best-in-class data and analytics solutions. We provide a range of consulting and systems integration services and solutions to our clients in the areas of Data Management, Analytics and Machine Learning, and Artificial Intelligence.
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 new technologies, providing the best of learning opportunities for our team.
We are focused and intentional about building a strong corporate culture in which individuals feel valued, supported, and cared for. We foster an environment where creativity thrives, paving the way for groundbreaking solutions and personal growth. Our open, collaborative, and empowering work culture is the main reason for our growth and success. To know more about our culture and employee benefits, visit our website https://www.freshgravity.com/employee- benefits/. We promise rich opportunities for you to succeed, to shine, to exceed even your own expectations.
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.