Location
Santa Monica, CA | United States
Job description
Large entertainment and media corporation in Santa Monica, CA is looking to hire an ETL Developer on contract basis. Role is hybrid and targeted to be onsite 1-2 days a week (Monday Thursday)
Summary of Position:
Seeking an ETL developer responsible for developing extractions, transformations and data loads from external and internal data sources. Furthermore, 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:
- 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
Experience & 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 (MapReduced), 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
- Self-starter with strong analytical and problem solving skills
- 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, a plus
- Knowledge of Home Entertainment, DMP Marketing and Sales and Planning, a plus
Report this job
- Dice Id: 10106335
- Position Id: JG13914
Job tags
Salary
