Data Engineer II B

Technical Data Engineer

• Own end-to-end design and delivery of PL/SQL and ETL components
• Define coding standards, performance benchmarks, and best practices
• Review and approve technical designs, code, and ETL workflows

Delivery & Stakeholder Interaction

• Collaborate with architects, product owners, and business stakeholders
• Provide technical estimates, risk assessment, and delivery plans
• Support releases, production deployments, and major incident resolution

Oracle Development (PL/SQL)

• Design, develop, and maintain complex Oracle PL/SQL components, including: (Stored Procedures, Functions, Packages, Triggers, Views and Materialized Views)

• Write and optimize complex SQL queries for high-volume transactional and analytical systems
• Implement efficient data processing logic using BULK COLLECT, FORALL, cursors, and collections
• Enforce coding standards, best practices, and documentation for PL/SQL development
• Work closely with data modelers and architects to ensure optimal schema and index design
• Provide support for production issues, bug fixes, and performance enhancements

Informatica (ETL) Development

• Hands-on development and maintenance of Informatica PowerCenter mappings, sessions, and workflows
• Design end-to-end ETL solutions for Data Warehousing and operational systems
  • Strong experience with Informatica transformations including: (Source Qualifier, Lookup (connected/unconnected), Joiner, Aggregator, Router, Expression, Filter, Update Strategy)
• Experience handling slowly changing dimensions (SCDs), incremental loads, and data validation checks
• Ability to analyze and resolve ETL job failures and data issues
• Monitor and enhance ETL performance using Informatica tuning techniques