Required Skills

Informatica Data Warehousing Data Integration ETL

Work Authorization

  • Us Citizen

  • Green Card

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 17th Nov 2020

JOB DETAIL

Role: Sr. ETL Developer        

Location: Local to Ohio Candidates Only

Visa: GC/USC Only  

Description:

 

ETL Developer with design, development,implementation.

 

REQUIRED Skill Sets:

• 8 years of experience with Informatica Power Center onData 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 dimensionalmodel design
• 3 years of Basic knowledge of UNIX/LINUX shell scripting
• Utilize ETL standards and practices towards establishing and followingcentralized metadata repository
• Computer literacy with Excel, PowerPoint, Word, etc.
• Effective communication, presentation, & organizational skills
• Ability to establish priorities & follow through on projects, payingclose 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 datawarehouse 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 withInformatica, Oracle SQL/PL-SQL, Unix commands and shell scripting;

• 2 years of Strong development experience in creating Sqoop scripts, PySparkprograms, HDFS commands, HDFS file formats (Parquet, Avro, ORC etc.), StreamSetspipeline creation, jobs scheduling, hive/impala queries, Unix commands,scripting and shell scripting etc.

DESIRED Skill Sets:

• Demonstrate effective leadership, analytical and problem-solving skills
• Required excellent written and oral communication skills with technical andbusiness teams.
• Ability to work independently, as well as part of a team
• Stay abreast of current technologies in area of IT assigned
• Establish facts and draw valid conclusions
• Recognize patterns and opportunities for improvement throughout the entireorganization
• Ability to discern critical from minor problems and innovate new solutions

 

 

Kawaljeet Kaur

 

Sr. Executive Technical Recruiter

TEK INSPIRATIONS LLC

US: 469 495 7146

Email ID: kawaljeet@tekinspirations.com

13573 Tabasco Cat Trail, Frisco, TX 75035

Company Information