Senior IDMC & Hadoop ETL Developer

Tata Consultancy Services Limited; Charlotte (NC); On-site; USD 120,000 - 128,000; Full time

Benefits offered by this job

Comprehensive medical coverage

Commuter benefits

Discretionary annual incentive

401K plan

Job summary

Tata Consultancy Services Limited in Charlotte, NC is seeking an experienced Informatica IDMC Developer to design, migrate and optimize ETL processes. The role requires 8+ years of experience, a Bachelor’s or Master’s degree, and strong SQL, Hadoop, and Oracle skills.

You will collaborate with cross-functional teams, implement data quality and data modeling best practices, and contribute to data warehouse design and performance tuning in a fast-paced BI environment.

Qualifications

• Bachelor's or master's degree in computer science or related field.
• Minimum 2 years experience in IDMC migration projects.
• ETL Process Development: Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools.
• 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.
• Experience with HDFS, MapReduce, and Hadoop ecosystems.
• Understanding data storage and data processing techniques in Hadoop.
• 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.

Responsibilities

• Bachelor's or master's degree in computer science or related field.
• Minimum 2 years experience in IDMC migration projects.
• ETL Process Development: Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools.
• 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.
• Experience with HDFS, MapReduce, and Hadoop ecosystems.
• Understanding data storage and data processing techniques in Hadoop.
• 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.

Skills

Informatica IDMC

Oracle

Hadoop

Education

Bachelor's or Master’s degree in CS/related field

Job description

Tata Consultancy Services Limited in Charlotte, NC is seeking an experienced Informatica IDMC Developer to design, migrate and optimize ETL processes. The role requires 8+ years of experience, a Bachelor’s or Master’s degree, and strong SQL, Hadoop, and Oracle skills.

You will collaborate with cross-functional teams, implement data quality and data modeling best practices, and contribute to data warehouse design and performance tuning in a fast-paced BI environment.