Lead Data Engineer Resume
0/5 (Submit Your Rating)
SUMMARY:
- more than 12 years of experience in the field of Information Technology
- Database development including Design architecture, development, system integration, and infrastructure readiness. extensive experience in managing & delivering projects, conducting business analysis to determine requirements and planning for systems implementation at the enterprise scale an effective communicator with honed relationship, leadership, planning, coordination and analytical skills with ability to view the larger picture, taking business - critical decisions from the front to attain business/ operational excellence. handling end-to-end implementing solutions on enterprise level from requirement analysis to system study, designing, coding testing, de-bugging, documentation and implementation extended experience in product based companies
- Design and implement Database architecture solutions for various application needs
- Analyse multiple sources of structured and unstructured data to propose and design data architecture solutions for scalability, high availability, fault tolerance, and elasticity
- Hands on experience in developing ETL/ ELT pipelines using Python & Spark
- Experience in developing Rest APIs and modelling data from API sources
- Develop conceptual, logical and physical design for various data types and large volumes
- Solid expertise in RDBMS and Dimensional Modelling, Designing of STAR, SNOW FLAKE Schemas
- Performance tuning ETL Packages, Stored procedures and Adhoc queries by applying standard practices, indexing strategies along with good understanding of tool & server architecture
- Developed numerous reports and complex dashboards in Power BI, Tableau etc.,
- Architect, design and implement high performance large volume data integration processes, database, storage, and other back-end services
- Hands-on expertise in developing Databases, Complex stored procedures, database objects(Tables, Views, Triggers etc.,), ETL packages & OLAP Cubes (Tabular and Multi-Dimensional) using Microsoft Intelligence BI Tools( SSIS, SSAS)Work closely with Business, at a technical and user level, to design and produce solutions
- Work closely with the product management and development teams to rapidly translate the understanding of customer data and requirements to product and solutions
- Participate in Rapid Application Development and Agile processes to deliver new Data warehouseservices and components.
- Set architectural vision and direction across a matrix of teams
- Design, development & maintenance of the ETL frameworks, Business Intelligence Solutions
- Responsible for all proactive /reactive response for Proposals across the different line of Businesses
- Providing Inputs for Pre sales team on different proposals
- Responsible of meeting practice objectives such as Recruitment Support & Team Interface, Handling Proof of concepts on technology space, Building competencies
- Sharing best practices, reviewing Projects from other Accounts
TECHNICAL SKILLS:
ETL Tools: SSIS, Informatica
Languages: Python, PowerShell, Spark, Advanced SQL
Database: MS SQL Server, Oracle, Redshift, DynamoDB
Database Tools: SQL Developer, Erwin
Repository System: TFS, GIT
BI/ Visualization Tools: SSAS, SSRS, Power BI, Tableau
Cloud Platform: AWS