Senior ETL Developer
Role: Sr. ETL Informatica ( Only W2)Experience: 12+ yearsLocation: Austin, TexasDuration: Long term 1+yearResponsibilities:Experience: 13+ years of proven experience as part Development, maintenance, and enhancement of Data Pipelines (ETL/ELT) and processes with thorough knowledge of star/snowflake schemasDeveloping complex SQL queries and SQL optimization.Experience with other cloud platforms (e.g., AWS, Google Cloud) and multi-cloud environmentsDevelopment experience must be full Life Cycle experience including business requirements gathering, data sourcing, testing/data reconciliation, and deployment within Business Intelligence/Data Warehousing Architecture.Skills:Proficiency in Informatica / PowerCenter / IDMC tools (4+ Years).Informatica IDMC (Cloud Data Integration / Application Integration) (3+ Years)Data pipeline development using cloud platformsSnowflake data warehousing (2+ Years)Salesforce (SFDC) integration (2+ Years)Informatica Salesforce Data Connector configuration (SFDC)Real-time and batch data integration of Salesforce to Snowflake and Snowflake to Salesforce.Data migration and ETL/ELT processesAPI-based integrations and data orchestrationStrong SQL and data modeling skillsPerformance tuning and troubleshooting of data pipelinesCertifications: Snowflake, Salesforce connector, IDMC Tools are PlusDevelopment, maintenance, and enhancement of Data Pipelines (ETL/ELT) and processes with thorough knowledge of star/snowflake schemasUnderstanding of Data ArchitectureKnowledge of ETL and data engineering standards and best practices for the design and development of data pipelines and data extract, transform and load processesDesign, build and test data products based on feeds from multiple systems, using a range of different storage technologies, access methods or bothKnowledge of data warehousing concepts, including multi-dimensional models and ETL logic for maintaining star-schemasGood Understanding of concepts and principles of data modelling.Ability to produce, maintain and update relevant data models for specific needs.Can reverse-engineer data models from a live systemSQL programming desirable (i.e., stored procedures dev.)Proficient in data analysis, defect identifications and resolutions.Strong professional verbal and written communication skills.Ability to work with little supervision and within changing priorities.Ability to analyze requirements and troubleshoot problems. Best Regards,Gatla VivekTalent Acquisition Specialist 5525 N Macarthur Blvd #125, Irving TX 75038.E-Mail: vivek.gatla@cloudresources.net