ETL Lead - 100%

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.

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