Diverse Lynx
DataStage Developer
Diverse Lynx, San Antonio, Texas, United States, 78208
Position : DataStage Developer
Location : San Antonio, TX / Plano, TX (Onsite)
Skills :
IBM Infosphere DataStage, Hyperion Essbase Analytics
Job Description :
Develop, test and maintain DBT models to transform raw data into meaningful insights as required by business
Understanding the existing ETL workflows implemented in IBM DataStage and replicate these transformations in DBT
Create DBT models to automate the UDAs (User developed applications)
Work on improving the performance and efficiency of data pipelines.
Identify bottlenecks and optimize SQL queries, transformations, and data loading processes to ensure optimal use of Snowflakes capabilities.
Implement data quality checks and validations to ensure accuracy, consistency, and reliability of data.
Test the dbt models and ensure that all the functionalities are working as expected.
Create control-m jobs to execute the dbt models Work with stakeholders to understand their data requirements and deliver as per their needs.
Coordinate with offshore to make them understand the requirements and help them out in case they are blocked with issues.
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.
Location : San Antonio, TX / Plano, TX (Onsite)
Skills :
IBM Infosphere DataStage, Hyperion Essbase Analytics
Job Description :
Develop, test and maintain DBT models to transform raw data into meaningful insights as required by business
Understanding the existing ETL workflows implemented in IBM DataStage and replicate these transformations in DBT
Create DBT models to automate the UDAs (User developed applications)
Work on improving the performance and efficiency of data pipelines.
Identify bottlenecks and optimize SQL queries, transformations, and data loading processes to ensure optimal use of Snowflakes capabilities.
Implement data quality checks and validations to ensure accuracy, consistency, and reliability of data.
Test the dbt models and ensure that all the functionalities are working as expected.
Create control-m jobs to execute the dbt models Work with stakeholders to understand their data requirements and deliver as per their needs.
Coordinate with offshore to make them understand the requirements and help them out in case they are blocked with issues.
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.