Job ID :
38238
Company :
Internal Postings
Location :
Irving, TX
Type :
Contract
Duration :
12 Months
Salary :
DOE
Status :
Active
Openings :
1
Posted :
13 Sep 2022
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