Senior ETL Developer

Senior ETL Developer Experience :

5+ Years

Job ID :

1945 Roles & Responsibilities Interact with Product and Client teams to better understand the technical and functional requirements Work with the Systems analyst and Translate business requirements to technology implementation Analyzing Data feeds and interfaces from a wide variety of systems Designing development schema for data feed development, ETL feeds Design responsibility for Data Lake, Data Warehouse, and Distributed Databases Design, Develop and implement ETL jobs using Informatica for Data extraction, parsing, and massaging of large disparate data sets using multiple platforms and technologies to enable complex aggregations, data analytics, and visualization. Build ETLs and other high-bandwidth services to help discover problems early Work with large Data Feeds and Heterogeneous Source Systems like Oracle, SQL Server, and Flat Files. Work on Dimensional Data modeling, Star Schema, FACT & Dimensions tables, Physical & logical data modeling. Test and debug all ETL and Oracle objects to evaluate the performance. Troubleshoot all parts of the data pipelines as necessary. Scheduling and monitoring ETL/ Informatica jobs in development, system testing, a production environment Essential Knowledge, Skills, and Experience Senior ETL Developer Preferred Experience Interact with Product and Client teams to better understand the technical and functional requirements Work with the Systems analyst and Translate business requirements to technology implementation Analyzing Data feeds and interfaces from a wide variety of systems Designing development schema for data feed development, ETL feeds Design responsibility for Data Lake, Data Warehouse, and Distributed Databases Design, Develop and implement ETL jobs using Informatica for Data extraction, parsing, and massaging of large disparate data sets using multiple platforms and technologies to enable complex aggregations, data analytics, and visualization. Build ETLs and other high-bandwidth services to help discover problems early Work with large Data Feeds and Heterogeneous Source Systems like Oracle, SQL Server, and Flat Files. Work on Dimensional Data modeling, Star Schema, FACT & Dimensions tables, Physical & logical data modeling. Test and debug all ETL and Oracle objects to evaluate the performance. Troubleshoot all parts of the data pipelines as necessary Scheduling and monitoring ETL/Informatica jobs in development, system testing, a production environment