Must Have Technical/Functional Skills
Primary Skill: Python
Secondary: Oracle PL/SQL, ETL
Experience: Minimum 7 years
Roles & Responsibilities
Bachelor’s or master’s degree in computer science or related field.
- Good hands-on years of experience in designing, building, and maintaining robust data pipelines using Python and SQL.
- Expert in writing complex SQLs
- Develop reusable scripts for data extraction from various structured and semi-structured file formats.
- Write optimized and scalable queries to retrieve, clean, and transform data for analytics and reporting.
- Integrate data from different sources, including APIs and multiple databases.
- Work closely with analysts, data scientists, and business stakeholders to deliver clean, reliable datasets for analysis.
- Document data workflows and ensure best practices in coding and version control.
- Good to have experience on Paginated Reports and Power BI issues, Power BI Development, enhancement, and Migration.
- Core Python: Expert-level proficiency in writing efficient, modular, and production-grade Python code for data extraction, transformation, and loading (ETL) processes.
- SQL & Databases: Highly skilled in writing complex SQL queries, stored procedures, and optimizing database interactions. Hands-on experience connecting Python scripts with various relational databases (e.g., PostgreSQL, MySQL, SQL Server).
- Data Source Integration: Extensive experience working with diverse file-based data sources such as CSV, JSON, and Excel, including parsing, transforming, and integrating them into ETL pipelines.
- API & DB Connectivity: Exposure to consuming REST APIs for data ingestion and integrating multiple database sources in a unified workflow.
Additional Skills:
- Familiarity with version control (Git), basic shell scripting, and working knowledge of data validation and performance tuning.
- PBI Skills: Desirable to have skills on Power BI Development, enhancement and Migration.
- Make an impact – Drive change for global enterprises and solve business challenges that matter.
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 Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
Salary Range: $95,000 - $125,000 a year