ETL Data Architect

Through our dedicated associates, Conduent delivers mission-critical services and solutions on behalf of Fortune 100 companies and over 500 governments - creating exceptional outcomes for our clients and the millions of people who count on them. You have an opportunity to personally thrive, make a difference and be part of a culture where individuality is noticed and valued every day.

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.
  
  

Conduent is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, creed, religion, ancestry, national origin, age, gender identity, gender expression, sex/gender, marital status, sexual orientation, physical or mental disability, medical condition, use of a guide dog or service animal, military/veteran status, citizenship status, basis of genetic information, or any other group protected by law.

People with disabilities who need a reasonable accommodation to apply for or compete for employment with Conduent may request such accommodation(s) by submitting their request through this form that must be downloaded: click here to access or download the form. Complete the form and then email it as an attachment to FTADAAA@conduent.com. You may also click here to access Conduent's ADAAA Accommodation Policy.

At Conduent we value the health and safety of our associates, their families and our community. For US applicants while we DO NOT require vaccination for most of our jobs, we DO require that you provide us with your vaccination status, where legally permissible. Providing this information is a requirement of your employment at Conduent.