Data Engineer

Hybrid (Monday to Wednesday only)Malvern, PA | 10 - 15 years of experienceJob DescriptionMust Have Technical/Functional SkillsPython, Glue ETL, Attunity, Pyspark, AWS (S3, IAM, Lambda, Cloud Formation)Roles & Responsibilities· Design, develop, and maintain scalable ETL/data integration pipelines using AWS Glue, PySpark, and Python.· Develop and optimize data transformation workflows to process large datasets from multiple source systems.· Utilize Attunity for real-time and batch data replication between on-premises and cloud environments.· Build and manage data lakes and storage solutions using Amazon S3, ensuring data quality, security, and governance.· Implement serverless data processing solutions using AWS Lambda and integrate with other AWS services.· Configure and manage IAM roles, policies, and permissions to ensure secure access to AWS resources.· Automate infrastructure provisioning and deployment using AWS CloudFormation.· Monitor, troubleshoot, and optimize ETL jobs, data pipelines, and cloud resources for performance and reliability.· Collaborate with business, analytics, and application teams to gather requirements and deliver data solutions.· Support CI/CD processes, perform code reviews, and maintain technical documentation following best practices.Generic Managerial Skills, If any· Planning & Execution – Effectively prioritize tasks, estimate effort, and ensure timely delivery of project milestones while balancing multiple commitments.· Stakeholder Management – Build strong relationships with business teams, clients, and leadership through proactive communication and expectation management.· Communication – Convey technical and non-technical information clearly through meetings, presentations, documentation, and status updates.· Collaboration – Foster teamwork across cross-functional groups, encourage knowledge sharing, and contribute to a positive team environment.· Decision Making – Analyze options, assess risks, and make informed decisions that align with both technical and business objectives.· Leadership & Ownership – Take accountability for deliverables, drive initiatives proactively, and lead by example to achieve team goals.· Risk & Issue Management – Identify potential risks early, address blockers proactively, and implement mitigation strategies to ensure smooth project execution.· Customer & Business Focus – Understand customer needs and business priorities, ensuring technical solutions deliver measurable value.· Mentoring & Coaching – Support team growth through guidance, code reviews, knowledge sharing, and skill development initiatives.· Project & Change Management – Adapt effectively to evolving requirements, manage priorities during change, and ensure successful delivery outcomes.TCS Employee Benefits Summary: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 As sistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.Salary Range: $120,000-$130,000 a year