SysMind Tech
Senior Data Engineer
SysMind Tech, San Antonio, Texas, United States, 78208
Position: Data Engineer
Location: San Antonio, TX(Onsite)
Job type: Full Time
Role Description:Analyze requirements and existing resources to Propose, create ETL designs and database objectsWork with project and business analyst leads in order to develop and clarify in-depth technical requirements including logical and physical data modeling activitiesDesign 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 operationsDevelops, enhances, debugs, supports, maintains and tests software applications that support business units or supporting functions using IBM Infosphere Data Stage ETL or any other cloud based ETL tool both ETL and ELT approaches. These application program solutions may involve diverse development platforms, software, hardware, technologies and tools.Must have hands-on on Snowflake development environment with all SQL operations. Must be aware of ELT approach as well.Participates in the design, development and implementation of complex applications, often using IBM Infosphere Information Server (IIS) products like Data Stage, Quality Stage on a Linux Grid environment. Control-M/Scheduling tools.Required Skills:
10+ Yrs Relevant IT software experience (Technical) in ETL Datastage or any other cloud based ETL Tool development Experience with databases like Snowflake (Cloud DB), Oracle, Netezza, MS SQL Server 2012+, DB2 and MS AccessExperience with job automation & scheduling software (Control-M) Strong ability to write SQL queriesDesired Skills: Familiar with Snowflake (Cloud DB), DBT, Kafka, Python, UNIX, Windows, File transfer utilities, process flow creation, ETL technologies, HadoopGood to have Skills:
Snow-Pro Certified. Strong SQL, Strong conceptual understanding of core DW Concepts including different approaches/methodologies. dbt (data build tool) experience is an added advantage
Location: San Antonio, TX(Onsite)
Job type: Full Time
Role Description:Analyze requirements and existing resources to Propose, create ETL designs and database objectsWork with project and business analyst leads in order to develop and clarify in-depth technical requirements including logical and physical data modeling activitiesDesign 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 operationsDevelops, enhances, debugs, supports, maintains and tests software applications that support business units or supporting functions using IBM Infosphere Data Stage ETL or any other cloud based ETL tool both ETL and ELT approaches. These application program solutions may involve diverse development platforms, software, hardware, technologies and tools.Must have hands-on on Snowflake development environment with all SQL operations. Must be aware of ELT approach as well.Participates in the design, development and implementation of complex applications, often using IBM Infosphere Information Server (IIS) products like Data Stage, Quality Stage on a Linux Grid environment. Control-M/Scheduling tools.Required Skills:
10+ Yrs Relevant IT software experience (Technical) in ETL Datastage or any other cloud based ETL Tool development Experience with databases like Snowflake (Cloud DB), Oracle, Netezza, MS SQL Server 2012+, DB2 and MS AccessExperience with job automation & scheduling software (Control-M) Strong ability to write SQL queriesDesired Skills: Familiar with Snowflake (Cloud DB), DBT, Kafka, Python, UNIX, Windows, File transfer utilities, process flow creation, ETL technologies, HadoopGood to have Skills:
Snow-Pro Certified. Strong SQL, Strong conceptual understanding of core DW Concepts including different approaches/methodologies. dbt (data build tool) experience is an added advantage