Software Developer

Tata Consultancy Services Limited
Charlotte, United States of America
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 135K

Job location

Charlotte, United States of America

Tech stack

Agile Methodologies
CA Workload Automation Ae
Data Cleansing
Data Integration
ETL
Data Warehousing
Hadoop Distributed File System
MapReduce
HBase
Hive
JSON
Job Scheduling
NoSQL
Apache Oozie
Oracle Applications
Parsing
Performance Tuning
PL-SQL
SQL Databases
Sqoop
System Testing
Management of Software Versions
XML
Apache Zookeeper
Apache Yarn
Informatica Powercenter
Spark
Apache Flume
Information Technology
Kafka
Bitbucket
Software Version Control

Job description

  • 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.

Requirements

Do you have experience in Version control?, Do you have a Master's degree?, Primary Skill: ETL Informatica Developer Secondary: Oracle, SQL Experience: Minimum 10 years Roles & Responsibilities

  • Bachelor's or master's degree in computer science or related field. 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., Qualifications : BACHELOR OF COMPUTER SCIENCE

Benefits & conditions

Pulled from the full job description

  • Pet insurance
  • Health insurance
  • Vision insurance
  • Dental insurance
  • Commuter assistance, 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. Salary Range: $95,000 - $135,000 a year

Apply for this position