Description

Design and implement data flow architectures for data warehouses, marts, and operational data stores.

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.

Responsibilities

• Design and implement data flow architectures for analytical structures.
• Configure ETL tools to build efficient data management and migration solutions.
• Develop system designs and define tool-to-database labor divisions.
• Deploy standard architecture components for production environments.
• Support task planning, scheduling, and effort estimation for data integration projects.

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