Job 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 8-10 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, Pre-sessions, Post-session, 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.