Senior Informatica Developer

SOFT’s client located in New York, NY is looking for a Senior Informatica Developer for a long term contract assignment.

Required Skills: • 8+ years of solid experience in Informatica Powercenter (including versions 8.6 & above), Unix (AIX) shell scripting, & Oracle (including 10G & above) PL/SQL programming, SQL Server stored procedures • 4 years of experience in big data technologies such as Sqoop, Spark, Flume, Hive, Impala, & HDFS on Cloudera • Experience with high volume of data • Experience in performance tuning of Informatica and relational databases especially Oracle and SQL Server • Experience in working with multiple flat files as sources and targets • Experience in working with unstructured data using Informatica data transformation services (DTS) • Strong verbal, presentation, and written communication skills • Strong initiative, ability to self-manage and also work in a team environment

Top 5 Required Technical Skills: 1. Informatica PowerCenter 8.6/9.6.X/10.X skills 2. Oracle SQL/PLSQL and SQL Server stored procedure skills 3. AIX shell scripting/Windows batch scripting skills 4. Big data integration technologies such as Sqoop, Spark, Flume, Hive, Impala, & HDFS on Cloudera 5. Informatica data transformation services (DTS) skills

Preferred Skills: • Informatica data profiling • Informatica data masking • SQL Server Integration services (SSIS) • Tableau

Responsibilities:

• Work under the guidance of data architects or SMEs to analyze and understand the source and target data systems to validate the business requirements • Develop the data integration jobs to transform and load both structured and unstructured data as per the specifications as required by the data architects • Apply Industry best practices during development with a strong focus on reusability and better performance • Mentor others in technology usage when required • Produce clearly articulated documentation in data integration • Provide inputs to architecture and design • Keeps other designers, team leads and project managers well informed of progress and results