Tamanna Sonnie

Tamanna Sonnie ETL Lead--linkedin.com/in/ tamanna-sonnie-b-   Summary   Data Warehouse & ETL Developer with 9+ years of experience in designing, developing, and implementing data warehouses and data marts. Proven ability to use SQL Server Integration Services (SSIS), Informatica, and SQL to extract, transform, and load data from disparate sources. Strong analytical and problem-solving skills. Excellent team player with a strong work ethic. Experience   Technical Lead/Senior ETL & Database Developer Infosys Pvt. Ltd, Vancouver, BC March 2023–Present US Ignite Datahub Collaborated with project managers and stakeholders to comprehend project objectives, scope, and requirements. Developed effective technical roadmaps and plans to achieve project goals. Led and mentored a team of developers throughout the project lifecycle, providing technical direction and ensuring successful project milestone delivery. Worked closely with business analysts and clients to understand needs and translate requirements into technical solutions. Designed and developed the technical architecture of the Datahub project, ensuring alignment with industry best practices and meeting scalability, performance, and security requirements. Evaluated and selected appropriate technologies, tools, and frameworks considering data integration, storage, and processing factors. Conducted thorough code reviews to ensure high-quality code and adherence to coding standards, providing constructive feedback to team members. Identified potential technical risks and issues proactively, devising strategies to mitigate them. Maintained regular communication with stakeholders on project progress and potential challenges. Fostered a collaborative and inclusive work environment, promoting teamwork and effective communication among team members and project stakeholders. Stayed updated with the latest ETL and data integration technologies, industry best practices, and emerging trends to continuously enhance the project's technical capabilities. Senior ETL & Database Developer Infosys Pvt. Ltd, Mohali, Punjab & Vancouver, BC December 2019 – February,2023 NY, KY & Magellan State Implementation Lead the team and provide high-level Impact Analysis, Design Implementation, and conduct Peer Review & Code Deployments using industry expertise. Proactively work on Test Planning Strategies, Estimation Planning, Scheduling & Tracking, Defect Fixing, Functional, Performance & Unit Acceptance Testing. Provide guidance and expertise in developing proposals and strategies for software/product design, including program end-to-end flow for specified business requirements. Conduct Peer reviews and walkthroughs with various business development stakeholders such as Business Analysts and Development Teams. Maintain positive client interactions and coordinate with overall technical leads and technical analysts of other dependent migration streams. Assemble project teams, assign individual responsibilities, enforce accountability, and ensure timely project completion. Showcase leadership skills by providing knowledge transfer and training sessions to Client IT employees on various domain and technology aspects. Data Architect, Professional /ETL Developer Fiserv India Pvt. Ltd. October 2016– November 2019 POS – Platform Optimization Strategy Independently handle clients and actively participate in requirement gathering and client calls. Mentor a team of two associates, facilitating requirements translation and implementation. Oversee production deployment and execute migration scripts on multiple environments, coordinating with various stakeholders. Utilize Attunity tool to extract data from Tandem through writing queries. Develop queries and create Stored Procedures to fetch data from client sources (SQL Sources) and client's logic. Design and modify ETL (Extract Transfer Load) packages for Extraction, Processing, and Upload operations. Perform Extraction package pulls from Source before data changes. Apply rules and logic within the Processing package to generate final data. Implement the Upload package to upload data from final tables processed in the Processing package into Tandem. Conduct code reviews, create unit test cases, and ensure delivery free of defects. Create stored procedures and SSIS packages as required. Associate Consultant/ETL & Reporting Developer Capgemini India Pvt. Ltd. October 2013–September 2016 LICENSING & REGISTRATION Direct interaction with the Users and Business Analysts while requirement gathering. Migrated database from the old version of Oracle-to-Oracle 11g through INFORMATICA 9.1. Documenting, Creating ETL design using Informatica. Responsible for logic, query building, data issue solving, and query fine-tuning. Developed various Reports like parameterized reports, Ad hoc reports, drill down and sub-reports for UK and APAC in SSRS according to the business requirements. Perform Unit Testing & Code Reviews Facilitate SIT and make code changes as per OAT feedback/defects. Responsible for planning and conducting the KT sessions after GO LIVE. Education   Bachelor of Technology Punjab Technical University, Jalandhar, Punjab Higher Secondary Central board of Secondary Education, Chandigarh, UT Skills   SQL Server Integration Services (SSIS) Informatica SQL Data Warehousing Data Modelling ETL Data Quality Agile Development Teamwork Communication