- Analyze requirements and existing resources to create efficient database and ETL designs to support system to system data integration
- Work with project and business analyst leads in order to develop and clarify in-depth technical requirements including logical and physical data modeling activities
- Design and implement ETL processes for data transactions related to Enterprise Data Warehouse, Operational Data Store (ODS), and other data structures to support our Business Intelligence operations
- Develops, enhances, debugs, supports, maintains and tests software applications that support business units or supporting functions using Hadoop ETL tool suite. These application program solutions may involve diverse development platforms, software, hardware, technologies and tools.
- Participates in the design, development and implementation of complex applications, often using Hadoop, Python, Spark, Git environment, Snowflake, aws.
- Required Skills:3+ Yrs Relevant IT software experience (Technical) in Haddop development Experience with databases like Netezza, Oracle, MS SQL Server 2012+, DB2 and MS Access And NOSQL dbs
- Experience with job automation & scheduling software (Control M) Strong ability to write SQL queries
Desired Skills: Familiar with UNIX, Windows, File transfer utilities, Visio, process flow creation, ETL technologies