ETL Lead - 100% Remote
- Contract
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.