Snowflake Developer
Location : Jaipur, India
Experience : 11 Year
Rate: $18 / Hourly
Availability : Immediate
Work From : Any
Category : Information Technology & Services
Edukondalu – 10+ Years – Snowflake Developer
PROFESSIONAL SUMMARY
Having 10+ years of experience in the information technology industry, Expertise in the development of Data warehousing and DBMS applications using DataStage, Snowflake, Snaplogic and Teradata.
7 years of DataStage experience in designing and developing jobs using IBM DataStage, IBM Quality Stage, Data Stage Designer, Data Stage Manager, and Data Stage Director on Server Engine.
3+ years of Snowflake experience in concepts like setting up resource monitors, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel .
Hands-on experience with Snowflake utilities, SnowSQL and SnowPipe.
Experience in Data Migration from Teradata to Snowflake cloud data warehouse.
Worked closely with business partners throughout the requirements gathering, technical design and development lifecycle phases.
Involved in Design, Development, testing and supporting phases of data warehousing projects.
Worked with different sources like Flat files, DB2, Oracle, SQL Server, Teradata, Snowflake DB and XML and JSON files.
Used Attunity ETL tool to connect sources like Oracle, DB2 DB and loaded data into Snowflake.
Having a Good Knowledge of writing Teradata and Snowflake SQL queries.
Having good experience in developing parallel jobs on GRID environment.
Extensively used Sequential File, Dataset, Filter, Switch, Aggregator, Change Capture, Lookup, Join, Tranformer, Copy, Oracle Enterprise, Surrogate Key Generator, Sort, Remove Duplicates stages while designing the DS Jobs.
Implemented Job Sequence to integrate the entire performance of the DataStage job designs.
Implemented Performance Tuning Techniques while designing ETL applications.
Having a Good Knowledge of UNIX and Oracle SQL.
Extensively worked on Change Requests to add/remove the columns, implementing new customer requirements.
Participating Client interactions frequently in the initial phase of the project.
Involved in Dev and QA environments.
Having a Good knowledge on Grid environment.
knowledge in Agile software development methodologies.
PEOPLE MANAGEMENT
Provide assistance in selection of representative employee groups for training.
Conduct training or knowledge sharing sessions.
Mentor team members in project teams with respect to product and domain skills on
projects.
Conduct technical, face to face interviews.
Conduct / support managers in conducting appraisals for team members and share final ratings with the relevant stakeholders.
Coordinate with the project/program manager in understanding how the employee can better contribute to the project, seek feedback and address concerns.
SOFTWARE SKILLS
DWH tools : IBM Infosphere Data Stage v11.3, v8.5, and v8.1
DBMS : Snowflake , Teradata , and Oracle.
Reporting tools : Power BI
Languages : SQL,C.
Operating systems : Win XP/2000/NT, UNIX
Others : Tidal ,Denodo and Toad.
PROFESSIONAL EXPERIENCE
Working as Technical Manager from Dec 2019 to till date
Worked as Sr. DataStage developer from Nov 2016 to Dec 2019
Worked as Sr. Associate consultant from Sep 2013 to Nov 2016
Worked as ETL Developer from April 2011 to Sep 2013
EDUCATIONAL QUALIFICATION
M.Tech (power system and automation)
ACHIEVEMENTS
Got all India 224 GATE score and gave 3 National conferences
MAJOR ASSIGNMENTS
Project # 1:
Project Title : SPM (Service Parts Management)
Client : Caterpillar India Private Limited
Duration : Nov 2016 – Till date
Role : Team Member
Environment : IBM Info Sphere Data Stage v11.3, Snowflake and Teradata.
Description:
Service Parts Management (SPM) is a suite of software solutions used to manage a complex, global, multi-layer supply chain within the Caterpillar Logistics Inc. The collaborative component used by dealers is Customer Relationship Management.
•Customer Relationship Management (CRM) – The commercial tools used by Caterpillar Logistics and Dealers to manage billing and pricing, claims/complaints and returns.
•Supplier Network Collaboration (SNC) – The commercial tool used by Caterpillar Logistics and Dealers to manage ASN creation for Dealer returns.
Responsibilities:
Analyze the existing information source
{{contact.cdata.phone}}
{{contact.cdata.email}}
View Resume
