Role Overview:
The Lead Data Engineer will be responsible for supporting the migration of legacy CRM systems to Salesforce, including designing and developing and testing data pipelines, designing and developing data models, and applying transformations to data. This role will also support ongoing projects in developing tables and building transformations in Snowflake.
Key Requirements :
- Use ETL Tool IICS, Informatica ETL - Salesforce CRM integration using industry accepted methodologies and procedures.
- Proficient in Informatica Cloud Services, IICS, Informatica Power Centre 9x, SQL, Data Analysis, Data warehousing, Salesforce for ETL processes.
- Work on Data extraction, transformation and loading data from various sources like Salesforce, Anaplan, Cloudera, Oracle, CSV/Flat file, Microsoft Azure, Xml, JSON file and UNIX server, Snowflake, Microsoft SQL server using Informatica Cloud.
- Work on both Application Integration and Data Integration Services.
- Work Rest webservices to Post data into the Client system and used Postman tool to validate the API response.
- Used Scrum Agile Methodology in my work (Daily Scrum Meeting, Sprint Backlog, 1on1 meeting).
- Work on Salesforce Workflow, Process builder, Email, Custom Object, Field Creations.
- Create dataflows and pipelines in Azure Data Factory.
- Create Copy activity which reads data from various sources and load data into Snowflake raw layer.
- Use Various sources to Pull into Power BI/Tableau such as SQL Server, Oracle.
- Create internal and external stage and transformed data during load in Snowflake.
- Develop and maintain ETL Process to move data from source system to Snowflake.
- Work on knowledge in DBT and Azure data bricks.
Key Skillset:
- 7-10 years' experience in data engineering.
- Strong knowledge of Salesforce, particularly Salesforce data structures and backend.
- Strong SQL skillset and experience building tables and applying transformations.
- Ability to self-manage tasks and time.
- Strong communication skills.
Benefits:
- Kloud9 provides a robust compensation package and a forward-looking opportunity for growth in emerging fields.
Equal Opportunity Employer:
- Kloud9 is an equal opportunity employer and will not discriminate against any employee or applicant on the basis of age, color, disability, gender, national origin, race, religion, sexual orientation, veteran status, or any classification protected by federal, state, or local law.
