ETL Data Architect

2 days ago

Hyderabad, Telangana, India Conduent Full time ₹ 15,00,000 - ₹ 25,00,000 per year

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.

  • Principal ETL/BI Consultant

    2 days ago

    Hyderabad, Telangana, India Data Intensity Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Develop modern scalable business intelligence and data warehouse solutions aligned with clients needs.Develop robust data loads using ODI , Oracle Integration Cloud (OIC) and other ETL toolsWorking on supporting client environments on ODI and all Oracle BI solutions( OAC, OAS, BIP, FDI, BI Apps)Support, troubleshooting and performance tuning for existing BI...

  • Senior ETL Architect

    4 days ago

    Hyderabad, Telangana, India IQVIA Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job Description: Data ArchitectKey ResponsibilitiesCollaborate with business stakeholders and product owners to gather business requirements.Architect, Design and implement scalable Snowflake-based cloud data warehouse solutions in alignment with Data Management product roadmap.Develop and optimize data pipelines using ETL/ELT frameworks and cloud-native...

  • Data Architect

    2 weeks ago

    Hyderabad, Telangana, India Ascent Health Solutions Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Company DescriptionAscent Health Solutions is a full-service Revenue Cycle Management and Healthcare Technology Services With over 25 years of expertise and a team of over 4,000 skilled professionals, we enhance the financial performance of healthcare providers. Our solutions include advanced AI-powered technology to drive efficiency and reduce costs. Our...

  • Data Architect

    1 hour ago

    Hyderabad, Telangana, India Covasant Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Experience : Yrs of experience as a Data Architect in complex, large-scale data environments.SSIS, Databricks Expertise : Strong hands-on experience working with SSIS, Databricks, including using Apache Spark for data processing and optimization.ETL Tools : Proficient with various ETL tools and frameworks such as Informatica, Talend, or SSIS or...

  • Enterprise Data Architect

    2 days ago

    Hyderabad, Telangana, India EverestDX Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Skills and Development : - We are seeking a highly skilled and innovative Database Architect, with a special focus on PostgreSQL and Solr, to join our team. - The ideal candidate will have a deep understanding of database architecture, experience with ETL tools, and expertise in designing and optimizing data pipelines. - This role requires a quick...

  • Architect - ETL

    3 days ago

    Hyderabad, Telangana, India insightsoftware Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job Description Location: Hyderabad (Work from Office) Working Hours: 5:00PM - 2:00AM IST Position Summary The Team Lead, Data Conversion will build positive relationships with customers and serve as a primary point of contact for large scale complex product implementations and business-led change initiatives. The role will include, but is not...

  • Architect - ETL

    4 days ago

    Hyderabad, Telangana, India insightsoftware Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job DescriptionLocation: Hyderabad (Work from Office)Working Hours: 5:00PM - 2:00AM ISTPosition SummaryThe Team Lead, Data Conversion will build positive relationships with customers and serve as a primary point of contact for large scale complex product implementations and business-led change initiatives. The role will include, but is not limited to:10+...

  • Architect - ETL

    3 days ago

    Hyderabad, Telangana, India insightsoftware Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job Description Location: Hyderabad (Work from Office)Working Hours: 5:00PM - 2:00AM IST Position SummaryThe Team Lead, Data Conversion will build positive relationships with customers and serve as a primary point of contact for large scale complex product implementations and business-led change initiatives. The role will include, but is not limited to:10+...

  • Architect - ETL

    2 days ago

    Hyderabad, Telangana, India insightsoftware Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job Description Location: Hyderabad (Work from Office)Working Hours: Rotational ShiftsWork Mode : Hybrid Position SummaryThe Team Lead, Data Conversion will build positive relationships with customers and serve as a primary point of contact for large scale complex product implementations and business-led change initiatives. The role will include, but is not...

  • ETL Developer

    2 days ago

    Hyderabad, Telangana, India Ares data private limited Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    **Job Description:** You will be an ETL Developer with 4-5 years of experience, focusing on Snowflake ETL processes. Your responsibilities will involve: - Fixing issues that occur when a job fails - Identifying the root cause of problems - Implementing necessary fixes - Writing PROCs and VIEWs - Knowledge of AIRFLOW is a plus **Qualifications Required:** -...