Integration Specialist

Proven work experience as a Database Programmer, Database Developer, or similar role.

Strong proficiency in SQL and hands-on experience with PostgreSQL.

Solid understanding of relational database concepts and principles.

Experience in database design, schema modeling, and optimization.

Familiarity with database administration tasks, such as user management, backup and recovery, and performance tuning.

Ability to write efficient SQL queries, stored procedures, and functions.

Detail-oriented with a focus on data accuracy and integrity.

Familiarity with software development methodologies and programming languages is a plus.

• 4+ yrs of experience having strong fundamentals on Windchill Customization & Configurations, Reporting Framework Customization, Workflow Customization , Customer handling
• Strong Customization background around Form Processors, Validator, data utilities, Form Controllers etc.
• Strong Programming skills in Java/J2EE technologies – JavaScript, GWT, JQuerry, XMLs, JSPs, SQL etc.
• Deep Knowledge in Windchill architecture

• Experience in atleast one full lifecycle PLM implementation with Windchill.
• Should have strong coding skills in Windchill development and Customization, ThingWorx Navigate Development (Mandatory), Thing Worx Architecture Configurations Mashup creation, ThingWorx and Windchill Upgrade

• Should have Build and Configuration management (Mandatory) - HPQC \JIRA\Azure\SVN\GITHUB \ Ant
• Knowledge & Experience in Build and Release process
• Having worked on custom upgrade will be a plus.
• Understanding of application s development environment, Database, data management and infrastructure capabilities and constraints. Understanding of Database administration, Database design and performance Tuning
• Follow Quality processes for tasks with appropriate reviews. Participate in sharing knowledge within the team.

Looking for a AWS Architect for our client branch in Noida

Experience: 8+ years of relevant experience

Location: Noida

Notice period : Immediate to 30 days joiners

Must have: AWS, Spark, Python, AWS Glue, AWS S3, AWS Redshift, Sage Maker, AppFlow, Data Lake Formation, AWS Security, Lambda, EMR, SQL

Good to have:

Cloud Formation, VPC, Java, Snowflake, Talend, RDS, Data Bricks

Responsibilities:

• Mentor Data Architect & Team and also able to Architect and implement ETL and data movement solutions like ELT/ETL/Data pipelines.
• Apply industry best practices, security, manage compliance, adopt appropriate design patterns etc
• Able to work and manage tests, monitors, manage and validate data warehouse activity including data extraction, transformation, movement, loading, cleansing, and updating processes.
• Able to code, test and dataset implementation and maintain and define data engineering standards
• Architect, Design and implement database solutions related to Big Data, Real-time/ Data Ingestion, Data Warehouse, SQL/NoSQL
• Architect, Design and implement automated workflows and routines using workflow scheduling tools
• Identify and Automate to optimize the performance.
• Conduct appropriate functional and performance testing to identify bottlenecks and data quality issues.
• Be able to implement slowly changing dimensions as well as transaction, accumulating snapshot, and periodic snapshot fact tables.
• Collaborate with business users, EDW team members, and other developers throughout the organization to help everyone understand issues that affect the data warehouse.

• 7-10 years experience with secure SDLC/DevSecOps practices such as automating security processes within CI/CD pipeline.
• At least 4 yrs. experience designing, and securing Data Lake & Web applications deployed to AWS, Azure, Scripting/Automation skills on Python, Shell, YAML, JSON
• At least 4 years of hands-on experience with software development lifecycle, Agile project management (e.g. Jira, Confluence), source code management (e.g. Git), build automation (e.g. Jenkins), code linting and code quality (e.g. SonarQube), test automation (e.g. Selenium)
• Hand-on & Solid understanding of Amazon Web Services & Azure-based Infra & applications
• Experience writing cloud formation templates, Jenkins, Kubernetes, Docker, and microservice application architecture and deployment.
• Strong know-how on VA/PT integration in CI/CD pipeline.
• Experience in handling financial solutions & customer-facing applications

Roles

• Accelerate enterprise cloud adoption while enabling rapid and stable delivery of capabilities using continuous integration and continuous deployment principles, methodologies, and technologies
• Manage & deliver diverse cloud [AWS, Azure, GCP] DevSecOps journeys
• Identify, prototype, engineer, and deploy emerging software engineering methodologies and tools
• Maximize automation and enhance DevSecOps pipelines and other tasks
• Define and promote enterprise software engineering and DevSecOps standards, practices, and behaviors
• Operate and support a suite of enterprise DevSecOps services
• Implement security automation to decrease the loop between the development and deployment processes.
• Support project teams to adopt & integrate the DevSecOps environment
• Managing application vulnerabilities, Data security, encryption, tokenization, access management, Secure SDLC, SAST/DAST
• Coordinate with development and operations teams for practical automation solutions and custom flows.
• Own DevSecOps initiatives by providing objective, practical and relevant ideas, insights, and advice.
• Act as Release gatekeeper with an understanding of OWASP top 10 lists of vulnerabilities, NIST SP-800-xx, NVD, CVSS scoring, etc concepts
• Build workflows to ensure a successful DevSecOps journey for various enterprise applications. 
• Understand the strategic direction to reach business goals across multiple projects & teams
• Collaborate with development teams to understand project deliverables and promote DevSecOps culture
• Formulate & deploy cloud automation strategies and tools

Skills

• Knowledge of the DevSecOps culture and principles.
• An understanding of cloud technologies & components
• A flair for programming languages such as Shell, Python, Java Scripts,
• Strong teamwork and communication skills.
• Knowledge of threat modeling and risk assessment techniques.
• Up-to-date knowledge of cybersecurity threats, current best practices, and the latest software.
• An understanding of programs such as Puppet, Chef, ThreatModeler, Checkmarx, Immunio, and Aqua.
• Strong know-how of Kubernetes, Docker, AWS, Azure-based deployments
• On the job learning for new programming languages, automation tools, deployment architectures

• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• Expertise of SQL/PL-SQL -ability to write procedures and create queries for reporting purpose.
• Must have worked on a reporting tool – Power BI/Tableau etc.
• Strong knowledge of excel/Google Sheets – must have worked with pivot tables, aggregate functions, logical if conditions.
• Strong verbal and written communication skills for coordination with departments.
• An analytical mind and inclination for problem-solving

Informatica PowerCenter (9x ,10.2) : Minimum 2+ years experience

SQL / PLSQL: Understanding of SQL procedure. Able to convert procedures into Informatica mapping.

Good to have- Advantage if you have knowledge of Windows Batch Script.