ETL Data Architect
ETL Data Architect
Posted on :
22-05-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Description
Job Track Description:
The ETL Data Architect would be responsible for driving data migration strategy and execution within complex Enterprise landscape. This role will be responsible to bring in the best practices of data migration and integrations with Salesforce.
- Bring in best practices for Salesforce data migration integration.
- Create Data migration strategy for Salesforce implementations.
- Define template/uniform file format for migrating data into Salesforce.
Must Skill:
- Data Architect with 810 years of ETL experience and 5 years of Informatica Cloud (IICS ICRT) experience. 5 years of experience on Salesforce systems.
- Develop comprehensive data mapping and transformation plans to align data with Salesforce data model and software solution.
- Good understanding of Salesforce data model and schema builder.
- Excellent understanding of relational database concepts and how to best implement database objects in the Salesforce.
- Experience integrating large sets of data into Salesforce from multiple data sources.
- Experience with EDI transactions.
- Experience in Design and Development of ETL/Data Pipelines.
- Excellent understanding of SOSL and SOQL and the Salesforce Security model.
- Full understanding of project life cycle and development methodologies.
- Ability to interact with technical and functional teams.
- Excellent oral written communication and presentation skills.
- Should be able to work in offshore / onsite model.
Experience:
- Expert in ETL development with Informatica cloud using various connectors.
- Experience with Real Time integrations and Batch scripting.
- Expert in implementing the business rules by creating various transformations working with multiple data sources like flat files relational and cloud database etc. and developing mappings.
- Experience in using ICS workflow tasks: Session Control Task Command tasks Decision tasks Event wait Email tasks Presessions Postsession and Pre/Post commands.
- Ability to migrate objects in all phases (DEV QA/UAT and PRD) following standard defined processes.
- Performance analysis with large data sets
- Experience in writing technical specifications based on conceptual design and stated business requirements.
- Experience in designing and maintaining logical and physical data models and communicates to peers and junior associates using flowcharts unified data language Data flow Diagram.
- Good Knowledge of SQL PL/SQL and Data Warehousing Concepts.
- Experience in using Salesforce SOQL is a plus.
Responsibilities:
- Excellent troubleshooting and debugging skills in Informatica Cloud.
- Significant knowledge of PL/ SQL including tuning triggers ad hoc queries and stored procedures.
- Strong analytical skills.
- Works under minimal supervision with some latitude for independent judgement.
- Prepare and package scripts and code across development test and QA environments.
- Participate in change control planning for production deployments.
- Conducts tasks and assignments as directed.
Employment Type
Full Time
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
