Tata Consulting Services (Usa) Lewisville , TX 75067
Posted 3 weeks ago
Skill: Data Analyst
Job Role:
Engage directly with business and technology partners to understand objectives to deliver analytic-centric solutions.
Support rapid prototyping activities that will validate business requirements, confirm solution definition and manage risk appropriately.
Works directly with team members from business sectors and the applications development team.
Uses technical knowledge, creativity, and company practices and priorities to obtain solutions to complex problems. Assist in quality assurance and defining testing strategy and risks.
Use judgment, creativity, and sound technical knowledge to obtain and recommend effective solutions.
Mandatory Skills:
Overall, 8+ years of experience in ETL development.
Expertise in Analysis, Design, development, support and Enhancements of ETL in data warehouse environment with any of the market available ETL Tool(such as Datastage/Informatica/Talend/SSIS/Abnitio e.t.c). Expertise implementing complex ETL logic with Toolset.
Good Understanding on ETL data load Strategies.
Knowledge/Experience in Data vault Modeling Design/Implementation.
Experience in relational databases with strong SQL Coding skills to create stored procedures/views for complex analytical use cases.
Exposure to Data Build Tool (DBT),Qlik replicate, Snowflake, Airflow, AWS infrastructure, CI/CD pipelines.
Troubleshoot and quickly resolve data quality issues, performance issues, database capacity issues, replication and other distributed data issues.
Exposure to Python programming.
Should be proficient in writing complex SQL queries.
Strong analyzing capabilities with an ability to fine-tune report/SQL query performance.
Exposure to Auto Finance process would be an added advantage.
#LI-CO1
Tata Consulting Services (Usa)