Analyst/Developer - Specialty 3

ETL (Matillion) Developer

• Understand your data sources.
• Follow the groups processes and strategy for developing the job.
• Handle data modeling, data warehouse architecture, data pipeline management, and ETL testing.
• Utilize various data warehousing fundamentals for setting up a data warehouse.
• Help to collect, manage, and analyze huge volumes of data for extraction, transformation, and loading.
• Implement database structure, data marts, data stores, and data lakes.
• Ensure high-end security and good quality of data.
• Safeguard proper functioning of data once the transfer is done.
• Seamless collaboration with data management teams on giving required data.
• Testing the warehouse infrastructure/storage system prior to data extraction
• Offer regular maintenance support.
• Administering ETL tools, app integration, performance tuning
• Working on technical/functional documentation
• Monitor pre-decided ETL jobs and ensure resolution of discrepancies.

Story Behind the Need - Business Group & Key Projects • Position's Contributions to Work Group
• Team culture
• Surrounding team & key projects
• Purpose of this team
• Reason for the request Position's Contributions to Work Group :
• The team is growing and working through a major Systems Transformation and building a Data Warehouse in Snowflake.
• The group previously only had a transactional system in Oracle and used DataStage for ETL.
• This job will work in a team environment to develop necessary ETL jobs using Matillon/ActiveBatch.
Reason/motivation for request :
• Backfill Typical Day in the Role • Typical task breakdown and rhythm
• Interaction level with team
• Work environment description
Typical task breakdown:
• Work is either assigned through projects (typically in Azure DevOps) or ServiceNow.
• Most efforts have some form of project update meeting or daily/weekly SCRUM.
Interaction with team :
• Highly collaborative environment.
• We are a mix of Agile principles and Waterfall.
Work environment :
• We are hybrid. We come in periodically to work in the office, but we are mostly from home. However, working full-time from the office is definitely a possibility if the resource preferred that. Candidate Requirements • Years of experience required
• Degrees or certifications required
• Disqualifiers
• Performance indicators Education & Experience Required:
• 5+ years' experience in ETL work. Direct experience in Matillion is preferred.
Technical Skills
(Required)
• Highly competent in Matillion, SQL, and have an ability to document well.
Soft Skills
(Required)

• Strong communication skills with business users.
• Strong collaboration with team members.
• Ability to learn and apply new knowledge quickly.

Required Skills : Moving from Oracle DB to Snowflake. ETL-Matillion OR Data Stage Experience with Oracle or Snowflake would be key
Basic Qualification :
Additional Skills :
Background Check :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :No
Candidate must be authorized to work without sponsorship ::No
Interview times set :Yes
Type of project :Other Project Type
Master Job Title :Misc: Non-Technical
Branch Code :Nashville