ETL Informatica/Hadoop Developer jobs in United States
info-icon
This job has closed.
company-logo

Tata Consultancy Services · 21 hours ago

ETL Informatica/Hadoop Developer

Tata Consultancy Services is a leading global IT services, consulting, and business solutions organization. They are seeking an ETL Informatica/Hadoop Developer who will design, develop, and maintain ETL processes using Informatica PowerCenter while ensuring data quality and integration from various sources.

Business Information SystemsConsultingInformation TechnologyIT Management
check
H1B Sponsor Likelynote

Responsibilities

ETL Process Development: Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools
Deep understanding of HDFS, YARN, MapReduce, Hive, Pig, HBase, Flume, Sqoop, Zookeeper, Oozie
Experience with Spark, Kafka, NoSQL databases
Experience in Agile Methodology
Experience with code versioning tools like Bit-Bucket
SQL Proficiency: Utilize SQL/PLSQL to extract, transform, and load data
Exposure to advanced transformations like data transformations, Parsing JSON/XML messages
Experience in Job scheduling tools Like Autosys
Data Integration: Integrate data from various sources, ensuring data consistency and quality
Data Warehouse Design: Design and maintain data warehouses to support business intelligence activities
Performance Optimization: Optimize SQL script/queries for speed and efficiency
Troubleshooting: Identify and resolve issues in ETL processes
Documentation: Create and maintain technical documentation for ETL processes
Testing: Perform unit, integration, and system testing on ETL processes
Collaboration: Collaborate with cross-functional teams to ensure successful implementation of ETL processes
Data Quality: Ensure data quality by implementing data cleansing and transformation processes
Data Modeling: Develop and maintain relational and dimensional data models

Qualification

ETL InformaticaHadoopSQLOracleData Warehouse DesignData IntegrationPerformance OptimizationAgile MethodologyData QualityData ModelingTroubleshootingTestingCollaborationDocumentation

Required

Bachelor's or master's degree in computer science or related field
Minimum 10 years of experience
ETL Informatica Developer
Deep understanding of HDFS, YARN, MapReduce, Hive, Pig, HBase, Flume, Sqoop, Zookeeper, Oozie
Experience with Spark, Kafka, NoSQL databases
Experience in Agile Methodology
Experience with code versioning tools like Bit-Bucket
SQL Proficiency: Utilize SQL/PLSQL to extract, transform, and load data
Exposure to advanced transformations like data transformations, Parsing JSON/XML messages
Experience in Job scheduling tools Like Autosys
Data Integration: Integrate data from various sources, ensuring data consistency and quality
Data Warehouse Design: Design and maintain data warehouses to support business intelligence activities
Performance Optimization: Optimize SQL script/queries for speed and efficiency
Troubleshooting: Identify and resolve issues in ETL processes
Documentation: Create and maintain technical documentation for ETL processes
Testing: Perform unit, integration, and system testing on ETL processes
Collaboration: Collaborate with cross-functional teams to ensure successful implementation of ETL processes
Data Quality: Ensure data quality by implementing data cleansing and transformation processes
Data Modeling: Develop and maintain relational and dimensional data models

Benefits

Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Company

Tata Consultancy Services

company-logo
Tata Consultancy Services is a business solutions company that specializes on information technology services and consulting.

H1B Sponsorship

Tata Consultancy Services has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (7880)
2024 (9690)
2023 (8537)
2022 (11159)
2021 (9813)
2020 (11984)

Funding

Current Stage
Public Company
Total Funding
unknown
2004-08-25IPO

Leadership Team

leader-logo
K. Krithivasan
Chief Executive Officer & Managing Director
linkedin
leader-logo
Aarthi Subramanian
President and Chief Operating Officer
Company data provided by crunchbase