ETL - Data warehousing Developer
SKILLS EVALUATION SHEET |
|
|||||
|
|
|||||
Candidate Name: |
|
|
||||
Total Experience: |
|
|
||||
Relevant Experience: |
|
|
||||
Notice Period: |
|
|
||||
|
|
|||||
Skills possessed by the candidate to perform the role efficiently |
Mandatory / Optional |
Name of Projects |
No: of months worked in each Project |
Description of work done using the skill |
|
|
Informatica - 5+ years hands on experience |
M |
|
|
|
||
Python - 2+ years hands on experience |
M |
|
|
|
||
SQL - 5+ expert |
M |
|
|
|
||
Snowflake - trained, certified, and at least 1-year hands on |
M |
|
|
|
||
STRONG interpersonal skills for direct customer facing and working across teams |
M |
|
|
|
||
Oracle |
O |
|
|
|
||
Airflow or Tidal |
O |
|
|
|
||
AWS |
O |
|
|
|
Description:
* CorpDev and M&A subject matter expertise
* Emphasis on Python and Snowflake
* Engineer to work closer with business stakeholders and more engaged in that working relationship at a higher level than initial role
ETL Datawarehouse Developer for CorpDev and M&A business
Business Technology connects people and technology to transform the future of work at Salesforce. Guided by our core values of Trust, Customer Success, Equality, Innovation, and Sustainability, we deliver business outcomes that fuel growth, drive competitive advantage, and empower our employees and customers globally. BT's scope stretches beyond traditional IT: We are also strategic partners, advocating for the best outcomes for our customers, always innovating, and helping to shape the future of work.
We oversee technology strategy, Salesforce on Salesforce, customer and partner enablement, applications engineering, infrastructure, collaboration, enterprise operations, architecture, and program enablement. We are Customer Zero, the best example of Salesforce products delivered globally, at scale, sustainably.
Salesforce's Data Engineering team sits alongside our centralized Analytics team, working together closely to ensure we are a data-driven company. Data Engineering is responsible for building and maintaining an infrastructure that powers: Product, Analytics, Marketing, Sales and Operations functions. Data Engineering is a foundational pillar for all of Salesforce and one of the most highly leveraged teams.
As a Data Engineer at Salesforce, you'll be a critical part of the development and enhancement of an innovative data environment by leveraging industry best practices and cutting-edge approaches. You'll collaborate with engineering to nail-down the data infrastructure, and with our business partners across all major functions at the organization to anticipate data needs, and proactively develop data solutions to address the toughest business problems. In short, you'll be building the foundation that allows the rest of the organization to understand our users and turn it into actionable steps to make our product even better and our business run smoother.
Our ideal candidate isn't satisfied until a project is seen through to meaningful impact. If you love working with data and want to see your work impact the entire organization, we want to talk to you!
What you'll do:
* Work alongside and support a talented team of data engineers.
* Build and maintain scalable automated data pipelines ground up. Be an expert of stitching and calibrating data across various data sources.
* Work with Salesforce's data ingestion, data platform and product teams to understand and validate instrumentation and data flow.
* Develop data set processes for data modeling, mining and production.
* Integrate new data management technologies and software engineering tools into existing structures
* Support regular ad-hoc data querying and analysis to better understand customer behaviors.
* Understand, monitor, QA, translate, collaborate with business teams to ensure ongoing data quality.
What a successful candidate will have:
* 5+ years experience designing, implementing, and maintaining relational / data warehousing environments (custom or structured ETL, preferably working with large data environments)
* 3+ years' experience in robust ETL tools such as Informatica
* 1-3 years' experience with developing robust and tested Python applications to support the data warehouse
* Experience working with Linux and debugging performance issues.
* Strong background in Data Warehousing concepts and schema design
* Experience implementing and managing Python open-source data tooling such as Airflow, DBT, SQL Alchemy, pandas, Jupiter
* History of designing, building, and launching extremely efficient & reliable data pipelines to move data (both large and small amounts) throughout a Data Warehouse.
* Experience working with RDBMS & MPP databases (Redshift, PostgreSQL, Snowflake), with ability to optimize queries for high volume environments.
* Must exhibit strong communication skills, empathy, and initiative
* Work close with business stakeholders and engaged maturing the working relationship between engineering and the business
Additional desired skills:
* Corporate Development and M&A subject matter expertise
* Hands on work experience using Snowflake.
