Data Engineering at Tata Consultancy Services in Milwaukee, Wisconsin

Posted in Other about 13 hours ago.

Type: full-time





Job Description:

Job Description
• 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.
• End to End experience in all stages of Software Development Life Cycle including Data mapping, build, unit testing, system integration testing and performance tuning.
• 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 Unix 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.
More jobs in Milwaukee, Wisconsin

General Business
about 5 hours ago

Pick 'n Save
Other
about 6 hours ago

Badger Meter
Other
about 8 hours ago

Baker Tilly Advisory Group, LP
More jobs in Other

Other
less than a minute ago

Vertiv Corporation
Other
less than a minute ago

Vertiv Corporation
Other
less than a minute ago

Vertiv Corporation