- Design, develop, and schedule DataStage ETL jobs to extract data from disparate source systems, transform, and load data into EDW for data mart consumption, self-service analytics, and data visualization tools.
- Provides hands-on technical solutions to business challenges & translates them into process/technical solutions.
- Conduct code reviews to communicate high-level design approaches with team members to validate strategic business needs and architectural guidelines are met.
- Evaluate and recommend technical feasibility and effort estimates of proposed technology solutions.
- Provide operational instructions for dev, QA, and production code deployments while adhering to internal Change Management processes.
- Coordinate Control-M scheduler jobs and dependencies
- Recommend and implement ETL process performance tuning strategies and methodologies.
- Conducts and supports data validation, unit testing, and QA integration activities.
- Compose and update technical documentation to ensure compliance to department policies and standards.
- Create transformation queries, stored procedures for ETL processes, and development automations.
- Ensure HIPPA, PHI, and regulatory compliance rules and stipulations are reinforced.
Minimum Requirements
Typically has 5+ years relevant experience
Critical Skills
- Possess extensive knowledge of application modeling principles, concepts and techniques.
- Competency in Kimball and Inmon EDW and data modeling pattern methodologies.
- High aptitude to acquire user requirements effectively, translate into technical specifications, and develop code base to satisfy business needs.
- Extensive database experience in one or more of the following databases: Oracle, DB2, SQL Server, Azure SQL DW, Snowflake.
- Strong data profiling, data mining, and data analysis aptitude.
- Complex SQL and PL/SQL development expertise.
- Strong working knowledge of relational data marts using star schema design.
- Comprehensive understanding of software development lifecycle and data warehousing concepts.