Description

Design, code, and maintain data warehousing systems and ETL pipelines to meet specific data storage requirements.

Responsibilities

• Consult with data management teams to define data storage and warehousing requirements.
• Design, code, and implement data warehousing systems based on technical specifications.
• Build and manage ETL pipelines and data replication processes.
• Perform preliminary testing, system validation, and troubleshooting of storage environments.
• Provide ongoing maintenance and support for data systems.

Required Skills

• 8+ years of hands-on development experience with Informatica, Informatica PowerCenter, or Informatica Intelligent Cloud Services (IICS) and Cloud Data Integration (CDI).
• 5+ years of experience with complex SQL, high-volume relational databases, and SQL query performance tuning.
• 3+ years of UNIX shell scripting experience.
• 3+ years of experience with schedulers such as Control-M or AutoSys.
• Hands-on experience with Informatica Intelligent Cloud Services (IICS) and Attunity.
• Experience querying NoSQL (Mongo) databases and Snowflake.
• Proficiency with AWS services including EC2, S3, and DynamoDB.
• Knowledge of Metadata Management and the application development lifecycle including CI/CD.
• Experience working within Agile software development methodologies.

Preferred Skills

• Advanced degree in Computer Science or IT.

Key Skills

Education

Any Graduate