Must Have Technical/Functional Skill
o Strong foundation in MS SQL server
o Create complex SQL queries, view, Stored procedure etc. in SQL server.
o Design and implement robust ETL using SSIS.
o Develop scalable and reusable Power BI solutions that adhere to best practices and industry standards.
o Integrate data from various sources, including on-premises databases, cloud services, and external APIs, into Power BI.
o Optimize data models for performance, ensuring efficient data retrieval and processing.
o Develop advanced DAX formulas and Power Query transformations to create complex calculations and data
transformations.
o Understanding and support existing reports in SSRS and developing new reports.
o Domain knowledge of metal and manufacturing industry is a big plus
o Strong analytical and problem-solving skills.
o Excellent communication and presentation skills, with the ability to convey technical concepts to
non-technical audiences.
o Ability to work effectively both independently and as part of a team
Roles & Responsibilities
o Coordinate with external technical and Functional team to understand requirements, convert that to
technical specifications.
o Understand existing source SQL data architecture
and rearchitect downstream SQL Datawarehouse based on new source system
o Modify existing standards as well as customized program based on requirement
o Analyze issues and provide resolution
o Work with offshore team to provide the requirements and supervise the overall work
o Testing of application
o Estimate the effort and timelines for enhancements
o Create/update technical specifications
Salary Range $120,000-$130,000 Per year
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 & amp; Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
#LI-SP1