Diverse Lynx
Developer - Datastage, Essbase, DBT
Diverse Lynx, San Antonio, Texas, United States, 78208
Role:- Developer - Datastage, Essbase, DBTLocation- San Antonio, TX - Onsite role/No RemoteDuration- Contract
Job Description:DeveloperDevelop, test and maintain DBT models to transform raw data into meaningful insights as required by businessUnderstanding the existing ETL workflows implemented in IBM DataStage and replicate these transformations in DBTCreate 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 modelsWork 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.Competencies: IBM InfoSphere DataStage, Hyperion Essbase Analytics
Experience (Years):8-10Essential Skills:DBT, Datastage, ETLDesirable Skills:DBT, Datastage, ETL
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.
Job Description:DeveloperDevelop, test and maintain DBT models to transform raw data into meaningful insights as required by businessUnderstanding the existing ETL workflows implemented in IBM DataStage and replicate these transformations in DBTCreate 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 modelsWork 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.Competencies: IBM InfoSphere DataStage, Hyperion Essbase Analytics
Experience (Years):8-10Essential Skills:DBT, Datastage, ETLDesirable Skills:DBT, Datastage, ETL
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.