ETL Lead Job at Tata Consultancy Services, Atlanta, GA

QkhGNklSTkpJdTZaUVN0em1wVkpBZjM1Znc9PQ==
  • 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

Vitaly Health

Locum Tenens - Family Medicine Physician Job at Vitaly Health

 ...Job Title: Locum Tenens - Family Medicine Physician Location: Minnesota State Position Overview: Our team at Vitaly Health is looking for a Family Medicine Physician to join our Medical Center on an ongoing Locum Tenens basis, with a start date of January... 

Wipro

Project Manager Job at Wipro

 ...FY22 REVENUE 10.4 BN USD WERE PRESENT IN 66 COUNTRIES OVER 1,400 ACTIVE GLOBAL CLIENTS Job Description Role: Project Manager Required Skills & Experience A flexible, hardworking and "can do" attitude, comfortable working in a fast-paced environment... 

Saransh Inc

Voice to Face Avatar Expert [Voice and Facial recognition systems development] Job at Saransh Inc

Role: Voice to Face Avatar Expert Location: San Jose, CA / Waukesha, WI / Toronto, Canada (Onsite required) Contract Duration: 6 Months Experience: 10+ Years Qualifications and Experience: Bachelor's or Master's degree in Computer Science, Artificial Intelligence...

Spicin Foods

Chief Operating Officer Job at Spicin Foods

Spicin Foods is a specialty food manufacturer based in Kansas City, KS with a 60,000 square foot BRC, Kosher, and HACCP-approved manufacturing facility. We produce over five hundred sauces, in addition to our very own branded unique products in our facility. We serve hundreds...

Proclinical Staffing

Quality Control Reviewer II Job at Proclinical Staffing

 ...Quality Control Reviewer II - Contract - Boulder, CO Proclinical is seeking a Quality Control Reviewer II for a hybrid role in Boulder...  ...major pharmaceutical, biopharmaceutical, biotechnology and medical device companies. Proclinical Staffing is an equal opportunity...