REMOVE
From: hiringzone98@googlegroups.com <hiringzone98@googlegroups.com> On Behalf Of suryaitrecruit
Sent: Friday, August 13, 2021 7:29 AM
To: Hiringzone98 <hiringzone98@googlegroups.com>
Subject: ETL Developer II 100% Remote
Hi
Hope you are doing well,
ETL Developer
100% Remote
6 Months contract
No Client Interview
Details of the role
ETL Development role to implement enhancements to existing process.
Key responsibilities:
- Develop stable, secure, scalable, and highly performing Code /Components which are easy to inspect, test, service, and support.
- Delivery within time commitments adhering to approved designs, Deployment standards and meeting set quality goals confirming to coding standards & best practice with minimal defects.
- Drive customer communication for the project. Participate in regular client meetings that led to useful feedback and create project plans that deliver solutions to client problems.
- 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 customers and functional specs.
- Provide accurate time and resource estimates result in on-schedule delivery
- Mentor juniors in the team and take accountability for their delivery like reviewing deliverables, providing solutions and providing technical support and training.
- Contribute to solutioning and ensuring solutions adhere to established technological standards
- identify the scenarios/functionality that are missing or do not meet the customer needs or usability and take proper action
- Independently handle component level design
- Analyze and permit impact of change
- Independently handle component level design
- Recognize broader relationships between the solution and customer needs, iron out dependencies and deliver code that produces value
- Designs 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 the spare time and present the learnings to others in the company
- Expertise and execute in Agile & other Delivery methodologies followed in the organization
Required Skills:
- Expertise in writing complex SQL queries
- Hands on experience on writing complex SQL queries using joins, aggregate/analytical functions, CTE etc.,
- Hands on experience in fine tuning the long running SQL Queries
- Expertise in developing Database components including creating views, stored procedures, triggers etc.
- Experience on RDBMS systems and concepts
- Extensive Experience in Data validation and Data Profiling
- Decent knowledge of transaction management mechanisms, ACID properties, Exception Handling
- Decent knowledge on data cardinality, Constraints, data quality rules, system level checks like, integrity check, isolation levels, compatibility levels in the system.
- Knowledge and hands-on experience with ETL development
- Hands on experience on implementing different loading strategies like SCD1 and SCD2, Table/ partition refresh, insert update, Swap Patriation etc.
- Experience in Consuming and writing data from and to Flat files, RDMBS systems, MPPS, Jason and XML.
- Ability to automate and build reusable executables for better delivery efficiency
- Ability to provide feasible and scalable Design/architecture for business requirements.
- Hands on experience on implementing efficient SSIS packages
- Experience in handling Operating system, ETL and Job scheduling and orchestration using SSIS
- Create test cases and perform unit testing of ETL Jobs
- Analytical mind with a problem-solving and debugging skills.
- Excellent Communication Skills
- Awareness of Replication, Synchronization and Disaster Management techniques
- Awareness of Data Quality Management
- Hands on experience on creating table partitions, indexes, views, materialized views etc.,
- Hands on experience in implementing data driven ETL designs
- Hands on experience in implementing reusable ETL components as per well-defined standards
- Efficient use of parameter and configuration files in ETL job implementation
- Hands on experience in applying performance tuning techniques on long running ETL Jobs
- Good to have knowledge of Agile Methodology (Scrum framework), JIRA
Regards,
----------------------------------------------------------
Surya Prakash
Technical Recruiter
Dynamiqal, LLC
260 Peachtree St NW Suite 2200, Atlanta, GA 30303
Phone: 619-359-0013 | Email : suryaitrecruit@gmail.com
--
You received this message because you are subscribed to the Google Groups "Hiringzone98" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hiringzone98+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/hiringzone98/f89f368c-8d8c-4af1-9afc-69ef1ac1bdd6n%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.