Description

Design and implement data flow architectures to load analytical structures including data warehouses, data marts, and operational data stores.

Responsibilities

• Configure and customize ETL tools to build efficient solutions for data management, conversion, and migration.
• Develop overall system designs and define the division of labor between ETL tools and databases.
• Deploy and customize standard architecture components for production environments.
• Support task planning, including scheduling and effort estimation for data integration projects.
• Mentor client personnel and train junior staff on integration methodologies.

Required Skills

• 5+ years of ETL development experience using Informatica, DataStage, or equivalent technologies.
• Advanced SQL skills with expertise in complex query building and performance tuning.
• Strong experience with Snowflake and cloud-based data environments.
• Proficiency in UNIX shell scripting, including COBOL and Perl.
• Hands-on experience with relational databases: SQL Server, Oracle, MySQL, or Netezza.
• Deep understanding of Data Warehouse concepts and data modeling.
• Ability to perform data profiling and analyze production volumes, batch schedules, and I/O statistics.
• Proven track record of resolving performance issues within operational environments.
• Experience working with DB2 and Hadoop targets.

Preferred Skills

• Experience with dbt (data build tool).
• Python programming skills.

Key Skills

Education

Any Graduate