| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Account Lead Technical Solutions Consultant Ad Tech Programmatic Matawan, NJ .Net full stack, Tech Lead, Senior Software Engineer, Architect Hackensack, NJ Electrical Systems Lead Mechanic Brooklyn, NY Technical Lead & MERN Stack Expert New York City, NY Lead FullStack Developer Philadelphia, PA Lead Android Developer Brooklyn, NY Maintenance Tech Manager Wyncote, PA |
|
Click here or scroll down to respond to this candidateSUMMARY
14 Years of Rich experience in IT. Installing, Configuring, Analyzing, Designing, Integrating, re-engineering, and developing highly sophisticated systems. Have wide range of IT knowledge in Software Analysis, Development, and Implementation of business applications for Banking, Logistics, Transportation, Finance, Insurance and Telecom verticals.
Worked extensively with Snowflake, AWS to design and implement robust data solutions.
Strong experience in Snowflake internal and integration of Snowflake with other data processing and reporting technologies
Experience in building and configuring Snow pipe. Experience with Snowflake Virtual Warehouses. Experience in Data ingestion to Snowflake from Different file types.
Ability to work with large and complex data sets like JSON, PARQUET, CSV files from various sources like AWS Cloud Storage.
Experience with Snowflake Multi-Cluster Warehouses and Snowflake Database, Schema and Table structures. Experience in using Snowflake Clone and Time Travel.
Hands on with the cloud technologies like AWS S3, Aurora, EC2, IAM and etc., Implemented data warehouses on AWS using Redshift in a POC.
Experience in real time streaming data. Handle Dev Ops effort in terms of CICD, Scanning, Code, Performance testing and Test coverage
Develop, enhance and test new/existing interfaces. The candidate will be part of existing agile team and will work on developing, enhancing ETL pipelines, design solutions,
Very Good Experience in Data Warehousing to develop ETL mappings and scripts in Informatica Power Center 10.4/10.2/9.6 .
Good Experience in developing and designing Informatica transformation objects, session tasks, worklet, workflows, workflow configurations and sessions (reusable and non-reusable).
Knowledge in Informatica Advanced Techniques Dynamic Caching, Memory Management, Parallel Processing to increase Performance throughput.
Involved in development of Informatica Mappings and Informatica Workflows. Created Mapplet and used them in different Mappings.
Change Data Capture mechanism using Informatica Mapping Variable. We can use the Informatica Mapping Variable to extract the CDC data.
Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows, tasks.
Very Good experience in using Teradata (currently using version 13.x/15.x,Oracle 12c/10g/9i/8i/7.x, MS SQL Server 2002/7.0/6.5, SQL Server 12.0/11.x, MS Access 7.0/2000, SQL, PL/SQL..
Expertise in working in Teradata 13.x,15.x systems and used utilities like Multi Load, Fast Load,
Fast Export, BTEQ, TPump, Teradata SQL.
Hands on with developing ETL in AWS Glue, and understand the process of Crawler and etc.,
Worked on analysis and documentation of OLAP reports requirements. Solid understanding of OLTP & OLAP concepts and challenges, especially with large data sets.
Having Knowledge in JAVA/J2EE Technologies. Knowledge in using IDEs such as My Eclipse, Eclipse (EE) for development. Having Knowledge in Mainframe DB2, Cobol, MQ. Knowledge in Hadoop, Hive, Python and Kafka
Participated in requirements Analysis reviews, Business reviews and working sessions to understand the requirements and system design.
Technical Skills
ETL TOOLS Informatica PHONE NUMBER AVAILABLE/ 9.6 / 9.1 ,IICS
BI TOOLS Tableau, Cognos7.x/8.x, Business-Objects 5.x/6.x
CLOUD SnowFlake, Snow SQL, AWS SCRIPT Python,Java Script
RDBMS Teradata 15.0 ,13.10, Oracle 12c/ 10g/11g, MS-SQL Server 2016, MySQL and SAP-HANA 9, DB2 OS Windows, Linux / Unix
FRAMEWORK Struts, Hibernate, spring LANGUAGES Java 2.0/J2EE, SQL, PL/SQL, XML, HTML, JavaScript and UML, C, C++
CLOUD AWS, S3, EC2, Aurora, Redshift, AWS Glue
DATA MODEL Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling,
OTHER TOOLS SQL Plus, Toad, Power Designer 9.6, Rational Rose 2000. IBM Rational Clear Case,
HP-QC,Hadoop, Hive, WinSCP, Putty, SSH, Autosys, Teradata SQL Assistant, Toad SQL Assistant, Teradata Utilities FastLoad, MultiLoad, FastExport, BTEQ, Git HUB, Jira, RALLY, Version one
Academic Qualification |
