Data Warehousing Specialist with IICS, AWS, and PySpark Expertise

4 weeks ago


Bloomington, Illinois, United States Syntricate Technologies Full time
Job Summary

Data Warehousing Specialist sought by Syntricate Technologies to design and develop data warehousing systems using IICS, AWS, and PySpark. The ideal candidate will have a strong background in data management and experience with Unix, SQL, and AWS infrastructure.

Responsibilities
  • Collaborate with data management teams to understand company data storage needs.
  • Present warehousing options to the company based on their storage requirements.
  • Design and code data warehousing systems to meet company specifications.
  • Conduct preliminary testing of the warehousing environment before data extraction.
  • Extract and transfer company data into the new warehousing environment.
  • Test the new storage system and troubleshoot any issues.

Requirements
  • Minimum 8 years of hands-on development experience.
  • Basic Python/PySpark skillset.
  • Basic AWS infrastructure knowledge.
  • Good understanding of Unix and SQL.
  • IICS ETL development experience.

About Syntricate Technologies

Syntricate Technologies is a leading provider of data management solutions. We are committed to delivering high-quality services to our clients and are seeking a skilled Data Warehousing Specialist to join our team.

  • Bloomington, Illinois, United States Saxon Global Full time

    Job Description: We are seeking a highly skilled Senior IICS/AWS Engineer to join our team at Saxon Global. As a key member of our engineering team, you will be responsible for designing, implementing, and maintaining complex data integration solutions using Informatica PowerCenter and AWS services. Key Responsibilities:Design and implement ETL pipelines...


  • Bloomington, Illinois, United States Diverse Lynx Full time

    Job Summary:We are seeking a highly skilled ETL Developer with expertise in Attunity to join our team at Diverse Lynx LLC. As a key member of our data integration team, you will be responsible for designing, developing, and implementing ETL processes to extract, transform, and load data from various sources into our cloud-based data warehouse.Key...


  • Bloomington, Illinois, United States Stratacent Full time

    Stratacent is seeking a seasoned data integration specialist to help modernize a financial customer's data ingestion patterns within their AWS data platform.This project requires a thorough understanding of ETL and data lake concepts, as well as experience working with AWS ecosystem tools such as Step Functions, Dynamo DB, and Glue.The ideal candidate will...


  • Bloomington, Illinois, United States Futran Tech Solutions Pvt. Ltd. Full time

    Job SummaryAs a Data Integration Specialist at Futran Tech Solutions Pvt. Ltd., you will be responsible for testing and validating the ETL (Extract, Transform, Load) processes to ensure data accuracy and integrity. The ideal candidate will have 5-6 years of experience in manual testing, with a strong background in Informatica and SQL. You will work closely...


  • Bloomington, Illinois, United States Saxon Global Full time

    Data Modeler SpecialistJob Summary: We are seeking a highly skilled Data Modeler Specialist to join our team at Saxon Global. The successful candidate will have a strong background in data warehouse and analytics, with expertise in data modeling, data mapping, and data dictionary development. Strong data warehouse and analytics background Data modeling,...


  • Bloomington, Illinois, United States Maintec Technologies Full time

    Job SummaryKubernetes Data Engineer - Cloud ExpertManage and administer Kubernetes clusters.Key ResponsibilitiesDevelop applications on Kubernetes using Python or Golang.Supporting batch processing using AWS EMR and Pyspark.Strong expertise in Pyspark, AWS Services, Dynamo DB, ELB, EC2, and Lambda.6-8 years of experience in data engineering.


  • Bloomington, Illinois, United States Futran Tech Solutions Pvt. Ltd. Full time

    Role: Data Integration Specialist Location: Futran Tech Solutions Pvt. Ltd. - Hybrid 3 days MUST HAVES: 6+ Years of Manual Testing Experience Informatica Expertise Master Data Management (MDM) - Complex Data Handling SQL Server Database Testing - Complex Queries, Joins, Normalization Test Case Creation and Execution PREFERRED: Informatica Data Quality...


  • Bloomington, Illinois, United States Futran Tech Solutions Pvt. Ltd. Full time

    Role:As a Data Management Specialist at Futran Tech Solutions Pvt. Ltd., you will be responsible for testing and ensuring the quality of our ETL processes. MUST HAVES:5-6 years of manual testing experience with Informatica MDM, SQL, and SQL Server Database Testing. Proficiency in complex queries, joins, normalization, and other advanced SQL...


  • Bloomington, Illinois, United States Saxon Global Full time

    Job Title: Informatica DPM/AWS SpecialistRole: Informatica DPM/AWS SpecialistOnsite: McLean, VA - 3 times a weekClient: Freddie MacMax Rate: $80/hourKey Responsibilities:7+ years of experience with Informatica products in the Data Governance & Privacy journey - Data Privacy Management and EDC.Hands-on experience with data quality and remediation tasks to...


  • Bloomington, Illinois, United States Maintec Technologies Full time

    ROLE:Data Systems EngineerLOCATION:RemoteDURATION:Long term contractClient:Maintec TechnologiesShift:Flexible scheduleRequired Skills:Snowflake, AWS Big Data, Kafka, Hadoop, Spark, MapReduce, Sqoop, Hive, HDFS, HBase, Cassandra, Vertica, Avro, Parquet, Pyspark, Scala, Hive Tuning, Bucketing, PartitioningJob Summary:As a Senior Big Data Engineer, you will...

  • Data Engineer Lead

    3 weeks ago


    Bloomington, Illinois, United States Capital One Full time

    About the Role:We are seeking a Lead Data Engineer to join our Enterprise Platforms Technology team at Capital One. As a Lead Data Engineer, you will be responsible for designing, developing, and implementing technical solutions in full-stack development tools and technologies.Key Responsibilities:Collaborate with Agile teams to design, develop, test,...

  • Data Engineer

    3 weeks ago


    Bloomington, Illinois, United States TMCI Full time

    Job DescriptionThe TMCI Data Quality Group is seeking a skilled Data Engineer to join our dedicated team. As a Healthcare IT Data Engineer, you will play a crucial role in designing, developing, and maintaining data pipelines, databases, and analytics solutions that support data-driven decision-making and patient care improvements in the healthcare...


  • Bloomington, Illinois, United States Saxon Global Full time

    Job Title: Informatica DPM/AWS SpecialistRole: Informatica DPM/AWS SpecialistLocation: Onsite in McLean, VA - 3 times a weekClient: Freddie MacMax Rate: $80/hourKey Responsibilities:7+ years of experience with Informatica products in the Data Governance & Privacy journey - Data Privacy Management and EDC.Hands-on experience with data quality and remediation...


  • Bloomington, Illinois, United States Saxon Global Full time

    Job Title: Senior Informatica ICS DeveloperJob Summary: We are seeking a highly skilled Senior Informatica ICS Developer to join our team at Saxon Global. The ideal candidate will have extensive experience in building ETL pipelines and data replication, as well as expertise in Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS),...


  • Bloomington, Illinois, United States TechnoGen Full time

    Job Summary:TechnoGen is seeking a skilled ETL Testing Specialist to join our team. The ideal candidate will have extensive experience in ETL testing, complex SQL, and data warehousing.Key Responsibilities: Develop and execute test cases for ETL processes Collaborate with development teams to identify and resolve testing issues Ensure data quality and...


  • Bloomington, Illinois, United States eTek IT Services, Inc. Full time

    Job Title: Senior Python Developer with AWS ExpertiseWe are seeking a highly skilled Senior Python Developer with expertise in AWS to join our team at eTek IT Services, Inc. As a key member of our development team, you will be responsible for designing, implementing, and maintaining our software applications and databases using Python and AWS services.Key...


  • Bloomington, Illinois, United States Saxon Global Full time

    Job Summary:We are seeking an experienced ETL Developer with expertise in Attunity to join our team at Saxon Global. The ideal candidate will have a strong background in ETL development, with a focus on Attunity, and be able to create sources, targets, mappings, and workflows for ETL jobs as per the design. Additionally, the candidate should be familiar with...


  • Bloomington, Illinois, United States Saxon Global Full time

    Job Title: Informatica DPM/AWS Specialist PositionJob Summary: We are seeking an experienced Informatica DPM/AWS specialist to join our team at Saxon Global. The ideal candidate will have a strong background in data governance and privacy, with expertise in Informatica products and AWS cloud.Key Responsibilities: Interpret data quality issues and develop...


  • Bloomington, Illinois, United States Maintec Technologies Full time

    Job SummaryWe are seeking a skilled Data Platform Engineer to join our team at Maintec Technologies. As a key member of our engineering team, you will be responsible for designing, implementing, and maintaining large-scale data processing systems on Kubernetes.Key Responsibilities:Manage and administer Kubernetes clustersDevelop and deploy applications on...


  • Bloomington, Illinois, United States ShiftCode Analytics Full time

    Job Summary:We are seeking a highly skilled Senior ETL Developer with expertise in Talend and Attunity to join our team at ShiftCode Analytics. The ideal candidate will have a strong background in building ETL processes using Talend/Attunity and a proven track record of delivering high-quality solutions.Key Responsibilities: Design and develop ETL processes...