Senior Data Engineer

Job Profile: Senior Data Engineer

Job Location: San Antonio, TX

Job Description

Role Description

1. Analyze requirements and existing resources to propose, create ETL designs and database objects.
2. Work with project and business analyst leads to develop and clarify in-depth technical requirements, including logical and physical data modeling activities.
3. 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.
4. Develop, enhance, debug, support, maintain, and test 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.
5. Must have hands-on experience in Snowflake development environment with all SQL operations and be aware of the ELT approach.
6. Participate in the design, development, and implementation of complex applications, often using IBM Infosphere Information Server (IIS) products like Data Stage and Quality Stage on a Linux Grid environment, along with Control-M/Scheduling tools.

Required Skills

1. 10+ years of relevant IT software experience (Technical) in ETL Datastage or any other cloud-based ETL tool development.
2. Experience with databases like Snowflake (Cloud DB), Oracle, Netezza, MS SQL Server 2012+, DB2, and MS Access.
3. Experience with job automation & scheduling software (Control-M).
4. Strong ability to write SQL queries.

Desired Skills

1. Familiarity with Snowflake (Cloud DB), DBT, Kafka, Python, UNIX, Windows, file transfer utilities, process flow creation, ETL technologies, and Hadoop.

Good to Have Skills

1. Snow-Pro Certified.
2. Strong SQL skills.
3. Strong conceptual understanding of core DW concepts including different approaches/methodologies.
4. DBT (data build tool) experience is an added advantage.

Regards,

Shubham Chandra
Sr. US IT Recruiter
Diverse Lynx LLC | 300 Alexander Park | Suite #200 | Princeton, NJ 08540
Office: +732-452-1006 Ext 330
Email: | URL:

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence, and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.