| ETL Data Engineer - Los Angeles - 91607 Hybrid at Remote, Remote, USA |
| Email: [email protected] |
| From: prashanth, AcuBahn Inc. [email protected] Reply to: [email protected] ETL Data Engineer Los Angeles - 91607 Hybrid contract position. Summary of Position: Lionsgate is currently 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 semistructured 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 Lionsgate business units to define and execute data ETLs Experience & Skills: Bachelors 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 Experience with AWS technologies 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 working with tools like Alteryx a plus Knowledge of Home Entertainment, DMP Marketing and Sales and Planning, a plus Keywords: csharp business works microsoft Delaware ETL Data Engineer - Los Angeles - 91607 Hybrid [email protected] |
| [email protected] View all |
| Wed Mar 27 00:02:00 UTC 2024 |