<p>Must Have Technical/Functional Skills</p> <p>Primary Skill: ETL Informatica Developer</p> <p>Secondary: Oracle, SQL</p> <p>Experience: Minimum 10 years</p> <p>Roles & Responsibilities</p> <ul> <li>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. </li><li>Deep understanding of HDFS, YARN, MapReduce, Hive, Pig, HBase, Flume, Sqoop, Zookeeper, Oozie. </li><li>Experience with Spark, Kafka, NoSQL databases. </li><li>Experience in Agile Methodology </li><li>Experience with code versioning tools like Bit-Bucket </li><li>SQL Proficiency: Utilize SQL/PLSQL to extract, transform, and load data. </li><li>Exposure to advanced transformations like data transformations, Parsing JSON/XML messages </li><li>Experience in Job scheduling tools Like Autosys </li><li>Data Integration: Integrate data from various sources, ensuring data consistency and quality. </li><li>Data Warehouse Design: Design and maintain data warehouses to support business intelligence activities. </li><li>Performance Optimization: Optimize SQL script/queries for speed and efficiency. </li><li>Troubleshooting: Identify and resolve issues in ETL processes. </li><li>Documentation: Create and maintain technical documentation for ETL processes. </li><li>Testing: Perform unit, integration, and system testing on ETL processes. </li><li>Collaboration: Collaborate with cross-functional teams to ensure successful implementation of ETL processes. </li><li>Data Quality: Ensure data quality by implementing data cleansing and transformation processes. </li><li>Data Modeling: Develop and maintain relational and dimensional data models. </li></ul> <p>TCS Employee Benefits Summary:</p> <p>Discretionary Annual Incentive.</p> <p>Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.</p> <p>Family Support: Maternal & Parental Leaves.</p> <p>Insurance Options: Auto & Home Insurance, Identity Theft Protection.</p> <p>Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.</p> <p>Time Off: Vacation, Time Off, Sick Leave & Holidays.</p> <p>Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.</p> <p>Salary Range: $95,000 - $135,000 a year</p>