ETL Developer

ETL Developer, SQL, Python, SSIS, API, Java, Matillion ETL
Full Time
Depends on Experience
Work from home not available Travel not required

Job Description

A local entertainment company is seeking an ETL developer responsible for developing extractions, transformations and data loads from external and internal data sources. The ETL developer must be an expert at migrating normalized, structured and semi-structured data into star, snowflake and other de-normalized data models. This means the developer needs to be able to read, analyze and digest what a business wants to accomplish with its data and develop the best possible ETL process around those goals. In addition, this position will be expected to deliver reporting architectures that pull data from the enterprise data warehouse into smaller report friendly data marts.

Responsibilities include:
• Developing ETL logic with common coding languages like SQL, Java, Python, XML, C#, VB
• Developing Microsoft SSIS packages, including alerts data validation checks
• Developing ETL solution for incoming sFTP, CSV, Excel, XML and JSON data feeds
• Deploying ETL job workflow with reliable error/exception handling and rollback framework
• Developing star and snowflake DW dimensional models for landing incoming data
• Developing ETL code with proper metadata definitions, models, schedules, and maintenance
• Adapting ETL code to accommodate changes in source data and new business requirements
• Troubleshooting and solving complex technical and data problems
• Managing software upgrades, capacity planning and system performance tuning
• Performing unit testing, system integration testing and assist with user acceptance testing
• Documenting the ETL detailed design and test results as part of development cycle
• Prioritizing development & enhancement requests to align with corporate goals and business needs
• Using different data warehouse architecture techniques like ODS, DM, ROLAP and MOLAP
• Manages automation of file processing as well as all ETL processes within a job workflow
• Ensuring data quality throughout data governance and master data management
• Ensuring compliance with regulatory requirements such as PCI, HIPPA, and SOX
• Collaborating with various business units to define and execute data ETLs

Required Skills:
• Bachelor's degree in computer science and 3-5 years of experience developing data ETLs
• Masters in CS, Stats or Math a plus
• Expert level experience with ETL development with Microsoft SSIS and SQL Server
• Strong background loading data from CSV, Excel, XML and JSON into DW
• Expert with MS SQL stored procedures, functions, indexing & SQL Server in-memory features
• Working knowledge of Hadoop (MapReduce), Apache SPARK, and columnar MPP
• Working knowledge of big data NoSQL, un-structured and semi-structured data
• SAP experience preferred - CRM, IPM, BW experience ideal
• DMP tagging of web and social media properties for marketing
• Ability to translate ideas and business requirements into fully functioning ETL workflows
• Strong experience with API development
• Strong experience with Java, a plus
• Experience working with Matillion ETL, a plus
• Experience with AWS technologies, Home Entertainment, DMP Marketing and Sales and Planning, is a plus

If you think you are a good fit for this position, please don’t hesitate to apply now!

PeopleWare Staffing, Inc. is dedicated to placing quality individuals into contract and full-time positions. There is no fee charged to our candidates or contractors. Our philosophy is to keep everyone's best interest at heart and make sure there is a good match on skills and personal interests.

PeopleWare offers its contractors health, dental, and vision insurance, along with a 401(k) plan with a matching contribution. For more information please visit our website:

Please Note: - We are unable to sponsor H1-B visas at this time. - No third party candidates will be considered for this position. - US citizens and those authorized to work in the US are encouraged to apply.

Posted By

302 W. Grand Ave., Suite 4 El Segundo, CA, 90245

Dice Id : ppleware
Position Id : D9369
Have a Job? Post it