ETL Specialist

Key Responsibilities:

As an ETL Specialist at Sysmind Tech, you will be responsible for designing and developing complex ETL interfaces using an agnostic tool set across various source and target types. SAP BODS is preferred, but expertise in other major ETL tools is also valuable. You will work on performance tuning and troubleshooting across all technologies used, with a strong background in DB and SQL skills, as well as data modeling. Additionally, you will lead developers and QA teams, adhering to committed timelines and leveraging Agile experience. You will work closely with upstream, downstream, and reporting system stakeholders to convert business requirements into technical requirements and JIRA stories. The ideal candidate will have 5+ years of experience in ETL tools, repository maintenance, migration of jobs/workflows/dataflows, job monitoring, break fix, user maintenance, CDC, Oracle Golden Gate, and working with various sources and targets to load data. You will be responsible for planning, developing, implementing, and managing data warehouse project deliverables, design documents, and high-level data mapping for ETL specifications. You will create transformations in ETL jobs to achieve data cleansing and standardizations during initial data load and provide support for integration testing, defect fixing, and deployment. Proficiency in transformations like Query, Push down, SQL, Table Comparison, Pivot, and Lookup, as well as databases like Oracle and SQL Server, dimensional modeling, data mining, and data warehouse concepts, is a must. Excellent analytical skills and knowledge to transfer data from Oracle, SQL Server tables, and Web Services either incrementally or full load to the Data warehouse on a periodic basis are also required. You should be able to troubleshoot existing ETL jobs, improve their performance, create and load data into Aggregate Tables using transformations, and perform tasks individually and independently.