Description

Build and troubleshoot complex data integration solutions, transformations, and security controls on-site in Deerfield, IL.

Responsibilities

• Develop metadata-driven data integration solutions and complex ETL workflows.
• Design advanced SQL queries and create unit and integration test scripts.
• Profile, secure, and govern data in transit and at rest.
• Utilize Unix/Linux and scheduling tools (TWS or Control-M) for data workflows.
• Contribute to agile ceremonies and provide technical guidance to team members.

Required Skills

• 6+ years of experience with ETL tools: Ab Initio, DataStage, or Informatica.
• Proficiency in Python, Java, and Unix scripting.
• Experience with Spark and open source technologies.
• Hands-on experience with cloud platforms: AWS, Azure, or GCP.
• Working knowledge of CI/CD pipelines using Jenkins and GitHub.
• Experience with BI stacks and data integration supplemental tools.
• Ability to design and implement data security and alerting mechanisms.

Preferred Skills

• Background in Financial MarTech.

Key Skills

Education

Any Graduate