Position: Informatica developer
Location: Plano, TX/Chicago IL
Duration: Long term/ Contractual
Primary skills: Informatica development, Snowflake, Informatica on cloud
•3+ years experience in Designing and developing data integrations using Informatica Cloud(IICS)
•5+ year's experience in Designing and developing data integrations using Informatica
•2+ years of experience in working on Snowflake architecture (virtual warehouses, staging, transient tables etc.)
•2+ years of experience in Unix shell scripting, Strong SQL experience
•Strong background in Informatica PowerCenter
•Experience in implementing ETL best practices and provide technical assistance in identifying, evaluating, and developing ETL solutions on IICS.
•Analyze data requirements, complex source data, and the data model, and determine the best methods in extracting, transforming and loading the data into the data staging, warehouse and other system integration projects.
•Analyze business requirements and document ETL high level and low level design based on requirements and ETL standards.
•Develop and deploy Informatica cloud components with reliable error/exception handling and rollback as required.
•Manage foundational data administration tasks such as scheduling jobs, troubleshooting job errors, identifying issues with job windows, assisting with data sync and performance tuning.