ETL Lead - 100%



New York, NY
Full Time
3y ago

Job Description

Title - ETL Lead

Location - 100% Remote 

Duration - 6+ Months

Note - East Coast Person Only and will have to start at 7 AM EDT (Prefer) to overlap with Europe office

  • Some background in Snowflake and Matillion will be required
  • 10+ years of progressive software development experience in ETL with last 4 years in Informatica development.
  • 2+ years of experience in Data and Analytics using any of the tools like Tableau, Qlik, Power BI, or SSRS
  • Expert in writing efficient Analytic and windowing functions in Oracle.
  • Expertise in writing and tuning complex SQL
  • Experience working and requirement gathering with BI teams for reporting dashboard on any of the tools such as Tableau, Looker, Power BI or Qlik
  • Expertise in using partitioning, transformations, incremental caching in Informatica toolset.
  • Expert understanding of slowly changing dimensions (SCD's) in Informatica.
  • Expert understanding of join logic and query optimization in Informatica
  • Experience with stored procedures, Triggers, PL/SQL in Oracle.
  • Extensive Business and/or technical background in the areas of Data modeling, EDW, Data Mart, Master Data Management, Metadata Management, Data Quality, Data Governance, Data integration (ETL) and Data Security
  • Must have experience in onsite/offshore model, handling a team of 3-5 offshore team members
  • Must have exp in Agile projects and be able to meet the demand of an agile environment.

Additional Information

All your information will be kept confidential according to EEO guidelines.

Apply for this job

Click on apply will take you to the actual job site or will open email app.

Click above box to copy link
Get exclusive remote work stories and fresh remote jobs, weekly 👇
View all remote jobs
Onkar By: Onkar