Data Engineer Job at Tata Consultancy Services, Cincinnati, OH

eDk4SWNzQ0JqRGVGWDN2YVUvTldueWZJQ2c9PQ==
  • Tata Consultancy Services
  • Cincinnati, OH

Job Description

Job Description

Skill: Data Engineering

  • Experience in Information Technology experience in Design, Development and Implementation of large scale and medium scale Data warehousing Applications using ETL tool IBM Infosphere Information server DataStage, SQL and Unix.
  • Experience in Snowflake Implementation.
  • End to End experience in all stages of Software Development Life Cycle including Data mapping, build, unit testing, system integration testing and performance tuning.
  • Experience with SQL implementation.
  • Experience with orchestration tool like Control M, TWS scheduler.
  • 5-7 years With a broad portfolio of AWS infrastructure tools (EBS, S3, EC2, Elastic IP, Route 53, VPC) and with cloud infrastructure management and automation technologies.
  • Working with basic structured, semi-structured, and unstructured data.
  • Exposure to modern data/analytics architecture (Big Data, Cloud, etc.).
  • Exposure to advanced analytics tools (Python, R, etc). Scripting (shell, python, ruby) skills for monitoring and automation.
  • Strong understanding of the principles of Data Warehousing using fact tables, dimension tables and star/snowflake schema modelling.
  • Worked extensively with Dimensional modelling, Data migration, Data cleansing, ETL Processes for data warehouses.
  • Developing and maintaining data pipelines for efficient data extraction, transformation, and loading (ETL) processes.
  • Collaborating with data analysts, data architects, and software engineers to understand data requirements and deliver relevant data sets (e.g., for business intelligence).
  • Building required infrastructure for optimal extraction, transformation and loading of data from various data sources using AWS and SQL technologies.
  • Advanced knowledge and expertise in designing and developing ETL jobs using IBM Infosphere DataStage and sound experience in other IIS suite like Information Analyzer and basics on Quality Stage.
  • Experience in IBM IIS DataStage Migration projects from planning to execution.
  • Possess very strong expertise & knowledge in core banking and insurance domain applications. Solutions oriented professional with excellent skills in field of analysis, design, development, customizations, and implementation of software applications.
  • Performance Tuning and Optimization of ETL jobs and SQL queries in ad-hoc and complex report environments.
  • Extensive experience with ETL to load data from Flat Files, XML, Oracle and DB2 to ODBC databases & to perform various transformations using Filter, Transformer, Join, Lookup, Aggregator, Change Capture, Remove Duplicate, Shared container, Nested condition, Routines, Command activity stages to create robust mappings in the DataStage Designer.
  • Familiar in using highly scalable parallel processing infrastructure using parallel jobs and multiple node configuration files.
  • Experienced in scheduling Sequence and parallel jobs using DataStage Director, UNIX scripts and scheduling tools.
  • Experience in troubleshooting of jobs and addressing production issues like data issues, ENV issues, performance tuning and enhancements.
  • Extensive experience in design and development of Decision Support Systems (DSS).
  • Extensive experience in Unit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT) and Performance Testing.
  • Worked with various databases like Oracle 10g/9i/8i, DB2, SQL Server, Teradata.
  • Experience in writing PL/SQL stored procedures, functions, and packages.
  • Proficient in writing Uni x shell scripts and extensive experience working with Unix operating systems.
  • Provided value addition to that client by developing new solutions of process, which reduced manual intervention of users and gained significant performance improvement of existing process.

Job Tags

Similar Jobs

Bespoke Careers

Senior Landscape Architect Job at Bespoke Careers

 ...This award-winning landscape architecture practice have a portfolio that spans the Globe. They are looking for creative, passionate, well-structured and proactive designers of the highest caliber to join their team in Miami. You will be working closely with senior partners... 

Tigermed

Senior Clinical Research Associate (Western Based CRA) Job at Tigermed

1. Job Purpose: This position is responsible for project management and study site management from site selection to initiation until monitoring and close-out of assigned clinical study studies in accordance with Tigermed or sponsor Standard Operating Procedures (SOPs...

Varonis

Sales Development Intern Job at Varonis

 ...Job Posting: Sales Development Intern Company: Varonis Systems, Inc. Summary: Are you eager to kickstart your sales career...  ...Maintain accurate account information and activity details in Salesforce (CRM). Requirements: Currently pursuing a Bachelors Degree... 

Krispy Kreme

Marketing Business Analyst Intern Job at Krispy Kreme

 ...own limited time offer collection! We are seeking a Business Analyst Intern for Krispy Kremes Delivered Fresh Daily platform to support...  ..., you will assist with compiling and analyzing performance data across multiple retail customers to identify trends and prepare... 

Net2Source Inc.

Lab Technician - I (Assistant) Job at Net2Source Inc.

 ...recruiter with Net2Source Inc. Our direct client is looking to hire a Lab Tech (Millsboro) - I (Assistant) in their growing team....  ...Position description for lab tech (entry level): A Laboratory Technician is responsible for critical laboratory procedures and duties in...