Tata Consultancy Services
Roles & Responsibilities
Design of complex ETL interfaces with an agnostic tool set for various source/target types
SAP BODS is preferred; if not, expert level in any major ETL tool
Performance tuning and troubleshooting skills across all technologies used
Strong in databases and SQL with decent data‑modeling skills
Ability to lead developers and QA, adhering to committed timelines (Agile experience preferred)
Work with upstream, downstream, and reporting system stakeholders to convert business requirements into technical requirements and JIRA stories
5+ years of experience in ETL tools, repository maintenance, migration of jobs/workflows/dataflows, job monitoring, break‑fix, user maintenance, CDC, Oracle Golden Gate, and working with various sources (Oracle, SAP, files) and targets (SQL Server, file uploads, etc.)
Responsible for planning, developing, implementing, and managing data‑warehouse project deliverables, design documents, and high‑level data mapping for ETL specifications
Create transformations in ETL jobs to achieve data cleansing and standardization during initial data load
Provide support for integration testing, defect fixing, and deployment; proficient in transformations such as Query, Push Down, SQL, Table Comparison, Pivot, and Look‑up
Proficient knowledge of databases such as Oracle (SQL queries) and SQL Server
Proficient knowledge of dimensional modeling, data mining, and data‑warehouse concepts
#J-18808-Ljbffr
Design of complex ETL interfaces with an agnostic tool set for various source/target types
SAP BODS is preferred; if not, expert level in any major ETL tool
Performance tuning and troubleshooting skills across all technologies used
Strong in databases and SQL with decent data‑modeling skills
Ability to lead developers and QA, adhering to committed timelines (Agile experience preferred)
Work with upstream, downstream, and reporting system stakeholders to convert business requirements into technical requirements and JIRA stories
5+ years of experience in ETL tools, repository maintenance, migration of jobs/workflows/dataflows, job monitoring, break‑fix, user maintenance, CDC, Oracle Golden Gate, and working with various sources (Oracle, SAP, files) and targets (SQL Server, file uploads, etc.)
Responsible for planning, developing, implementing, and managing data‑warehouse project deliverables, design documents, and high‑level data mapping for ETL specifications
Create transformations in ETL jobs to achieve data cleansing and standardization during initial data load
Provide support for integration testing, defect fixing, and deployment; proficient in transformations such as Query, Push Down, SQL, Table Comparison, Pivot, and Look‑up
Proficient knowledge of databases such as Oracle (SQL queries) and SQL Server
Proficient knowledge of dimensional modeling, data mining, and data‑warehouse concepts
#J-18808-Ljbffr