ETL Developer

Description

Job Description Reporting into the Senior Manager of Data Integration & Stewardship, this role will be responsible for translating business requirements (defined user story, acceptance criterion, etc.) into technical processes and solutions that will support the enterprisewide national sales data architecture suite, inherently allowing the organization to deploy more efficient integration efforts and datasets at scale.
Key Roles & Responsibilities Design and create ETL mapping configurations via Informatica Cloud into differing endpoints/sources (big data platforms, data warehouses, business intelligence platforms), focusing on both the shortterm deliverables, but also considering the big picture application of how the data project adheres to the overall enterprise architecture roadmap
Partner with Data Operations peers (integration, engineering, etc.) to understand broader business requirements and articulate required next steps to understand how to deliver endstate (i.e. what questions need to be asked and answered to model, profile, build, integrate, and deploy)
Validate and test the progression/evolution of the ETL design relative to the desired reporting capability user interface, identifying potential quality and/or general architecture concerns that are vital to successful and scalable delivery
Support the specific data definitions and stewardship functions attributed to the data assets (i.e. in partnership with peer group that owns the BI/reporting development), including but not limited to columnlevel business and technical definitions, itemization of product lineage and processes, etc.
Technical Skills Experience/advanced skills associated with suite of data migration solutions, particularly Informatica Cloud/Informatica Intelligent Cloud Services (IICS) and Power Center
Proven ETL development skills, inclusive of data warehousing/data modeling
Strong SQL skills and database development experience (TSQL, PL/SQL)
Familiarity operating in a Teradata environment
Understanding/exposure of working with big data (Hadoop) processes and concepts
Comfortable in an Amazon Web Services (AWS) environment
Prior utilization of mining Salesforce.com data is desired, but not required
Business Skills Advanced problemsolving skills with the demonstrated ability to effectively learn new business tools and processes
Selfmotived and works at a highlevel independently, even with limited or ambiguous requirements/direction
Project Management/knowledge of software development lifecycle (SDLC)
Exposure to agile development methodology will be helpful, but not required