Etl Lead

ObjectEdge , Navi Mumbai · www.objectedge.com · Full-time employment · Programming

  • 12-15 Years ETL / ELT Dev and design experience
  • 5-8 years’ experience with ETL/ELT Development using SQL and ETL Tools (e.g. Pentaho, Talend, Informatica, BODS, DataStage, Ab Initio, SSIS etc)
  • ETL Architecture and Design Experience
  • 3-5 years on Big Data technologies including Python, Spark, NoSQL and Hadoop/Hive
  • 5 or more years experience in analyzing, designing, documenting and maintaining complex ETL / ELT Job Flows and  programs.
  • 10 or more years experience in Data Integration Strategy, creating Data Integration Design/Specifications and development activities for Data Warehouse Environment
  • Strong experience in Data Quality, Source Systems Analysis, and Business Rules Validation.
  • Understanding of data integration best practices in data warehouse environment including scaling, performance tuning and error handling
  • Strong written and oral communication skills are essential.
  • Would require working with business users / Business/ Data Analysts, understanding requirements, and translating the requirements into a end-end automated data pipeline for the DW/BI ecosystem.
  • Strong conceptual and practical understanding of Relational Database and NoSQL Database Systems , Data Marts and Data Warehouse design (Star Schema, Normalised (TNF), OLAP and such)
  • Strong SQL, Stored procedures, UDF and ETL development skills in a multi-tier environment.
  • Experience with Snowflake Platform is a major plus
  • Strong knowledge of flat file formats incl. compressed , XML, JSON and file format conversion.
  • Experience with Amazon AWS environment and /or Microsoft Azure environment is desirable
  • Experience with Linux and  Windows Server environments
  • Good understanding of SDLC and Agile Methodologies.
  • Good understanding of ETL and ELT best practices and experience with ETL/ELT Mapping documentation
  • Proven strength in interpreting customer business needs and translating them into application and operational requirements.
  • Strong problem solving skills and analytical skills with proven strength in applying root cause analysis.
  • Ability to communicate verbally and in technical writing to all levels of the organization in a proactive, contextually appropriate manner.
  • Strong teamwork and interpersonal skills at all levels.
  • Dedicated to excellence in one’s work; strong organizational skills; detail-oriented and thorough.
  • Able to prioritize work by dividing time, attention and effort between current project workload and on-going support tasks.
  • Bachelor’s Degree in Information Technology or other related field is required.  Master’s Degree is preferred

Apply for this position

Login with Google or GitHub to see instructions on how to apply. Your identity will not be revealed to the employer.

It is OK for recruiters, HR consultants, and other intermediaries to contact this employer