ETL Developer


  • Job ID:

    4057
  • Pay rate range:

    $65 - $68
  • City:

    Chicago
  • State:

    Illinois
  • Duration:

    10/23/2022 - 04/23/2023
  • Job Type:

    Contract
  • Job Description

    ETL Informatica / Developer

    6 months

    Remote fine

    $65 - $68 / HR (1.5x overtime)

     

    Requirements:  

    • 5 to 7+ years of experience within the field of data engineering or related technical work including business intelligence, analytics
    • Experience designing and building scalable and robust data pipelines to enable data-driven decisions for the business
    • Very good understanding of Data warehousing concepts and approaches
    • Hands-on experience building complex business logics and ETL workflows using Informatica IICS and PowerCenter.
    • Good Proficient in SQL, PL/SQL and preferably experience in Snowflake
    • Good Experience in one of the scripting languages: Python or Unix Scripting
    • Experience in streaming data or injecting data at near real time using methods like Kafka
    • Hands-on experience in AWS cloud and AWS native technologies such as Glue, Lambda, Kinesis, Lake Formation, S3, Redshift
    • Experience using Spark EMR, RDS, EC2, Athena, API capabilities, CloudWatch, CloudTrail is a plus
    • Experience with Business Intelligence tools like Tableau, Cognos, ThoughtSpot, etc is a plus.
    • Hands on experience in building data lakes
    • Experience in data cleansing, data validation and data wrangling.
    • Good experience in Monitoring and improving the performance of process when required
    • Strong verbal and written communication skills

    Must have:

    • Support Production batch environment. 
    • Knowledge & Experience: 3+ years of Informatica Power Center software experience is
    • Strong SQL Knowledge is REQUIRED. 
    • Strong understanding of using ETL tools to integrate systems.
    • Knowledge of System Development Life Cycle (SDLC). 
    • 3+ years working with DB2 or equivalent RDBMS is preferred. 
    • Informatica Power Center 9.6 experience preferred.
    • Java development experience preferred. 
    • Shell scripting experience preferred. 
    • Autosys experience preferred.
    • Good Proficient in SQL, PL/SQL and preferably experience in Snowflake

       

    • Good Experience in one of the scripting languages: Python or Unix Scripting

      Experience in streaming data or injecting data at near real time using methods like Kafka

      Hands-on experience in AWS cloud and AWS native technologies such as Glue, Lambda, Kinesis, Lake Formation, S3, Redshift

       

    • Experience using Spark EMR, RDS, EC2, Athena, API capabilities, CloudWatch, CloudTrail is a plus

       

    • Experience with Business Intelligence tools like Tableau, Cognos, ThoughtSpot, etc is a plus.

     

    Expectations:    

    We work in a team environment; there is an expectation that this role portrait represents the core responsibilities of the role, but other responsibilities may surface based on what needs to be done. Colleagues in this role are expected to have an overall understanding of the project plan and participate outside of their core responsibilities when needed. Fluctuating work schedule can be expected during nights and weekends depending on system availability and deliverable dates

     

    #PCIT #LI-Remote

Add Reference

CONTRACTORS

Find and apply to jobs on the go

Take our free app with you anywhere. Enter your phone number and we’ll send you the download link.

  • +1

`

Client Registration Request