Job summary:


Title:
Informatica with Big Data, PySpark

Location:
Columbus, OH, United States

Length and terms:
Long term - W2 or C2C


Position created on 02/22/2021 10:57 pm

Job description:


*** Webcam interview *** Initial PO till /2021 with extensions; usually project goes for 3+ years with this customer *** Initial remote due to covid then Onsite;  ***

  • 8+ years of experience with Informatica Power Center on Data Warehousing or Data Integration projects
  • Proven ability to write high quality code
  • 7+ years of experience with Expertise implementing complex ETL logic
  • 3+ years of experience Develop and enforce strong reconciliation process
  • Accountable for ETL design documentation
  • 5+ years of Strong SQL experience (prefer Oracle)
  • 5+ years of Good knowledge of relational database, data vault and dimensional model design
  • 3+ years of Basic knowledge of UNIX/LINUX shell scripting
  • Utilize ETL standards and practices towards establishing and following centralized metadata repository
  • Computer literacy with Excel, PowerPoint, Word, etc.
  • Effective communication, presentation, & organizational skills
  • Ability to establish priorities & follow through on projects, paying close attention to detail with minimal supervision
  • Required Education: BS/BA degree or combination of education & experience
  • Familiar with Project Management methodologies like Waterfall and Agile
  • Perform other duties as assigned
  • Analysis, Design, development, support and Enhancements of ETL/ELT in data warehouse environment with Cloudera Bigdata Technologies (Hadoop, MapReduce, Sqoop, PySpark, Spark, HDFS, Hive, Impala, StreamSets, Kudu, Oozie, Hue, Kafka, Yarn, Python, Flume, Zookeeper, Sentry, Cloudera Navigator) along with Informatica, Oracle SQL/PL-SQL, Unix commands and shell scripting;
  • 2+ years of Strong development experience in creating Sqoop scripts, PySpark programs, HDFS commands, HDFS file formats (Parquet, Avro, ORC etc.), StreamSets pipeline creation, jobs scheduling, hive/impala queries, Unix commands, scripting and shell scripting etc.

 


Contact the recruiter working on this position:



The recruiter working on this position is Ajay Chappidi(Shaji Team)
His/her contact number is +(1) (202) 6290353
His/her contact email is ajayc@msysinc.com

Our recruiters will be more than happy to help you to get this contract.