IICS Developer

GoAhead Solutions has an immediate need for an IICS(Informatica Intelligent Cloud Services) Developer in Boston, MA. This would be a Twelve month contract to start out with extension. This is a hybrid position and will require to work onsite a couple of days a week.

Major Responsibilities:

-Must have Kafka experience.

-Create/Enhance ETL jobs as needed to load external feeds into warehouse tables/data mart tables.

-Work with an agile team to deliver and evolve the data platform services

-Provide technical support to User Acceptance and Integration testing environments by researching suspected anomalies and periodically refreshing the environments.

-Performance tuning ETL process and user queries.

-Develop the production process to automate the ETL and create documentation to transition the process to the Production team.

-3 plus years of experience distributed databases particularly in designing and implementing ETL processes; understanding of data models and data flow.

-Experience in data modelling, schema designing, data loading, data replication, SQL Query writing and optimization on distributed databases preferably on Cloud Technologies.

-Working experience with distributed databases on cluster/platform.

-Must have at least 1 plus year hands-on experience in Integrating Informatica Cloud (IICS)

-Experience with AWS technologies

-Experience in working in Agile methodology

-Proficiency in understanding relational, star schema and dimensional data models

-Excellent oral and written communication.

-Ability to handle multiple priorities and meet deadlines.