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.