ETL Lead Job at Tata Consultancy Services, Atlanta, GA

TTdhcFF4MG9RSTZyY0tHSVFEdEFKTjFBcnc9PQ==
  • Tata Consultancy Services
  • Atlanta, GA

Job Description

Role: ETL Lead

Location: Atlanta, GA, USA(Onsite)

Job Type: Full Time

Must Have Technical/Functional Skills:

Informatica IICS, Orace, Databricks, SQL, Python, Databricks.

Experience Required:

10 Plus years of experience in the analysis, design, development, testing and maintenance of ETL/ELT solutions o Strong experience in the areas of Data Integration, Data Warehousing, application integration and Business Intelligence as an SME/Architect, showcasing deep knowledge of the platform's capabilities o Knowledge of Informatica products: Intelligent Data Management Cloud or (IICS), Informatica Power Center (10.4), Data Quality, Power Exchange and MDM. o Knowledge of connecting IICS to popular cloud platforms like Azure o Design end-to-end ETL processes using Python to extract,transform, and load data from diverse sources into a centralized data warehouse.

Worked on join, filter, aggregator, router, sorter, sequence generator, hierarchy-parser, expression transformations in informatica cloud IICS- Data Integration. o Experience working with Informatica IICS tool effectively using it for Data Migration from multiple source systems o Demonstrated success in building Restful API Integration, SOAP (WSDL) using IICS. o Develop modular and scalable ETL workflows, ensuring efficient data processing and seamless integration with downstream applications. o Integrate Data bricks with data lakes and data warehouses like AWS S3, Azure Data Lake Storage. o Strong knowledge in Data warehousing concepts, Relational Database Management Systems and Dimensional modeling. o Experience with database systems like SQL Server, Oracle, MySQL, and Mongo DB. o Implement Azure Data bricks cluster, notebooks, jobs and auto scaling. o Prepare Technical Design documents, Run books after completion of development. o Knowledge on Python Scripting. o Good working experience in Agile and Waterfall methodologies.

Roles & Responsibilities:

Lead the overall Data ingestion, ETL process. o Quickly adapt to standard policies/procedures processes and business needs. o Provide oversight and solutions to address gaps in application functionality, data quality, and performance related issues and executing/revising/Updating, and SQL code to respond to different maintenance requests. o Lead the automation effort by developing scripts in Unix and or Python o Handle performance challenges and incorporate best practice to improve efficiency.

Job Tags

Full time, Work experience placement,

Similar Jobs

AM Hotshots LLC

Lease Purchase Semi Truck Driver (m/w/d) Job at AM Hotshots LLC

 ...Job Description: CDL A LEASE PURCHASE WALK AWAY LEASE -PLUS 75% OF GROSS BE YOUR OWN BOSS AND EARN UP TO $2,500 PER WEEK + AM HOT...  ...Valid CDL A Only 6 months of experience needed with CDL A (OTR or Regional) Must Meet FMCSA/DOT driver regulations... 

Honda Dev. and Mfg. of Am.,LLC

Senior User Experience Researcher Job at Honda Dev. and Mfg. of Am.,LLC

 ...qualified individuals with diverse backgrounds, experiences, continuous improvement values, and a...  ...the Future! JOB PURPOSE: The Senior UX Researcher conducts research on how...  ...Bachelors Degree in Human Factors, Industrial Design, UX design; Engineering, Psychology,... 

AM Hotshots LLC

Lease Purchase Semi Truck Driver Job at AM Hotshots LLC

 ...Your Opportunity Awaits: Become Your Own Boss as a Lease Purchase Semi Truck Driver! Join AM Hot Shots and drive your own semi truck with our CDL A Lease Purchase program. With a walk-away lease structure, you can earn up to $2,500 per week! ~ No Money Down... 

LanceSoft

Litigation Paralegal Job at LanceSoft

 ...Litigation Paralegal Company Description: Law firm renowned for successfully representing personal injury victims throughout the New York metro area. Built a reputation for excellence in legal representation and client service. Role Description: We are seeking a... 

Ryder

Warehouse Industrial Improvement Engineer Job at Ryder

 ...can review the Job Applicant Privacy Policy by clicking here ( . Job Description : Summary This position supports the Ryder Continuous Improvement culture across the operation by actively applying continuous improvement methods to support operations. The...