Architect

Tata Consultancy Services; Charlotte (NC); On-site; USD 90,000 - 140,000; Full time

Job summary

Tata Consultancy Services in Charlotte, NC is seeking an experienced ETL Informatica Developer to design and optimize data integration solutions. You will work with Oracle, SQL, and big data tools to build robust data pipelines and data warehouses for business intelligence.

Required is a minimum of 10 years in ETL/BI, proficiency with Spark, Hadoop ecosystem basics, and experience with Autosys or similar job schedulers.

Qualifications

• Minimum 10 years of experience in ETL and data warehousing.
• Strong SQL/PLSQL and Oracle background.
• Experience with ETL tools like Informatica.
• Knowledge of data modeling and data quality practices.

Responsibilities

• Deep understanding of HDFS, YARN, MapReduce, Hive, Pig, HBase, Flume, Sqoop, Zookeeper, Oozie.
• Experience with Spark, Kafka, NoSQL databases.
• Experience in Agile Methodology.
• SQL Proficiency: Utilize SQL/PLSQL to extract, transform, and load data.
• Data Warehouse Design: Design and maintain data warehouses to support BI activities.
• Performance Optimization: Optimize SQL scripts and 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.

Skills

ETL Informatica Developer

Oracle

SQL

Education

Bachelor of Computer Science

Tools

BitBucket

Job description

Job Description

Primary Skill: ETL Informatica Developer

Secondary: Oracle, SQL

Experience: Minimum 10 years

Roles & Responsibilities

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

Salary Range- $90,000-$140,000 a year

Qualifications

BACHELOR OF COMPUTER SCIENCE