Job Seekers, Please send resumes to resumes@hireitpeople.com Must Have Skills: IICS Development Snowflake Development Data modelling Nice to have skills: Java Detailed Job Description: 5+ yrs Experience in IICS Application Integration components Expertise in using methodologies for data extraction, transformation and loading data using various transformations like Expression, Router, Filter, Lookup, Update Strategy, Union, and Aggregator. Build Service connectors for Real Time integration with Third party applications. Experience in Integrating Informatica cloud with other applications like Salesforce. Strong technical experience building data integration processes by constructing mappings, tasks, taskflows, schedules, and parameter files. Ability to write scripts for File watching and File transfer protocols. Experience leveraging and writing architectural patterns, best practices and guidelines for enterprise applications. Atleast 4 yrs Experience with SnowSQL development Develop implement and optimize stored procedure and function using SQL (Snowflake SQL preferable) Demonstrate expertise in data modeling and ELT using Snowflake SQL, implementing complex stored procedures and best practices with data warehouse and ETL concepts Expert level in working with SQL against Snowflake data warehouse Experience working with different file formats like Parquet, CSV, Fixed width, JSON etc. Familiarity with code versioning tools Git. Knowledge of implementing CI/CD on the pipelines is a plus. Experience gathering and analyzing system requirements Communicate project status with management

Minimum years of experience: 7 - 10 years

Certifications Needed: No

Top responsibilities you would expect the Subcon to shoulder and execute:

Requirement analysis, analyze and understand data structure of source systems data available thru OData collaborate with offshore provide demo to the client on working software

Interview Process (Is face to face required?) No

Does this position require Visa independent candidates only? No