Description

You will manage the full life cycle of data warehousing projects, from design through implementation.

Responsibilities

• Design and develop data warehouses, operational data stores, data marts, and data migrations.
• Build data pipelines for big data processing using Hadoop, Hive, and Spark to load data lakes.
• Implement event-driven data integration and cloud data solutions using IICS, ADF, Azure, and Snowflake.
• Execute unit and integration testing while deploying code across QA, UAT, and production environments.
• Resolve performance bottlenecks and ensure stability for applications and batch jobs.

Required Skills

• Proficiency in T-SQL and PL/SQL.
• Experience with Unix shell scripting and Python.
• Hands-on work with Microsoft SQL Server, Oracle, Netezza, Teradata, or DB2.
• Experience with ETL tools including Informatica PowerCenter, IDQ, and SSIS.
• Knowledge of schedulers such as AutoSys, Zen, or CA7.
• Familiarity with big data technologies including Hadoop, Hive, and Spark.
• Experience with cloud integration tools like Informatica Intelligent Cloud Services (IICS), ADF, Azure, and Snowflake.
• Master’s Degree in Computer Applications or equivalent with at least 1 year of related experience.
• Ability to travel up to 60% to client locations within the US.

Key Skills

Education

Master’s Degree in Computer Applications or Equivalent