| ETL developer - Los Angeles - 91607 Hybrid - Locals at Remote, Remote, USA |
| Email: [email protected] |
| From: Prashanth, AcuBahn Inc. [email protected] Reply to: [email protected] 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 |
| [email protected] View all |
| Tue Mar 12 03:13:00 UTC 2024 |