Senior Data Integration Specialist

6 days ago


Atlanta, Georgia, United States iVoyant Full time
About the Job

iVoyant is seeking a skilled Senior ETL Developer to join our client Digital Team.

The successful candidate will work closely with client functional SMEs to understand requirements and develop technical designs for data integration projects.

Key responsibilities include ensuring data availability and validity, creating and maintaining data mappings, logical and physical data models, and business and technical test cases.

The ideal candidate will also assist in developing data pipelines using Informatica BDM or Python to ensure ongoing data collection, consolidation, and management.

Additionally, they will aid in optimizing operations by manipulating and aggregating disparate data sources into a format easily digestible by data scientists and stakeholders.

Responsibilities
  1. Take ownership of the Functional Data Domain assigned to the Data Engineer.
  2. Work with Functional teams to understand requirements, data sources, and business rules.
  3. Identify, analyze, and profile data across various source systems to ensure data fits business requirements.
  4. Raise any data anomalies and work with functional users to close any anomalies or data gaps.
  5. Identify relationships across multiple source systems and create reference data with the help of data stewards.
  6. Finalize technical Source-to-Target mapping to develop data pipelines from source systems to the dimensional model.
  7. Work with the team of Developers for the technical implementation of the Data Pipelines.
  8. Ensure Unit and Integration tests complete successfully and drive QA/UAT with Functional users.
Qualifications

The ideal candidate will have:

  • Deep working experience of SQL, databases, and tables structure to query data from various places, integrate, and present results to the business.
  • Deep working experience of ETL, data pipelines using Informatica (DEI/BDM) or equivalent technologies.
  • Strong critical thinking and problem-solving skills.
Required Skills
  • Deep working experience of SQL, databases, and tables structure to query data from various places, integrate, and present results to the business.
  • Deep working experience of ETL, data pipelines using Informatica (DEI/BDM) or equivalent technologies.
  • Strong critical thinking and problem-solving skills.
Other Skills
  • Knowledge of Big Data platforms (e.g., Hadoop, Map/Reduce, Spark, HBase, HDInsight, Data Bricks, Hive) and programming languages like UNIX shell scripting, Python, etc.
  • Knowledge of reporting and BI packages (e.g., PowerBI, Tableau, SAP BO, etc.).
Education

Bachelor's Degree in Computer Science, Engineering, and/or background in Mathematics and Statistics; Master's or other advanced degree a plus.



  • Atlanta, Georgia, United States iVoyant Full time

    About the JobiVoyant is seeking a highly skilled Senior Data Integration Specialist to join our Digital Team. As a key member of our team, you will work closely with functional SMEs to understand business requirements and design technical solutions.Key ResponsibilitiesDevelop and maintain data pipelines using Informatica (DEI/BDM) or equivalent...


  • Atlanta, Georgia, United States iVoyant Full time

    About the JobiVoyant is seeking a highly skilled Senior Data Integration Specialist to join our Digital Team. As a key member of our team, you will work closely with functional SMEs to understand business requirements and design technical solutions.Key ResponsibilitiesDevelop and maintain data pipelines using Informatica (DEI/BDM) or equivalent...


  • Atlanta, Georgia, United States iVoyant Full time

    About the JobiVoyant is seeking a highly skilled Senior Data Integration Specialist to join our Digital Team. As a key member of our team, you will work closely with our clients' functional Subject Matter Experts (SMEs) to understand their requirements and develop technical designs for data integration projects.Key ResponsibilitiesData Domain Ownership: Take...


  • Atlanta, Georgia, United States MultiPlan Full time

    Job SummaryWe are seeking a highly skilled Data Integrity Specialist to join our team at MultiPlan. As a key member of our organization, you will play a critical role in ensuring the accuracy and integrity of our data.Key ResponsibilitiesCoach and mentor less experienced team members to ensure optimal quality, data integrity, and performance.Mentor...


  • Atlanta, Georgia, United States SunPlus Data Group, Inc Full time

    Job DescriptionCompany OverviewSunPlus Data Group, Inc. is a leading provider of project management, software engineering, and supply chain solutions. With over 20 years of experience, we offer industry-specific solutions and consulting services to clients nationwide.Job SummaryWe are seeking a highly skilled Workday Integration Specialist to join our team....


  • Atlanta, Georgia, United States TRC Talent Solutions Full time

    SQL Developer Job DescriptionWe are seeking a skilled SQL Developer to support our warranty management processes. The ideal candidate will have experience working with SQL Server and PostgreSQL, as well as proficiency in writing SQL queries and managing databases.Key Responsibilities:Data Integration: Develop and maintain processes to efficiently import and...


  • Atlanta, Georgia, United States FSA Federal Full time

    Job SummaryWe are seeking a highly detail-oriented Data Integrity Specialist to join our team at FSA Federal. As a key member of our team, you will be responsible for reviewing and evaluating data from multiple sources, ensuring its accuracy and completeness.Key ResponsibilitiesVerify the accuracy and completeness of received data and informationResolve...


  • Atlanta, Georgia, United States Apex Systems Full time

    Senior Integrations EngineerWe are seeking a highly skilled Senior Integrations Engineer to join our team at Apex Systems. As a key member of our integration team, you will be responsible for designing, developing, and implementing comprehensive integration strategies that enable seamless data exchange between systems.Key Responsibilities:Develop and...


  • Atlanta, Georgia, United States Apex Systems Full time

    About the RoleWe are seeking a highly skilled Senior Integrations Engineer to join our team at Apex Systems. As a key member of our integration team, you will be responsible for designing, developing, and implementing comprehensive integration strategies that enable seamless data exchange between systems.Key ResponsibilitiesDevelop and implement integration...


  • Atlanta, Georgia, United States Stellar Consulting Solutions, LLC Full time

    Job Title: ETL Data EngineerThe Data Engineer will play a crucial role in designing, developing, and implementing integration processes for the Enterprise Data Lake, Data Warehouse, and Applications. This position requires a strong background in full lifecycle development using multiple platforms or languages.Responsibilities:Design, develop, and implement...

  • SQL Developer

    3 weeks ago


    Atlanta, Georgia, United States TRC Talent Solutions Full time

    About the Role:We are seeking a skilled SQL Developer to fill a key position in our team at TRC Talent Solutions. In this role, you will be responsible for integrating data from Excel into our SQL Server and PostgreSQL databases, ensuring the smooth and efficient management of warranty data.Key Responsibilities:Data Integration: Develop and maintain...


  • Atlanta, Georgia, United States Stellar Consulting Solutions, LLC Full time

    Job Title: ETL Data EngineerThe Data Engineer will play a crucial role in designing, developing, and implementing integration processes for the Enterprise Data Lake, Data Warehouse, and Applications. This position requires a strong background in full lifecycle development using multiple platforms or languages.Key Responsibilities:Design and develop efficient...


  • Atlanta, Georgia, United States Hexaware Technologies Full time

    Job DescriptionWe are seeking a highly skilled Data Integration Lead to join our team at Hexaware Technologies.Key Responsibilities:Design and implement data integration solutions using SQL and related technologies.Collaborate with cross-functional teams to ensure data quality and integrity.Develop and maintain data models and architectures.Analyze business...


  • Atlanta, Georgia, United States NTT DATA Full time

    Job Title: Senior Solution Architect - o9NTT DATA is seeking a highly skilled Senior Solution Architect to join our Integrated Demand and Supply Planning team. As a Senior Solution Architect, you will be responsible for designing and implementing o9 solutions for our clients, ensuring that their supply chain operations are optimized and efficient.Key...


  • Atlanta, Georgia, United States Lorven technologies Full time

    Job SummaryWe are seeking a highly skilled ETL Test Engineer to join our team at Lorven technologies. As an ETL Test Engineer, you will be responsible for collaborating with cross-functional teams to certify and promote code to higher level environments, owning test execution, defect management, and test progress reporting.Key Responsibilities:Collaborate...


  • Atlanta, Georgia, United States Equifax Full time

    Senior Data Steward Job DescriptionEquifax is seeking a highly skilled Senior Data Steward to support our Global Identity, Fraud, and Compliance Fraud Product team.In this role, you will provide data governance expertise to review and adapt existing data governance guidelines to a new multi-data domain platform.You will analyze and improve data quality...


  • Atlanta, Georgia, United States Amazon Data Services, Inc. Full time

    About the RoleWe are seeking a highly skilled and experienced Data Center Operations Specialist to join our team at Amazon Data Services, Inc. in Atlanta, GA. As a key member of our operations team, you will be responsible for ensuring the smooth operation of our data centers, including electrical and mechanical systems, and providing exceptional support to...


  • Atlanta, Georgia, United States Emory University Full time

    Job SummaryEmory University is seeking a highly skilled Senior Data Assurance Specialist to join our Research Grants & Contracts team. As a key member of our team, you will play a critical role in ensuring the accuracy and integrity of our financial data.Key ResponsibilitiesConduct compliance reviews of high-risk transactions or awards to ensure adherence to...


  • Atlanta, Georgia, United States NTT DATA Full time

    Job Title: Anaplan Senior Solution ArchitectWe are seeking a highly skilled Anaplan Senior Solution Architect to join our Integrated Demand and Supply Planning team at NTT DATA. As a key member of our team, you will be responsible for designing and implementing Anaplan solutions for our clients, leveraging your expertise in supply chain planning and...


  • Atlanta, Georgia, United States NTT DATA Full time

    Job Title: Senior Supply Chain ArchitectWe are seeking a highly skilled Senior Supply Chain Architect to join our team at NTT DATA. As a key member of our Integrated Demand and Supply Planning (IDSP) consulting team, you will be responsible for designing and implementing o9 solutions for our clients.Key Responsibilities:Lead the requirement gathering process...