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 new 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 recent 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

📌 Consultant/ Sr. Consultant (Pune)
🏢 Fresh Gravity
📍 Pune