ETL Informatica Engineer with Snowflake Experience

As a ETL Informatica Engineer with Snowflake Experience at NTT DATA, your role involves being a member of the Controls Engineering, Measurement and Analytics (CEMA)-Technology Risk Solutions development team. Your primary focus will be on sourcing data and developing data solutions for Legal, Compliance, Audit, and Risk Management functions within Morgan Stanley. You will be responsible for developing data workflows, views, and stored procedures, as well as performing data analysis, and monitoring and tuning queries and data loads. Collaboration with data providers, data scientists, data developers, and data analytics teams is essential to implement client-specific business requirements effectively. • *Key Responsibilities:** - Develop ETLs, stored procedures, triggers, and views on the DB2-based Data Warehouse - Perform data profiling and analysis on source system data to ensure proper integration and representation in models - Monitor query and data load performance, performing tuning as necessary - Provide assistance during QA & UAT phases to confirm validity of potential issues and determine root cause and resolution • *Qualifications Required:** - Bachelor's degree in Computer Science, Software Engineering, Information Technology, or related field - At least 5 years of experience in data development and solutions in highly complex data environments with large data volumes - At least 5 years of experience developing complex ETLs with Informatica PowerCenter - At least 5 years of SQL / PLSQL experience with the ability to write ad-hoc and complex queries - Experience developing complex stored procedures, triggers, MQTs, and views on IBM DB2 - Strong understanding of advanced data warehouse concepts - Experience with scripting languages like Perl and Python - Familiarity with data ingestion into Hadoop, Autosys, or Airflow is a plus NTT DATA is a trusted global innovator of business and technology services, serving 75% of the Fortune Global 100. With a commitment to helping clients innovate, optimize, and transform for long-term success, NTT DATA has diverse experts in more than 50 countries. As a Global Top Employer, the company offers services including business and technology consulting, data and artificial intelligence, industry solutions, and application development and management. NTT DATA is a leading provider of digital and AI infrastructure and is part of the NTT Group, investing over 3.6 billion each year in R&D to support organizations and society in moving confidently into the digital future. If you are passionate about data engineering and seeking a challenging opportunity to work in a dynamic and innovative environment, we encourage you to apply to join our team at NTT DATA in Bangalore, Karnataka, India. As a ETL Informatica Engineer with Snowflake Experience at NTT DATA, your role involves being a member of the Controls Engineering, Measurement and Analytics (CEMA)-Technology Risk Solutions development team. Your primary focus will be on sourcing data and developing data solutions for Legal, Compliance, Audit, and Risk Management functions within Morgan Stanley. You will be responsible for developing data workflows, views, and stored procedures, as well as performing data analysis, and monitoring and tuning queries and data loads. Collaboration with data providers, data scientists, data developers, and data analytics teams is essential to implement client-specific business requirements effectively. • *Key Responsibilities:** - Develop ETLs, stored procedures, triggers, and views on the DB2-based Data Warehouse - Perform data profiling and analysis on source system data to ensure proper integration and representation in models - Monitor query and data load performance, performing tuning as necessary - Provide assistance during QA & UAT phases to confirm validity of potential issues and determine root cause and resolution • *Qualifications Required:** - Bachelor's degree in Computer Science, Software Engineering, Information Technology, or related field - At least 5 years of experience in data development and solutions in highly complex data environments with large data volumes - At least 5 years of experience developing complex ETLs with Informatica PowerCenter - At least 5 years of SQL / PLSQL experience with the ability to write ad-hoc and complex queries - Experience developing complex stored procedures, triggers, MQTs, and views on IBM DB2 - Strong understanding of advanced data warehouse concepts - Experience with scripting languages like Perl and Python - Familiarity with data ingestion into Hadoop, Autosys, or Airflow is a plus NTT DATA is a trusted global innovator of business and technology services, serving 75% of the Fortune Global 100. With a commitment to helping clients innovate, optimize, and transform for long-term success, NTT DATA has diverse experts in more than 50 countries. As a Global Top Employer, the company offers services including business and technology consul