About Big Oh Tech :

Big Oh Notation creates enterprise great cutting-edge software products and helps companies achieve their business goals by providing high-quality IT talent.

Big Oh Notation is ISO 27001 and CMMI Level 3 certified company

Big Oh Tech, strives to be a leader in the global marketplace for IT solutions in software development, enterprise app development, staff augmentation, and offshore outsourcing.

Big Oh is a dream team of 100+ technology enthusiasts constantly putting efforts into delivering scalable solutions to complex challenges leading to enhanced business revenue.

Our strategic, technical, and creative solutions provide comprehensive support to our patrons, which is perhaps why we're unswervingly ahead of the curve.

Job Description :

Responsibilities :

- Develop and maintain ETL jobs using the Talend Data Integration suite for batch and real-time data processing.

- Write and optimize complex SQL scripts, queries, and analytical functions for data transformation and validation.

- Recreate, enhance, and troubleshoot stored procedures, functions, and packages in Oracle and Vertica environments.

- Perform impact analysis and data lineage tracking for changes in source systems and downstream dependencies.

- Migrate legacy ETL workflows and SQL logic to Talend-based frameworks.

- Implement data quality and data profiling checks to ensure the reliability and accuracy of ingested data.

- Support data reconciliation and validation efforts between source and target systems.

- Collaborate with DBAs and infrastructure teams to optimize data storage, indexing, and partitioning strategies.

- To participate in code reviews, version control, and deployment automation for ETL scripts and database code.

- Troubleshoot and resolve production data issues and support root cause analysis.

Requirements :

Mandatory - Bachelor's degree (B. Tech )

- Proficient in using the Talend ETL suite for data integration and transformation.

- Deep working knowledge of Oracle, Microsoft SQL Server, and PostgreSQL databases.

- Exposure to Vertica as a data warehouse solution.

- Expertise in SQL query development for data extraction, manipulation, and analysis.

- Solid understanding of designing and maintaining stored procedures across multiple RDBMS.

- Knowledge of data security, integration, and interoperability best practices in data engineering.

- Familiarity with data warehousing concepts, including OLAP and data cubes.

- Experience with metadata management and implementing data quality frameworks.

- Programming skills in Python, SQL, or Java for building data workflows and automation scripts.

- 5-10 years of relevant experience