Talend Developer. St Louis LilyLifestyle

Innova Solutions is immediately hiring a Talend Developer

Position type:
Permanent

Duration:
Fulltime

Location:

MO, US

• Develop stable, secure, scalable and highly performing code/components which are easy to inspect, test, service and support.
• Deliver within time commitments adhering to approved designs, deployment standards and meeting set quality goals confirming to coding standards & best practice with minimal defects.
• Learn to influence team and stakeholders to proactively resolve issues.
• Perform unit/module testing of software to find errors and confirm programs meet specifications.
• Write dev plan covering all scenarios based on information provided by functional specs.
• Provide accurate time and resource estimates that result in on-schedule delivery.
• Mentor juniors in the team and take accountability for their delivery by reviewing deliverables, providing solutions and technical support and training.
• Contribute to solutioning and ensuring solutions adhere to established technological standards.
• Identify scenarios/functionality that are missing or lack usability and take proper action.
• Independently handle component level design.
• Analyze and permit impact of change.
• Design and implement proof of concept as needed for solutions as an individual contributor.
• Expand software engineering knowledge beyond what is needed to complete the work; learn new technologies/platforms during spare time and present learnings to others in the company.
• Expertise and execute in Agile & other delivery methodologies followed in the organization.

• Knowledge and hands‑on experience with ETL development.
• Hands‑on experience implementing different loading strategies like SCD1 and SCD2, table/partition refresh, insert‑update, swap partitioning using Talend.
• Experience in consuming and writing data to and from flat files, RDBMS systems, MPPS, JSON and XML using Talend.
• Experience with RDBMS systems and concepts.
• Expertise in writing complex SQL queries and developing database components including creating views, stored procedures, triggers etc.
• Create test cases and perform unit testing of ETL jobs using Talend.
• Hands‑on experience orchestrating ETL jobs using Talend.
• Hands‑on experience creating triggers on TAC server for scheduling the Talend jobs.
• Experience creating batch‑level processing, parallel processing using Talend.
• Analytical mind with problem‑solving and debugging skills.
• Excellent communication skills.
• Awareness of replication, synchronization and disaster management techniques.
• Awareness of data quality management.

• Hands‑on experience implementing efficient ETL jobs.
• Hands‑on experience implementing CDC ETL jobs and well‑versed in using different data transformations like data enrichment, aggregation, removing duplicates etc., as per business needs.
• Hands‑on experience implementing data‑driven ETL designs.
• Hands‑on experience implementing reusable ETL components as per well‑defined standards.
• Efficient use of parameter and configuration files in ETL job implementation.
• Hands‑on experience applying performance tuning techniques on long‑running ETL jobs.

• Experience handling operating system, ETL and job scheduling and orchestration using Python.
• In‑depth knowledge and hands‑on experience with Unix/Linux programming (shell and/or Perl).
• In‑depth knowledge and hands‑on experience with Power Shell scripting (shell and/or Perl).

• Hands‑on experience creating table partitions, indexes, views, materialized views etc.
• Hands‑on experience writing complex SQL queries using joins, aggregate/analytical functions, CTE etc.
• Hands‑on experience fine‑tuning long running SQL queries.

• Good to be aware of OS compute, networking, internal workings of DB and ETL server and its impact on ETL design, data transfer and data processing.
• Good to have knowledge of Agile methodology.

• B.E /
  
  B.Tech, MS, M.Tech, MCA
• 3‑8 years of experience

Pay Range: $95,000 – 111,500 per year.

Pay range offered to a successful candidate will be based on several factors, including the candidate's education, work…