Analyst

Primary Skill ETL Informatica Developer Secondary Skills Oracle, SQL Experience Minimum 10 years Responsibilities 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. Utilize SQL/PLSQL to extract, transform, and load data. Exposure to advanced transformations such as parsing JSON/XML messages. Experience with job scheduling tools like Autosys. Integrate data from various sources, ensuring data consistency and quality. Design and maintain data warehouses to support business intelligence activities. Optimize SQL scripts/queries for speed and efficiency. Identify and resolve issues in ETL processes. Create and maintain technical documentation for ETL processes. Perform unit, integration, and system testing on ETL processes. Collaborate with cross‑functional teams to ensure successful implementation of ETL processes. Ensure data quality by implementing data cleansing and transformation processes. Develop and maintain relational and dimensional data models. Qualifications Bachelor of Computer Science. Salary $100,000 – $130,000 per year. #J-18808-Ljbffr Tata Consultancy Services Limited